JACKSON HEIGHTS

1 - 50 of 16369

BAYVIEW PLBG & HTG CORP

#0002222

PLUMBING


BEST DESIGN CONSTRU CO

#0606553

EQUIPMENT


JEN FU CONSTRUCTION INC

#0013992

EQUIPMENT WORK


QMB PLUMBING & HEATING IN

#0001892

EQUIPMENT WORK


QMB PLUMBING & HEATING IN

#0001892

PLUMBING


NASK BUILDERS INC

#0027019

ALTERATION


A&A BUILDING CONSULTANTS

#0039605

EQUIPMENT WORK


A&A BUILDING CONSULTANTS

#0039605

EQUIPMENT WORK


ATTACK PLUMBING INC

#0001531

PLUMBING



J.D. MASTERS PLUMB. AND HEATING

#0001345

EQUIPMENT WORK


UNITED COOLING & HEATING INC.

#0013432

EQUIPMENT WORK


UNITED COOLING & HEATING INC.

#0013432

EQUIPMENT WORK


PASSEGGIOS PLG & HTG

#0001886

PLUMBING


A.B LAUNDRY CORP

#0000143

EQUIPMENT


A.B LAUNDRY CORP

#0000143

EQUIPMENT WORK


A.B LAUNDRY CORP

#0000143

EQUIPMENT WORK


UNIVERSAL DESIGN & CONSTR

#0608057

EQUIPMENT WORK


SKYLINE DEVELOPMENT GRP LLC

#0024812

EQUIPMENT


NY PREFERRED CONSTRUCTION

#0600083

ALTERATION


PETER MICELI PLG

#0001824

PLUMBING


CHIEF FIRE PREVENTION & MECHANIC

#0000814

EQUIPMENT WORK


CHRIS OWEN PLG & HTG INC

#0001358

PLUMBING


NEW YORK BUSINESS FIRE SYSTEM IN

#0000504

EQUIPMENT WORK


ALLIED FIRE CONTROL

#0000336

EQUIPMENT WORK


HUDSON DEVELOPMENT & CONST.

#

EQUIPMENT WORK


SUN LIGHT CONST

#

ALTERATION


SKYLINE DEVELOPMENT GROUP LLC

#0024812

ALTERATION


PETER MICELI PLUMBING

#0001824

PLUMBING



FAMILY AWING INC

#0026482

ALTERATION


CK PRO GLASS CORP

#0019842

ALTERATION


ATLANTIC SCAFFOLDING

#

EQUIPMENT


YORK SCAFFOLD EQUIPMENT

#0002450

EQUIPMENT


#

EQUIPMENT


#

EQUIPMENT WORK


ARCH BUILDERS INC

#0027450

EQUIPMENT WORK


VINCESKY & MAY PLUMB & HTG LLC

#0001505

PLUMBING


NEW YORK SIGN CITY INC.

#0000145

SIGN


#

SIGN


NORTH EASTERN CONTRACTING CO

#

EQUIPMENT WORK


NORTH EASTERN CONTRACTING CO

#

EQUIPMENT WORK


MAINLAND PLG AND HEATING

#0000404

PLUMBING


SENTINEL FIRE CONTROL INC

#0000230

EQUIPMENT WORK


CITY FIRE CONTROL INC.

#

EQUIPMENT WORK


HUDSON DEVELOPMENT & CONSTR.

#

EQUIPMENT WORK


MAGOR PLUMBING & HEATING

#0001119

PLUMBING


#

ALTERATION


ELITE HEATING AND COOLING

#0002719

EQUIPMENT WORK


ELITE HEATING AND COOLING

#0002719

EQUIPMENT WORK


(default) 2 queries took 485 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 ( '(+JACKSON +HEIGHTS)' IN BOOLEAN MODE) LIMIT 5050504
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+JACKSON +HEIGHTS)' IN BOOLEAN MODE)11481