OAKLAND GARDENS

151 - 200 of 11100

NA

#

EQUIPMENT WORK



N/A

#0008797

ALTERATION


ACUTE CONSTRUCTION INC

#0026514

NEW BUILDING


ACUTE CONSTRUCTION INC.

#0026514

ALTERATION


ACUTE CONSTRUCTION INC.

#0026514

EQUIPMENT


ACUTE CONSTRUCTION INC.

#0026514

ALTERATION


CALA/SACCO MECHANCIAL INC.

#0001057

PLUMBING


ACUTE CONSTRUCTION INC.

#0029294

EQUIPMENT


WEN WU

#

ALTERATION


ALL CORP

#0029294

ALTERATION


ALL CORP

#0029294

EQUIPMENT


PILOT GREAT CONTR.CORP

#0007159

EQUIPMENT


PILOT GREAT CONTR.CORP

#0007159

FOUNDATION


PILOT GREAT CONTR.CORP

#0007159

FOUNDATION


PILOT GREAT CONTR.CORP

#0007159

ALTERATION


PILOT GREAT CONTR.CORP

#0007159

EQUIPMENT


PILOT GREAT CONTR.CORP

#0007159

ALTERATION


C2 PLUMBING CORP

#0000474

PLUMBING


C2 PLUMBING CORP

#0000474

PLUMBING


S.A.CARADONNA

#0041124

ALTERATION


ALL ISLAND REMODELERS

#

ALTERATION


N/A

#0000754

PLUMBING



WAGWER WEINTRAUB PLG HEATING INC

#0000626

ALTERATION


ZHUO YUE CONSTRUCTION INC

#0604830

EQUIPMENT


ZHUO YUE CONSTRUCTION INC

#0604830

ALTERATION


BRAVO BUILDING SERVICES*

#0603642

EQUIPMENT WORK


TRIBORO PLBNG AND HTG COR

#0001943

PLUMBING


C2 PLUMBING CORP

#0000474

PLUMBING


DUMONT PLG

#0000341

PLUMBING


PETERS CONSTRUCTION GROUP

#0027357

ALTERATION


PETERS CONSTRUCTION GROUP

#0027357

ALTERATION


SENID PL & HTG CORP

#0001220

PLUMBING


D/B/A/ K.H. CONSTRUCTION

#0022577

ALTERATION


JENESY AMERICA INC

#0025581

ALTERATION



ELMWOOD PLG & HTG

#0000803

PLUMBING


N/A

#0001386

PLUMBING


HOUSECRAFT REMODELERS CORP.

#

EQUIPMENT WORK


KEW FOREST PLG AND HEATING

#0001525

PLUMBING


KEW FOREST PLG AND HEATING

#0001525

EQUIPMENT WORK


GORDON ENVIRINMENT & MECHANICAL

#0001074

ALTERATION


GORDON ENVIRINMENT & MECHANICAL

#0001074

ALTERATION


BILLY CONTRACTORS

#0014789

EQUIPMENT


BILLY CONTRACTORS

#0014789

EQUIPMENT


BILLY CONTRACTORS

#0014789

EQUIPMENT


BILLY CONTRACTORS

#0014789

EQUIPMENT


N/A

#

ALTERATION


HIP HING CONSTR.CO.INC

#

ALTERATION


(default) 2 queries took 735 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 ( '(+OAKLAND +GARDENS)' IN BOOLEAN MODE) LIMIT 150, 5050506
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+OAKLAND +GARDENS)' IN BOOLEAN MODE)11729