S RICHMOND HL [Permits for S RICHMOND HL]

401 - 450 of 1838

SINGH, BALJIT

Individual

Active


PABON, RAFAEL

Individual

Active


SINGH, PARMINDER

Individual

Active


SINGH, DHARMBIR

Individual

Active


SINGH, GURPREET

Individual

Active


KUMAR, RAKESH

Individual

Active


SAHADEO, CHANDRAPAUL

Individual

Inactive


KAUR, ANOOP

Individual

Inactive


DERBEW, ALEYAS

Individual

Active


SINGH, AMANDIP

Individual

Active


ADAMS, GEORGE

Individual

Inactive


SURAT, RAYMOND R.

Individual

Inactive


SINGH, KULWANT

Individual

Active


KAYANI J, SHAMAS

Individual

Inactive


SINGH, GURNAND

Individual

Active


SINGH, SURJEET

Individual

Active


SINGH, JASPAL

Individual

Active


NATHOO, WILLIAM

Individual

Active


SINGH-MULTANI, KHALWINDER

Individual

Active


SAHADEO, BISSESSAR

Individual

Active


HIDALGO, ALICIA

Individual

Active


SINGH, PARMINDER

Individual

Active


SINGH, GURWINDER

Individual

Active


NIEVES, WILLIAM

Individual

Active


MOJUM, ROY

Individual

Inactive


GILL, IQBAL

Individual

Active


CABRERA, CRISTOBAL

Individual

Active


SANTOS, JOSE A

Individual

Active


DREBSKY, JEFFREY

Individual

Inactive


SINGH, SUKHWINDER

Individual

Active


ROOPCHAN, RAJESH

Individual

Active


MOLINA, MANUEL

Individual

Active


KAUR, RAJINDER

Individual

Active


KAUR, PASHMINDER

Individual

Active


BUDHU, VIDYANANDA

Individual

Active


KHEMRAJ, MESHAN

Individual

Active


MANIRAM, DOODNOUTH

Individual

Active


KAUR, KULJIT

Individual

Active


JADDUROY, DIANAND

Individual

Inactive


SINGH, GURDEEP

Individual

Active


VEGA, MANUEL

Individual

Inactive


BARKER, WORDSWORTH

Individual

Active


MAHABEERSINGH, MAHASE

Individual

Active


SINGH, BALJINDER

Individual

Inactive


RANDHAWA, HARMANDEEP

Individual

Active


RODRIGUEZ, RINGO

Individual

Active


T-MOBILE

Business

Inactive


GULZAR, NFN

Individual

Active


SEVERINO, PEDRO

Individual

Active


SINGH, PRITAM

Individual

Active


(default) 2 queries took 335 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 400, 50505080
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)11255