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 = 1277 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 = 1277 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 = 1277 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 W Wingleton
Baldwin, MI 49304
Dick Huey with Dick Huey Real Estate, original listing - (800) 733-4839

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,900,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Dick Huey Real Estate
Agency Phone: (800) 733-4839

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 173 acre(s)
Property Type: Land-Other
Year Built: --
Notes: This high, hardwood-covered parcel has unusual development potential but could also become your fabulous trout fishing estate. Where else can you find an incredible 2.78 MILES of frontage on the wild and scenic Pere Marquette River, the finest trout stream in the state? You could own 116.22 acres of land with an impressive 14,686 feet of frontage on the mainstream in Sweetwater Township, Lake County, Michigan, five miles west of Baldwin.  The property has remained undeveloped for 70 years as a scenic part of Cannon River Ranch, their cherished “land across the river.” They have never before offered it for sale. It has direct access and power from W. Wingleton Road, which adjoins the property. Lake County plows it in winter and maintains it year-round. It is beautiful land above a mighty river where you see eagles, otters, and deer, and the songs of birds fill the air. Congress designated the Pere Marquette as a National Wild and Scenic River. It is also recognized as one of the few trout and salmon fishing rivers of this quality remaining in the nation. It is the best in Michigan, confirmed by 50 years of DNR sampling statistics. It may be the best trout stream east of the Mississippi. This river was the location for the first brown trout introduction in the United States in 1884. Rainbow trout were planted a year later in 1885, and those early introductions developed into a self-sustaining migratory steelhead population. It is the largest river in Michigan without a dam and one of only two rivers in Michigan where the State regulates canoe, kayak, and fishing boat traffic to preserve its wildness. Today, the river nurtures large resident brown trout and provides world-class year-round fishing opportunities for rainbows, steelhead, and Chinook salmon. Six other parcels of various size are also available at Cannon River Ranch. It will all be sold. Call or text Dick Huey at 231-631-3317 or email at [email protected] for more information or to schedule a showing.
MlsNumber: --
ListingId: 1926127


Listing Provided By: Dick Huey Real Estate, original listing
Phone: (231) 631-3317
Office Phone: (800) 733-4839
Agent Name: Dick Huey
Disclaimer: Copyright © 2024 Northern Great Lakes Realtors MLS. 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