Red House

Establishment, food and bar at 369 King Street East, Kingston, ON K7K 2Y1, Canada. Here you will find detailed information about Red House: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Food   Bar  

Address:
369 King Street East
Kingston
Ontario K7K 2Y1
Canada
Get directions

Phone:
+1 613-767-2558

Website:
redhousekingston.com

Photos

Reviews of Red House

Sorry, but now we haven't any revews about Red House.

Add review

About redhousekingston.com

Red House Kingston
Kingston's locally owned upscale pub & restaurant serving craft beer and the best locally sourced foods. Their two Kingston locations serve up an amazing selection of local and craft beers along with some of Kingston's best food made with locally sourced ingredients
Craft beer, local, live music, beer, draught, draft, tap, cask, best beer, best food

1SELECT * FROM `item` WHERE url = 'red-house' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16832') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('322713')
0SELECT * FROM `category` WHERE id IN ('96','99','144') LIMIT 3
0SELECT * FROM `locality` WHERE url = 'kingston-on' LIMIT 1
0SELECT * FROM `region` WHERE id = 176 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 322713 AND `date` < '2024-04-25 20:15:52' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('322713')
1SELECT * FROM `item` WHERE id IN ('303706','309389','7986','303786','8175','303465') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16832') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('7986','8175','303465','303706','303786','309389')
0SELECT * FROM `category` WHERE id IN ('96','99','155','158','175','148','174') LIMIT 7
0SELECT * FROM counts where updated="2024-04-25" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-25" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
3SELECT * 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 4
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15005','14985') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('144416','144417','144418','144419')
0SELECT * 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 7
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1