Tobacco Retail Dealer [Permits for Tobacco Retail Dealer]

451 - 500 of 14450


WEST END DISCOUNT

Business

Active


FAMILY DOLLAR #6737

Business

Inactive


108 DELI & GROCERY INC.

Business

Active


A-ROD GROCERY

Business

Active


FAMILY DOLLAR #8614

Business

Inactive


FAMILY DOLLAR #3934

Business

Active



GREEN APPLE GOURMET II INC.

Business

Inactive


FAMILY DOLLAR #7069

Business

Inactive


FLATBUSH SMOKE & VAPE SHOP

Business

Active


RADFAN INC.

Business

Active


969 UNITED DELI INC.

Business

Active


NEW BEST DELI CORP

Business

Active


WILSON 26 DELI GROCERY CORP

Business

Active


SMITH ORGANICS INC

Business

Active



GOURMET DELI & GRILL CORP I

Business

Active


GREEN STAR FOODS

Business

Active


SOHO DELI GROCERY

Business

Active


VINOD NEWS CENTER

Business

Active



FAMILY DOLLAR #7029

Business

Inactive


ST. PAUL DELI GROCERY INC.

Business

Active


FAMILY DOLLAR #7145

Business

Inactive




249 STREET FOODMART INC

Business

Active



FOOD FAIR DELI & PIZZA

Business

Active


MONEY MINIMARKET INC

Business

Inactive


FAMILY DOLLAR #6185

Business

Active



Come n Pick

Business

Active


CIGAR VAPE INC I

Business

Active


TOP BK DELI CORP

Business

Active


BHELA INC.

Business

Inactive



395 GOURMET AND GROCERY CORP

Business

Inactive


FAMILY DOLLAR #6851

Business

Inactive


RINCON GROCERY & DELI INC

Business

Active


7 Eleven Store #36096A

Business

Inactive




S DELI & GROCERY

Business

Inactive


WEBSTER AV PETROLEUM LLC.

Business

Active


J.M. ASIK CIGAR COMPANY LLC

Business

Active


UTICA DELI & GRILL INC

Business

Active


MINTO, MOJAJA

Business

Active



(default) 2 queries took 52 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 450, 50505052
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)110