STATEN ISLAND

1 - 50 of 183139

QUALITY PLUMBING, INC

#0001039

PLUMBING

STATEN ISLAND

STATEN ISLAND


CUSTOM SOUTH CONSTRUC LLC

#0012626

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


JB BUZCO PLUMBING LLC

#0001846

PLUMBING

STATEN ISLAND

STATEN ISLAND


QUALITY PLUMBING, INC

#0001039

PLUMBING

STATEN ISLAND

STATEN ISLAND


CUSTOM SOUTH CONSTRUC LLC

#0012626

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


DELTAMER, INC

#0605664

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


DELTAMER, INC

#0605664

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


DELTAMER, INC

#0605664

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


DELTAMER, INC

#0605664

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


FLOW-RIGHT PLBG & HTG COR

#0002295

PLUMBING

STATEN ISLAND

STATEN ISLAND


FLOW-RIGHT PLBG & HTG COR

#0002295

PLUMBING

STATEN ISLAND

STATEN ISLAND


DISCOVER GENERAL CONTRACTING

#0004772

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


DISCOVER GENERAL CONTRACTING

#0004772

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


LANE ASSOCIATES

#0048918

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


ROCKFORD PLMBG & HTG CO

#0000196

PLUMBING

STATEN ISLAND

STATEN ISLAND


DISCOVER GENERAL CONTRACTING

#0004772

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


DISCOVER GENERAL CONTRACTING

#0004772

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


QUALITY PLUMBING, INC

#0001039

PLUMBING

STATEN ISLAND

STATEN ISLAND


CUSTOM SOUTH CONSTRUC LLC

#0012626

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


JB BUZCO PLUMBING LLC

#0001846

PLUMBING

STATEN ISLAND

STATEN ISLAND


QUALITY PLUMBING, INC

#0001039

PLUMBING

STATEN ISLAND

STATEN ISLAND


CUSTOM SOUTH CONSTRUC LLC

#0012626

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


JB BUZCO PLUMBING LLC

#0001846

PLUMBING

STATEN ISLAND

STATEN ISLAND


SKEN SERVICES CORP

#0027600

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


SKEN SERVICES CORP

#0027600

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


AWL INDUSTRIES INC

#0000139

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


QUALITY PLBG., INC

#0001039

PLUMBING

STATEN ISLAND

STATEN ISLAND


ARI-JON CONSTRUCTION CORP.

#0024199

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


EASTERN PLBG & MECH CONTR

#0002257

PLUMBING

STATEN ISLAND

STATEN ISLAND


NEW YORK

MANHATTAN


TOMCO MECHANICAL CORP

#0002274

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


MAD PLBG & HTG CORP

#0000987

PLUMBING

STATEN ISLAND

STATEN ISLAND


PETER HARDT INC

#0005444

ALTERATION

STATEN ISLAND

STATEN ISLAND


A&W SYSTEMS INC.

#0009646

PLUMBING

STATEN ISLAND

STATEN ISLAND


STRUCTURAL IMPROVEMENT CORP

#0008174

ALTERATION

STATEN ISLAND

STATEN ISLAND


ONE REALE REALTY, LTD

#999995

ALTERATION

STATEN ISLAND

STATEN ISLAND


AMERICAN CONTRACTORS INC.

#0003822

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


ARI-JON CONSTRUCTION CORP.

#0024199

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


ARI-JON CONSTRUCTION CORP.

#0024199

NEW BUILDING

STATEN ISLAND

STATEN ISLAND


NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


DMJ CONTRACTING CORP.

#0013129

ALTERATION

STATEN ISLAND

STATEN ISLAND


STATEN ISLAND

STATEN ISLAND


A.J CONTRACTING CORP OF NEW YORK

#0021599

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


RICHMOND ALL CITY CONTRACTING

#0026724

ALTERATION

STATEN ISLAND

STATEN ISLAND


K.M.C. PLBG & HTG

#0001744

PLUMBING

STATEN ISLAND

STATEN ISLAND


S & S BUDGET CONTRACTORS

#0020709

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


OWNER

#

ALTERATION

STATEN ISLAND

STATEN ISLAND


SERVIDIO INC

#0027671

EQUIPMENT WORK

STATEN ISLAND

STATEN ISLAND


SERVIDIO INC

#0027671

EQUIPMENT

STATEN ISLAND

STATEN ISLAND


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