S RICHMOND HL [Permits for S RICHMOND HL]

201 - 250 of 1838

LOPEZ, OVIDIO

Individual

Inactive


MOHAMMED, RAFFIQUE

Individual

Active


K . S . B COMMUNICATIONS INC

Business

Inactive


SAUNDERS, ANTHONY

Individual

Inactive


SINGH, BALKAR

Individual

Active


GILL, SUNNY

Individual

Active


SINGH, DALVINDER

Individual

Inactive


WILLIAMS, LIONEL G.

Individual

Active


N ARJUN CONSTRUCTION, CORP.

Business

Active


SINGH, LAKHUIR

Individual

Active



ZOOM ZOOM WIRELESS, INC.

Business

Active


RAMNOT CONSTRUCTION CORP.

Business

Active


CHAHAT WIRELESS CORP.

Business

Active


LIZ'S RICHMOND CLEANERS, INC.

Business

Inactive


TRIUMPH ASSET SERVICES

Business

Active


SINGH, HARVINDER

Individual

Active


HOME STYLE DELI GROCERY INC

Business

Active


KUMAR, HARPINDER

Individual

Inactive


RITE AID STORE #4991

Business

Active


QUEENS AUTO MALL, INC.

Business

Active


WIRELESS NETWORK

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


ALLY, ASIF M

Individual

Active


PKG ENTERPRISES INC

Business

Active


INFOCLONE COMPUTERS

Business

Active


SINGH, HARMEL

Individual

Active


GINTER, KENNETH

Individual

Active


SLIM DELI CORP.

Business

Active


KAUR, BALJINDER

Individual

Inactive



101 AUTO MALL INC

Business

Active


RICHMOND TOWING INC.

Business

Inactive


Elite Wireless Group NY

Business

Active


BARROS, RODRIGO E

Individual

Active


MOBILE PLAZA NYC INC

Business

Active


BABA SUPER MARKET INC.

Business

Active


ANGULO, DINA LUZ

Individual

Active


RITE AID STORE #572

Business

Active


SINGH, JASWINDER

Individual

Active


KAUR, RAJINDER

Individual

Inactive



SINGH, GURMUKH

Individual

Active


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