BRONX

1 - 50 of 317218

PALACE HOIST&SCAF CORP N

#0605160

EQUIPMENT

BRONX

BRONX


PALACE HOIST&SCAF CORP N

#0605160

EQUIPMENT

BRONX

BRONX


E.W. HOWELL CO, LLC

#0019416

NEW BUILDING

BRONX

BRONX


E.W. HOWELL CO, LLC

#0019416

EQUIPMENT

BRONX

BRONX


E.W. HOWELL CO, LLC

#0019416

EQUIPMENT

BRONX

BRONX


CIVETTA COUSINS JV LLC

#0000625

EQUIPMENT

BRONX

BRONX


CIVETTA COUSINS JV LLC

#0000625

EQUIPMENT WORK

BRONX

BRONX


E.W. HOWELL CO, LLC

#0019416

NEW BUILDING

BRONX

BRONX


E.W. HOWELL CO, LLC

#0019416

NEW BUILDING

BRONX

BRONX


E.W. HOWELL CO, LLC

#0019416

NEW BUILDING

BRONX

BRONX


LAWRENCE J. LEVINE

#0000097

EQUIPMENT WORK

BRONX

BRONX


SAFWAY SERVICES LLC

#0038939

EQUIPMENT

BRONX

BRONX


PAR PLUMBING CO., INC

#0000161

PLUMBING

BRONX

BRONX


PAR PLUMBING CO., INC

#0000161

PLUMBING

BRONX

BRONX


PAR PLUMBING CO., INC

#0000161

EQUIPMENT WORK

BRONX

BRONX


SIGNATURE CONSTRUCTION GR

#0002111

EQUIPMENT WORK

BRONX

BRONX


RENEWAL CONSTRUCTION SERV

#0036326

EQUIPMENT WORK

BRONX

BRONX


CENTRAL CONSTRUCTION MANA

#0036271

EQUIPMENT WORK

BRONX

BRONX


BRONX STORE & EQUIPMENT

#0005404

ALTERATION

NEW YORK

MANHATTAN


BRONX STORE & EQUIPMENT

#0005404

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX STORE & EQUIPMENT

#0005404

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX STORE & EQUIPMENT

#0005404

ALTERATION

NEW YORK

MANHATTAN


BRONX STORE AND EQUIPMENT CO

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX STORE AND EQUIPMENT CO

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX STORE EQUIPMENT CO INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX STORE EQUIPMENT CO INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX STORE EQUIPMENT CO INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX STORE EQUIPMENT CO INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX STORE EQUIPMENT CO INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX MECHANICAL CORP.

#0000594

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX STORE EQUIP CO INC.

#0005404

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX BUILDERS_T/A BRONX STORE

#0005404

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX BUILDERS

#0005404

EQUIPMENT WORK

NEW YORK

MANHATTAN


TELCOM ENGINEERING GP INC

#0027646

ALTERATION

BRONX

BRONX


DYNAMIC RENOVATIONS AND D

#0600834

EQUIPMENT

BRONX

BRONX


ALIGIADO, PETER-BRONX

#0002626

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX BUILDERS

#0005404

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX BUILDERS

#0005404

EQUIPMENT WORK

NEW YORK

MANHATTAN


DATA WATERPROOFING INC

#0037687

ALTERATION

BRONX

BRONX


BRONX STORE EQPTMNT. CO INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX STORE EQPTMNT. CO INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


AGLIARDO PETER-BRONX

#0002626

EQUIPMENT WORK


POSITIVE ELEC ASSOC INC

#0601633

EQUIPMENT WORK

BRONX

BRONX


360 PLBG & MECHANICAL COR

#0002104

PLUMBING

BRONX

BRONX


NY BRONX BKLYN AND QUEENS FIRE

#74-B

EQUIPMENT WORK

NEW YORK

MANHATTAN


NY BRONX BKLYN AND QUEENS FIRE

#74-B

EQUIPMENT WORK

NEW YORK

MANHATTAN


TJ CONSTRUCTION OF BRONX INC

#

EQUIPMENT WORK

NEW YORK

MANHATTAN


BRONX MECHCORP

#0000594

PLUMBING

NEW YORK

MANHATTAN


BRONX MECH. CORP

#0000594

PLUMBING

NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


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