Tobacco Retail Dealer [Permits for Tobacco Retail Dealer]

201 - 250 of 14450


EASTSIDE GROCERY

Business

Active


108 CAR CARE, INC.

Business

Inactive





UNIVERSITY DELI & GROCERY

Business

Active


CARROLL STREET FOOD CORP.

Business

Active


J & J NEWS, INC.

Business

Active


GREEN OLIVE DELI CORP

Business

Active


J & J NEWS, INC.

Business

Inactive


BULLPEN DELI INC

Business

Active


535 8TH AVENUE CORP

Business

Active


CARLITOS DELI GROCERY CORP

Business

Inactive


PLAZA PUEBLA GROCERY INC.

Business

Active


HOULAHAN, PEGGY JANE

Business

Active


NEW FIVE STAR 88 INC.

Business

Active



WINNERS CONVENIENCE INC

Business

Active


7 ELEVEN STORE # 33616B

Business

Active


Liberty Deli and Pizza

Business

Inactive


789 EAST 163RD STREET, INC.

Business

Active


AVE Z FOOD MART CORP

Business

Inactive


SIDI M TOURE

Business

Active


A & B BUSINESS CORP.

Business

Active


GLEN WAY FOOD INC

Business

Inactive


JULIAN DELI CORP

Business

Active




7 Eleven Store #35621A

Business

Active


NEW BLONDIE FOOD 3 CORP

Business

Active


ARGO TRADING, INC

Business

Active


BUHRE SMOKE ZONE INC

Business

Active


J & J NEWS, INC.

Business

Inactive


UNIVERISTY PLACE NEWSSTAND

Business

Active


2 FAMOUS GOURMET DELI, INC

Business

Active


7 Eleven Store #39875A

Business

Active


GSA GAS, CORP.

Business

Inactive


16 ST DELI & GROCERY INC

Business

Inactive


ARCA FUELS INC

Business

Active


MANOR SUPERETTE & BAGELS

Business

Active


980 COLUMBUS FOOD CORP.

Business

Active


LEODANY GROCERY INC

Business

Active


QUICK STOP

Business

Active


JERSEY MINIMARKET CORP

Business

Inactive


ORLANDO NEWS, INC.

Business

Active


ASTORIA GOURMET DELI NY INC

Business

Active


NATURAL SUPERMARKET CORP

Business

Active




(default) 2 queries took 273 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 200, 50505025
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)11248