CORONA [Permits for CORONA]

1 - 50 of 1338

ANGELS FLOWER SHOP

Business

Inactive


MARSHALL, JASON T.

Individual

Inactive


RAMIREZ, BAIRON

Individual

Active


EL HUERTO MINI MARKET CORP

Business

Inactive


LA FAVORITA DELI & GROCERY

Business

Inactive


LIMON, BENJAMIN J

Individual

Inactive


MARTINEZ, MAURICIO

Individual

Active


KHOLMIRZOEV, ANSORI

Individual

Active


PATEL, BHARATKUMAR C

Individual

Inactive


F & R GROCERY

Business

Inactive


LOJA, CLAUDIO

Individual

Active


JESSICA'S ENTERPRISE INC

Business

Inactive


CORONA, FRANCISCO

Individual

Active


PACIFICO FOOD CORP

Business

Inactive


SEA TOWN CORONA NY LLC

Business

Inactive


ALVARADO, MAXIMINA

Business

Inactive


ROOSEVELT FOOD CORP.

Business

Inactive


FIRST STOP GROCERY

Business

Inactive


SEA TOWN CORONA NY LLC

Business

Inactive


BLANCAS VARIETYS

Business

Inactive


CONDOR RECORDS

Business

Inactive


A+ GOURMET DELI INC

Business

Inactive


POLOMSKY, ROSTISLAV

Individual

Inactive



OCHOA, JAIRO

Individual

Inactive


MARIAH GROCERY

Business

Inactive


GOMEZ, TEODORO

Individual

Active


MENDOZA FLOWERS AND GIFT SHOP

Business

Inactive


72 EMPLOYMENT AGENCY, INC.

Business

Active


SKYVIEW GOURMET DELI CORP

Business

Active



CORONA 104 LAUNDROMAT INC.

Business

Inactive


NEW HK LAUNDROMAT INC

Business

Inactive


108 CORONA MEGAWASH INC.

Business

Inactive


CLEAN 102 CLEANERS, INC.

Business

Inactive



45TH AVE LAUNDRY

Business

Inactive


NEW DO RIGHT ENTERPRISE INC

Business

Inactive


MARIO LAUNDROMA

Business

Inactive


GOOD NEIGHBOR LAUNDROMAT CORP.

Business

Inactive


A & R NORTHERN BLVD. INC.

Business

Inactive


chen, xuhong

Individual

Inactive


BO BO LAUNDROMAT INC.

Business

Inactive


MARISOL LAUNDROMAT II INC.

Business

Inactive


CORONA NEW TOWN LAUNDROMAT INC

Business

Inactive


TAVERAS LAUNDROMAT CORP.

Business

Inactive


SUNDAY BEST CLEANERS, INC.

Business

Inactive


QUALITY LAUNDROMAT

Business

Inactive


YANG, JING

Individual

Inactive



(default) 2 queries took 338 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 50505016
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)11322