Tobacco Retail Dealer [Permits for Tobacco Retail Dealer]

401 - 450 of 14450

HOLLIS DELI & GRILL CORP

Business

Active


WEST 14 CANDY STORE INC.

Business

Inactive


PARMAR, ROSHAN

Business

Active


BEDSTUY FINEST DELI CORP

Business

Active


DUANE READE

Business

Active



OCEAN DELI CORP

Business

Active


3 HANDS DELI & GRILL CORP

Business

Active



Fresh Deli

Business

Active



DL DELI GROCERY CORP.

Business

Active


REGIZ CORP

Business

Active



G&G GROCERY STORE INC.

Business

Active


7 STAR DELI GROCERY INC

Business

Inactive


LUCKY 7 SMOKE SHOP

Business

Inactive


TERRA SOUTH AVE RETAIL CORP

Business

Active


MK GOODIES INC.

Business

Inactive


GIFTAMILLION.COM INC

Business

Active


WHITE PLAINS FOODS INC

Business

Inactive


PIMENTEL DELI GROCERY

Business

Active


BUHRE MINI MART & DELI

Business

Active


AB NEWS & LOTTO INC

Business

Active


THE DOWN TOWN ASSOCIATION

Business

Active




J & J NEWS, INC.

Business

Active




BREAD & BUTTER

Business

Active


STOP & SHOP #2593

Business

Active


PACIFICO FOOD CORP

Business

Active


GOLDEN GOURMET CORP.

Business

Active



RANGEL FOOD CENTER CORP.

Business

Active


G.S. DELI & GROCERY INC.

Business

Active


SMOKE BIZARRE CORP

Business

Active


LA VAKANA GROCERY CORP

Business

Active


MARCY EXPRESS GROCERY CORP

Business

Inactive



1420 GROCERY CORP

Business

Active


7 Eleven Store #36477A

Business

Active



159 CANDY GROCERY CORP

Business

Active


ONE STOP FINEST INC

Business

Active


R M GROCERY & DELI CORP

Business

Active


VOLKO, KERZHNER

Business

Active


J & J NEWS, INC.

Business

Active


SETKEM DELI GROCERY, LLC

Business

Inactive


(default) 2 queries took 266 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 400, 50505028
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)11238