NEW YORK

251 - 300 of 1382634

UNIVERSAL CONST

#0002390

EQUIPMENT WORK

NEW YORK

MANHATTAN


COSTROTTA CONSTR.

#0008516

EQUIPMENT WORK

NEW YORK

MANHATTAN


ACCESS PLUMBING CORP.

#0001688

PLUMBING

NEW YORK

MANHATTAN


IBK ENTERPRISES INC

#0003758

EQUIPMENT WORK

NEW YORK

MANHATTAN


IBK ENTERPRISES INC

#0003758

EQUIPMENT WORK

NEW YORK

MANHATTAN


IBK ENTERPRISES INC

#0003758

EQUIPMENT

NEW YORK

MANHATTAN


IBK ENTERPRISES INC

#0003758

EQUIPMENT WORK

NEW YORK

MANHATTAN


IBK ENTERPRISES INC

#0003758

EQUIPMENT WORK

NEW YORK

MANHATTAN


IBK ENTERPRISES INC

#0003758

EQUIPMENT

NEW YORK

MANHATTAN


M Y SHEET METAL CORP

#0018178

EQUIPMENT WORK

NEW YORK

MANHATTAN


SMART PLUMBING & HEATING CORP

#0000708

EQUIPMENT WORK

NEW YORK

MANHATTAN


SMART PLUMBING & HEATING CORP

#0001250

PLUMBING

NEW YORK

MANHATTAN


SKINNER INTERIORS

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


RANGER PLG INC

#0001270

PLUMBING

NEW YORK

MANHATTAN


SEASONS CONTR. CORP.

#0008433

EQUIPMENT

NEW YORK

MANHATTAN


GJF CONSTRUCTION CORP

#0001056

EQUIPMENT WORK

NEW YORK

MANHATTAN


GJF CONSTRUCTION CORP

#0001056

EQUIPMENT WORK

NEW YORK

MANHATTAN


JBS GROUP

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


KINGS STAR CONSTRUCTION C

#0607573

EQUIPMENT WORK

NEW YORK

MANHATTAN


SING CONSTRUCTION, INC

#0024858

EQUIPMENT WORK

NEW YORK

MANHATTAN


WELLBILT EQUIPMENT CORP

#0002779

EQUIPMENT

NEW YORK

MANHATTAN


WELLBILT EQUIPMENT CORP

#0002779

EQUIPMENT WORK

NEW YORK

MANHATTAN


WELLBILT EQUIPMENT CORP

#0002779

EQUIPMENT WORK

NEW YORK

MANHATTAN


CHINATOWN_PLUMMING_&_HEATING

#0001135

PLUMBING

NEW YORK

MANHATTAN


ALLIED FIRE CONTROL SVCS

#0000336

EQUIPMENT WORK

NEW YORK

MANHATTAN


APOLLO 11 INDUSTRIES INC

#0009597

EQUIPMENT WORK

NEW YORK

MANHATTAN


APOLLO 11 INDUSTRIES INC

#0009597

EQUIPMENT WORK

NEW YORK

MANHATTAN


CHINATOWN PLUMBING &HEATING,INC.

#0000545

EQUIPMENT WORK

NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


BETA PLUMBING & HTNG CORP

#0001671

PLUMBING

NEW YORK

MANHATTAN


CHINATOWN PLBG & HTG INC

#0001135

PLUMBING

NEW YORK

MANHATTAN


CITY FIRE CONTROL INC

#CL "

EQUIPMENT WORK

NEW YORK

MANHATTAN


ATLANTIC SCAFFOLDING

#

EQUIPMENT

NEW YORK

MANHATTAN


SPRING SCAFFOLDING LLC

#0607447

EQUIPMENT

NEW YORK

MANHATTAN


CRO-INTERNATIONAL INC

#0601302

EQUIPMENT WORK

NEW YORK

MANHATTAN


J & F NYS CONTRACTING INC

#0603858

EQUIPMENT WORK

NEW YORK

MANHATTAN


BOLD & BOLT VISUAL, CORP

#0000218

SIGN

NEW YORK

MANHATTAN


CIRCLE PLUMBING CORP

#0001350

EQUIPMENT WORK

NEW YORK

MANHATTAN


FULL CIRCLE CONSTRUCTION OF NY

#0023976

EQUIPMENT WORK

NEW YORK

MANHATTAN


ATLANTIC WATER AND SEWER INC

#0001511

PLUMBING

NEW YORK

MANHATTAN


FULL CIRCL CONSTR OF NY LLC

#0023976

EQUIPMENT WORK

NEW YORK

MANHATTAN


FULL CIRCL CONSTR OF NY LLC

#0023976

EQUIPMENT WORK

NEW YORK

MANHATTAN


GREAT CITY PLBG & HTG CORP

#0001350

PLUMBING

NEW YORK

MANHATTAN


FRED M SCHILDWACHTER

#0002591

EQUIPMENT WORK

NEW YORK

MANHATTAN


FRED M SCHILDWACHTER

#0002591

EQUIPMENT WORK

NEW YORK

MANHATTAN


OUTDOOR INSTALLATIONS LLC

#0031591

EQUIPMENT

NEW YORK

MANHATTAN


OUTDOOR INSTALLATIONS LLC

#0031591

EQUIPMENT

NEW YORK

MANHATTAN


SPRING SCAFFOLDING LLC

#0607447

EQUIPMENT

NEW YORK

MANHATTAN


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