RICHMOND HILL

1 - 50 of 24163

CENTRAL CONSTRUCTION MANA

#0036271

EQUIPMENT WORK


PAL-MAR PLBG & HTG INC

#0001533

PLUMBING


CENTRAL CONSTRUCTION MANA

#0036271

EQUIPMENT WORK


CHAMPION COMBUSTION CORP

#0004254

EQUIPMENT WORK

RICHMOND HILL

QUEENS


GEMSTAR CONSTRUCTION CORP

#0003189

EQUIPMENT WORK

RICHMOND HILL

QUEENS


RICHMOND HILL

QUEENS


MARCO POLO PLBG & HTG INC

#0000335

PLUMBING

RICHMOND HILL

QUEENS


OWNER

#999994

NEW BUILDING


QRC DESIGN CORP

#0607827

EQUIPMENT WORK


TOP DOG PLBG & HTG CORP

#0002025

PLUMBING


CRU MECH. & HTG., INC.

#0001485

PLUMBING


GWANGGAETOU DEVELOPMENT CORP.

#0023609

EQUIPMENT


GWANGGAETOU DEVELOPMENT CORP.

#0023609

EQUIPMENT


GWANGGAETOU DEVELOPMENT CORP.

#0023609

ALTERATION


DELPHI PLG & HTG INC

#0000991

PLUMBING


DELPHI PLG & HTG INC

#0000991

EQUIPMENT WORK


R & L HEATING & AIR CONDITIONING

#0003860

EQUIPMENT WORK


FRITCH CONSTRUCITON CO INC

#0013598

EQUIPMENT WORK


FRITCH CONSTRUCITON CO INC

#0013598

EQUIPMENT WORK


ACE CONTRACTING

#0001379

PLUMBING


JACK PICCINI. INC

#0005157

EQUIPMENT WORK


ELDOR ELECTRIC, LLC.

#0034969

EQUIPMENT WORK


ELDOR ELECTRIC, LLC.

#0034969

EQUIPMENT WORK


SENTINEL FIRE CONTROL,INC.

#0000230

EQUIPMENT WORK



STATE ENVIROMENT SVCES

#0002166

EQUIPMENT WORK



RELIAVLE FIRE PROTECTION

#0000151

EQUIPMENT WORK


MCALPINE CONTRACTORS

#0004796

EQUIPMENT WORK


MCALPINE CONTRACTORS

#0004796

EQUIPMENT WORK


MCALPINE CONTRACTORS

#0004796

EQUIPMENT WORK


DELPHI PLUMBING & HEATING

#0000991

PLUMBING


A.H.A. GENERAL CONSTRUCTION

#0000991

PLUMBING


A.H.A. GENERAL CONSTRUCTION

#0000991

PLUMBING


MONARCH CONSTRUCTION CORP.

#

EQUIPMENT WORK


MONARCH CONSTRUCTION CORP.

#

EQUIPMENT WORK


KUCICH PLG.

#0000749

PLUMBING


KUCICH PLG.

#0000749

PLUMBING


KUCICH PLG.

#0000749

PLUMBING


BORJ CONSTRUCTION CORP.

#

EQUIPMENT WORK


CAPITOL FIRE SPRINKLER

#0000288

EQUIPMENT WORK


L G PLUMBING INC. CORP.

#0007653

PLUMBING


GLOBE PLUMBING & HEATING CORP.

#0001071

PLUMBING


CAPITOL FIRE SPRINKLER

#

EQUIPMENT WORK


CAPITOL FIRE SPRINKLER CORP.

#0000288

EQUIPMENT WORK



JEREZ CONSTRUCTION INC

#0031061

ALTERATION


MOTTCO CONTRACTING CORP

#0033793

ALTERATION


MB KIM ARCHITECT PC

#0020286

EQUIPMENT WORK


SRM CONSTRUCTION & EXPEDITING SE

#0030912

ALTERATION


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