S RICHMOND HL [Permits for S RICHMOND HL]

51 - 100 of 1838

SEPULVEDA, MACHISTE

Individual

Inactive


KAUR, RANJIT

Individual

Inactive


HARRICHARAN, SATDEO

Individual

Inactive


SUKHWINDER, SINGH

Individual

Active


HONGFA LAUNDROMAT INC.

Business

Inactive


LIONS 123 INC.

Business

Inactive


MENDEZ, GUSTAVO

Individual

Inactive


GADURAS LAUNDROMAT, INC.

Business

Inactive


BUDHRAM, JAIRAM

Individual

Active


MAHIL, MANJIT S

Individual

Active


PMP CONVENIENCE CORP.

Business

Active


LIBERTY AVE. LAUNDROMAT, INC.

Business

Inactive


SINGH, HARVINDER

Individual

Active


SINGH, HARBHAJAN

Individual

Active



LAVA XPRESS, INC.

Business

Inactive



SEHMBY, HARMEET

Individual

Inactive


SINGH, LOVEPREET

Individual

Active


ASLAM, MUHAMMAD

Individual

Active


ALLY, AZZEM

Individual

Inactive


SUKHOO, LAKHANLALL

Individual

Active


KISSOON, MOHABIR

Individual

Active


WIRELESS 1 OF RICHMOND HILL

Business

Inactive


AMY'S CLEANERS

Business

Inactive


RICHMOND TOWN CLEANERS

Business

Inactive


AAL'S LAUNDROMAT

Business

Inactive


BHIRO, NIPAUL B.

Individual

Active


SINGH, SEERANIE

Individual

Active


TOP RICHMOND CLEANERS, INC.

Business

Inactive


VILLA RUSSO/IL PALAZZIO

Business

Inactive


KHOKER, BRIAN S

Individual

Active



EMPIRE LAUNDROMAT USA INC.

Business

Inactive


CARMEN'S LAUNDROMAT COMPANY

Business

Inactive


Sookrajh, Aviskar

Individual

Active


FRESH POINT MARKET INC.

Business

Active


SALERNO, DAVID D

Individual

Active



JH & H LAUNDROMAT INC.

Business

Inactive


DANINO, MEIR Y

Individual

Active


SIDDIQUE, MOHSIN

Individual

Active


Ramjattan, Tejram

Individual

Active


AAA ACE TRANSMISSIONS INC.

Business

Inactive


LEONARD, BHARRAT

Individual

Active


132-03 JAMAICA LAUNDRY CORP.

Business

Inactive


KOMAL, JATINDER S

Individual

Active


SINGH, RASHPAL

Individual

Active


SINGH, KULWINDER

Individual

Active


HEER, DHARAMVEER

Individual

Inactive


(default) 2 queries took 237 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 50, 50505016
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)11221