ELMHURST [Permits for ELMHURST]

101 - 150 of 1579

SALMA L& M JEWELRY CORP

Business

Inactive



CARDONA, CHRISTIAN CAMILO

Individual

Inactive


SIBRE, ROBERTH

Individual

Active



LUXURY LAUNDROMAT, INC

Business

Inactive


KEARNEY STREET LAUNDROMAT INC.

Business

Inactive


URREHMAN, KHALIL

Individual

Active



KIM, YONG S

Individual

Inactive


DSM LAUNDROMAT INC

Business

Inactive


MALIK, KABBIR

Individual

Inactive


CHILLOGALLI, CESAR

Individual

Active


USA CLEAN CENTER CO., INC.

Business

Inactive


RENOIR FRENCH CLEANERS

Business

Inactive


TJP CLEANERS INC

Business

Inactive


SAH, SHAILENDRA

Individual

Active


TAE WOO CLEANER

Business

Inactive


ELMCOR LAUNDROMAT INC.

Business

Inactive


ENCARNACION, DANILSA

Individual

Inactive


ZHANG, DUAN JUN

Individual

Active


ELMHURST LAUNDRY CENTER INC.

Business

Inactive


KAIRUPAN, ALEXANNIE D

Individual

Active


ULLAH, NAQI

Individual

Active


MICHAEL DELI GRILL CORP

Business

Active


DO RE MI LAUNDROMAT, INC.

Business

Inactive


WANG FUN REE LAUNDROMAT

Business

Inactive


SUNSHINE BRIGHT DRY CLEANERS

Business

Inactive


32-01 JUNCTION INC.

Business

Inactive


110 LAUNDROMAT INC.

Business

Inactive


ZHENG'S LAUNDROMAT

Business

Inactive


G&Q LAUNDROMAT, INC

Business

Inactive


EYYUP, GUNES

Individual

Inactive


CASH FOR GOLD JEWELRY

Business

Active


KINGS AND QUEENS HOMES CORP

Business

Inactive


M.Y LAUNDROMAT

Business

Inactive


LUMIS LAUNDROMAT CORP

Business

Inactive


FOUR SEASON CLEANERS

Business

Inactive


MUSLUOGLU, SUBUTAY

Individual

Active


VERIZON WIRELESS

Business

Active



LEE, CARL K

Individual

Active


HUA YU LAUNDROMAT

Business

Inactive


YUEN, PATRICK

Individual

Inactive


BAO'S LAUNDROMAT INC.

Business

Inactive


GOLDEN 44 WASH & DRY, INC.

Business

Inactive


968 LAUNDROMAT

Business

Inactive


XU ASTORIA BLVD LAUNDRY LLC

Business

Inactive


BOON CHU THAI PLACE

Business

Active


THE PAISA JEWELRY CSP CORP

Business

Active


(default) 2 queries took 21 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 100, 50505021
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)110