Tobacco Retail Dealer [Permits for Tobacco Retail Dealer]

1 - 50 of 14450




M & S DELI OF S.I. INC

Business

Active


HONEY BEE DELI AND GROCERY

Business

Active


BAISLEY GAS AND STORE INC

Business

Inactive


DON MARTO MINIMARKET CORP

Business

Inactive


SMOKE ZONE 2, INC

Business

Active


AZ DELI GROCERY INC I

Business

Inactive


RASHID NEWSSTAND

Business

Active


SUPERIOR MARKET

Business

Inactive


FRESH TO GO DELI CORP

Business

Active


MZN DELI & GROCERY INC

Business

Inactive


7 Eleven Store #38309H

Business

Active


147 SPICY DELI INC

Business

Inactive


PAKSEY ASSOCIATES, INC.

Business

Active


CLASSIC PHARMACY, INC.

Business

Active


ASA GROCERIES LLC

Business

Active




SHAIKH, ALTAF L

Business

Active


ASHU DREAM USA, INC

Business

Active


RICHMOND CARDSMART, INC

Business

Active


FARRAGUT GAS, INC.

Business

Active


GREENBERG, JOEL

Business

Active



COD GOURMET DELI CORP

Business

Active


76 MADISON GROCERY CORP

Business

Active



J & J GENERAL STORES INC.

Business

Active


1ST AVENUE NEWSSTAND CORP

Business

Active


Dollar General Store# 19221

Business

Inactive


HENRY, SOO

Business

Inactive


MI PARADA DELI GROCERY CORP

Business

Inactive


ALI BABA ORGANIC, INC.

Business

Active


515 DELI CORP

Business

Active


SEAPORT NEWS

Business

Active


7-ELEVEN STORE# 33684A

Business

Active


5 STAR JAMAICA DELI CORP

Business

Active


7 Eleven Store #38310H

Business

Active


POLANCO DELI GROCERY

Business

Active


7 Eleven Store #32653B

Business

Active


128 EDGECOMBE DELI CORP

Business

Inactive


PRESTIGE GOURMET DELI CORP

Business

Active


ROOSEVELT GROCERY

Business

Active


BROADWAY GRAB & GO CORP

Business

Active



Store #35702J

Business

Active


MINI MARKET TENARES CORP.

Business

Active


COLUMBIA SMOKE SHOP, INC.

Business

Inactive


(default) 2 queries took 378 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 ( '(+Tobacco +Retail +Dealer)' IN BOOLEAN MODE) LIMIT 5050507
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Tobacco +Retail +Dealer)' IN BOOLEAN MODE)11371