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 = 1629 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1629 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1629 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

38 Olliffe Lane North
Cameron, MT 59720

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2252
Agency: Keller Williams Western Montana

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential
Year Built: 2018
Notes: Incredible custom built home with attention to details on 20+ acres bordering STATE grounds (unobstructed views of Madison Range on east side), a large ranch on the north side (protecting Tobacco Root Mountain views), & the Gravelly Range is to the west. Located just minutes from Blue Ribbon Trout fishing on the Madison River or head to the mountains for hiking & hunting. Your new neighbors are often antelope, elk, & an occasional moose may even wander into your yard. The open floor plain is enhanced even more as you enjoy 9' walls & large windows adding lots of light. The kitchen has Knotty Alder soft close cabinets (with pull out drawers in pantry), 42" downdraft Jennair 5 burner cooktop, & is graced with Enchanted Forest granite counter tops. As you look into the living room you will see Sphinx Mountain framed through the double doors that lead onto the east facing deck (perfect location for your morning coffee) or enjoy the beauty & warmth of the propane fireplace if too chilly to enjoy it outdoors. The Master Suite has a huge walk in closet (cherry wood organizer for storage), jetted tub with a view, LARGE walk in custom tiled shower, & a beautiful double vanity with a center drawer cabinet. The 2 guest bedrooms are in the southern wing of the house adding privacy for all. The guest bath also has a double vanity, 4' surround shower, & it is located between the two guest rooms. There is a half bath as well for easy access during evenings of entertaining. If you like to tie flies, quilt or just need office space (Fiber Optics is run to the house making it a great location for work at home owners) then you will enjoy the added location of the an extra room off of the main living area. The double car garage (fully finished & heated) is accessed from the mudroom/laundry room (washer & dryer convey at closing without warranty) & once again, attention to detail as it also contains a custom made cabinet with barn door access. The mechanical room is located in the garage & houses propane furnace, whole house water system, salt free water softener, ultraviolet light sanitizer, & tankless on demand hot water heater. The details can be found in the supplements as they are too numerous to mention all here. An hour to Yellowstone Park. Serene, end of the road, private get-away is your home base as you enjoy all the recreational opportunities the Madison Valley has to offer! In Montana you don't just buy a property.....you purchase a new lifestyle!!
MlsNumber: 387941


Listing Provided By: Keller Williams Western Montana, original listing
Name: Keller Williams Western Montana
Phone: (406) 926-3434
Office Name: Keller Williams Western MT - Big Sky
Office Phone: (406) 926-3434
Agent Name: Melinda Merrill
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.


Local Real Estate Expert

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 = 1629 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Real Estate Expert Photo for Sarah Smith
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App