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 = 1250 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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 = 1250 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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 = 1250 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;

11882 Davis Creek Drive
Wolverine, MI 49799
Terri Vizina with Indian River, original listing - (231) 238-9336

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $439,900
Beds: 4
Baths: Full: 3
Status: Active Under Contract
SqFt: 2900 Square Feet
Agency: Indian River
Agency Phone: (231) 238-9336

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Looking for tranquility without sacrificing convenience? This impeccably maintained 4-bedroom, 3-bathroom home offers the perfect blend of peaceful living and easy access to Northern Michigan's most desirable communities.<br /> Situated on 5 private acres, the home welcomes you with beautifully maintained grounds and a sense of pride in ownership that's evident from the moment you arrive. Inside, you'll find a thoughtfully designed layout featuring a main-floor master suite and recently remodeled, tastefully updated bathrooms. The heart of the home is an open-concept living area that seamlessly connects the living room, kitchen, & dining space—all updated with sophisticated finishes. Beautiful windows frame serene, green views, while the attached deck offers an ideal space to unwind and relax. The outdoor amenities of this neat and tidy home include:<br /> Heated attached garage<br /> Sprinkler system<br /> 30x40 pole barn with a 12x40 screened-in porch & a<br /> 14x30 workshop<br /> 12x32 camper cover<br /> Additional lean-to for storage<br /> Mechanics that must be noted are air conditioning, forced air heat, a generator, a heated garage, and an external wood-burning heating system.<br /> Enjoy the nearby Sturgeon River, groomed trail systems, ORV trails, and hundreds of acres of state land just moments away. Can't forget to mention that this home is super close to Burt Lake and Indian River. Whether you're seeking a primary residence or a Northern Michigan retreat, this property offers unmatched comfort, space, and convenience.
MlsNumber: --
ListingId: 201834734


Listing Provided By: Indian River, original listing
Phone: (231) 499-8931
Office Phone: (231) 238-9336
Agent Name: Terri Vizina
Disclaimer: Copyright © 2025 Coldwell Banker Schmidt 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