CORONA [Permits for CORONA]

401 - 450 of 1338

TRADING USED AUTO PARTS CORP.

Business

Inactive


MARTINEZ, BELKIS V

Individual

Active


KOUASSI, ANE

Individual

Active


INFANTE, FELIX E

Individual

Active


Rukhilloev, Rustambek

Individual

Inactive


XIA, XU DONG

Individual

Active


NURULLAEV, SHAMSHOD

Individual

Inactive


NURITDINOV, JAMOLITDIN

Individual

Inactive


SANTIAGO, YAMIL

Individual

Active


VINANZACA, TEODORO

Individual

Active


JG CONCRETE CORP.

Business

Active


106TH TIRES & WEELS CORP.

Business

Active


IPD WIRELESS

Business

Active


CASANOVA'S BILLIARDS CORP.

Business

Inactive


A & B VARIETIES CORP

Business

Inactive


CORONA GOURMET DELI INC

Business

Inactive


BLAS AUTO GLASS CORP.

Business

Active


HORACE HARDING OPERATING, LLC

Business

Inactive




CORONA 88 LAUNDROMAT

Business

Active


CORONA SEWING CENTER

Business

Active


MARIANITA'S GROCERY CORP.

Business

Active


NEW HK LAUNDROMAT INC

Business

Active


WELCOME MARKET INC

Business

Inactive


CRYSTAL TREE INC

Business

Active


FULL CELL INC

Business

Inactive


111 DELI STOP CORP

Business

Inactive


AMC CONSTRUCTION LLC

Business

Active


CORONA CASA DE EMPENO INC.

Business

Inactive



MDK NY INTERIOR CORP

Business

Inactive



DUANE READE

Business

Inactive


MARK STAR JEWELRY, INC.

Business

Active


CORONA MOBILE CORP

Business

Active


JUNCTION ASSOCIATES INC.

Business

Inactive


Pawn Star Inc

Business

Inactive


FIVE STAR AUTO GROUP, INC.

Business

Active


108 corona megawash inc

Business

Active


G & F HOMES, INC

Business

Inactive


BUBBLE OCEAN LAUNDROMAT INC

Business

Active


FULL CELL INC

Business

Inactive


COOPER WANG INC.

Business

Inactive


RED MOVIL DMBM INC

Business

Active


3 STAR GROCERY CORP.

Business

Active


HERRERA, VIRGILIO

Business

Active


TU ESQUINA GROCERY

Business

Active


SUPERIOR DELI & GRILL

Business

Active


FIRST STOP GROCERY

Business

Inactive


(default) 2 queries took 433 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 400, 505050122
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)11311