SOUTH OZONE PARK

1 - 50 of 16140

PRECISION PLBG SVCS., INC

#0001762

PLUMBING


STANLEY LEWIS CONTR, CORP

#0001983

PLUMBING


ORION PLUMBING & HTG CORP

#0001350

PLUMBING


C2 PLUMBING CORP

#0000860

EQUIPMENT WORK


SHEA BUILDING CORP

#

ALTERATION



WINNLEY CONSTRUCTION CO.

#

EQUIPMENT WORK


ACE CONTRACTING CORP.

#0000601

EQUIPMENT WORK


ACE CONTRACTING CORP.

#0000601

PLUMBING


TC DESIGN & CONST

#

EQUIPMENT WORK


TC DESIGN & CONST

#

EQUIPMENT WORK


TC DESIGN & CONST

#

EQUIPMENT WORK


DUO COLONY FUEL OIL CORP

#

EQUIPMENT WORK


DUO COLONY FUEL OIL CORP

#

EQUIPMENT WORK


J.V. PIPER & SPROTTE, INC.

#0000316

PLUMBING


MAGOR PLUMBING & HEATING

#0001119

PLUMBING


US REGAL CONTRACTORS INC

#0607089

EQUIPMENT


CUSTOMBUILT HOMES INC

#0036215

NEW BUILDING


CUSTOMBUILT HOMES INC

#0036215

NEW BUILDING


CUSTOMBUILT HOMES INC

#0036215

EQUIPMENT


W.R. PLBG AND HTG CORP

#0001956

PLUMBING


W.R. PLBG AND HTG CORP

#0001956

PLUMBING


MRM DEVELOPMENT CORP

#0031889

FOUNDATION


MRM DEVELOPMENT CORP

#0031889

EQUIPMENT


MRM DEVELOPMENT CORP

#0031889

FOUNDATION


CUSTOMBUILT HOMES INC

#0036215

EQUIPMENT


CUSTOMBUILT HOMES INC

#0036215

NEW BUILDING


CUSTOMBUILT HOMES INC

#0036215

NEW BUILDING


CUSTOMBUILT HOMES INC

#0036215

FOUNDATION


CUSTOMBUILT HOMES INC

#0036215

FOUNDATION


CUSTOMBUILT HOMES INC

#0036215

NEW BUILDING


CUSTOMBUILT HOMES INC

#0036215

NEW BUILDING


CUSTOMBUILT HOMES INC

#0036215

EQUIPMENT


W.R. PLBG AND HTG CORP

#0001956

PLUMBING


W.R. PLBG AND HTG CORP

#0001956

PLUMBING


EVEREST CONSTRUCTION DEVE

#0002482

EQUIPMENT


EVEREST CONSTRUCTION DEVE

#0002482

NEW BUILDING


21 PLUMBING & HEATING INC

#0002173

PLUMBING


W.R. PLBG AND HTG CORP

#0001956

PLUMBING


JRS CONSTRUCTION & EXPEDI

#0601448

NEW BUILDING


JRS CONSTRUCTION & EXPEDI

#0601448

EQUIPMENT


CONSTRUX LLC

#0035230

EQUIPMENT


CONSTRUX LLC

#0035230

NEW BUILDING


CONSTRUX LLC

#0035230

FOUNDATION


CONSTRUX LLC

#0035230

FOUNDATION


EVEREST CONSTRUCTION DEVE

#0002482

NEW BUILDING


EVEREST CONSTRUCTION DEVE

#0002482

EQUIPMENT


21 PLUMBING & HEATING INC

#0002173

PLUMBING


W.R. PLBG AND HTG CORP

#0001956

PLUMBING


JRS CONSTRUCTION & EXPEDI

#0601448

NEW BUILDING


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