Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3137 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3137 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3137 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

334 Mt Hwy 87 Highway
Cameron, MT 59720

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,299,999
Beds: 3
Baths: 4
Status: Active
SqFt: 4158
Agency: Montana Territorial Land Co.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential
Year Built: 2017
Notes: Beautiful views out every window from this wonderful custom Log home. Perfect for entertaining family and friends, the main floor houses a spacious living room, dining area with deck, kitchen with custom soft close mahogany cabinets, granite countertops and a large island with seating. The Master Suite located on the main floor has dual vanities, a large soaking tub, large walk-in shower, walk-in closet and private deck. The upstairs loft offers two bedrooms, a full bath and living area. Downstairs features a walk out basement with living area, full kitchen, storage area, 1 bedroom and full bath. Home has an attached garage and a detached 1500 sq. ft. shop, that makes a great work space with plenty of room for equipment and toy storage. The property has year-round access and is centrally located on beautiful Raynold’s Pass. Adventure awaits you in any direction from this comfortable and inviting home. Whether you want world-class fly fishing on the Madison River or Henrys Fork of the Snake River, or a lake day on any of five lakes within proximity. Cliff and Wade Lakes, Henrys Lake, Quake Lake or Hebgen Lake are all just 10 to 20 minutes away and offer a wide variety of stunning views and fun for all water recreation. West Yellowstone and the west entrance to Yellowstone National Park are a short 25-minute drive away and offer a host of year-round recreational activities from hiking, biking and skiing, to snowshoeing and snowmobiling. This property is the perfect place to come live where you play!
MlsNumber: 388400


Listing Provided By: Montana Territorial Land Co., original listing
Name: Montana Territorial Land Co.
Phone: (406) 646-7145
Office Name: Montana Territorial Land Co
Office Phone: (406) 646-7145
Agent Name: Liz Watt
Disclaimer: Copyright © 2024 Big Sky Country MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App