CORONA [Permits for CORONA]

101 - 150 of 1338


HDA GLOBAL INC.

Business

Active


99TH STREET LAUNDROMAT

Business

Inactive


LLIGUICOTA, VICTOR

Individual

Inactive


JASON'S LAUNDRY, INC.

Business

Inactive


DNC LAUNDROMAT INC.

Business

Inactive



LEO, MICHAEL P

Individual

Active


LATIENDA DELI CORP

Business

Inactive


CRYSTAL TREE INC

Business

Inactive


CORONA DRY CLEANERS

Business

Inactive


ROOSIE LAUNDROMAT INC.

Business

Inactive


JACK'S GROCERY & DELI CORP.

Business

Active


RAINBOW DROP LAUNDROMAT INC.

Business

Inactive


LAM, YUNG

Individual

Active


LOS ANDES LAUNDROMAT

Business

Inactive


CHEN, HAO QIU

Individual

Inactive


4112 TAPAN LAUNDROMAT CORP.

Business

Inactive


L C LAUNDROMAT

Business

Inactive



FAICAN, ANGEL

Individual

Active


G & Y LAUNDROMAT INC.

Business

Inactive


OI WAH LAUNDROMAT INC.

Business

Inactive


CANDY & GROCERY FOOD CORP

Business

Active


CHASIJUAN, GUILLERMO

Individual

Inactive


108 CAR CARE, INC.

Business

Inactive


FRANCO, MIZRAIM

Individual

Active


URENA, MAXIMO A

Individual

Active


STOP 1

Business

Active


PAUL, SHYAMAL K

Individual

Inactive


GUMAN DELI GROCERY CORP

Business

Active


LEO, MICHAEL P.

Individual

Active



GRIFFITH, MICHAEL L

Individual

Active


RODRIGUEZ, YOAN

Individual

Active


RIVERA, JAIME

Individual

Inactive


ULLOA, SEGUNDO

Individual

Active


MUKARRAMOV, ANVAR

Individual

Inactive


JR FAMILY GROCERY INC.

Business

Active


AZEEZ, SHAZAM

Individual

Inactive


TOP 1 DELI GRILL INC

Business

Active


NATIONAL DELI & GROCERY INC

Business

Inactive


JR FAMILY GROCERY INC.

Business

Active


CORONA GOURMET DELI INC

Business

Active


BARBECHO, MANUEL

Individual

Active


LUCKY 7 SMOKE SHOP

Business

Inactive


7 ELEVEN STORE #34023

Business

Active



SMOKEY INC

Business

Active


PACIFICO FOOD CORP

Business

Active


(default) 2 queries took 429 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 100, 50505046
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)11383