Electronic Cigarette Dealer [Permits for Electronic Cigarette Dealer]

251 - 300 of 671

BP

Business

Active


YALLA DELI GROCERY CORP

Business

Active


MEHTA, RANJAN

Business

Active


Woodside Grocery

Business

Active


AVE B BEER & CIGAR NYC INC.

Business

Active



MCCARREN DELI & GRILL

Business

Active


Beyond Vape

Business

Active


SPRING ICONIC SWEET SHOP

Business

Active


ATLANTIC GAS INC

Business

Active


SAID NEWSSTAND

Business

Active


SMITH FINEST DELI CORP.

Business

Active


AVENUE NEWSSTAND LLC

Business

Active


79-07 EXPRESS NEWS, INC.

Business

Active


NIHA MINI MART INC

Business

Active


BROOKLYN SMOKE SHOP INC

Business

Active



S & M BRONX INC

Business

Active




CITY PLAZA INC

Business

Active



85TH STREET DELI, INC.

Business

Active


EZ DELI GROCERY CORP I

Business

Active


BEER & SMOKE SHOP

Business

Active


KINGS HAMILTON AVE, MOBIL

Business

Active


BUSHWICK DELI CORP

Business

Active


CARD CORNER II, INC.

Business

Active


LEONARD NEWS INC

Business

Active


ASIFALI1090@GMAIL.COM

Business

Active


BP

Business

Active


QUEENS DELI & GROCERY CORP.

Business

Active



EAST SIDE SMOKE SHOP

Business

Active



NEWS ON 23RD

Business

Active


PRAMUKH 71, INC.

Business

Active


COLLECTIBLES USA INC.

Business

Active




VILLAGE FUNKY EXPRESS CORP.

Business

Active


BP

Business

Active


RED ARROW STORE

Business

Active


ASTORIA CARD PLUS

Business

Active


PLAZA NEWS CAFE LLC

Business

Active



MIDTOWN QUICK MART CORP

Business

Active


SUNIL MAGNANI

Business

Active


US BRAZIL GROCERY INC

Business

Active


KINGS VALLEY FRUIT, INC.

Business

Active


(default) 2 queries took 340 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 ( '(+Electronic +Cigarette +Dealer)' IN BOOLEAN MODE) LIMIT 250, 50505062
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Electronic +Cigarette +Dealer)' IN BOOLEAN MODE)11278