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

95106 62nd Street
Dowagiac, MI 49047
Jennifer Wurster with Coldwell Banker Realty, original listing - (269) 469-3950

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,225,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1903 Square Feet
Agency: Coldwell Banker Realty
Agency Phone: (269) 469-3950

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1956
Notes: Welcome to coveted Magician Lake! This home boasts 2.1 acres with sunset views in a quiet area of the lake. With 100 feet of sandy shoreline, an extra-deep lot, and additional land across the road for parking or future expansion, this property offers unmatched potential. Offered turn-key.<br /> <br /> 1903 SF with 3 bed/2 baths, massive deck, boat dock, and lakeside patio and fire pit to enjoy the lake in any season. <br /> <br /> Recent updates include an updated kitchen, master suite, main bath, roof, AZEK material deck, lakeside patio, lawn irrigation system, and invisible fence. <br /> <br /> The vaulted great room overlooks the deck and the beautifully landscaped lakeside yard, creating a bright and airy living space. Dining room is big enough for family and friends and comes with a real field-stone fireplace and butternut tongue and groove paneling. There is an additional living room for the kids to escape to as well as a three-season porch to relax and unwind, taking in the serene lake views. <br /> <br /> Ample storage space with attached 2-car garage which owners are including plans to convert this space into additional living space; 1-car garage - Ping Pong anyone?; 3-stall high-ceiling 26 x35 storage building for all of the lake toys.<br /> <br /> <br /> This spacious property offers unparalleled lakefront living with room to roam and grow. Whether you're relaxing on the lakeside patio, enjoying the sunsets from the deck, or hosting friends and family by the fire pit, this home has it all.<br /> <br /> Don't miss this rare opportunity to own a piece of paradise on Magician Lake! Call today to schedule your private showing.
MlsNumber: --
ListingId: 24048616


Listing Provided By: Coldwell Banker Realty, original listing
Phone: (309) 453-3098
Office Phone: (269) 469-3950
Agent Name: Jennifer Wurster
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