S.OZONE PARK

251 - 300 of 74903

NEW YORK

MANHATTAN


ORION PLUMBING & HTG CORP

#0001350

PLUMBING


HWANG & PARK DESIGN AND

#0602711

EQUIPMENT WORK

NEW YORK

MANHATTAN


HWANG & PARK DESIGN AND

#0602711

ALTERATION

NEW YORK

MANHATTAN


HWANG & PARK DESIGN AND

#0602711

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK CAKE INC L EXPRESS

#0014288

EQUIPMENT WORK

NEW YORK

MANHATTAN


ARK BRYANT PARK CORP

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK HOLTZER CONSTRUCTION LLC

#0033934

EQUIPMENT WORK

NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


SHAW PARK CORP INC

#0029577

ALTERATION

NEW YORK

MANHATTAN


PARK AVE HALL HDFC

#

ALTERATION

NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


254 PARK AVE SOUTH/RENOV 80 LTD

#0004438

ALTERATION

NEW YORK

MANHATTAN


RAPIED PARK INDUST.

#

ALTERATION

NEW YORK

MANHATTAN


SHAW PARK CORP INC

#0029577

EQUIPMENT WORK

NEW YORK

MANHATTAN


SHAW PARK CONSTR MGT

#0016228

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK AVE INTERIORS

#0013169

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK AVE INTERIORS

#0020500

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK PLUMB CO

#0000161

PLUMBING

NEW YORK

MANHATTAN


PARK AVE CONTRACTING

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


MORRIS PARK CONTRACTING CORP.

#0011500

FULL DEMOLITION

NEW YORK

MANHATTAN


MORRIS PARK CONTRACTING CORP.

#0011500

EQUIPMENT

NEW YORK

MANHATTAN


PARK FERRY INC

#0011071

EQUIPMENT

NEW YORK

MANHATTAN


PARK FERRY INC

#0011071

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK FERRY INC

#0011071

EQUIPMENT WORK

NEW YORK

MANHATTAN


PARK FERRY ,INC.

#0011071

ALTERATION

NEW YORK

MANHATTAN


PARK FERRY ,INC.

#0011071

ALTERATION

NEW YORK

MANHATTAN


PARK 75 GOURMET FOOD CO

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


823 PARK AVENUE LLC

#0038058

ALTERATION

NEW YORK

MANHATTAN


823 PARK AVENEU,LLC

#0038058

EQUIPMENT WORK

NEW YORK

MANHATTAN


823 PARK AVENUE LLC.

#0038058

ALTERATION

NEW YORK

MANHATTAN


823 PARK AVENUE LLC.

#0038058

ALTERATION

NEW YORK

MANHATTAN


823 PARK AVENUE, LLC.

#0038058

EQUIPMENT WORK

NEW YORK

MANHATTAN


823 PARK AVENUE, LLC.

#0038058

EQUIPMENT WORK

NEW YORK

MANHATTAN


823 PARK AVENUE, LLC.

#0038058

EQUIPMENT WORK

NEW YORK

MANHATTAN


823 PARK AVENUE, LLC.

#0038058

EQUIPMENT WORK

NEW YORK

MANHATTAN


B PARK CORP

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


B PARK CORP

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


MOUNT MORRIS PARK DENTAL

#0605135

ALTERATION

NEW YORK

MANHATTAN


1145 PARK CORP

#

ALTERATION

NEW YORK

MANHATTAN


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