STATEN ISLAND

251 - 300 of 183139

N/A

#

ALTERATION

STATEN ISLAND

STATEN ISLAND


N/A

#

ALTERATION

STATEN ISLAND

STATEN ISLAND


C.N.T. BUILDERS & CONST. CORP

#0008262

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


STATEN ISLAND

STATEN ISLAND


CALL TEH PLUMBING CORP

#0001890

PLUMBING

STATEN ISLAND

STATEN ISLAND


LA FE CONSTRUCTION INC

#0021361

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


VERTICAL SOLUTIONS INC

#0027649

ALTERATION

STATEN ISLAND

STATEN ISLAND


ARRAY COMMUNICATIONS INC

#0604331

ALTERATION

STATEN ISLAND

STATEN ISLAND


STATEN ISLAND

STATEN ISLAND


W.W. & SONS PLBG & HTG INC.

#0010888

PLUMBING

STATEN ISLAND

STATEN ISLAND


BONA FIDE FUEL & OIL CO. INC.

#0005283

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


POSITIVE PLBG & HTG CORP.

#0000797

PLUMBING

STATEN ISLAND

STATEN ISLAND


POSITIVE PLUMBING & HEATING CORP

#0000797

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


ODYSSIA GLOBAL COMM. CORP

#0018635

ALTERATION

STATEN ISLAND

STATEN ISLAND


ORBIT PLUMBING & HEATING INC.

#0000957

PLUMBING

STATEN ISLAND

STATEN ISLAND


TRIPLE G CONSTRUCTION CORP

#0011560

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


TRIPLE G CONSTRUCTION CORP

#0011560

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


GATEWAY DEMOLITION CORP

#0001023

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


GATEWAY DEMOLITION CORP

#0001023

FULL DEMOLITION

STATEN ISLAND

STATEN ISLAND


RICHMOND CONTRACTING CO INC

#0005349

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


TROOST BROS INC

#0005511

ALTERATION

STATEN ISLAND

STATEN ISLAND


BLOCK 7880 REALTY CORP

#0016565

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


PAT MC CANN PLUMBING

#0001589

PLUMBING

STATEN ISLAND

STATEN ISLAND


N/A

#0999995

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


STAR INDUSTRIAL SERV CO

#0004269

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


ATLANTIC SCOFFOLDING

#

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


BLADE CONTRACTING, INC.

#0003032

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


SPRING ENTERPRIS INC.

#0002147

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


SPRING ENTERPRIS INC.

#0002147

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


JOSEPH FERRIGNO P&H CO

#0001678

PLUMBING

STATEN ISLAND

STATEN ISLAND


DECKERMASTER

#0016822

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


LEPORE CONSTRUCTION

#0013146

ALTERATION

STATEN ISLAND

STATEN ISLAND


J P INTERIORS INC

#0025875

ALTERATION

STATEN ISLAND

STATEN ISLAND


J P INTERIORS INC

#0025875

ALTERATION

STATEN ISLAND

STATEN ISLAND


KEYSPAN PLUMBING SOLUTIONS

#0000610

PLUMBING

STATEN ISLAND

STATEN ISLAND


STATEN ISLAND

STATEN ISLAND


LEPORE CONSTRUCTION

#0013146

ALTERATION

STATEN ISLAND

STATEN ISLAND


LEPORE CONSTRUCTION

#0013146

ALTERATION

STATEN ISLAND

STATEN ISLAND


EP PLUMBING CO

#0001254

PLUMBING

STATEN ISLAND

STATEN ISLAND


SCHOOL CONSTRUCTION AUTHORITY

#999995

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


ADAM'S EUROPEAN CONTRACTG

#0016217

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


STATEN ISLAND

STATEN ISLAND


URBAHN ARCHITECTS

#0999995

ALTERATION

STATEN ISLAND

STATEN ISLAND


NEW YORK STONE CO.INC

#0004350

ALTERATION

STATEN ISLAND

STATEN ISLAND


STATEN ISLAND

STATEN ISLAND


ADAM'S EUROPEAN CONTRACTG

#0016217

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


ADAM'S EUROPEAN CONTRACTG

#0016217

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


ADAM'S EUROPEAN CONTRACTG

#0016217

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


ADAM'S EUROPEAN CONTRACTG

#0016217

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


ADAM'S EUROPEAN CONTRACTG

#0016217

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


(default) 2 queries took 3421 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 ( '(+STATEN +ISLAND)' IN BOOLEAN MODE) LIMIT 250, 50505011
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+STATEN +ISLAND)' IN BOOLEAN MODE)113410