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

3974 N Hayward (access To Angel Island)
Munising, MI 49862
TIM KEOHANE with GREAT LAKES & LAND OF MARQUETTE, INC., original listing - (906) 228-9312

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,780,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2079 Square Feet
Agency: GREAT LAKES & LAND OF MARQUETTE, INC.
Agency Phone: (906) 228-9312

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: PRIVATE ISLAND FOR SALE - WITH TURN-KEY HOME, IN THE WILD AND SCENIC UPPER PENINSULA OF MICHIGAN! - This 9.38 Acre Island is located in AuTrain Township in central Alger County, in the Heart of the Hiawatha National Forest. - Sixteen Mile Lake is one of 413 lakes, located within the 894,836 Acre Hiawatha National Forest. It is a natural spring fed 443-acre flooded headwater area with a channel that serves as a tributary to the Sturgeon River. This Sturgeon River flows south to Nahma, Michigan where it flows into Big Bay de Noc in the northern part of the Green Bay estuary of Lake Michigan. - The Springs are located in the northern portion of the lake, and water ranges from 1 to 12 feet in depth throughout the lake. Approximately 80 percent of the lake is less than 7 feet in depth. - The All Sport Lake is mostly undeveloped and contains fish species typical of inland lakes in northern Michigan. Northern pike, Yellow perch, and Bass are the primary species found. - Called Angel Island, this tree covered property is the ONLY Island in the Western section of the lake, and there are Three Islands in the Eastern section. - The Island is 9.38 +/- Acres in size – with nearly a half mile of shoreline. - The Owners have thought of everything, for future development opportunities for the Island. They had it surveyed and secured the necessary approvals to divide it into four parcels. Parcel A is 2.293 Acres in size (with 566+ Feet of shoreline), and is where the beautiful Home is located. - Parcel B is 2.408 Acres in size with 671+ Feet of shoreline. Parcel C is 2.535 Acres in size with 608+ Feet of shoreline. Parcel D is 2.148 Acres in size with 641+ Feet of shoreline. - An underwater power line from the mainland brings electrical service to the island, and a Transformer has been installed in the center of the island to allow a “service drop” to all four surveyed parcels. - A 1.417 Acre surveyed mainland parcel provides an area to build a pole barn for storage of boats, trailers, toys, and vehicles See Survey Parcel F. There is a 30-foot-wide easement along the southern edge of a mainland lot for launching of boats and the installation of a seasonal dock. See Survey Parcel E. - The Beautiful home was built for Year-Round living and is located only a 1/10th mile boat or snowmobile trip from a mainland dock to the island dock for easy access all year. - The 3,400+ square-foot Log Sided Home features a large Main Floor open concept Living Area with a prow-front window wall made of triple glass patio doors that reach to the peak of the vaulted-ceiling, and a large stone facia electric fireplace. The Kitchen features custom hickory cabinetry, a spacious raised snack bar for casual dining with handcrafted log stools. The adjoining Dining area Patio doors provide access to the deck which offers spectacular lake, sunset and sunrise views, throughout the season. The deck extends around the entire home so there is... Continued In Addendum
MlsNumber: --
ListingId: 50150190


Listing Provided By: GREAT LAKES & LAND OF MARQUETTE, INC., original listing
Phone: (906) 228-9312
Office Phone: (906) 228-9312
Agent Name: TIM KEOHANE
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