ASTORIA [Permits for ASTORIA]

101 - 150 of 2491

HOUSE OF SUDZ II INC.

Business

Inactive


PROFESSIONAL LAUNDROMAT OF N Y

Business

Inactive


BORDONE, ROSARIO

Individual

Active


IBAY, DIANE

Individual

Inactive



KHARLAMOV, DANILA

Individual

Active


GALLINO, RICHARD R

Individual

Active


IBX SERVICES, LLC

Business

Active


NAVARRO, DENNISE

Individual

Active


SC LAUNDROMAT INC.

Business

Inactive


PANGIO GROUP INC

Business

Inactive


SENDROW, SCOTT H

Individual

Active


JOY LAUNDROMAT INC.

Business

Inactive


SPIN CITY CORP.

Business

Inactive


WASH-TIME, INC.

Business

Inactive


CK1 PROCLEANER INC

Business

Inactive


AGUERO, ANDRES

Individual

Inactive


ARGYROS, GEORGIOS

Individual

Active


LINDBAUM LAUNDROMAT INC

Business

Inactive


LUNA, SAMUEL

Individual

Inactive


97-26 LLC

Business

Inactive


FODOR, ZSOLT

Individual

Inactive


HENGAL, JONATHAN

Individual

Active


31 ST WASH WORLD INC.

Business

Inactive


ORDAS, ANTONIO

Individual

Active


PREDA, STEFAN

Individual

Active


THE BONNIE

Business

Active


HECKER, CANDYCE

Individual

Active


HIROSE, AKIKO

Individual

Active


WHIZ CLEANERS

Business

Inactive


CRUZ, MARIA DEL CAMPO

Individual

Inactive


SPAJIC, MIRKO

Individual

Active


Gamble, Zachary

Individual

Inactive


MAMMIS, PETER

Individual

Inactive


MOULAVASSILIS, JIM

Individual

Active


DORIS LAUNDROMAT INC.

Business

Inactive


Speed Wash I Laundry Corp.

Business

Inactive


PENA, ROBERTO

Individual

Active


GENEL, GURHAN

Individual

Inactive


CHOW'S LAUNDRY, INC

Business

Inactive


G & M LAUNDROMAT

Business

Inactive


Walsh, Steven

Individual

Active



MAGIC LAUNDRY SERVICES INC.

Business

Inactive


RODRIGUEZ, ANTONIO

Individual

Active


AAN DELI & GROCERY INC.

Business

Active


TJ 21 CLEANERS CORP.

Business

Inactive


MIYAKE, JUN

Individual

Active


V.N.M.G. SERVICES, LLC

Business

Inactive


ARABATZIS, DIMITRIOS

Individual

Inactive


(default) 2 queries took 230 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 100, 50505019
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)11211