SUNNYSIDE

351 - 400 of 9197

SUNNYSIDE

QUEENS


SUNNYSIDE

QUEENS


LURGANBOY CORP.

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


ATLANTIC SCAFFOLD

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


J BARONE & CO INC

#0000495

PLUMBING

SUNNYSIDE

QUEENS


LURGANBOY CORP

#

EQUIPMENT

SUNNYSIDE

QUEENS


LURGANBOY CORP

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


LURGANBOY CORP

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


FIRE COMMAND CO, INC

#0000136

EQUIPMENT WORK

SUNNYSIDE

QUEENS


ALFRED C. COLLINS

#0000337

EQUIPMENT WORK

SUNNYSIDE

QUEENS


PFEIFFER P,HTG,SPKL CONT

#0000335

PLUMBING

SUNNYSIDE

QUEENS


SUNSET PLBG & FIRE PROT

#0001199

PLUMBING

SUNNYSIDE

QUEENS


THREE STAR CONSTRUCTION C

#0028689

EQUIPMENT

SUNNYSIDE

QUEENS


THREE STAR CONSTRUCTION C

#0028689

EQUIPMENT WORK

SUNNYSIDE

QUEENS


THREE STAR CONSTRUCTION C

#0028689

EQUIPMENT WORK

SUNNYSIDE

QUEENS


LLOYD G DRUMMOND PLBG&GEN

#0001386

PLUMBING

SUNNYSIDE

QUEENS


SUNNYSIDE

QUEENS


QUACO P¢LG & HTG

#0000712

PLUMBING

SUNNYSIDE

QUEENS


CHAMPION COMPACTORS

#

EQUIPMENT WORK

SUNNYSIDE

QUEENS


DUO COLONY FUEL OIL CORP.

#0004212

EQUIPMENT WORK

SUNNYSIDE

QUEENS


D & L PLUMBING & HEATING

#0007718

EQUIPMENT WORK

SUNNYSIDE

QUEENS


MILAZIM PULATANI

#0034135

EQUIPMENT WORK

SUNNYSIDE

QUEENS


STAR INDUSTRIAL SERVICE CO. INC.

#0002635

EQUIPMENT WORK

SUNNYSIDE

QUEENS


STAR INDUSTRIAL CO. INC.

#0002635

EQUIPMENT WORK

SUNNYSIDE

QUEENS


JOSEPH FERRIGNO PLUMBING & HTG

#0000256

PLUMBING

SUNNYSIDE

QUEENS


CASINO DEVELOPMENT CORP

#0023624

EQUIPMENT

SUNNYSIDE

QUEENS


CASINO DEVELOPMENT CORP

#0023624

EQUIPMENT WORK

SUNNYSIDE

QUEENS


GOLDSMITH CONSTRUCTION CORP

#0029263

EQUIPMENT WORK

SUNNYSIDE

QUEENS


HARVARD PLG

#0001610

PLUMBING

SUNNYSIDE

QUEENS


GANMAR REALTY

#0999994

EQUIPMENT WORK

SUNNYSIDE

QUEENS


JSEO STUDIO INC

#0607964

EQUIPMENT WORK

SUNNYSIDE

QUEENS


STARTEC MECHANICAL LLC

#0038441

EQUIPMENT WORK

SUNNYSIDE

QUEENS


KORMAN DESIGN & BUILD

#0001362

EQUIPMENT WORK

SUNNYSIDE

QUEENS


Sunnyside

QUEENS


PISTILLI CONSTRUCTION & DEV CORP

#0008021

EQUIPMENT WORK

Sunnyside

QUEENS


KORMAN DESIGN & BUILD

#0001362

EQUIPMENT WORK

SUNNYSIDE

QUEENS


KORMANN DESIGN & BUILD

#0001362

EQUIPMENT

SUNNYSIDE

QUEENS


KORMANN DESIGN & BUILD

#0001362

EQUIPMENT WORK

SUNNYSIDE

QUEENS


NEW YORK SIGN CONTR

#0000218

SIGN

SUNNYSIDE

QUEENS


UNITECH DESIGN INC DBA SPACESIGN

#0025984

ALTERATION

SUNNYSIDE

QUEENS


T-REX PLBG & HTG INC

#0010387

PLUMBING

SUNNYSIDE

QUEENS


CUSTOM CABINETS LTD

#0032312

EQUIPMENT WORK

SUNNYSIDE

QUEENS


BERGER SIGN INC.

#0000155

SIGN

SUNNYSIDE

QUEENS


SUNNYSIDE

QUEENS


EAST COAST CUSTOM CONTACTING INC

#0037274

ALTERATION

SUNNYSIDE

QUEENS


CUSTOM CABINETS LTD

#0032312

EQUIPMENT WORK

SUNNYSIDE

QUEENS


ACTION AWNING & SIGN CORP

#0006989

ALTERATION

SUNNYSIDE

QUEENS


B & J FIRE INC. T/A/ FIREMASTER

#0000228

EQUIPMENT WORK

SUNNYSIDE

QUEENS


UNITECH DESIGN INC

#0025984

ALTERATION

SUNNYSIDE

QUEENS


SASCO WATERPROFING CO. INC

#0015307

ALTERATION

SUNNYSIDE

QUEENS


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