Salmon River Inn

Establishment and lodging at 714 Sayward Road, Sayward, BC V0P, Canada. Here you will find detailed information about Salmon River Inn: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
714 Sayward Road
Sayward
British Columbia V0P
Canada
Get directions

Website:
salmonriverinn.ca

Photos

Reviews of Salmon River Inn

Sorry, but now we haven't any revews about Salmon River Inn.

Add review

About salmonriverinn.ca

Sayward By the Sea - Hotel and pub is located on the central North East coast of Vancouver Island, It is an ideal family resort getaway boasting a friendly restaurant with home cooked meals. Some of the best fishing, hiking and various outdoor activities abound in this idilic pristine setting.
Salmon River Inn, Sayward By The Sea, Sayward BC, Vancouver Island Resort, RV resort, RV Park, hotel, restaurant & lounge, family get-away, fishing, fishing charters, birding, bird watching, accommodations

1SELECT * FROM `item` WHERE url = 'salmon-river-inn' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14965') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('175070')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
1SELECT * FROM `locality` WHERE url = 'sayward-bc' LIMIT 1
0SELECT * FROM `region` WHERE id = 169 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 175070 AND `date` < '2024-04-19 07:37:14' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('175070')
0SELECT * FROM `item` WHERE id IN ('175206','175166','175068','175102','175151','175184') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14965') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('175068','175102','175151','175166','175184','175206')
0SELECT * FROM `category` WHERE id IN ('96','164','108') LIMIT 3
0SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
5SELECT * 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 ('176','174') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('16919','16189','16475') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('49710','49711','49713','49714')
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 ('176') LIMIT 1