CORONA [Permits for CORONA]

51 - 100 of 1338

KING 103 LAUNDROMAT INC

Business

Inactive


YANG LAUNDROMAT

Business

Inactive


GL 108 LAUNDROMAT INC.

Business

Inactive


L & G BEST LAUNDROMAT INC.

Business

Inactive


CRYSTAL BALL GROUP INC.

Business

Inactive


SUWAL ELECTRONICS

Business

Active


5 DE MAYO GROCERY CORP

Business

Active


LOPEZ, JOSE A

Individual

Inactive


PUEBLA LAUNDROMAT, INC.

Business

Inactive


BIG RUSS LTD.

Business

Inactive


YANCUI'S LAUNDROMAT L.L.C.

Business

Inactive


C & Y LAUNDROMAT LLC

Business

Inactive


Y & Y LAUNDROMAT, INC.

Business

Inactive


EXPRESS 1 LAUNDROMAT

Business

Inactive


URBAN LAUNDROMAT INC.

Business

Inactive


BABA LOKENATH LAUNDROMAT INC.

Business

Inactive


111 LAUNDROMAT

Business

Inactive


CORONA, ROBERT

Individual

Active


DREAMLAND AMUSEMENTS

Business

Active


ROMERO, GILBERTO

Individual

Inactive



CONDORS, JEORGE

Individual

Active



101 NORTHERN LAUNDROMAT INC.

Business

Inactive


FRIENDLY LAUNDROMAT

Business

Inactive


L ONE LAUNDROMAT, INC

Business

Inactive


JSLS LAUNDRY, INC.

Business

Inactive


LAVANDERA LAUNDROMAT, INC.

Business

Inactive


LOKENATH LAUNDROMAT INC.

Business

Inactive


ABREU, HEREDIA A

Individual

Active




99 ST. LAUNDRY LLC

Business

Inactive


J.M.B. LAUNDROMAT CORP.

Business

Inactive


BLAINE, LI YE D

Individual

Active


RUILOVA, GEORGE

Individual

Active


MOROCHO, MANUEL

Individual

Active


SHEN, INC.

Business

Inactive


SHOWERS OF GRACE LLC

Business

Active


GM AUTO BODY REPAIR INC.

Business

Active


COSME, SAMANTHA

Individual

Inactive


QUIZHPILEMA, PATRICIO

Individual

Active


FLORENCE CLEANERS

Business

Inactive



CORONA 103 LAUNDROMAT, INC.

Business

Inactive


sinchi, saulo

Individual

Inactive


JIANHUA, WANG

Individual

Inactive


ISABEL'S LAUNDRY CORP.

Business

Inactive


QUEENS SUPER LAUNDROMAT

Business

Inactive


AKMAGAMBETOV, ANUAR

Individual

Inactive


(default) 2 queries took 565 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 ( '(+CORONA)' IN BOOLEAN MODE) LIMIT 50, 50505048
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+CORONA)' IN BOOLEAN MODE)11517