NEW YORK

1 - 50 of 1382634

DUNCAN PARTNERS LLC

#0039686

EQUIPMENT WORK

NEW YORK

MANHATTAN


MILLENIUM CENTURY CONSTRUCTION

#0032393

EQUIPMENT WORK

NEW YORK

MANHATTAN


MILLENIUM CENTURY CONSTRUCTION

#0032393

EQUIPMENT WORK

NEW YORK

MANHATTAN


ABCO PEERLESS SPRINKLER C

#0000208

EQUIPMENT WORK

NEW YORK

MANHATTAN


ABCO PEERLESS SPRINKLER C

#0000208

EQUIPMENT WORK

NEW YORK

MANHATTAN


N B PLUMBING & HEATING IN

#0000926

EQUIPMENT WORK

NEW YORK

MANHATTAN


METROPOLITAN BUILDING SER

#0602953

EQUIPMENT WORK

NEW YORK

MANHATTAN


DONNELLY MECHANICAL CORP

#0000796

EQUIPMENT WORK

NEW YORK

MANHATTAN


METROPOLITAN BLDG SER LLC

#0602953

EQUIPMENT WORK

NEW YORK

MANHATTAN


METROPOLITAN BLDG SER LLC

#0602953

EQUIPMENT WORK

NEW YORK

MANHATTAN


METROPOLITAN BLDG SER LLC

#0602953

EQUIPMENT WORK

NEW YORK

MANHATTAN


METROPOLITAN BLDG SER LLC

#0602953

EQUIPMENT WORK

NEW YORK

MANHATTAN


METROPOLITAN BLDG SER LLC

#0602953

EQUIPMENT WORK

NEW YORK

MANHATTAN


METROPOLITAN BLDG SER LLC

#0602953

EQUIPMENT WORK

NEW YORK

MANHATTAN


METROPOLITAN BLDG SER LLC

#0602953

EQUIPMENT WORK

NEW YORK

MANHATTAN


METROPOLITAN BLDG SER LLC

#0602953

EQUIPMENT WORK

NEW YORK

MANHATTAN


METROPOLITAN BLDG SER LLC

#0602953

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


N B PLUMBING & HEATING IN

#0000926

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


GEORGE SCHWARZ ARCH. PLLC

#999991

ALTERATION

NEW YORK

MANHATTAN


CS BRIDGE CORP

#0603235

EQUIPMENT

NEW YORK

MANHATTAN


MOTT & PRINCE CONSTRUCTION CORP

#0036924

EQUIPMENT WORK

NEW YORK

MANHATTAN


MOTT & PRINCE CONSTRUCTION CORP

#0036924

EQUIPMENT

NEW YORK

MANHATTAN


STRUCTURE-TONE INC

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


TRIDENT CONTRACTING CORP

#0035665

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE TONE

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


STRUCTURE TONE

#0002660

EQUIPMENT WORK

NEW YORK

MANHATTAN


PREFERRED SPRKLR & MECH C

#0000973

EQUIPMENT WORK

NEW YORK

MANHATTAN


OUTDOOR INSTALLATIONS LLC.

#0031591

EQUIPMENT

NEW YORK

MANHATTAN


TRIDENT CONTRACTING CORP

#0035665

EQUIPMENT WORK

NEW YORK

MANHATTAN


TRIDENT CONTRACTING CORP

#0035665

EQUIPMENT WORK

NEW YORK

MANHATTAN


INTERSTATE FIRE PROTECTION INC

#0000980

EQUIPMENT WORK

NEW YORK

MANHATTAN


CS BRIDGE CORP

#0603235

EQUIPMENT

NEW YORK

MANHATTAN


CS BRIDGE CORP

#0603235

EQUIPMENT

NEW YORK

MANHATTAN


CS BRIDGE CORP

#0603235

EQUIPMENT

NEW YORK

MANHATTAN


MOTT AND PRINCE CONSTRUCTION

#0036924

EQUIPMENT

NEW YORK

MANHATTAN


TRIAD PLBG & MECH CORP

#0001638

PLUMBING

NEW YORK

MANHATTAN


JP LOFLANDS

#0006276

EQUIPMENT WORK

NEW YORK

MANHATTAN


JP LOFLANDS

#0006276

EQUIPMENT

NEW YORK

MANHATTAN


JP LOFLANDS

#0006276

EQUIPMENT WORK

NEW YORK

MANHATTAN


(default) 2 queries took 7763 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 ( '(+NEW +YORK)' IN BOOLEAN MODE) LIMIT 5050503
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+NEW +YORK)' IN BOOLEAN MODE)117760