SAINT ALBANS

1 - 50 of 8928

EMDI LTD

#0000905

EQUIPMENT WORK

SAINT ALBANS

QUEENS


BK ENGINEERING

#0000905

EQUIPMENT WORK

SAINT ALBANS

QUEENS


MICHAEL BORRUTO GEN CONT*

#0013353

NEW BUILDING

SAINT ALBANS

QUEENS


MICHAEL BORRUTO GEN CONT*

#0013353

NEW BUILDING

SAINT ALBANS

QUEENS


MICHAEL BORRUTO GEN CONT*

#0013353

NEW BUILDING

SAINT ALBANS

QUEENS


MICHAEL BORRUTO GEN CONT*

#0013353

EQUIPMENT

SAINT ALBANS

QUEENS


MICHAEL BORRUTO GEN CONT*

#0013353

EQUIPMENT

SAINT ALBANS

QUEENS


MICHAEL BORRUTO GEN CONTR

#0013353

NEW BUILDING

SAINT ALBANS

QUEENS


CHRIS OWEN PLBG & HTG INC

#0001358

PLUMBING

SAINT ALBANS

QUEENS


CHRIS OWEN PLBG & HTG INC

#0001358

PLUMBING

SAINT ALBANS

QUEENS


FALCO CONCRETE INC.

#0037773

EQUIPMENT

SAINT ALBANS

QUEENS


FALCO CONCRETE INC.

#0037773

FULL DEMOLITION

SAINT ALBANS

QUEENS


FALCO CONCRETE INC.

#0037773

FULL DEMOLITION

SAINT ALBANS

QUEENS


DELTA DEMO OF NY INC

#0027401

EQUIPMENT

SAINT ALBANS

QUEENS


DELTA DEMO OF NY INC

#0027401

FULL DEMOLITION

SAINT ALBANS

QUEENS


BTON LLC

#0604969

FOUNDATION

SAINT ALBANS

QUEENS


BTON LLC

#0604969

NEW BUILDING

SAINT ALBANS

QUEENS


BTON LLC

#0604969

FOUNDATION

SAINT ALBANS

QUEENS


LLOYD G DRUMMOND PLBG&GEN

#0001386

PLUMBING

SAINT ALBANS

QUEENS


BTON LLC

#0604969

EQUIPMENT

SAINT ALBANS

QUEENS


KAIETEUR CONSTRUCTION INC

#0037139

EQUIPMENT

SAINT ALBANS

QUEENS


KAIETEUR CONSTRUCTION INC

#0037139

NEW BUILDING

SAINT ALBANS

QUEENS


KAIETEUR CONSTRUCTION INC

#0037139

NEW BUILDING

SAINT ALBANS

QUEENS


C2 PLUMBING CORP

#0000860

EQUIPMENT WORK

SAINT ALBANS

QUEENS


C & T PLUMBING & HTG INC

#0002025

PLUMBING

SAINT ALBANS

QUEENS


FIRST CHOICE PLUMBING CORP

#0001210

PLUMBING

SAINT ALBANS

QUEENS


SMO CONTRACTORS INC

#0039208

EQUIPMENT

SAINT ALBANS

QUEENS


SMO CONTRACTORS INC

#0039208

NEW BUILDING

SAINT ALBANS

QUEENS


UMANA DESIGNS INC

#0034253

NEW BUILDING

SAINT ALBANS

QUEENS


UMANA DESIGNS INC

#0034253

EQUIPMENT

SAINT ALBANS

QUEENS


MRM DEVELOPMENT CORP

#0031889

NEW BUILDING

SAINT ALBANS

QUEENS


MRM DEVELOPMENT CORP

#0031889

NEW BUILDING

SAINT ALBANS

QUEENS


MRM DEVELOPMENT CORP

#0031889

EQUIPMENT

SAINT ALBANS

QUEENS


MRM DEVELOPMENT CO

#0031889

NEW BUILDING

SAINT ALBANS

QUEENS


MRM DEVELOPMENT CO

#0031889

EQUIPMENT

SAINT ALBANS

QUEENS


FIRST CHOICE PLUMBING COR

#0001210

PLUMBING

SAINT ALBANS

QUEENS


FIRST CHOICE PLUMBING COR

#0001210

PLUMBING

SAINT ALBANS

QUEENS


NA

#0999994

EQUIPMENT WORK

SAINT ALBANS

QUEENS


A J CONSTRUCTION INC

#0022648

ALTERATION

SAINT ALBANS

QUEENS


WAGNER ZIV PLUMBING & HEATING

#0009435

PLUMBING

SAINT ALBANS

QUEENS


SAINT ALBANS

QUEENS


SAINT ALBANS

QUEENS


GRAFTON CONSTRUCTION CORPORATION

#0005913

ALTERATION

SAINT ALBANS

QUEENS


JOE TRUCE PLG INC

#0000811

PLUMBING

SAINT ALBANS

QUEENS


SJ VISION AND SON

#0002016

PLUMBING

SAINT ALBANS

QUEENS


ADNET ENTERPRISES, LLC

#0033423

EQUIPMENT

SAINT ALBANS

QUEENS


ADNET ENTERPRISES, LLC

#0033423

ALTERATION

SAINT ALBANS

QUEENS


ADNET ENTERPRISES, LLC

#0033423

ALTERATION

SAINT ALBANS

QUEENS


ADNET ENTERPRISES LLC

#0033423

EQUIPMENT

SAINT ALBANS

QUEENS


ADNET ENTERPRISES LLC

#0033423

ALTERATION

SAINT ALBANS

QUEENS


(default) 2 queries took 984 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 ( '(+SAINT +ALBANS)' IN BOOLEAN MODE) LIMIT 5050507
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+SAINT +ALBANS)' IN BOOLEAN MODE)11977