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

1601 Lakeside
Barton City, MI 48705

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $350,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1500
Agency: GERWECK REAL ESTATE GROUP,LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 1991
Notes: You have got to see this beautiful lakefront home! This home has been family owned and beautifully cared for for over 30 years and it shows. Home is located in the beautiful and private Lakes in the Green Association and sits on 10 acres of pristine land which boasts almost 600 feet of lake frontage and includes a boat dock. The home has two bedrooms, 1.5 bathrooms and a huge gorgeous fireplace to keep you warm and cozy on those cold northern winter evenings. Home also has two covered porches, one downstairs and one upstairs to look out to the lake. Bonus room has a sauna and storage room. This home also has a heated 40 X 38 3 to 4 car garage with upstairs living quarters that includes, a kitchen, and a large open room to fix how you please. The downstairs of this garage has a full bathroom, laundry room with washer and dryer and a hot tub! An attached enclosed lean-to on this huge garage is for all of your outdoor toys. Come and see this home for yourself! On the side yard, there is a huge additional space for your guests campers and this area has been set up with electric and water for their use. Home and garage have a newer steel roof(2016), !6,000 watt whole house generator, (still under warranty) newer 110 foot well installed in 2019. All appliances stay including two washers, and two dryers. Furniture and household items are negotiable. So much more to say, so much to offer in this beautiful home!
MlsNumber: 50099053


Listing Provided By: GERWECK REAL ESTATE GROUP,LLC, original listing
Name: GERWECK REAL ESTATE GROUP,LLC
Phone: (734) 243-4200
Office Name: Gerweck Real Estate in Monroe
Office Phone: (734) 243-4200
Agent Name: Cherie Shields
Disclaimer: Copyright © 2024 Monroe County Association of Realtors ®. 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