S.OZONE PARK

151 - 200 of 74903

BRYANT PARK CORPORATION

#0602990

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRYANT PARK CORPORATION

#0602990

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRYANT PARK CORPORATION

#0602990

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRYANT PARK CORPORATION

#0602990

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK CONSTRUCTION CORP

#0003116

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK CONSTRUCTION CORP

#0003116

EQUIPMENT

NEW YORK

MANHATTAN


PARK CONSTRUCTION CORP

#0003116

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK CONSTRUCTION CORP

#0003116

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK CONSTRUCTION CORP

#0003116

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRYANT PARK REST CORP

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK PLUS, INC

#0605719

EQUIPMENT WORK

NEW YORK

MANHATTAN


277 PARK AVE LLC

#

ALTERATION

NEW YORK

MANHATTAN


ADG PARK CONSTRUC GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


ADG PARK CONSTRUC GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


ADG PARK CONSTRUC GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT WORK

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT WORK

NEW YORK

MANHATTAN


ADG PARK CONSTRUC GROUP LLC

#0026247

ALTERATION

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT WORK

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT WORK

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


ADG PARK CONSTRUC GROUP LLC

#0026247

ALTERATION

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


ADG PARK CONSTRUCTION GROUP LLC

#0026247

EQUIPMENT

NEW YORK

MANHATTAN


PARK AVENUE DEV. SVCS LLC

#0601792

EQUIPMENT

NEW YORK

MANHATTAN


APPROVED OIL CO OF BKLYN

#0004273

EQUIPMENT WORK

REGO PARK

QUEENS


APPROVED OIL CO OF BKLYN

#0004273

EQUIPMENT WORK

REGO PARK

QUEENS


APPROVED OIL COMPANY OF

#0037848

EQUIPMENT WORK

REGO PARK

QUEENS


PARK SIDE CONSTR CONTR INC

#0031591

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK PLUS, INC

#0605719

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK EAST CONSTRUCTION

#0005917

ALTERATION

NEW YORK

MANHATTAN


PARK EAST CONSTRUCTION CORP

#0005917

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK EAST CONSTRUCTION CORP

#0005917

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK EAST CONSTRUCTION CORP

#0005917

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK PLUMBING CO INC

#0000161

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK PLUS, INC

#0605719

EQUIPMENT WORK

NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


PARK SIDE CONSTRUCTION CO

#0036613

EQUIPMENT

NEW YORK

MANHATTAN


PARK SIDE CONSTRUCTION CO

#0036613

EQUIPMENT

NEW YORK

MANHATTAN


PRECISION PLBG SVCS., INC

#0001762

PLUMBING


PARK ROYAL MGMT. CORP

#0011450

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK ROYAL MANAGEMENT CORP.

#0011450

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK ROYAL MGMT CORP

#0011450

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK ROYAL OWNER'S INC

#0011450

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK ROYAL OWNER'S INC

#0011450

EQUIPMENT WORK

NEW YORK

MANHATTAN


(default) 2 queries took 3375 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 ( '(+S.OZONE +PARK)' IN BOOLEAN MODE) LIMIT 150, 50505017
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+S.OZONE +PARK)' IN BOOLEAN MODE)113358