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

3487 Rushton Road
Central Lake, MI 49622

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $700,000
Beds: 5
Baths: 5
Status: Active
SqFt: 3639
Agency: The Geno D'Angelo Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 1998
Notes: Waterfront home on the Upper Chain of Lakes. Discover lakeside living in this custom home nestled on five acres of secluded natural beauty. The property boasts 225 feet of private waterfront on Hanley Lake. Launch your boat from the aluminum and vinyl dock and you are 10 minutes from Intermediate Lake. Turn your boat north and go up the chain to Ellsworth, fishing all the way. Your recreational vehicles can be stored in the 32’ x 48’ pole barn with 12-foot RV drive through doors and a mechanic’s pit. The barn houses a 20’x 24’ heated workshop with its own bathroom and shower. The modest ranch exterior belies the spacious interior, over 3600 square feet. The two 4-season porches will become your favorite rooms. They provide panoramic views of the seasonal flora progression and daily observations of the abundant wildlife. Alternatively, you can watch from the patio off the walk out lower level and hear the birds singing. A home for nature lovers. The upstairs kitchen has lifetime quartz counters. The lower kitchen anchors a large room where you can feed any size crowd. The lower level also has two bedrooms and a full bathroom making it a private place for guests, a rental, or an in-law unit. A 3-ton Trane heat pump provides central air conditioning in the summer and supplements the gas heat in the colder months for year-round comfort. The house is off a paved road with a long concrete drive including a turnaround and apron. Combined with the attached three car garage, there is plenty of parking for family and friends. Make this well-built, well-maintained property your family retreat.Located just a mile from town amenities, including shopping and dining options, and less than an hour from Traverse City, Petoskey, and Gaylord, this property seamlessly combines seclusion with convenience. Escape to your own private paradise and embrace the essence of lakeside living at its finest!
MlsNumber: 1921850


Listing Provided By: The Geno D'Angelo Group, original listing
Name: The Geno D'Angelo Group
Phone: (231) 487-6141
Office Name: The Geno D'Angelo Group
Office Phone: (231) 487-6141
Agent Name: Geno D'Angelo
Disclaimer: Copyright © 2024 Northern Great Lakes Realtors MLS. 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