S RICHMOND HILL [Permits for S RICHMOND HILL]

151 - 200 of 1451

VAPORIZE INC

Business

Active


SABHARWAL, MOHIT

Individual

Active


DIAVEL DESIGNS CORP

Business

Active


BOTTARI, MARIE

Individual

Active


SINGH, AMANDEEP

Individual

Active


CAI, JINHUA

Individual

Inactive


101 CORNER FOOD MART INC

Business

Active


LOPEZ, OVIDIO

Individual

Inactive


MOHAMMED, RAFFIQUE

Individual

Active


K . S . B COMMUNICATIONS INC

Business

Inactive


SAUNDERS, ANTHONY

Individual

Inactive


GILL, SUNNY

Individual

Active


WILLIAMS, LIONEL G.

Individual

Active


N ARJUN CONSTRUCTION, CORP.

Business

Active



ZOOM ZOOM WIRELESS, INC.

Business

Active


RAMNOT CONSTRUCTION CORP.

Business

Active


CHAHAT WIRELESS CORP.

Business

Active


SINGH, HARVINDER

Individual

Active


HOME STYLE DELI GROCERY INC

Business

Active


QUEENS AUTO MALL, INC.

Business

Active


KGS SERVICES INC

Business

Active


RASHMEET CONSTRUCTION CORP

Business

Active


KAUR, SUKHRAJ

Individual

Inactive


RAMNOT, JOHN

Individual

Active


WIRELESS 2010 INC.

Business

Active


QUIK TOWING INC

Business

Inactive


PETERS, ROMELL A

Individual

Active


FAGOT, WILBER

Individual

Active


PKG ENTERPRISES INC

Business

Active


SINGH, HARMEL

Individual

Active


GINTER, KENNETH

Individual

Active


SLIM DELI CORP.

Business

Active



101 AUTO MALL INC

Business

Active


Elite Wireless Group NY

Business

Active


MOBILE PLAZA NYC INC

Business

Active


BABA SUPER MARKET INC.

Business

Active


ANGULO, DINA LUZ

Individual

Active


KAUR, RAJINDER

Individual

Inactive



T-Mobile

Business

Active


RIGHT CHOICE SUPPLY INC

Business

Active


SAMMY, VENESSA

Individual

Active


SINGH, KAMALJIT

Individual

Active


A & M DELI & GRILL INC

Business

Active


WALGREENS STORE #12490

Business

Active


SRB LIBERTY WIRELESS INC

Business

Active


RAGHUBIR, DENNIS O

Individual

Active


SINGH, PARMINDER

Individual

Active


(default) 2 queries took 332 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 150, 50505039
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)11293