S RICHMOND HILL [Permits for S RICHMOND HILL]

601 - 650 of 1451

R&M HOME IMPROVEMENT

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


KSD APPLIANCES INC

Business

Inactive


ALL IN ONE CONSTRUCTION LLC

Business

Inactive




JAP RESTORATION INC.

Business

Active



NANDRAM HOME IMPROVEMENT CORP

Business

Inactive


HONG KONG WASH & DRY

Business

Active



SURIEL DELI & GROCERY INC

Business

Inactive



supermysticconstructioncorp

Business

Inactive


GENESIS STORE 1

Business

Inactive


LIMAS TIRE SHOP, INC.

Business

Active


FUTURE RESTORATION, INC.

Business

Active


EBRO CONSTRUCTION CORP

Business

Inactive


TECH 4 LESS INC

Business

Active


JADDUROY, DIANAND

Business

Inactive


ANMOL K CONSTRUCTION CORP

Business

Active


N BARLOW CONSTRUCTION LLC

Business

Active


J S SAINI CONSTRUCTION CORP

Business

Active


R & G AUTO REPAIR, INC.

Business

Active


TBRO'S RENOVATION INC.

Business

Active



SMART MOBILE STOP CORP

Business

Active


ezra supply inc

Business

Active


FOUR SEASON USED CARS INC.

Business

Active


FIORE LANDSCAPING, INC.

Business

Active


LOCKDOCTOR LOCKSMITHS, INC.

Business

Active


PERSAUD ENTERPRISES INC.

Business

Active


DENNIS RIGAS FLORAL CREATIONS

Business

Inactive


SKYPE CONSTRUCTION CORP

Business

Inactive


TABARA TIRE SHOP INC.

Business

Inactive


HILLSIDE TIRE SHOP, INC.

Business

Inactive



MAHANAIM GE32 CORP

Business

Inactive




CARMEN'S LAUNDROMAT COMPANY

Business

Active



VICKTECK CONSTRUCTION CORP

Business

Active



(default) 2 queries took 993 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 ( '(+S +RICHMOND +HILL)' IN BOOLEAN MODE) LIMIT 600, 505050417
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+S +RICHMOND +HILL)' IN BOOLEAN MODE)11576