Tobacco Road Sports Cafe & Brewery

Full information about place - Establishment, food, cafe and bar "Tobacco Road Sports Cafe & Brewery" at 505 West Jones Street, Raleigh, NC 27603. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Website:
tobaccoroadsportscafe.com

Price level:
Moderately

Phone number:
+1 919-301-8793

Address:
505 West Jones Street, Raleigh, NC 27603
Get directions

Categories:
Establishment   Food   Cafe   Bar  

Suggest changes

Opening times

Click to load full map
 

Reviews about Tobacco Road Sports Cafe & Brewery

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Tobacco Road Sports Cafe & Brewery

Nearest places

Weather in Raleigh, NC

3SELECT * FROM `item` WHERE url = 'tobacco-road-sports-cafe-brewery' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('31036') LIMIT 1
2SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('333605')
0SELECT * FROM `category` WHERE id IN ('189','219','239','240') LIMIT 4
1SELECT * FROM `locality` WHERE url = 'raleigh-nc' LIMIT 1
3SELECT * FROM `region` WHERE id = 66 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 333605 AND `date` < '2024-05-10 09:51:34' ORDER BY `date` DESC
2SELECT * FROM `photos` WHERE `item_id` IN ('333605')
2SELECT * FROM `item` WHERE id IN ('336278','224039','335802','333690','336040','336104') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
1SELECT * FROM `locality` WHERE id IN ('31036') LIMIT 1
2SELECT * FROM `photos` WHERE `item_id` IN ('224039','333690','335802','336040','336104','336278')
4SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('224039','333690','335802','336040','336104','336278')
0SELECT * FROM `category` WHERE id IN ('189','213','243','247','272') LIMIT 5
0SELECT * FROM counts where updated="2024-05-10" and table_name like 'news'
0SELECT * FROM counts where updated="2024-05-10" and table_name like 'news'
2SELECT * FROM `category` ORDER BY name
6SELECT * FROM `item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 8
1SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('30484','30593','31036','30702') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('382003','382004','382005','382006','382007','382008','382009','382010')
1SELECT * FROM `locality` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `locality`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 12
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM counts where updated="2024-05-10" and table_name like 'locality'
0SELECT * FROM counts where updated="2024-05-10" and table_name like 'item'
0SELECT * FROM counts where updated="2024-05-10" and table_name like 'reviews'
0SELECT * FROM counts where updated="2024-05-10" and table_name like 'photos'