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;

1672 Hampton
Gladwin, MI 48624

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $269,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1500
Agency: SUGAR SPRINGS REAL ESTATE

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1988
Notes: Come Experience the Best of Both Worlds with this 3 Bedroom/ 2 Bath Stunner, located in Northern Michigan's "Best Kept Secret" Sugar Springs. You'll be hard pressed to find a bad view anywhere from this 1500sqft Contemporary Style home located directly across the street from 780 acre All Sports Lake Lancer 1 of 2 Lakes in Sugar Springs. Step into this Open Air concept home and be greeted by Vaulted Ceilings & Incredible amount of Natural Light from a pair of doorwalls that lead out from both the Dining area & the Living Room & both leading out to the covered deck. Step back in and you will see the well appointed kitchen fully equipped with Stove/Range, Refrigerator, Dishwasher & Microwave, good counterspace gives you plenty of space without feeling cramped while whipping up your favorite meal. Primary Bedroom is on the Main level offering double set of closets for plenty of space both there and the bedroom and again plenty of natural light from the pair of windows. Full Bath on main level, 2 additional bedrooms as well as a 1/2 bath upstairs. Come back down and find a Wonderful Family room at the end of the hall that offers a Huge space for Entertainment & Fun this room as well offers Great Natural light from another doorwall as well as a window and additional door that leads out to the back deck offering a nice outside entertainment area. Just off the deck you will find the detached 2+ car garage. Full concrete driveway. The yard has been recently freshened up with new mulch and additional landscaping. This yard offers some wonderful mature trees for shade, the lot also abuts a common area that extends all the way to the road towards the lake so you will never have anything to ever block your view of the lake. Sit out on the deck in the morning or evening and experience both Incredible Sunrises & Sunsets. Come take a closer look at some of the additional amenities that Sugar Springs offers its owners from the 18 hole Championship Golf Course, Indoor Pool & Workout Facility, Tennis/Pickle Ball Courts, 2 All Sports Lakes Lancer (780 acres) & Lancelot (220 acres) which is completely private to the membership with many Beach Club areas to choose from you'll always have a place to go lounge on the beach, Great Fishing on both lakes, we also have a Fantastic Restaurant (THE HEARTH) Put the Cherry on the sundae as they say with our own 3500ft Natural Grass Airstrip for those who choose to Fly In. You are not going to want to wait to long to take a closer look at this 1 as it Will Not Last Long !!! Owner is Offering this property Fully Furnished w/few exceptions including the shark on the wall which makes this offering even more enticing, So Call Today For More Information!!
MlsNumber: 50138623


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