SUNNYSIDE

101 - 150 of 9197

ARKARA CONSTRUCTION CO INC

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


D & L PLUMBING AND HEATING

#0007718

EQUIPMENT WORK

SUNNYSIDE

QUEENS


XINOS CONSTRUCTION CORP

#0008573

EQUIPMENT

SUNNYSIDE

QUEENS


XINOS CONSTRUCTION CORP

#0008573

EQUIPMENT WORK

SUNNYSIDE

QUEENS


APPROVED ENERGY LLC

#0001679

PLUMBING

SUNNYSIDE

QUEENS


CROOM PLG AND HEATING CORP

#0000705

EQUIPMENT WORK

SUNNYSIDE

QUEENS


SUNNYSIDE

QUEENS


HYDRO COMPACTOR INC

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


APPROVED OIL CO OF BKLYN

#0002709

EQUIPMENT WORK

SUNNYSIDE

QUEENS


SUNNYSIDE

QUEENS


NATIONAL ENERGY SYSTEMS INC.

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


TWIN CONTRACTORS INC

#0023468

ALTERATION

SUNNYSIDE

QUEENS


PETROLEUM TANK CLEANERS L

#0001814

EQUIPMENT WORK

SUNNYSIDE

QUEENS


CHAUDRY SHARIF

#0039835

ALTERATION

SUNNYSIDE

QUEENS


ALPHA REST. AND WATR. INC

#0027033

ALTERATION

SUNNYSIDE

QUEENS


ALPHA REST. AND WATR. INC

#0027033

ALTERATION

SUNNYSIDE

QUEENS


IONEL DUMITRACU

#0028233

ALTERATION

SUNNYSIDE

QUEENS


MISTY PLUMBING

#0000652

EQUIPMENT WORK

SUNNYSIDE

QUEENS


MISTY PLUMBING

#0000652

EQUIPMENT WORK

SUNNYSIDE

QUEENS


CASTLE PETROLEUM INC

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


SUNNYSIDE

QUEENS


MZZ WALDOLOWSKI CORP

#0039727

EQUIPMENT

SUNNYSIDE

QUEENS


MZZ WALDOLOWSKI CORP

#0039727

EQUIPMENT WORK

SUNNYSIDE

QUEENS


METRO CONTRACTING NY, INC

#0038109

EQUIPMENT

SUNNYSIDE

QUEENS


EDWARD LEVINSON

#0002351

EQUIPMENT WORK

SUNNYSIDE

QUEENS


JACK PICCINI, INC

#0005157

EQUIPMENT WORK

SUNNYSIDE

QUEENS


COLGATE SCAFFOLDING

#

EQUIPMENT

SUNNYSIDE

QUEENS


BRICKENS CONS

#

ALTERATION

SUNNYSIDE

QUEENS


SUNNYSIDE

QUEENS


UNITECH DESIGN

#0000215

ALTERATION

SUNNYSIDE

QUEENS


MAGOR PLG AND HEATING CORP

#0001119

PLUMBING

SUNNYSIDE

QUEENS


ALLISON HEANEY

#0002732

EQUIPMENT WORK

SUNNYSIDE

QUEENS


ALLISON HEANEY

#0002732

EQUIPMENT WORK

SUNNYSIDE

QUEENS


JRS CONSTRUCTION & EXPEDI

#0601448

ALTERATION

SUNNYSIDE

QUEENS


JRS CONSTRUCTION & EXPEDI

#0601448

ALTERATION

SUNNYSIDE

QUEENS


THREE STAR CONSTRUCTION C

#0028689

EQUIPMENT WORK

SUNNYSIDE

QUEENS


THREE STAR CONSTRUCTION C

#0028689

EQUIPMENT WORK

SUNNYSIDE

QUEENS


TASLIM CONSTRUCTION INC

#0038305

EQUIPMENT WORK

SUNNYSIDE

QUEENS


TASLIM CONSTRUCTION INC

#0038305

EQUIPMENT WORK

SUNNYSIDE

QUEENS


THE PLUMBING COMPANY INC

#0001950

PLUMBING

SUNNYSIDE

QUEENS


ALLIED FIRE CONTROL

#0000336

EQUIPMENT WORK

SUNNYSIDE

QUEENS


MILLENUIM CENTURY

#0032393

EQUIPMENT WORK

SUNNYSIDE

QUEENS


MILLENUIM CENTURY

#0032393

EQUIPMENT WORK

SUNNYSIDE

QUEENS


CRETE RESTAURANT

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


CRETE RESTAURANT

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


H & R CONSTRUCTION GROUP INC

#0032429

EQUIPMENT

SUNNYSIDE

QUEENS


H & R CONSTRUCTION GROUP INC

#0032429

EQUIPMENT WORK

SUNNYSIDE

QUEENS


OVR INC

#0008513

EQUIPMENT WORK

SUNNYSIDE

QUEENS


#0032429

EQUIPMENT

SUNNYSIDE

QUEENS


N.Y SIGN CONTRACTOR

#0000218

SIGN

SUNNYSIDE

QUEENS


(default) 2 queries took 774 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Permit`.`id`, `Permit`.`Source`, `Permit`.`License_Permit_Holder`, `Permit`.`Business_Description`, `Permit`.`License/Permit_Number`, `Permit`.`Permit_Type_Description`, `Permit`.`Permit_Subtype_Description`, `Permit`.`Permit_Issuance_Date`, `Permit`.`Permit_Expiration_Date`, `Permit`.`Permit_Status_Date`, `Permit`.`Permit_Status_Description`, `Permit`.`Address`, `Permit`.`Street`, `Permit`.`City`, `Permit`.`Zip_Code`, `Permit`.`Borough`, `Permit`.`Building_ID_No`, `Permit`.`Borough_Block_Lot`, `Permit`.`Latitude_WGS84`, `Permit`.`Longitude_WGS84`, `Permit`.`License/Permit_Holder_Name`, `Permit`.`DOB_Skilled_Trades_Lic_Num`, `Permit`.`DOB_Skilled_Trades_Lic_Type` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+SUNNYSIDE)' IN BOOLEAN MODE) LIMIT 100, 5050505
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+SUNNYSIDE)' IN BOOLEAN MODE)11769