Tobacco Retail Dealer [Permits for Tobacco Retail Dealer]

501 - 550 of 14450

RED HOOK FOOD CORP.

Business

Inactive


GATEWAY NEWSSTAND

Business

Active


KEY FOOD

Business

Active


PURELY ORGANIC CORP

Business

Active


18TH AVE. CONVENIENCE, INC.

Business

Active


FAMILY DOLLAR #6481

Business

Active



CIRCLE PLAZA DELI INC

Business

Active


PAGE BAGELS INC

Business

Active


ALI, ESSA M

Business

Inactive


TREMONT GAS INC.

Business

Active


CORNER 77 BROADWAY

Business

Inactive


GARDEN DELI & GRILL

Business

Active




H & H DELI CORP

Business

Active


BAMN DELI GROCERY CORP

Business

Active



KJ ASTORIA GOURMET INC

Business

Active


LONG ISLAND CITY FOOD CORP

Business

Active


FAMILY DOLLAR #6368

Business

Active


VINCENT'S BAGELS INC.

Business

Active


FAMILY DOLLAR #6604

Business

Inactive


THE ROCK HOUSE

Business

Active


MADISON GOURMET DELI CORP

Business

Inactive


JANI USA INC.

Business

Active



GREEN BASKET & MORE INC

Business

Active


RED HOOK FOOD CORP.

Business

Inactive


314 SUPER DELI LLC

Business

Active


681 DELI GROCERY STORE # 1 INC

Business

Inactive


SPRINGS FINEST DELI CORP.

Business

Inactive


FAMILY DOLLAR #5364

Business

Inactive



FLAT GAS INC.

Business

Active


7-ELEVEN STORE# 39192A

Business

Active


FAMILY DOLLAR #6184

Business

Active


Stop 4 Deli and Grocery Inc

Business

Active


FAMILY DOLLAR #7136

Business

Inactive


FANA DELI GROCERY

Business

Active


FRANK'S MINI MARKET CORP

Business

Inactive


MC DELI GROCERY

Business

Active



BROOKLYN MINI MARKET INC

Business

Inactive


BROADWAY CORNER STORE CORP.

Business

Active


S&T SUPERMARKETS INC.

Business

Active





FAMILY DOLLAR #6745

Business

Active


(default) 2 queries took 259 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 500, 50505031
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)11228