SOUTH RICHMOND HILL [Permits for SOUTH RICHMOND HILL]

501 - 550 of 728

CARS ON ORDER, LTD.

Business

Active


AIRJDATH, VIMAL

Individual

Active





DESI DELI & HALAL MEAT CORP

Business

Inactive


BDS GENERAL CONSTRUCTION INC.

Business

Inactive


GUR CONTRACTING, CORP.

Business

Active


LAL, TARSEM

Business

Inactive


ARSH GEN CONSTRUCTION CORP.

Business

Active


HEMA CONSTRUCTION INC.

Business

Inactive


SALOME GROCERY CORP

Business

Active


A & G SYNDICATE, INC.

Business

Active


ANIL & SONS JEWELRY INC

Business

Active





LOVE CONSTRUCTION CORP

Business

Active


SHIV CONTRACTING INC.

Business

Active


CHETRAM, CHOLESHWAR

Business

Active


BALKAR CONSTRUCTION, INC.

Business

Active



LIBERTY GOLD OF USA LLC

Business

Active


FARM FRESH GROCERY, INC

Business

Inactive


YORK CONSTRUCTION CORP

Business

Inactive


101 PIT STOP INC.

Business

Active


SUNNY M CONSTRUCTION INC

Business

Active


BARROS CONSTRUCTION CORP.

Business

Active


CALICO RESTORATION INC

Business

Inactive



NEWBIT CONSTRUCTION INC.

Business

Active


GOODMAN CONSTRUCTION CORP

Business

Inactive


CONSTRUCTION

Business

Active


NET CONSTRUCTION, INC.

Business

Inactive


MAHI PAINTING, INC.

Business

Active


HSA CONSTRUCTION CORP.

Business

Inactive


LJC HOME IMPROVEMENT

Business

Active


D & H AUTO BODY

Business

Active



EMPIRE STAIRS & RAILING INC

Business

Active


HSA CONSTRUCTION CORP.

Business

Active



JEP CONTRACTING CORP

Business

Active


RAMU NAUTH JEWELRY INC.

Business

Inactive



DREAMLITE CONSTRUCITON CORP

Business

Active



RADIOSHACK CORPORATION

Business

Inactive




(default) 2 queries took 203 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+SOUTH +RICHMOND +HILL)' IN BOOLEAN MODE) LIMIT 500, 505050203
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+SOUTH +RICHMOND +HILL)' IN BOOLEAN MODE)110