ASTORIA [Permits for ASTORIA]

201 - 250 of 2491

WHIZ CLEANERS

Business

Inactive


TISSIRA, MOHAMED

Individual

Active


DAVE BRAND LAUNDRY, INC.

Business

Inactive




VICKY'S LAUNDROMAT INC

Business

Inactive


Best Today's Laundromat

Business

Active


R M A SUPER LAUNDROMAT INC

Business

Inactive


METRO CLEANER & LAUNDROMAT INC

Business

Inactive


2701 CLEANERS INC.

Business

Inactive


AROUND THE CORNER LAUNDROMAT 2

Business

Inactive


KING OF QUEENS LAUNDROMAT, LLC

Business

Inactive


AREVALO, EMMANUEL

Individual

Inactive


KCL 4J CORP.

Business

Inactive


BING FANG ZHOU

Business

Inactive


KRUMMENAUER, PAULO

Individual

Active


DITMARS CLEANERS

Business

Inactive



HUI HUI LAUNDROMAT, INC.

Business

Inactive


T & J CRYSTAL INC

Business

Inactive


PADILLA, NICOLE B

Individual

Active


THE LAUNDRY REPUBLIC CORP.

Business

Inactive


MK LAUNDROMAT CORP.

Business

Inactive


BAILEY, WARREN L

Individual

Active


MURPHY, TIMOTHY

Individual

Active


25 JJ LAUNDROMAT, INC.

Business

Inactive


PERUVIAN LAUNDROMAT CORP.

Business

Inactive


JORDAN, GERARD

Individual

Active


JMW ROCKET LAUNDROMAT, INC.

Business

Inactive


A & E CLEANERS CORP

Business

Inactive


XL LAUNDROMAT, INC.

Business

Inactive


NATAGANA, INC.

Business

Inactive


Annis Florals

Business

Active


ANDREAKOS, APOSTOLOS

Individual

Active


HP 1 LAUNDROMAT, INC.

Business

Inactive


APOSTOLAKIS, APOSTOLOS

Business

Inactive



KWIK LAUNDROMAT, INC.

Business

Inactive



LONG ISLAND CITY FLOWER INC

Business

Active


SULTONOV, ABDULAZIZ

Individual

Inactive


260 MARC VALET, INC

Business

Inactive


YOUNG LAUNDROMAT INC

Business

Inactive


STICKLES, JEFFREY

Individual

Inactive


STEHLING, PHILLIP

Individual

Active


Abdelkerim, Doaa

Individual

Inactive


TSOUROS, SOPHOCLES

Individual

Active



TEDDY'S BEST, INC.

Business

Inactive


Z.H. ASTORIA ENTERPRISES INC.

Business

Inactive


(default) 2 queries took 382 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 200, 50505031
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)11351