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

40 Acres Off Snowmobile Trail 133
Mohawk, MI 49950
Timothy Keohane with Great Lakes & Land Real Estate Co, Inc - Marquette, original listing - (906) 228-9312

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $78,800
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Great Lakes & Land Real Estate Co, Inc - Marquette
Agency Phone: (906) 228-9312

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Land-Other
Year Built: --
Notes: MICHIGAN WOODED 40-ACRE PARCEL FOR SALE! This property is located in Sherman Township, in the Keweenaw County in the Upper Peninsula of Michigan – a Township along the Keweenaw Bay’s western shore - Near Lake Superior’s Hermit Bay. The property is located a few miles north of the once booming Historic Mining Village of Gay. This area was organized in 1898 when the Mohawk Mining Company built a stamping mill on the nearby shore of Lake Superior. It was followed by the building of a second stamping mill built by the Wolverine Mining Company. A Smelter here heated ore to extract copper, which was then stamped into copper ingots. A post office opened in 1904, named for Joseph E. Gay, long associated with mining in the area. Three distinctive tourist Landmarks in the area are the Gay School House, The Mohawk Stamp Mill ruins, and the 256 foot-high Gay Smoke Stack – which is used as a navigational aid… and a fourth, the Popular Gay Bar which was once the home of the Stamping Mill Superintendent. It opened in the 1930’s after the mines, the mills and smelter closed and Prohibition was repealed. The parcel has a small tributary of the Tobacco River flowing through its western side. The Tobacco River is 14 miles long. It rises at the outlet of Thayer Lake and flows east, then south to Lake Superior, which it joins near the Village of Gay. The River is a stocked Brook Trout Stream. Lake Superior is the largest fresh water lake in the world! It offers some excellent fishing for black crappie, jumbo perch, northern pike, rock bass, smallmouth bass, tiger muskie and walleye and it offers good Coho salmon and Rainbow trout catches. About 31 Acres of the property consists of Woody Wetlands – Woody Wetlands usually have trees such as tamarack, cedar, or balsam fir; a hardwood swamp usually has trees such as red maple, black ash, American elm, or balsam poplar; and shrub swamps usually have shrubs such as tag alder, willows, or red osier dogwood
MlsNumber: --
ListingId: 50111417


Listing Provided By: Great Lakes & Land Real Estate Co, Inc - Marquette, original listing
Phone: (906) 228-9312
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