SUNNYSIDE

201 - 250 of 9197

PAL MASONRY, INC.

#

ALTERATION

SUNNYSIDE

QUEENS


AGEE HEATING SERVICE CORP.

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


RB HTG CONSULTING GPOUP

#0005292

EQUIPMENT WORK

SUNNYSIDE

QUEENS


RB HTG CONSULTING GPOUP

#0005292

EQUIPMENT WORK

SUNNYSIDE

QUEENS


RB HTG CONSULTING GPOUP

#0005292

EQUIPMENT WORK

SUNNYSIDE

QUEENS


PAR PLUMBING CO., INC

#0037096

EQUIPMENT WORK

SUNNYSIDE

QUEENS


GOLDEN TOUCH CONST. CORP.

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


N/A

#0009435

PLUMBING

SUNNYSIDE

QUEENS


LNC INTERNATIONAL INC

#0602242

EQUIPMENT WORK

SUNNYSIDE

QUEENS


LNC INTERNATIONAL INC

#0602242

EQUIPMENT WORK

SUNNYSIDE

QUEENS


LNC INTERNATIONAL INC

#0602242

EQUIPMENT

SUNNYSIDE

QUEENS


LNC INTERNATIONAL INC

#0602242

EQUIPMENT WORK

SUNNYSIDE

QUEENS


GOLDEN TOUCH CONST. CORP.

#0004212

EQUIPMENT WORK

SUNNYSIDE

QUEENS


PAR PLUMBING CO., INC

#0000161

PLUMBING

SUNNYSIDE

QUEENS


PUBLIC FUEL SVC.CO.

#0005215

EQUIPMENT WORK

SUNNYSIDE

QUEENS


PUBLIC FUEL SVC.CO.

#0005215

EQUIPMENT WORK

SUNNYSIDE

QUEENS


LNC INTERNATIONAL INC

#0602242

EQUIPMENT WORK

SUNNYSIDE

QUEENS


CUBE PLUS, INC

#0035520

EQUIPMENT WORK

SUNNYSIDE

QUEENS


CUBE PLUS, INC

#0035520

EQUIPMENT WORK

SUNNYSIDE

QUEENS


CUBE PLUS, INC

#0035520

EQUIPMENT WORK

SUNNYSIDE

QUEENS


CRU MECH 7 HTG INC

#0001485

PLUMBING

SUNNYSIDE

QUEENS


CUBE PLUS, INC

#0035520

EQUIPMENT WORK

SUNNYSIDE

QUEENS


CUBE PLUS, INC

#0035520

EQUIPMENT WORK

SUNNYSIDE

QUEENS


CRU MECHANICAL

#0001485

PLUMBING

SUNNYSIDE

QUEENS


UNITECH DESIGN INC

#0025984

ALTERATION

SUNNYSIDE

QUEENS


KORMAN DESIGN & BUIL

#0001362

ALTERATION

SUNNYSIDE

QUEENS


KORMAN DESIGN AND BUILD

#0001362

ALTERATION

SUNNYSIDE

QUEENS


PETER PLUMBING ASSOC. INC

#0001876

PLUMBING

SUNNYSIDE

QUEENS


KORMAN DESIGN & BUILD

#0001362

ALTERATION

SUNNYSIDE

QUEENS


KORMAN DESIGN & BUILD

#0001362

EQUIPMENT WORK

SUNNYSIDE

QUEENS


KORMAN DESIGN & BUILD

#0001362

EQUIPMENT WORK

SUNNYSIDE

QUEENS


NEW YORK BUSINESS FIRE SYSTEM IN

#0000504

EQUIPMENT WORK

SUNNYSIDE

QUEENS


PETER PLUMBING ASSOC. INC

#0001876

PLUMBING

SUNNYSIDE

QUEENS


NAYCI CNTRCTING ASSOC LLC

#0035174

ALTERATION

SUNNYSIDE

QUEENS


NAYCI CNTRCTING ASSOC LLC

#0035174

ALTERATION

SUNNYSIDE

QUEENS


K&K INTERIOR DESIGN LLC

#0607138

ALTERATION

SUNNYSIDE

QUEENS


GENET PLBG & HTG CORP

#0001400

PLUMBING

SUNNYSIDE

QUEENS


PINNACLE PLBG & HTG CORP

#0001624

PLUMBING

SUNNYSIDE

QUEENS


CHIEF FIRE PREVENTION & FILTER

#0000389

EQUIPMENT WORK

SUNNYSIDE

QUEENS


N/A

#

ALTERATION

SUNNYSIDE

QUEENS


FIRE COMMAND CO INC

#0000136

EQUIPMENT WORK

SUNNYSIDE

QUEENS


NEW YORK SIGN CITY INC

#0019149

ALTERATION

SUNNYSIDE

QUEENS


DBA BHI INC

#0001310

PLUMBING

SUNNYSIDE

QUEENS


NOVA PLUMBING & HEATING INC.

#0000556

EQUIPMENT WORK

SUNNYSIDE

QUEENS


A TO Z NORMN AVE

#

ALTERATION

SUNNYSIDE

QUEENS


ERGEN FUEL OIL CO.

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


MRE AIR MECH

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


MRE AIR MECH

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


SUNNYSIDE

QUEENS


N/A

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


(default) 2 queries took 800 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 200, 5050506
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+SUNNYSIDE)' IN BOOLEAN MODE)11794