Hirock Inn

Establishment and lodging at Chauncey Street, Elkford, BC V0B 1H0, Canada. Here you will find detailed information about Hirock Inn: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
Chauncey Street
Elkford
British Columbia V0B 1H0
Canada
Get directions

Phone:
+1 250-865-2226

Website:
hirockinn.com

Photos

Reviews of Hirock Inn

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

Add review

About hirockinn.com

elkford hotel - The Hi Rock Inn
Hi Rock Inn is adjacent to a baseball park and a beautifully maintained 9-hole golf course. The Hi Rock Inn is a perfect place for families, seniors, or anyone who enjoys the serenity nature provides.
elkford hotel, elkford hotels, elkford accommodation, elkford accommodations, elkford motel, elkford motels, hotels elkford, accommodations elkford, motels elkford, rocky mountain accommodations, rocky mountain fly fishing, southern bc fly fishing , elkford fly fishing accommodation, fly fishing elk river, elkford fly fishing, elk river fly fishing, elk valley fly fishing, rocky mountain flyfishing, southern bc flyfishing , elkfordfly fishing accommodation, flyfishing elk river, elkford flyfishing, elk rive

2SELECT * FROM `item` WHERE url = 'hirock-inn' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14764') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('171928')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
1SELECT * FROM `locality` WHERE url = 'elkford-bc' LIMIT 1
0SELECT * FROM `region` WHERE id = 169 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 171928 AND `date` < '2024-04-20 03:57:27' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('171928')
1SELECT * FROM `item` WHERE id IN ('171959','171971','171956','172000','172199','172009') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14764') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('171956','171959','171971','172000','172009','172199')
0SELECT * FROM `category` WHERE id IN ('96','117','118','100','143') LIMIT 5
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'
1SELECT * 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 ('176','171') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('16461','15465') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('391137','391138','391139','391140')
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