Tobacco Retail Dealer [Permits for Tobacco Retail Dealer]

601 - 650 of 14450

FAMILY DOLLAR #6855

Business

Inactive


FAMILY DOLLAR #7255

Business

Active


96 CANDY AND GROCERY INC.

Business

Inactive


A & A GROCERY DELI, INC

Business

Inactive


ALONSO GROCERY

Business

Inactive



48 BODEGA INC

Business

Active


KLEIN'S GROCERY, INC.

Business

Active



ELIM TRADING CORP.

Business

Active



M & S SMOKE SHOP, INC.

Business

Active


NICHOLAS EXPRESS DELI CORP.

Business

Active


THIRD AVE GROCERY & DELI

Business

Inactive


S & K DELI AND GRILL INC

Business

Inactive


HP 42ND FRUIT STORE INC

Business

Active


DAY DELI GROCERY CORP.

Business

Active


JUBILEE SMOKE & VAPE INC

Business

Active



FAMILY DOLLAR #4255

Business

Inactive


WOODSIDE FOOD CENTER CORP.

Business

Active


NY HOOKAH PLUS INC.

Business

Inactive


LUCKY 21 CONVENIENCE, INC.

Business

Active


TREMONT CORNER STORE CORP.

Business

Active


TRISHA CONVENIENCE INC.

Business

Inactive


AF FOOD CORP.

Business

Active



SABAH CANDY & CROCERY

Business

Active


FAMILY DOLLAR STORE #6852

Business

Inactive


EGAN DELI INC

Business

Active


KING GOURMET DELI CORP.

Business

Active


SMA GOURMET DELI CORP

Business

Active



FAMILY DOLLAR #7005

Business

Active


FAMILY DOLLAR #6112

Business

Inactive


AARON INC

Business

Active



DOUBLE A & H DELI CORP

Business

Active


20TH AVE. MINI MARKET

Business

Active



FREEMAN DELI CORP

Business

Inactive


BROADWAY FINEST DELI CORP

Business

Active


FAMILY DOLLAR #5751

Business

Active


TWO GUYS DELI & GROCERY INC

Business

Active


LORD OF KINGS INC

Business

Active



FAMILY DOLLAR #7270

Business

Active


FAMILY DOLLAR #7070

Business

Active


METRO BEER & SMOKE INC

Business

Active


LUCKY CORNER GROCERY

Business

Active


(default) 2 queries took 327 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 600, 50505046
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)11281