ASTORIA [Permits for ASTORIA]

251 - 300 of 2491

CHIC CLEANER, INC.

Business

Inactive


TENCHODO LAUNDROMAT

Business

Inactive


DITMARS LAUNDRY CORP.

Business

Inactive


SEFEROVIC, IFET

Individual

Inactive


WELL DUN CLEAN & TAILOR INC.

Business

Inactive


SPEED WASH II LAUNDRY CORP.

Business

Inactive


S&M ORTIZ LAUNDROMAT II INC.

Business

Inactive


HUSSAIN, GHAYOOR

Individual

Active



ALMIROUDIS, GEORGE JR

Individual

Inactive


DIKOMO INC.

Business

Inactive


WIDE LAKE 4, INC.

Business

Active


301 BROADWAY LAUNDROMAT INC.

Business

Inactive


QUICK DROP OFF LAUNDROMAT INC

Business

Inactive


CHAUDHRY, MOHAMMED J

Individual

Active


POUMPOURAS, THEODOROS

Individual

Active


TENEZACA, JAIME

Individual

Active


FAMOUS CLEANERS

Business

Inactive


3N BUBBLES, INC.

Business

Inactive


FLOSSOS, SPIRO

Individual

Active


Green Spin Laundry Express

Business

Inactive


BROADWAY 21 CLEANERS

Business

Inactive


GREEN SPIN LAUNDRY

Business

Inactive


DOHERTY, DAVID MICHAEL

Individual

Active


HOUSE OF SUDZ

Business

Inactive


ALL NIGHT CANDY CORNER CORP.

Business

Inactive


ELKHEZZANI, ABDELAMINE

Individual

Inactive


S&M ORTIZ LAUNDROMAT II INC.

Business

Inactive


M.Y. CLEANERS COMPANY

Business

Inactive


NISSENBOUM, DANIEL EVAN

Individual

Inactive


ASTORIA LAUNDRY DEPOT INC

Business

Inactive


MILIC, MILAN

Business

Inactive


YW ASTORIA INC

Business

Active


Mercado, Nelson

Individual

Active


XU ASTORIA BLVD LAUNDRY LLC

Business

Inactive


LAUNDRY BASKET ASTORIA, LLC

Business

Inactive


KIRSCH, SAMUEL

Individual

Active


AROUND THE CORNER LAUNDROMAT

Business

Inactive


DUNN, IAN

Individual

Active


DUN-RITE LAUNDROMAT INC.

Business

Inactive


THALA LLC

Business

Active


JERIC ENTERPRISES INC

Business

Inactive


PRINCESS DRY CLEANERS INC.

Business

Inactive


MARKATOS, SPIRO

Individual

Inactive


JODIE KING LAUNDRY INC

Business

Inactive


Carter, Marie

Individual

Active


LEE LUCKY LAUNDROMAT INC

Business

Inactive


BERKITEN, MURAT

Individual

Inactive


LARA, BRANDO

Individual

Active


RadioShack

Business

Active


(default) 2 queries took 372 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 ( '(+ASTORIA)' IN BOOLEAN MODE) LIMIT 250, 50505036
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+ASTORIA)' IN BOOLEAN MODE)11336