ELMHURST [Permits for ELMHURST]

151 - 200 of 1579

MO & CHO DRYCLEANERS, LLC

Business

Inactive


SUN BRITE LAUNDROMAT INC.

Business

Inactive


ABDULSALAM, OMOTOYOSI

Individual

Active


GOOD NEIGHBOR LAUNDROMAT

Business

Inactive


COPE, LEVANDER R

Individual

Active


OCAL, ABDULLAH

Individual

Inactive


GALAXY ROOM

Business

Inactive


J & M LAUNDROMAT

Business

Inactive


START FRESH LAUNDRAY

Business

Inactive


NEW A.D. LAUNDROMAT,INC

Business

Inactive


ABREU, ALBERTO B

Individual

Active


BALLY LAUNDROMAT INC.

Business

Inactive


HORTENCIA'S LAUNDROMAT

Business

Inactive


JIN XIU LAUNDRYMAT INC.

Business

Inactive


NEW WOODSIDE GROCERY

Business

Active


TUNCER, VOLKAN

Business

Inactive


MARISOL LAUNDROMAT III CORP.

Business

Inactive


LUPITA LAUNDROMAT INC

Business

Inactive


DYLAN'S LAUNDROMAT CORP.

Business

Inactive


SPRAUER, MICHELLE

Business

Active


jarrin yumbla, edison

Individual

Inactive


SEMPERTEGUI, CARLOS A

Individual

Active


HAQUE, MOHAMMED M

Individual

Active


He, Wendy

Individual

Active



JAIRALA, FARIK

Individual

Inactive


WU, YIHUA

Individual

Active


PRONTO FOOD MART

Business

Active


VEGA, JEAN PAUL

Individual

Active


WU, SHICAN

Individual

Inactive


Athanasatos, John

Individual

Active


GILL, RAVINDER

Individual

Inactive


SOHEL, ABU S.

Individual

Active


BRAVO-GUAMAN, PABLO

Individual

Active


CHUA, JACINTO

Individual

Active


TINEO, ARNES A.

Individual

Inactive


JIN SHUAI CHEN

Business

Active



BADHAN, HARBANS

Individual

Active


QUICK STOP GROCERY, INC

Business

Active


NEW BAXTER DELI, INC

Business

Active


GILHOOLY, MICHAEL J

Individual

Active


KUMA, TRIPTA

Individual

Active


CHAND, SANDEEP

Individual

Active


PARRA, WILSON

Individual

Inactive


CORONA GOURMET DELI INC

Business

Active


PORTILLO, JOSE

Individual

Inactive


DL DELI GROCERY CORP.

Business

Active


AREVALO, JORGE R

Individual

Inactive


G&G GROCERY STORE INC.

Business

Active


(default) 2 queries took 283 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 ( '(+ELMHURST)' IN BOOLEAN MODE) LIMIT 150, 50505047
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+ELMHURST)' IN BOOLEAN MODE)11236