SOUTH RICHMOND HILL [Permits for SOUTH RICHMOND HILL]

1 - 50 of 728

GILLESPIE, WILLIAM P.

Individual

Active


APNA BAZAR CASH & CARRY

Business

Active


BAJWA, MUHAMMAD

Individual

Active


Singh, Agambeer

Individual

Active


SINGH, HARSHPREET

Individual

Active


PIRIZ, BRUNO

Individual

Active


PORTZ FLORAL MART, INC

Business

Inactive


BUDHRAM, MOHABIR

Individual

Active


APNA SOHNA BAZAR

Business

Inactive


QUEENS DELI & GROCERY CORP.

Business

Active


TRINI DELITE

Business

Inactive


S.K CANDY AND TOBACCO CORP

Business

Inactive


SINGH, AMANDIP

Individual

Active


S.K CANDY AND TOBACCO CORP

Business

Active


NEW DARWESH CONSTRUCTION INC.

Business

Inactive


JATTAN, ROGER

Individual

Active


HONG KONG LAUNDROMAT INC.

Business

Inactive


LIBERTY CONSTRUCTION

Business

Active


NO 1 MODERN LAUNDROMAT INC

Business

Inactive



KAUR, RANJIT

Individual

Inactive


SUKHWINDER, SINGH

Individual

Active


GADURAS LAUNDROMAT, INC.

Business

Inactive


PMP CONVENIENCE CORP.

Business

Active


LIBERTY AVE. LAUNDROMAT, INC.

Business

Inactive


SEHMBY, HARMEET

Individual

Inactive


SINGH, LOVEPREET

Individual

Active


ASLAM, MUHAMMAD

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


Ramjattan, Tejram

Individual

Active


KOMAL, JATINDER S

Individual

Active


PREM'S LAUNDRY INC.

Business

Inactive


HENRY'S LAUNDROMAT INC.

Business

Inactive


EMPIRE LAUNDROMAT USA INC.

Business

Active


SINGH, HARDEEP

Individual

Active


LIBERTY AVENUE LAUNDRY CORP.

Business

Inactive


KING FAHD DELI AND GROCERY INC

Business

Inactive


VIVA LAUNDROMAT, INC

Business

Inactive



SURUJNARINE, SOMATTIE

Individual

Active


SINGH, KULWANT

Individual

Active


SINGH, GIAN

Individual

Inactive


RICHMOND HILL CLEANERS INC.

Business

Inactive


DINMAHAMAD, MOONAF

Individual

Active


SINGH, BALDEV

Individual

Active


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