S RICHMOND HILL [Permits for S RICHMOND HILL]

1 - 50 of 1451

GILLESPIE, WILLIAM P.

Individual

Active


SINGH, BHAGWANT

Individual

Active


APNA BAZAR CASH & CARRY

Business

Active


Y&Z DELI CORP.

Business

Inactive


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


PEREZ, FREDDY

Individual

Inactive


BALGOBIN, PAULLEY

Individual

Active


ROSE, CHRISTOPHER

Individual

Active


GARCIA, NELSON A

Individual

Active


SINGH, AMANDIP

Individual

Active


S.K CANDY AND TOBACCO CORP

Business

Active


NEW DARWESH CONSTRUCTION INC.

Business

Inactive



DUER, STEPHEN C

Individual

Inactive


LAGUMDZJIA, EMIL

Individual

Inactive



MARTINEZ VAZQUEZ, RENE

Individual

Inactive



JATTAN, ROGER

Individual

Active


JONES, JAMES C

Individual

Active


Y & M LUCKY LAUNDROMAT INC.

Business

Inactive


MUNOZ, GABRIEL A

Individual

Inactive


HONG KONG LAUNDROMAT INC.

Business

Inactive


LIBERTY CONSTRUCTION

Business

Active


CLEAN CITY LAUNDROMAT NY INC

Business

Inactive


SINGH, MANPREET

Individual

Active


NO 1 MODERN LAUNDROMAT INC

Business

Inactive



SEPULVEDA, MACHISTE

Individual

Inactive


KAUR, RANJIT

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


(default) 2 queries took 254 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 50505013
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)11241