FLUSHING [Permits for FLUSHING]

201 - 250 of 2928

THEODORAKATOS, MARIA

Individual

Active


JEON, CHUNG KOOK

Individual

Inactive


BONNIE BRITE CLEANERS

Business

Inactive


Y&B ENTERTAINMENT MANOR INC

Business

Inactive


CHU, PING

Individual

Active


FLUSHING JEWELRY & PAWN LLC

Business

Active


LI LI LAUDROMAT

Business

Inactive


HARRIS, ISAAC

Individual

Inactive


STAR LAUNDROMAT CORP.

Business

Inactive


ON-THE-MARC DRY CLEANERS INC

Business

Inactive


Pavich, Philip

Individual

Active


MITCHELL GARDENS CLEANERS INC.

Business

Inactive


HYSENI, GENTIAN

Individual

Active


PANETTA, FRANCESCO

Individual

Active


KISSENA QUALITY CLEANERS, LLC

Business

Inactive


RUAN, CHUNYONG

Individual

Inactive


MARQ&W LLC

Business

Active


Liu, Qiming

Individual

Active


192 LAUNDROMAT INC.

Business

Inactive


CHOE, YONGGI

Individual

Active


JI XIANG 168 LAUNDROMAT INC.

Business

Inactive


SUPER C. GROUP INC.

Business

Inactive


HABER, SCOTT A

Individual

Active


SEVEN CLEANERS

Business

Inactive


AGRO, LUIGI

Individual

Active


AUBURNDALE LAUNDROMAT INC.

Business

Inactive


DEMARIO, JEFFREY

Individual

Active


LI, DONGRI

Individual

Inactive


WOLOS, MICHAL

Individual

Active


CAPUTO, JOSEPH

Individual

Active


EAST BUILDERS INC

Business

Active


HARRIS, JUSTIN

Individual

Active


NEW IN & OUT CLEANERS INC

Business

Inactive


GOOD LUCK LAUNDROMAT

Business

Inactive


GREENWAY CLEANER INC.

Business

Inactive


SCHIAVONE, MICHAEL

Individual

Active


NAR DRY CLEANING INC

Business

Inactive


ZHOU, CHANGBO

Individual

Active


KIM, WALTER

Individual

Inactive



E GARDEN FLUSHING INC

Business

Active


USA Debt Inc.

Business

Inactive


MEADOW LAUNDROMAT, INC.

Business

Inactive


FROM HAT TO TOE

Business

Inactive


Zheng, Yindi

Individual

Active


DOTTERER, HEIDI M

Individual

Inactive


KELLEY, BRUCE

Individual

Inactive


XU, QIANGHUA

Individual

Inactive


WANG, WANG QING

Individual

Inactive


CHEM-1 ENTERPRISES OF NY

Business

Inactive


(default) 2 queries took 239 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 ( '(+FLUSHING)' IN BOOLEAN MODE) LIMIT 200, 50505021
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+FLUSHING)' IN BOOLEAN MODE)11218