Frontier Motel

Establishment and lodging at 122 British Columbia 23, Revelstoke, BC V0E 2S0, Canada. Here you will find detailed information about Frontier Motel: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
122 British Columbia 23
Revelstoke
British Columbia V0E 2S0
Canada
Get directions

Rating

1 /5

Based on 1 reviews

Add review

Photos

Reviews of Frontier Motel

  •  
    Clay Green Added 2017-07-30
    It's super cheap. That's the highlight. When you arrive after driving 8 hours the last thing that you want to hear is that your reservation may or may not be valid even after confirming on the way and that every night people are sent away regardless of booking in advanced and confirming the day of their stay. The extra $40 is worth the stay anywhere else

Add review

1SELECT * FROM `item` WHERE url = 'frontier-motel' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14947') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('448735')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'revelstoke-bc' LIMIT 1
0SELECT * FROM `region` WHERE id = 169 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 448735 AND `date` < '2024-04-27 23:53:11' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('448735')
1SELECT * FROM `item` WHERE id IN ('206120','206273','448774','205527','206133','448663') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14947') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('205527','206120','206133','206273','448663','448774')
0SELECT * FROM `category` WHERE id IN ('96','99','159','115','103','110','107','109') LIMIT 8
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-27" 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 ('170') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15371') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('442081','442082','442083','442084')
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 ('169') LIMIT 1