SPRINGFIELD GARDENS

51 - 100 of 11853

C2 PLUMBING CORP

#0000860

EQUIPMENT WORK


C & T PLUMBING & HTG INC

#0002025

PLUMBING


C & T PLUMBING & HTG INC

#0002025

PLUMBING


V.A GENERAL HOME IMPROVEM

#0034895

EQUIPMENT


V.A GENERAL HOME IMPROVEM

#0034895

NEW BUILDING


LAKHI GENERAL CONTRACTOR

#0001390

EQUIPMENT


C2 PLUMBING CORP

#0000860

EQUIPMENT WORK


C & T PLUMBING & HTG INC

#0002025

PLUMBING


C & T PLUMBING & HTG INC

#0002025

PLUMBING


SOMAL HOME IMPROVEMENTS.I

#0037751

NEW BUILDING


SOMAL HOME IMPROVEMENTS.I

#0037751

FOUNDATION


SOMAL HOME IMPROVEMENTS.I

#0037751

FOUNDATION


SOMAL HOME IMPROVEMENTS.I

#0037751

EQUIPMENT


SOMAL HOME IMPROVEMENTS.I

#0037751

FOUNDATION


SOMAL HOME IMPROVEMENTS.I

#0037751

NEW BUILDING


SOMAL HOME IMPROVEMENTS.I

#0037751

FOUNDATION


C & T PLUMBING & HTG INC

#0002025

PLUMBING


C & T PLUMBING & HTG INC

#0002025

PLUMBING


E.W. HOWELL CO, LLC

#0019416

EQUIPMENT


E.W. HOWELL CO, LLC

#0019416

NEW BUILDING


ARA PLUMBING CORP

#0000826

PLUMBING


ILE CONSTRUCTION INC

#0035824

EQUIPMENT


ILE CONSTRUCTION INC

#0035824

NEW BUILDING


ILE CONSTRUCTION GROUP*

#0604880

EQUIPMENT


ILE CONSTRUCTION GROUP*

#0604880

NEW BUILDING


24 SEVEN PLUMBING INC

#0000695

PLUMBING


ILE CONSTRUCTION GROUP*

#0604880

EQUIPMENT


ILE CONSTRUCTION GROUP*

#0604880

NEW BUILDING


PRO STAR PLBG AND HTG INC

#0001223

PLUMBING



BTON LLC

#0604969

EQUIPMENT


BTON LLC

#0604969

NEW BUILDING


C & T PLUMBING & HTG INC

#0002025

PLUMBING


C & T PLUMBING & HTG INC

#0002025

PLUMBING


BTON LLC

#0604969

EQUIPMENT


BTON LLC

#0604969

NEW BUILDING


C & T PLUMBING & HTG INC

#0002025

PLUMBING


C & T PLUMBING & HTG INC

#0002025

PLUMBING


BTON LLC

#0604969

EQUIPMENT


BTON LLC

#0604969

NEW BUILDING


C & T PLUMBING & HTG INC

#0002025

PLUMBING


C & T PLUMBING & HTG INC

#0002025

PLUMBING


SOMAL HOME IMPROVEMENTS.I

#0037751

FOUNDATION


SOMAL HOME IMPROVEMENTS.I

#0037751

FOUNDATION


SOMAL HOME IMPROVEMENTS.I

#0037751

NEW BUILDING


SOMAL HOME IMPROVEMENTS.I

#0037751

FOUNDATION


SOMAL HOME IMPROVEMENTS.I

#0037751

NEW BUILDING


SOMAL HOME IMPROVEMENTS.I

#0037751

EQUIPMENT


SOMAL HOME IMPROVEMENTS.I

#0037751

FOUNDATION


C & T PLUMBING & HTG INC

#0002025

PLUMBING


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