CORONA [Permits for CORONA]

151 - 200 of 1338

VILLADA, CONRAD

Individual

Active



G.S. DELI & GROCERY INC.

Business

Active


HIRALDO, EUSEBIO

Individual

Active


MAURICIO HOMES CORP

Business

Active


108 DELI & GROCERY INC.

Business

Active




Castano-Jimenez, Giancarlo

Individual

Active


JOHN'S FLOWER SHOP INC.

Business

Active


SANTOS, JUAN A

Individual

Active


ATAFO, HENRY

Individual

Inactive




Ubaydi, Surush

Individual

Inactive


SP PLUS CORPORATION

Business

Active


LUCKY CORONA INC.

Business

Active


FLUSHING AUTO SALVAGE, INC

Business

Inactive


LEMA, MARIO C

Individual

Active


KHOSHIMOV, KHURSHID

Individual

Inactive


ENCALADA, FRANKLIN

Individual

Active



CETECOR CONSTRUCTION CORP.

Business

Active


MAMBETALIYEV, KENENBAY

Individual

Inactive


CASTRO, LUIS

Individual

Inactive


RITE AID STORE #4499

Business

Active


SHAYMARDANOV, DILSHOD

Individual

Active


RAKHMATOV, AMON

Individual

Inactive


NEW A+ GOURMET DELI, INC

Business

Active


WALGREENS STORE #07294

Business

Active


CELLVISION

Business

Active


ZAMORA, MAURICIO

Individual

Active



Miranda, Jeffrey

Individual

Active


Toruno, Carlos

Individual

Active


HUANG, SHOUCHAO

Individual

Inactive



Ubaydi, Doriyush

Individual

Inactive


FARCIERT, F GIL

Individual

Active


DISCOUNT DELI & GROCERY

Business

Inactive


SPEEDWAY #07814

Business

Active


CHARYYEV, ROVSHAN

Individual

Inactive


SAETEROS MORA, BLANCA N

Individual

Active


SPRINT SPECTRUM L.P.

Business

Active


KISTAUBAYEV, AZAMAT

Individual

Inactive


ARROYO, DAVID M

Individual

Active


SPRINT SPECTRUM L.P.

Business

Active


JUANITO DELI GROCERY CORP

Business

Inactive


COMENDANT, EVGHENI

Individual

Inactive


KARMA

Business

Active


(default) 2 queries took 346 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 150, 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)11300