SPRINGFIELD GARDENS

151 - 200 of 11853

ALFOMEGA CONSTRUCTION LLC

#0038847

ALTERATION


ALFOMEGA CONSTRUCTION LLC

#0038847

ALTERATION


JTP PLBING CONTRACTOR, LT

#0001637

PLUMBING


JUNIOR CARTER MECH. CORP

#0030793

ALTERATION


MCCAULEY'S CONSTRUTION CO INC

#0014215

NEW BUILDING


N/A

#0027081

EQUIPMENT WORK


NA

#

EQUIPMENT WORK


VACALLUZZI CONSTRUCTION CORP.

#0009812

ALTERATION



HOLLIS CONSTRUCTION CORP

#

FULL DEMOLITION



AVOCA MANAGEMENT CORP

#0022104

ALTERATION


WRIGHTS GEN CPN STRUCTION CORP

#0012331

ALTERATION


GRAFTON CONSTRUCTIOFN CORP

#0005913

EQUIPMENT


GRAFTON CONSTRUCTIOFN CORP

#0005913

EQUIPMENT WORK



N/A

#

ALTERATION


MILLENNIUM BLDG CONSTRUCTION

#0019574

ALTERATION


MILLENNIUM BLDG CONSTRUCTION

#0019574

ALTERATION


INTERBOROUGH PLUMBERS INC.

#0001864

PLUMBING


N/A

#0999994

ALTERATION


WAGNER ZIV

#0009435

PLUMBING


SAABI CONSTRUCTION INC

#0020697

ALTERATION


SAABI CONSTRUCTION INC

#0020697

EQUIPMENT WORK


SIGN FABRICATION

#0000155

SIGN


SIGN FABRICATION

#0000155

SIGN


SIGN FABRICATION

#0000155

SIGN


B'S PLG

#0001639

PLUMBING


MIKE HOME IMPROVEMENTS

#0010193

ALTERATION


CLARK'S PLUMBING AND HEATING

#0001509

PLUMBING


ENTERPRISE PLBG & HTG INC

#0000594

PLUMBING


ROCK E SMALL PLBG&HTG INC

#0001864

PLUMBING


#

ALTERATION


UNIVERSAL CONSTRUCTION AND BUILD

#0034602

ALTERATION




CAPE PLUMBING INC

#0001137

PLUMBING


SAMUEL HOME IMPROVEMENT

#0014869

ALTERATION


SAMUEL HOME IMPROVEMENTS

#0014869

ALTERATION


BOWEN PLUMBING CORP.

#0000901

PLUMBING


THE PLUMBING CO., INC

#0000626

PLUMBING


DIE HARD HOME IMPROVEMENT

#0029966

ALTERATION


PRIVATE HOUSE OWNER

#0999994

ALTERATION


LINZI CONTRACTING SERV

#0999994

NEW BUILDING



N.A

#0023514

ALTERATION


N/A

#0009435

PLUMBING


APOLLO CORP

#

EQUIPMENT WORK


NA

#

ALTERATION


LLOYD G. DRUMMOND PLG.

#0001386

PLUMBING


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