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

6375 Joanne Street
Lake, MI 48632
Angela M Batten with Real Estate One-Ortonville, original listing - (248) 627-5414

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $274,900
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1676 Square Feet
Agency: Real Estate One-Ortonville
Agency Phone: (248) 627-5414

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: A little slice of heaven awaits! Nestled on a picturesque 15.5 acres alongside the serene Big Mud Lake, this northern home offers an idyllic retreat for those seeking tranquility and natural beauty. As you arrive, you'll be greeted by a sprawling landscape that seamlessly blends lush greenery with stunning lakeside views just off in the distance. Open floor plan, neutral decor, and brand-new carpet! All appliances included too! The property features a huge pole barn/garage, perfect for storing all your outdoor equipment, recreational vehicles, or even a workshop for your projects. It’s an ideal space for enthusiasts of all kinds, ensuring that you have ample room for storage and activities. One of the standout features of this home is the whole house generator, providing peace of mind during unexpected power outages. You can enjoy the comforts of home regardless of the weather, making it perfect for year-round living or seasonal getaways. The fenced yard adds an extra layer of privacy and security, making it a safe haven for all to play freely. Whether you’re hosting gatherings or simply enjoying quiet evenings, the yard provides ample space for outdoor activities and relaxation. The property boasts a private dock on the water, offering easy access for fishing, boating, or simply soaking in the stunning sunsets over the lake. It’s the perfect spot to unwind after a long day or to launch your adventures on the water. <br /> Recently, the home has been enhanced with a newly enclosed porch, complete with a charming swing that invites you to curl up with a book or sip your morning coffee while soaking in the views. The newly constructed deck is perfect for entertaining friends and family, providing an excellent space for barbecues, evening stargazing, or enjoying the beauty of the outdoors.
MlsNumber: --
ListingId: 20240077699


Listing Provided By: Real Estate One-Ortonville, original listing
Phone: (248) 343-0979
Office Phone: (248) 627-5414
Agent Name: Angela M Batten
Disclaimer: Copyright © 2024 Realcomp Limited II. 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