FLUSHING [Permits for FLUSHING]

251 - 300 of 2928

JUN, SURIN

Individual

Inactive


LU, CHIALING

Individual

Inactive


KISSENA CLEANERS, INC

Business

Inactive


SEO, DONG

Individual

Active


WANG, MENGHAO

Individual

Active


APPLE 21 CLEANER INC

Business

Inactive


PEOPLE EMPLOYMENT AGENCY

Business

Active



RICCARDI, STEPHEN

Individual

Active


SHANG, SHUPING

Individual

Active


ROYAL 88 CLEANERS INC.

Business

Inactive


42-63 PING AN LAUNDROMAT INC.

Business

Inactive


KIM, BRYAN JANG UK

Individual

Active


WONG, KWONG YIU

Individual

Active


FOUR SEASONS FLORISTS, INC.

Business

Active


PERMA CLEAN CORP.

Business

Inactive


LINDEN VIEW LAUNDROMAT

Business

Inactive


ROLDAN, WALTER

Individual

Active


Spielmann, Paul

Individual

Active


HU, JOYCE W

Individual

Active


HAPPY GARDEN LAUNDROMAT INC.

Business

Inactive


WANGS EMPLOYMENT AGENCY

Business

Active


GRACE SCOT CLEANERS

Business

Inactive


HARTOFILIS, PETER

Individual

Active


AMI CONVENIENCE INC

Business

Active


LOPEZ PORTILLO, JOVEL

Individual

Active


RONG CHENG LAUNDROMAT INC.

Business

Inactive


SANCHEZ-LIM, JOSE

Individual

Active


Tong, Hoyin

Individual

Active


RICKY DELI STORE II INC.

Business

Active


Hztech Access Inc

Business

Active


GUO, WEIXING

Individual

Inactive


RAMIREZ, JOSE G

Individual

Active


INZALACO, FILOMENA J

Individual

Inactive


LI, JIMMY K

Individual

Active


WU, ZHONGHUA

Individual

Active


Kou, Hiu fu

Individual

Active


DARBY, SOO-HWA

Individual

Active


T & F UNITED INC

Business

Active


HUANG, BAO SONG

Individual

Active


PARK SERVICE STATION INC.

Business

Active


MUSSATAYEV, BATYRLAN

Individual

Inactive


RIVERA, DIANA

Individual

Active


ROSENTHAL, ABE

Individual

Inactive


Individual

Active



BACUKU, LUAN

Individual

Active


CHEN, FU-QUAN

Individual

Active


GUZMAN, JAROL

Individual

Active


TANG, ALEX

Individual

Active


(default) 2 queries took 286 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 250, 50505044
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)11242