SPRINGFIELD GARDENS

351 - 400 of 11853

MARIO AND NINO CONSTRUCTION CORP

#0001518

EQUIPMENT WORK


SAME

#

ALTERATION


A & R HOME IMPROVEMENT CO

#0031445

EQUIPMENT WORK


K&K IMPROVEMENT

#0022968

ALTERATION


THE PLUMBING COMPANY

#0000626

PLUMBING


CARIBBEAN CONTRACTING COR

#0019469

ALTERATION


CRU MECHANICAL & HTG INC

#0001485

PLUMBING


NEW CASTLE CONSULTING CO

#0035206

ALTERATION


S.J. VISION & SON PLG. & HTG

#0002016

PLUMBING


PRO WORK CONSTRUCTION INC.

#0026736

ALTERATION


PRO WORK CONSTRUCTION INC.

#0026736

ALTERATION


S.J. VISION & SON P & H HTG

#0002016

PLUMBING


N/A

#

ALTERATION


J.S. RESTORATION USA INC

#0602396

EQUIPMENT WORK


CLASSIQUE CONSTRUCTION & DESIGN

#0017258

EQUIPMENT WORK


LENNY & RABBY CONSTR

#0034748

ALTERATION


LENNY & RABBY CONSTR

#0034748

EQUIPMENT


LLOYD DRUMMOND PLUMBING

#0001386

PLUMBING


ANTHONEY G. ANDERSON

#0605843

ALTERATION


ANTHONEY.G ANDERSON

#0605843

ALTERATION


ROCK E SMALL PLBG&HTG INC

#0001864

PLUMBING


ROCK E SMALL PLBG&HTG INC

#0001864

PLUMBING


SKYWAY PLG AND HEATING

#0000728

PLUMBING




N/A

#

ALTERATION


ERNIE'S CARPENTRY

#0037548

EQUIPMENT WORK


ACTIVE PLUMBING & HEATING

#0001960

PLUMBING


PARTINICO CONSTRUCTION CO

#0002781

EQUIPMENT WORK


ACTIVE PLBG & HTG CORP

#0001960

PLUMBING


THEODORE WAGNER PLG & HTG

#0009435

PLUMBING


N.A

#

EQUIPMENT WORK


AVA CONSTRUCTION SERVICE CORP

#0024219

ALTERATION



ASD BILDERS INC

#0028515

ALTERATION


ASD BILDERS INC

#0028515

EQUIPMENT


CATHOLIC GUARDIAN SOCIETY

#0999994

EQUIPMENT WORK


PEROTTO ASSOCIATES

#0002602

ALTERATION


EXTRA VANTAGE CONST. INC

#0600276

EQUIPMENT WORK


CECIL PETERS

#0026391

EQUIPMENT WORK


ROCK E SMALL PLBG&HTG INC

#0001864

PLUMBING


DKN CONSTRUCTION

#0020529

ALTERATION


ORION PLUMBING & HTG CORP

#0001350

PLUMBING


BROWNE BLDR AND HOME IMPR

#0602467

EQUIPMENT


BROWNE BLDR AND HOME IMPR

#0602467

EQUIPMENT WORK


GUERRERO'S INC

#0037237

EQUIPMENT WORK


GUERRERO'S INC

#0037237

EQUIPMENT WORK


GUERRERO'S INC

#0037237

EQUIPMENT


ORION PLUMBING & HTG CORP

#0001350

PLUMBING


SASCO WATERPROOFING INC

#0007013

EQUIPMENT WORK


(default) 2 queries took 781 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 ( '(+SPRINGFIELD +GARDENS)' IN BOOLEAN MODE) LIMIT 350, 50505011
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+SPRINGFIELD +GARDENS)' IN BOOLEAN MODE)11770