Country View Motel

Establishment and lodging at 47379 Homestead Road, Steeves Mountain, NB E1G 4J8, Canada. Here you will find detailed information about Country View Motel: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
47379 Homestead Road
Steeves Mountain
New Brunswick E1G 4J8
Canada
Get directions

Phone:
+1 506-863-1117

Website:
countryviewmotelandrestaurant.com

Rating

4.8 /5

Based on 5 reviews

Add review

Photos

Reviews of Country View Motel

  •  
    Ryan Mills Added 2018-10-30
    Awsome hot turkey sandwich and homemade fries. Apple pie I was disappointed in it had no flavor and was very bland. But was a good experience will be back again.
  •  
    GAIL PROKOSH Added 2018-09-08
    Food was awesome and staff were beyond helpful...prices were great also.definitely wil stop by again
  •  
    Tammy Feere Added 2018-09-01
    Very good food.. very friendly service. You feel at home
  •  
    Brenda MacRae Added 2018-08-23
    Had my Birthday dinner with Joe and Christopher here. Food was amazing!! Will definitely go bk!!!
  •  
    Pierre Landry Added 2018-08-17
    Food is simple, plentiful and tasty. Great view and staff very friendly and helpful. It's also only ten minutes away from the hustle of the city.

Add review

About countryviewmotelandrestaurant.com

Country View Motel & Restaurant

1SELECT * FROM `item` WHERE url = 'country-view-motel' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15652') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('323780')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
1UPDATE locality SET weather = '{\"date\":\"2024-04-20\",\"data\":{\"2024-04-20\":{\"10\":{\"temp\":8,\"pressure\":1013,\"humidity\":84,\"icon\":\"10d\",\"wind\":5},\"13\":{\"temp\":6,\"pressure\":1012,\"humidity\":86,\"icon\":\"10d\",\"wind\":5},\"16\":{\"temp\":6,\"pressure\":1010,\"humidity\":90,\"icon\":\"10d\",\"wind\":3},\"19\":{\"temp\":4,\"pressure\":1007,\"humidity\":96,\"icon\":\"10n\",\"wind\":2},\"22\":{\"temp\":4,\"pressure\":1006,\"humidity\":96,\"icon\":\"10n\",\"wind\":2}},\"2024-04-21\":{\"01\":{\"temp\":3,\"pressure\":1007,\"humidity\":96,\"icon\":\"04n\",\"wind\":2},\"04\":{\"temp\":2,\"pressure\":1008,\"humidity\":95,\"icon\":\"04n\",\"wind\":3},\"07\":{\"temp\":5,\"pressure\":1009,\"humidity\":76,\"icon\":\"03d\",\"wind\":3},\"10\":{\"temp\":10,\"pressure\":1009,\"humidity\":47,\"icon\":\"01d\",\"wind\":4},\"13\":{\"temp\":12,\"pressure\":1007,\"humidity\":36,\"icon\":\"03d\",\"wind\":5},\"16\":{\"temp\":10,\"pressure\":1006,\"humidity\":53,\"icon\":\"04d\",\"wind\":4},\"19\":{\"temp\":6,\"pressure\":1007,\"humidity\":74,\"icon\":\"10n\",\"wind\":3},\"22\":{\"temp\":4,\"pressure\":1007,\"humidity\":81,\"icon\":\"04n\",\"wind\":3}},\"2024-04-22\":{\"01\":{\"temp\":2,\"pressure\":1005,\"humidity\":93,\"icon\":\"04n\",\"wind\":3},\"04\":{\"temp\":1,\"pressure\":1005,\"humidity\":89,\"icon\":\"01n\",\"wind\":3},\"07\":{\"temp\":5,\"pressure\":1007,\"humidity\":66,\"icon\":\"01d\",\"wind\":6},\"10\":{\"temp\":6,\"pressure\":1009,\"humidity\":39,\"icon\":\"04d\",\"wind\":7},\"13\":{\"temp\":6,\"pressure\":1011,\"humidity\":29,\"icon\":\"03d\",\"wind\":6},\"16\":{\"temp\":5,\"pressure\":1013,\"humidity\":31,\"icon\":\"01d\",\"wind\":5},\"19\":{\"temp\":-1,\"pressure\":1017,\"humidity\":50,\"icon\":\"01n\",\"wind\":2},\"22\":{\"temp\":-2,\"pressure\":1019,\"humidity\":53,\"icon\":\"01n\",\"wind\":1}}}}' WHERE id = 15652 LIMIT 1
0SELECT * FROM `locality` WHERE url = 'steeves-mountain-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
11SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 323780 AND `date` < '2024-04-20 14:09:48' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('323780')
0SELECT * FROM `item` WHERE id IN ('39012','323629','323717','39597','39274','39279') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15652','15537','15409') LIMIT 3
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('39012','39274','39279','39597','323629','323717')
0SELECT * FROM `category` WHERE id IN ('96','99','107','103','128','100','120','121') LIMIT 8
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
4SELECT * 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 ('17962','17888','17752') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('101388','101389','101390','101391')
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