OAKLAND GARDENS

51 - 100 of 11100

AMC ENGINEERING

#0035996

EQUIPMENT WORK


N/A

#

EQUIPMENT WORK


STEPHEN THORPE INC

#0000993

PLUMBING


AMC ENGINEERING PLLC

#0035996

EQUIPMENT WORK


AMC ENGINEERING PLLC

#0035996

EQUIPMENT WORK


POPULAR PLBG & HTG

#0001399

PLUMBING


CHENG JIAN CONSTRUCTION

#0014459

ALTERATION


CHENG JIAN CONSTRUCTION

#0014459

NEW BUILDING


CHENG JIAN CONSTRUCTION

#0014459

NEW BUILDING


CHENG JIAN CONSTRUCTION

#0014459

EQUIPMENT


LIVE IN STYLE CONSTRUCTION CORP

#0006450

ALTERATION


T.M.J. PLUMBING & HEATING

#0009086

PLUMBING


VALUE PLUMBING INC

#0000747

PLUMBING


AMAR CONSTRUCTION CC

#0002576

ALTERATION


AQUEDUCT PLBG & MECH. COR

#0001285

PLUMBING


HUA NENG DECORATION & CON

#0600744

ALTERATION


HUA NENG DECORATION & CON

#0600744

NEW BUILDING


HUA NENG DECORATION & CON

#0600744

NEW BUILDING


HUA NENG DECORATION & CON

#0600744

FOUNDATION


HUA NENG DECORATION & CON

#0600744

FOUNDATION


HUA NENG DECORATION & CON

#0600744

EQUIPMENT


HUA NENG DECORATION & CON

#0600744

FOUNDATION


HUA NENG DECORATION & CON

#0600744

FOUNDATION


HUA NENG DECORATION & CON

#0600744

ALTERATION


CALA/SACCO-MECHANICAL INC

#0001057

PLUMBING


CALA/SACCO-MECHANICAL INC

#0001057

PLUMBING


CHAMP PLUMBING & HTG CORP

#0001701

PLUMBING


CHAMP PLUMBING & HTG CORP

#0001701

PLUMBING


GOLDEN ROCK DESIGNS

#

ALTERATION


WIND STAR CONSTRUCTION CORP

#0014325

NEW BUILDING


WASOFF PLG & UTILITY CO. INC.

#0000868

PLUMBING


WIND STAR CPNSTRUCTION CORP

#0014325

EQUIPMENT


WIND STAR CPNSTRUCTION CORP

#0014325

NEW BUILDING


SANO CONSTRUCTION CORP

#0013328

FULL DEMOLITION


SANO CONSTRUCTION CORP

#0013328

EQUIPMENT


SANO CONSTRUCTION CORP

#0013328

FULL DEMOLITION


WINDSTAR CONST CORP RP

#0014325

NEW BUILDING


WINDSTAR CONST CORP RP

#0014325

NEW BUILDING


WINDSTAR CONST CORP RP

#0014325

EQUIPMENT


WINDSTAR CONST CORP RP

#0014325

EQUIPMENT


WINDSTAR CONST CORP RP

#0014325

NEW BUILDING


WINDSTAR CONST CORP RP

#0014325

NEW BUILDING


LI SHIGN LAM CO

#0001888

PLUMBING


SPRING CONSTRUCTION

#0024223

ALTERATION


N/A

#

ALTERATION


CITY K MECHANICAL CORP.

#0002678

ALTERATION


MAINLAND PLBG. & HTG. INC.

#0000404

PLUMBING


BABEL DESIGN INC

#0016750

EQUIPMENT WORK


VARATECH INDUSTRRIES INCNC

#0024051

FULL DEMOLITION


VARATECH INDUSTRRIES INCNC

#0024051

EQUIPMENT


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