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;

1395 Us Highway 287 & 9 Fopar Road N
Cameron, MT 59720
Nancy Clark with AmeriMont Real Estate, original listing - (406) 284-6546

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,150,000
Beds: 4
Baths: Full: 4, ¾: 1
Status: Active
SqFt: 7932 Square Feet
Agency: AmeriMont Real Estate
Agency Phone: (406) 284-6546

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Incredible RIVERFRONT Opportunity: Two Neighboring Properties Being Sold Together!<br /> Ideally located between Ennis' newly expanded airport and Yellowstone Park in Cameron, MT with great year round access. <br /> Listing includes:<br /> 1)A massive 4,000 sq ft log lodge situated on 3.45 acres, boasting 325 ft of Madison River frontage. This spacious lodge offers endless potential, with 9 RV full hook-ups already in place, and DEQ approval for additional riverfront cabins or condos, all with breathtaking views and direct river access. <br /> 2)An adjoining 3,900 sq ft craftmanship residence with 150+/- ft of Madison River frontage, currently operating two successful VRBO units. This high end home features stunning views from both levels, 2 separate living areas with fireplaces, a hot tub and impressive wrap-around deck with stairs to the river. This is an idyllic setting for relaxation and recreation.<br /> <br /> Dream big! Log Lodge offers expansive 2,000 sq ft main floor with vaulted timbers, a grand staircase, multiple bathrooms and a walk-in cooler perfectly designed for hosting large gatherings. Stay in the home while you build your own private riverfront condos or cabins and keep large lodge for everyone to gather together. <br /> <br /> Home comes fully furnished and is turn-key ready with 5 bedrooms and 5 bathrooms. Great design for personal use or as a rental property. Whether you choose to use it as your residence, duplex, or capitalize on its VRBO rental history, this property offers flexibility and income potential. There is demand in this area for year round work force housing.<br /> <br /> Imagine owning both properties and having the freedom to create your Montana dream retreat—whether it’s a vacation escape, a family compound, a joint venture with your hunting and fishing partners, or a mix of riverfront cabins and condos. The possibilities are endless!<br /> <br /> Located in a destination area renowned for world-class fly fishing, hunting, snowmobiling, lakes, skiing and only 40 minutes from Yellowstone National Park. This is a once-in-a-lifetime opportunity.<br /> Bring your creativity to make your dream a reality. Call your favorite realtor for a tour today.
MlsNumber: --
ListingId: 396804


Listing Provided By: AmeriMont Real Estate, original listing
Phone: (406) 579-9190
Office Phone: (406) 284-6546
Agent Name: Nancy Clark
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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App