ELMHURST [Permits for ELMHURST]

51 - 100 of 1579

LARA, DANIEL

Individual

Inactive


CURIEL, JUAN C

Individual

Inactive


PRADHAN, LEELAMANI

Individual

Inactive


MARISOL LAUNDROMAT INC.

Business

Inactive



SUPER BAXTER LAUNDRY

Business

Inactive


RAINBOW LAUNDROMAT

Business

Inactive


NEW SMILE LAUNDROMAT, INC.

Business

Inactive


KIRALI, KORAY

Individual

Active


BENJAMIN CLEANERS

Business

Inactive


Q.C. SUPER LAUNDRY INC.

Business

Inactive


NEW STARFIVE DRY CLEANERS INC.

Business

Inactive


CLEAN CITY E ELMHURST, LLC

Business

Inactive


Broadway Laundromat

Business

Inactive


TENEZACA, ANGEL

Individual

Active


CORONA NEW TOWN LAUNDROMAT INC

Business

Inactive


PLAZA, JULIO C

Individual

Active


BRITTON LAUNDROMAT, LLC

Business

Inactive


ERIC CLEANERS

Business

Inactive



ILDA'S PLACE II

Business

Inactive


TMW GROUP INC

Business

Active


HAPPY CLEANERS OF NY, INC.

Business

Inactive


LEE'S LAUNDROMAT

Business

Inactive


RODRIGUEZ, ANDRE

Individual

Inactive


BETTY'S CATERING CORP.

Business

Inactive


ILIS, CONSTANTIN

Individual

Active


LA GUARDIA LAUNDRY MART CORP.

Business

Inactive


S & D WHITNEY LAUNDROMAT,INC.

Business

Inactive


HI-STYLE CLEANERS CORP.

Business

Inactive


BUSY BEE FUTURE, INC.

Business

Inactive


SANABRIA, OSCAR

Individual

Active


RONG LAUNDROMAT INC.

Business

Inactive


T-Mobile

Business

Active


GUERRA, MANUEL R

Individual

Active


VERIZON WIRELESS

Business

Active


NEW LEIGH'S CLEANERS INC.

Business

Inactive


COMFORT II, INC.

Business

Inactive


SUASNAVAR, VICTOR

Individual

Active


DELAHANTY, JAMES E

Individual

Active


SABA JEWELERS INC.

Business

Active


SUN LAUNDROMAT

Business

Inactive


BOON CHU THAI PLACE

Business

Active


KING'S CLEANER

Business

Inactive


GARDEN BAY CLEANER 1 INC

Business

Inactive


CORONA, ROBERT

Individual

Active


MOROCHO, GERMAN

Individual

Inactive



RUPA EMPLOYMENT CORP

Business

Active


MARCANO, ENRIQUE

Individual

Active


(default) 2 queries took 229 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 50, 50505015
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)11214