EAST ELMHURST

1 - 50 of 13672

NICCON CONSTRUCTION INC

#0034702

ALTERATION

EAST ELMHURST

QUEENS


N&D PLB & HTG CORP

#0001570

PLUMBING

EAST ELMHURST

QUEENS


GMP CONSTRUCTION SOLUTIONS LTD

#0036849

EQUIPMENT

EAST ELMHURST

QUEENS


GMP CONSTRUCTION SOLUTIONS LTD

#0036849

ALTERATION

EAST ELMHURST

QUEENS


VALUE PLUMBING INC

#0000747

PLUMBING

EAST ELMHURST

QUEENS


OLYPUS GENERAL CONSTRUCTION CORP

#0001744

EQUIPMENT WORK

EAST ELMHURST

QUEENS


DNA PLUMBING CONTRACTORS

#0001343

PLUMBING

EAST ELMHURST

QUEENS


BROWN PLG

#0001094

PLUMBING

EAST ELMHURST

QUEENS


KANTEX CONSTRUCTION CO

#0034009

EQUIPMENT WORK

EAST ELMHURST

QUEENS


MARCO POLO DESIGN CORP

#0605718

ALTERATION

EAST ELMHURST

QUEENS


#

PLUMBING

EAST ELMHURST

QUEENS


CITY PLUMBING & HTG CORP

#0001701

PLUMBING

East Elmhurst

QUEENS


SCHERILLO &SONS CONSTRUCTION

#0009201

EQUIPMENT

East Elmhurst

QUEENS


SCHERILLO &SONS CONSTRUCTION

#0009201

NEW BUILDING

East Elmhurst

QUEENS


FELICONI DEVELOPMENT CORP

#0039292

FULL DEMOLITION

EAST ELMHURST

QUEENS


FELICONI DEVELOPMENT CORP

#0039292

EQUIPMENT

EAST ELMHURST

QUEENS


FELICONI DEVELOPMENT CORP

#0039292

FULL DEMOLITION

EAST ELMHURST

QUEENS


TAN DEVELOPMENT, LLC

#0608213

EQUIPMENT

East Elmhurst

QUEENS


TAN DEVELOPMENT, LLC

#0608213

NEW BUILDING

East Elmhurst

QUEENS


TAN DEVELOPMENT, LLC

#0608213

NEW BUILDING

East Elmhurst

QUEENS


TAN DEVELOPMENT, LLC

#0608213

EQUIPMENT

East Elmhurst

QUEENS


BTON LLC

#0604969

NEW BUILDING

East Elmhurst

QUEENS


BTON LLC

#0604969

EQUIPMENT

East Elmhurst

QUEENS


BTON LLC

#0604969

NEW BUILDING

East Elmhurst

QUEENS


BTON LLC

#0604969

EQUIPMENT

East Elmhurst

QUEENS


VERA CONSTRUCTION INC

#0031159

NEW BUILDING

East Elmhurst

QUEENS


VERA CONSTRUCTION INC

#0031159

EQUIPMENT

East Elmhurst

QUEENS


VERA CONSTRUCTION INC

#0031159

FULL DEMOLITION

EAST ELMHURST

QUEENS


VERA CONSTRUCTION INC

#0031159

EQUIPMENT

EAST ELMHURST

QUEENS


VERA CONSTRUCTION INC

#0031159

FULL DEMOLITION

EAST ELMHURST

QUEENS


CALA/SACCO-MECHANICAL INC

#0001057

PLUMBING

East Elmhurst

QUEENS


BARTELLINO CONSTRUCTION C

#0601684

EQUIPMENT

EAST ELMHURST

QUEENS


BARTELLINO CONSTRUCTION C

#0601684

FULL DEMOLITION

EAST ELMHURST

QUEENS


COBALT ENGINEERING

#0015403

ALTERATION

EAST ELMHURST

QUEENS


COBALT ENGINEERING

#0015403

EQUIPMENT WORK

EAST ELMHURST

QUEENS


N/A

#0999994

EQUIPMENT WORK

EAST ELMHURST

QUEENS


CN PLUMBING INC.

#0001252

PLUMBING

EAST ELMHURST

QUEENS


THE PLUMBING COMPANY INC

#0000626

PLUMBING

EAST ELMHURST

QUEENS


GOLDSMITH CONSTRUCTION CORP

#0029263

ALTERATION

EAST ELMHURST

QUEENS


A INTERNATIONAL LTD

#0999994

ALTERATION

EAST ELMHURST

QUEENS


EAST ELMHURST

QUEENS


EAST ELMHURST

QUEENS


A. INTERNATIONAL, LTD

#0012333

ALTERATION

EAST ELMHURST

QUEENS


A. INTERNATIONAL, LTD

#0012333

ALTERATION

EAST ELMHURST

QUEENS


SATELLITE EAST PLUMBING INC

#0001715

PLUMBING

EAST ELMHURST

QUEENS


AXIAL CONSTRUCTION CORP.

#0007787

ALTERATION

EAST ELMHURST

QUEENS


AXIAL CONSTRUCTION CORP.

#0007787

ALTERATION

EAST ELMHURST

QUEENS


LUVER PLG & HTG

#0001347

PLUMBING

EAST ELMHURST

QUEENS


RICKY CONSTRUCTION CO INC

#0011054

ALTERATION

EAST ELMHURST

QUEENS


WAGNER ZIV PLG & HTG

#0009435

PLUMBING

EAST ELMHURST

QUEENS


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