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;

Tbd Deerton-sand Lake Road
Deerton, MI 49822

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $48,800
Beds: --
Baths: --
Status: Active
SqFt: --
Agency:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential
Year Built: --
Notes: MICHIGAN WOODED 40-ACRE RECREATIONAL PARCEL FOR SALE! This property is located in Onota Township which lies along the southern shore of Lake Superior, in the Upper Peninsula of Michigan. - Because of its vast forests, Onota Township has a rich history in producing lumber for buildings and charcoal manufacturing (for smelting iron ore). Much of this work was done in the early days by Scandinavians. - The property is made up of two 20-Acre parcels. The Western parcel is made up of 10.35 Acres of Mixed Forest, 9.39 Acres of Woody Wetlands, .32 Acre of Evergreen Forest, .14 Acre of Pasture/Hay, and .05 Acre of Low Intensity Development. The Eastern parcel is made up of 10.78 Acres of Woody Wetlands, 7.95 Acres of Mixed Forest, and 1.51 Acres of Evergreen Forest. - The old Duluth South Shore and Atlantic railroad, now the groomed "Harvey to Autrain" Multi-Use State Trail, passes through the south western part of the "40", and is how you access the property. This east-west trail is 30 miles long and goes from Marquette County all the way to AuTrain. Also noted as Trail 417 on some maps, it is signed, graveled, and groomed seasonally for snowmobiles. Hiking, Biking, Snowmobiling, ATVing. The area is known for outdoor recreational activities. About 1 1/2 miles north-east of the property offered for sale is Highway M-28. There you can find the access to a hike through old-growth forests which ends at a rocky shoreline near the mouth of the Laughing Whitefish River where it enters Lake Superior. At the end is a public access site that features a small gravel ramp for boat access. [The hiking path runs along Laughing Whitefish Point Road (also known as North Point Road]. - From M94 which runs a few miles south of the property is access to the 1,728 Acre Laughing Whitefish Lake Preserve. It is located between the Laughing Whitefish Falls Scenic Area and the Hiawatha National Forest. Laughing Whitefish Falls is one of the most spectacular falls.
MlsNumber: 50110172


Listing Provided By: , original listing
Office Name: Great Lakes & Land Real Estate Co, Inc - Marq
Office Phone: (906) 228-9312
Agent Name: Timothy Keohane
Disclaimer: Copyright © 2024 LandLeader. 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