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

1265 River Road
Beulah, MI 49617

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $890,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2108
Agency: A.L.M.& Associates, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1980
Notes: This is the PREMIER Platte river property. This property is set up for family entertainment and relaxing. Three bedroom, 2 full baths and 1 1/2 bath and another room that could be an additional bedroom house sits amongst a cluster of trees and lush gardens all overlooking the river. Heated floors two laundry rooms and a fantastic kitchen. Custom stone and marble counters throughout the house Two paved driveways one for just parking and one for access to the 34 x 26 garage with an nice attached work shop for gardening supplies or hobby room. Excellent location 15 minutes from crystal mountain resort 30 minutes from Traverse city and 20 minutes from Lake Michigan and the city of Frankfort. Fantastic place with prime Platte river frontage for fishing canoeing, Kayaking or just relaxing. Second floor has a walk In closet with a marble shower with radiant heat throughout along with custom cabinets and a loft which can be used for storage.<br /> First floor has hardwood floors along with a great room which has limestone tile and radiant heat throughout along with custom cabinets in the kitchen.<br /> Custom stone and marble counters throughout the house.<br /> Pole Barn which has an attached garden room<br /> <br /> Wood shed next to the house.<br /> <br /> House has a gas fireplace made of stone.<br /> <br /> Second floor has a master suite with a gorgeous view over looking the river<br /> Two washers and two dryers along with all appliances stay with the house;<br /> Platte River has an annual fall salmon run.
MlsNumber: 24012861


Listing Provided By: A.L.M.& Associates, LLC, original listing
Name: A.L.M.& Associates, LLC
Phone: (231) 723-3555
Office Name: Coldwell Banker Professionals ALM Manistee
Office Phone: (231) 723-3555
Agent Name: Michael Cnudde
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. 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