SOUTH RICHMOND HILL [Permits for SOUTH RICHMOND HILL]

551 - 600 of 728

Sprint

Business

Active


H & R CONSTRUCTION

Business

Active



NEW BRICK CONSTRUCTION INC.

Business

Active


DANNY SINGH LLC

Business

Active




ICELLULAR LLC

Business

Active


NEW YORK A-1 TIRE SHOP

Business

Active



T-MOBILE NORTHEAST LLC

Business

Inactive





SABI CONSTRUCTION CORP

Business

Active


NY SKYLINE CONTRACTING

Business

Inactive


AHMAD, SULAIMAN

Business

Active


GOLD PALACE INC.

Business

Active


CLASSIC WIRELESS CORP.

Business

Inactive


VARUN CONSTRUCTION INC.

Business

Active


MS GOLD EXCHANGE

Business

Active



RadioShack

Business

Active


CITY LINK CONSTRUCTION INC.

Business

Active






NEW WILLIAM'S LAUNDROMAT INC.

Business

Inactive


KRSS HOME IMPROVEMENT INC

Business

Inactive


A - Z CONSTRUCTION INC

Business

Active


YASH & B CONSTRUCTION CORP.

Business

Active



EXPRESS NY CONSTRUCTION INC

Business

Active


M SINGH ENTERPRISES INC

Business

Active


DYNAMIC ADIV SETHI CORP

Business

Inactive


CHEVY DELI & GROCERY CORP.

Business

Active


BIG BEN'S SMOKE SHOP, INC.

Business

Inactive


HEERA & G BUILDERS INC

Business

Active


MR GROUP SERVICES CORP

Business

Inactive


SONNY'S ROTI SHOP

Business

Active


T-MOBILE

Business

Inactive


DYNAMIC ADIV SETHI CORP

Business

Active


LOCHAN SINGH CONSTRUCTION

Business

Active


SINGH, NAVJOT

Business

Inactive


JK MOBILE SHOP

Business

Inactive



S. SINGH CONSTRUCTION CORP

Business

Active




(default) 2 queries took 432 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 550, 505050204
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)11228