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

5075 Dunbar
Gladwin, MI 48624

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $629,900
Beds: 4
Baths: 4
Status: Active
SqFt: 3451
Agency: SUGAR SPRINGS REAL ESTATE

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2011
Notes: Welcome to Exceptional in " Sugar Springs " Northern Michigan's Best Kept Secret !! Come & Take a closer look at this 4 possible 5 Bedroom 3 1/2 Bath 3451sqft Custom Built Home built in 2011.The Moment you step in the door you Definitely Know "Your Home" Great Spacious Open Floor Plan for Wonderful Views of Water & Lake Lancer the Larger of 2 All Sports Lakes that Sugar Springs offers. Large open Eat-In kitchen with bar area offers a nice spot to congregate at. Formal Dining area has a large bank of built in cabinets that store all the extras that fill up your kitchen, you also have a adjoining 11X12 Sunroom done up in Knotty Pine that leads out to a Great Water view Deck. Step back inside off the Deck into the living room & Enjoy views of Lake Lancer from a complete wall of windows & you'll Never feel cramped with the elevated Ceiling's that run through most of the home & done in knotty pine. The Natural wood burning fireplace will keep you toasty throughout those chilly evenings, stepping back into the well appointed kitchen you'll find Quartz countertops & stainless steel Maytag Appliances as well as a vast amount of cupboard space. 3 Bedrooms including the Primary bedrooms along with 3 Full Baths are on the main floor for ease of convenience & bathrooms must be seen to appreciate . Go upstairs & you will find 1 more dedicated bedroom as well as an additional 13X19 area that is being used for a fifth bedroom & a 1/2 bath there is also a large 27x13 area w/Natural Gas Fireplace used for misc. & could be used for just about anything. Go back downstairs & find a main floor laundry leading out to the 2 car garage which also is where the mechanicals are for the home. Another Great attribute that this property offers is there is water views from both the front & back of the home. The waterside of this property has a steel seawall as well as a floating dock & a permanent cantilever dock you never have to take out. This Property offers wonderful outdoor space and a well maintained & professionally manicured yard & outdoor sitting areas. Come take a closer look at All that Sugar Springs has to offer from their 18hole Championship Golf Course to the Indoor Pool & Workout Facility, Tennis/Pickle Ball courts. 2 All Sports Lakes totaling 1000 Acres of Water Fun, many Beach Clubs, The HEARTH Restaurant & even a 3500ft Natural Grass Airstrip so make your way to Sugar Springs Today before this 1 Gets Away !!!
MlsNumber: 50138004


Listing Provided By: SUGAR SPRINGS REAL ESTATE, original listing
Name: SUGAR SPRINGS REAL ESTATE
Phone: (989) 948-4509
Office Name: SUGAR SPRINGS REAL ESTATE
Office Phone: (989) 256-3556
Agent Name: RYAN ROPP
Disclaimer: Copyright © 2024 Clare Gladwin Board 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