EAST ELMHURST [Permits for EAST ELMHURST]

51 - 100 of 609

XU ASTORIA BLVD LAUNDRY LLC

Business

Inactive


THE PAISA JEWELRY CSP CORP

Business

Active


MO & CHO DRYCLEANERS, LLC

Business

Inactive


SUN BRITE LAUNDROMAT INC.

Business

Inactive


GOOD NEIGHBOR LAUNDROMAT

Business

Inactive


COPE, LEVANDER R

Individual

Active


GALAXY ROOM

Business

Inactive


J & M LAUNDROMAT

Business

Inactive


NEW A.D. LAUNDROMAT,INC

Business

Inactive


HORTENCIA'S LAUNDROMAT

Business

Inactive


LUPITA LAUNDROMAT INC

Business

Inactive


jarrin yumbla, edison

Individual

Inactive


HAQUE, MOHAMMED M

Individual

Active


JAIRALA, FARIK

Individual

Inactive


WU, SHICAN

Individual

Inactive


Athanasatos, John

Individual

Active


GILL, RAVINDER

Individual

Inactive


SOHEL, ABU S.

Individual

Active


TINEO, ARNES A.

Individual

Inactive


BADHAN, HARBANS

Individual

Active


QUICK STOP GROCERY, INC

Business

Active


GILHOOLY, MICHAEL J

Individual

Active


KUMA, TRIPTA

Individual

Active


CHAND, SANDEEP

Individual

Active


DL DELI GROCERY CORP.

Business

Active


Hot, Samira

Individual

Active


MIEDZIEJEWSKI, MARCIN

Individual

Inactive


SINGH, AVTAR

Individual

Active


KEITA, PAPA

Individual

Inactive


JOHNSON, CHRISTOPHER

Individual

Active


PARKER, HAYWOOD L

Individual

Active


SAFOS, ZACHARIAS

Individual

Active


DAY DELI GROCERY CORP.

Business

Active


DOGANIS, GEORGIOS

Individual

Inactive


B & D CONSTRUCTION NY, CORP.

Business

Inactive


SALIM, HASAN

Individual

Active


SPEEDWAY#07806

Business

Active


BABIC, MARINKO

Individual

Inactive


SP PLUS CORPORATION

Business

Active


DURSI, FRANK

Individual

Active


BERRETTINI, DANNY J

Individual

Active


KONTARINES, STEVE E

Individual

Inactive


WE-LINK EMPLOYMENT LLC

Business

Inactive


SINGH, JASBIR

Individual

Active


DOUKAKIS, NIKOLAOS

Individual

Active


COREA, ANDRE

Individual

Active


WILSON, JOE

Individual

Inactive


SANCHEZ-PINEDA, JUAN

Individual

Inactive


WALGREENS STORE #04058

Business

Active


100-15 DITMARS PARKING LLC

Business

Active


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