HOWARD BEACH

1 - 50 of 10020

FOUR POINTS P & H CORP

#0000796

PLUMBING

HOWARD BEACH

QUEENS


CASE PLUMBING LLC

#0000860

EQUIPMENT WORK

Howard Beach

QUEENS


UNVERISAL CONSTRUCTION CONSULTAN

#0034126

EQUIPMENT WORK

HOWARD BEACH

QUEENS


HSU & ASSOC INC

#0001151

ALTERATION

HOWARD BEACH

QUEENS


N/A

#0011488

ALTERATION

HOWARD BEACH

QUEENS


N/A

#

ALTERATION

HOWARD BEACH

QUEENS


ROCCO FANELLI

#0012154

PLUMBING

HOWARD BEACH

QUEENS


D/B/A/ J.B GENERAL CONTRACTING 7

#0007362

EQUIPMENT WORK

HOWARD BEACH

QUEENS


HOWARD BEACH

QUEENS


TOP NOTCH BUILDING CONSTR

#0607145

ALTERATION

HOWARD BEACH

QUEENS


TOP NOTCH BUILDING CONSTR

#0607145

ALTERATION

HOWARD BEACH

QUEENS


PATRICK DOLAN PLG CO, INC

#0000903

PLUMBING

HOWARD BEACH

QUEENS


ALCO STORE DEVELOPMENT CO

#0007763

EQUIPMENT WORK

HOWARD BEACH

QUEENS


J.G. CONST CONTRA CORP

#0604756

EQUIPMENT WORK

HOWARD BEACH

QUEENS


W.R. PLBG AND HTG CORP

#0001956

PLUMBING

HOWARD BEACH

QUEENS


W.R. PLBG AND HTG CORP

#0001956

PLUMBING

HOWARD BEACH

QUEENS


OWNER

#0999994

EQUIPMENT WORK

HOWARD BEACH

QUEENS


THE PLUMBING COMPANY INC

#0025348

ALTERATION

HOWARD BEACH

QUEENS


GUERRERO'S INC

#0037237

EQUIPMENT WORK

HOWARD BEACH

QUEENS


HOWARD BEACH

QUEENS


L.R.P CORPORATION

#0001556

PLUMBING

HOWARD BEACH

QUEENS


ACUTE COSNTRUCTION

#0026514

ALTERATION

HOWARD BEACH

QUEENS


N/A

#

EQUIPMENT WORK

HOWARD BEACH

QUEENS


LA CROIX CORP

#

ALTERATION

HOWARD BEACH

QUEENS


J. HERTLER PLG. & HTNG.

#0000614

PLUMBING

HOWARD BEACH

QUEENS


LA CROIX CORP

#

ALTERATION

HOWARD BEACH

QUEENS


HOWARD BEACH

QUEENS


INTER COUNTY MECHICAL CORP

#

EQUIPMENT WORK

HOWARD BEACH

QUEENS


SCHMELZ BROTHERS

#0012067

PLUMBING

HOWARD BEACH

QUEENS


N/A

#

ALTERATION

HOWARD BEACH

QUEENS


BELROSE FIRE SUPPRESSION

#0000396

EQUIPMENT WORK

HOWARD BEACH

QUEENS


MASTERCRAFT CUSTOM INTERIORS

#0029462

ALTERATION

HOWARD BEACH

QUEENS


MASTERCRAFT CUSTOM INTERIORS

#0039940

ALTERATION

HOWARD BEACH

QUEENS


CLOVERDALE MASTER P& H

#0001353

PLUMBING

HOWARD BEACH

QUEENS


JOSEPH_BALKIN INC

#0001281

PLUMBING

HOWARD BEACH

QUEENS


J.B. GENERAL CONTRACTOR, INC.

#0007362

ALTERATION

HOWARD BEACH

QUEENS


J.B. GENERAL CONTRACTOR, INC.

#0007362

ALTERATION

HOWARD BEACH

QUEENS


PAL MAR PLG & HTG

#0001533

PLUMBING

HOWARD BEACH

QUEENS


HOWARD BEACH

QUEENS


CLOVERDALE MASTER P&H INC

#0001353

PLUMBING

HOWARD BEACH

QUEENS


HEADS UP FIRE SPRINKLER

#0000328

EQUIPMENT WORK

HOWARD BEACH

QUEENS


N.A

#

ALTERATION

HOWARD BEACH

QUEENS


THEODORE WAGNER PLG & HTG

#0009435

PLUMBING

HOWARD BEACH

QUEENS


PROPERLY ORGANIZED TIMBER

#0039665

ALTERATION

HOWARD BEACH

QUEENS


FIRST CHOICE PLUMBING COR

#0001210

PLUMBING

HOWARD BEACH

QUEENS


C N PLUMBING INC

#0001252

PLUMBING

HOWARD BEACH

QUEENS


UNIVERSAL CONSTRUCTION INT.&EXT

#0014376

ALTERATION

HOWARD BEACH

QUEENS


BONIBO CONSTRUCTION CORP

#0029788

EQUIPMENT

HOWARD BEACH

QUEENS


BONIBO CONSTRUCTION CORP

#0029788

NEW BUILDING

HOWARD BEACH

QUEENS


VALUE PLUMBING INC

#0000747

PLUMBING

HOWARD BEACH

QUEENS


(default) 2 queries took 692 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 ( '(+HOWARD +BEACH)' IN BOOLEAN MODE) LIMIT 50505023
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+HOWARD +BEACH)' IN BOOLEAN MODE)11669