SOUTH RICHMOND HILL [Permits for SOUTH RICHMOND HILL]

251 - 300 of 728

KAP RES INC

Business

Active


JEETA CONSTRUCTION CORP.

Business

Active


TIMES WIRELESS INC

Business

Active


ID AUTO MALL

Business

Active


CROWN GOLD EXCHANGE

Business

Inactive


85 Collision Concepts Inc

Business

Active


DYNAMIC ADIV SETHI CORP

Business

Active


FIXJOINT INC

Business

Active


PARK GREEN CONSTRUCTION INC

Business

Active




KAIETEUR CONSTRUCTION, INC.

Business

Active


DSR HOME EXPO INC.

Business

Active



JOHN GC INC.

Business

Active



TIME WIRELESS

Business

Active


CUSTOM BUILD 1 INC

Business

Active


JAS WIRELESS INC

Business

Active


ECHO COMMUNICATIONS

Business

Inactive


LOVELY STAR WIRELESS 4 INC

Business

Active


CITY STAR RENOVATION INC

Business

Inactive


FARM BOY MARKET

Business

Active



JOSAN CONSTRUCTION CORP

Business

Active


BANNIE BUILDERS INC

Business

Active


MOLINA CARPENTRY, CORP.

Business

Active


A Z CONSTRUCTION INC

Business

Inactive





YS DANNY'S JEWELRY INC.

Business

Active


B.C. PAINTING, CORP.

Business

Active




HK WIRELESS & MORE CORP

Business

Inactive


WIRELESS WORLD

Business

Active


WIRELESS EXPERTS 1 LLC

Business

Active



RNK WIRELESS INC

Business

Active



ABM CONSTRUCTION USA INC

Business

Active


B&R CONTRACTORS, INC.

Business

Active



NANDRAM HOME IMPROVEMENT CORP

Business

Inactive



supermysticconstructioncorp

Business

Inactive


LIMAS TIRE SHOP, INC.

Business

Active


TECH 4 LESS INC

Business

Active


JADDUROY, DIANAND

Business

Inactive


(default) 2 queries took 355 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 250, 505050122
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)11233