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 Rd 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: --
Baths: --
Status: Active
SqFt: 3932 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: Commercial Sale-Other
Year Built: 2008
Notes: Incredible RIVERFRONT Commercial Opportunity: Two Neighboring Properties Being Sold Together! Ideally located between Ennis' newly expanded airport and Yellowstone Park in Cameron, MT with great year round access. Listing includes an RV Park with Lodge and Home next door.<br /> <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. 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. 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 an event venue. Destination wedding venues outside of Yellowstone Park are in demand! <br /> Stay in the home while you build out your business next door. 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. <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! 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. Bring your creativity to make your dream a reality. Call your favorite realtor for a tour today.
MlsNumber: --
ListingId: 396803


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