STATEN ISLAND

301 - 350 of 183139

ADAM'S EUROPEAN CONTRACTG

#0016217

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


ADAM'S EUROPEAN CONTRACTG

#0016217

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


ADAM'S EUROPEAN CONTRACTG

#0016217

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


ADAM'S EUROPEAN CONTRACTG

#0016217

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


YORK SCAFFOLDING EQUIPMENT

#0002450

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


YORK SCAFFOLDING EQUIPMENT

#0002450

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


SPRING SCAFFOLDING INC.

#0002147

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


A.BERWIND PLUMBING AND HEATING

#0000180

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


MIDTOWN HVAC ENTERPRISES

#0602474

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


LERA HOMES,INC.

#0024661

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


LERA HOMES INC

#0024661

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


LERA HOMES INC

#0024661

FULL DEMOLITION

STATEN ISLAND

STATEN ISLAND


DUO PLUMBING & HEATING CORP

#0001649

PLUMBING

STATEN ISLAND

STATEN ISLAND


DUO PLUMBING & HEATING CORP

#0001649

PLUMBING

STATEN ISLAND

STATEN ISLAND


SCARAN OIL SERVICE CO. INC.

#0002970

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


TARANTO CONSTRUCTION

#0004850

ALTERATION

STATEN ISLAND

STATEN ISLAND


STATEN ISLAND

STATEN ISLAND


AJM COMMODITIES

#0016703

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


AJM COMMODITIES

#0016703

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


CLOVER DRAINAGE INC.

#0012930

FULL DEMOLITION

STATEN ISLAND

STATEN ISLAND


CLOVER DRAINAGE INC.

#0012930

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


S.DEMAIO PLBG & HTG

#0000782

PLUMBING

STATEN ISLAND

STATEN ISLAND


LT GENERAL CONTR. INC.

#0016594

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


LT GENERAL CONTR. INC.

#0016594

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


SILLER BROS CONSTR. CORP

#0004826

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


SILLER BROS CONSTR. CORP

#0004826

ALTERATION

STATEN ISLAND

STATEN ISLAND


SILLER BROTHER'S CONSTRUC

#0004826

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


SILLER BROTHER'S CONSTRUC

#0004826

ALTERATION

STATEN ISLAND

STATEN ISLAND


R.S.F. PLBG & HTG CORP.

#0000487

PLUMBING

STATEN ISLAND

STATEN ISLAND


N/A

#

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


GALANTE HOME IMPROVEMENT INC.

#0002954

ALTERATION

STATEN ISLAND

STATEN ISLAND


MONELLO ENTERPRISES INC

#0033625

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


MONELLO ENTERPRISES INC

#0033625

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


N/A

#

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


V & M DRAIN CLEANING INC

#0001719

PLUMBING

STATEN ISLAND

STATEN ISLAND


LOUIS L. BUTTERMARK & SONS INC

#0007879

PLUMBING

STATEN ISLAND

STATEN ISLAND


N/A

#

ALTERATION

STATEN ISLAND

STATEN ISLAND


PATRICK MILANO

#0025458

ALTERATION

STATEN ISLAND

STATEN ISLAND


MAD PL & HEATING INC

#0000987

PLUMBING

STATEN ISLAND

STATEN ISLAND


STATEN ISLAND

STATEN ISLAND


CASTELUCCI PLBG & HEATING

#0000592

PLUMBING

STATEN ISLAND

STATEN ISLAND


FRANK A. VACCARO,INC.

#

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


ASHRAF NASARALLA

#0034486

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


F & D ASSOCIATES, INC.

#0012094

ALTERATION

STATEN ISLAND

STATEN ISLAND


F & D ASSOCIATES

#0012094

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


MORTON L CHAIT

#0010529

PLUMBING

STATEN ISLAND

STATEN ISLAND


COOL RUNNINGS INC

#0037100

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


COOL RUNNINGS INC

#0037100

ALTERATION

STATEN ISLAND

STATEN ISLAND


ALISON PLBG & HTG INC

#0001500

PLUMBING

STATEN ISLAND

STATEN ISLAND


RICHMOND CONTRACTING CO INC

#0017661

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


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