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

22483 Gauthier
Skanee, MI 49962

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $425,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1266
Agency: Up North Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1999
Notes: Waterfront Cottage with 150’ of accessible shoreline on Lake Superior! Absolutely Gorgeous views of Huron Bay and the Huron Islands from the park-like front yard! The open concept layout features large, picturesque windows, a vaulted knotty-pine tongue and groove ceiling and ceramic tile flooring throughout. In the evenings or on those chilly mornings, you can cozy up to the beautiful wood burning, stone fireplace! The eat-in kitchen is a great size and complete with a bow window and island seating. The front deck is the perfect place to sit and relax while you enjoy watching the sunset over the bay! The all-season sunroom offers additional living space and beautiful views from every which way! Full bathroom and laundry are located on the main floor. The end of the hallway presents the two bedrooms. The second story offers an interior balcony view and is home to the master bedroom suite! Featuring a jet soaking tub, skylight and private outdoor balcony! The two-car detached garage has a nice workshop and power. This property is in a prime recreational area in the Upper Peninsula of Michigan that lends access to 1,000’s of acres of public lands, ATV/Snowmobile trails, waterfalls, and much more! Huron Bay is known for it’s sandy lake-floor, pebbled shoreline and calm waters making it the perfect destination for all types of recreational activities! Fishing is a dream come true with a variety of species! This property is being sold with most of the furnishings and a backup Cummins 6800-watt gasoline generator! Find all the peace and privacy here on this seasonal, private, dead-end road with no through traffic!
MlsNumber: 50125567


Listing Provided By: Up North Realty, original listing
Name: Up North Realty
Phone: (906) 524-2211
Office Name: UP NORTH REALTY
Office Phone: (906) 524-2211
Agent Name: ANNIE CRANFORD
Disclaimer: Copyright © 2024 Upper Peninsula 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