ByWard Blue Inn

Establishment and lodging at 157 Clarence Street, Ottawa, ON K1N 5P7, Canada. Here you will find detailed information about ByWard Blue Inn: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
157 Clarence Street
Ottawa
Ontario K1N 5P7
Canada
Get directions

Phone:
+1 613-241-2695

Website:
bywardblueinn.com

Photos

Reviews of ByWard Blue Inn

Sorry, but now we haven't any revews about ByWard Blue Inn.

Add review

About bywardblueinn.com

ByWard Blue Inn
ByWard Blue Inn is located on a quiet residential street overlooking the ByWard Market Heritage District with unobstructed views of Parliament Hill, the U.S.A. embassy or the dramatic steeples of the 19th century St. Brigid's church. This charming Inn offers people traveling for business or pleasure great room rates in a fantastic location.

1SELECT * FROM `item` WHERE url = 'byward-blue-inn' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17033') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('51836')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'ottawa-on' LIMIT 1
0SELECT * FROM `region` WHERE id = 176 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 51836 AND `date` < '2024-04-20 13:57:17' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('51836')
2SELECT * FROM `item` WHERE id IN ('52053','321370','321396','321418','323822','321437') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17033') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('52053','321370','321396','321418','321437','323822')
0SELECT * FROM `category` WHERE id IN ('96','128','148','152','174','161','99','155','154') LIMIT 9
0SELECT * FROM counts where updated="2024-04-20" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-20" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
1SELECT * 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 ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17938') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('439458','439459','439460','439461')
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