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 = 1260 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 = 1260 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 = 1260 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;

2610 S River Rd.
Beaverton, MI 48612

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1400
Agency: Whitetail Properties Real Estate, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 36 acre(s)
Property Type: Residential
Year Built: --
Notes: Here is one of the nicest properties I have had the pleasure of listing in a long time—a unique opportunity to own acreage with over 1/2 mile of frontage on the Cedar River. Beautiful views around every bend in the river; the possibilities are endless on this one. The approximate 1400 sq. ft. three-bedroom, two-full-bath ranch home with a large all-seasons room on the back with full windows and sliding glass doors overlooks the pond behind the house. The house has two large stone fireplaces. There is a very nice 30x40 pole barn with concrete floors and electrical and two smaller outbuildings that are perfect for extra storage. Here is one of the nicest properties I have had the pleasure of listing in a long timea unique opportunity to own acreage with over 1/2 mile of frontage on the Cedar River. Beautiful views around every bend in the river; the possibilities are endless on this one. The approximate 1400 sq. ft. three-bedroom, two-full-bath ranch home with a large screened-in porch on the back overlooks the pond. The house has two large stone fireplaces. There is a very nice 30x40 pole barn with concrete floors and electrical and two smaller outbuildings that are perfect for extra storage. A smaller two-bedroom 15' x 30' cabin could be fixed up and used as a guest cabin. The property itself has a pond with a windmill aeration system in place. Enjoy excellent hunting right outside your back door. Trails throughout the property and a nice food plot area in the back. The deer sign on the property was still very evident from last fall, with rubs, scrapes, and runways that look like cattle paths throughout the property. This one checks all the boxes and will not last long. Call today for your own private showing!
MlsNumber: 24014687


Listing Provided By: Whitetail Properties Real Estate, LLC, original listing
Name: Whitetail Properties Real Estate, LLC
Phone: (231) 330-4107
Office Name: Whitetail Properties Real Estate, LLC
Office Phone: (231) 330-4107
Agent Name: Jeff Chilman
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