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','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;

6378 S Mac Road
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: $6,900,000
Beds: 43
Baths: Full: 17
Status: Active
SqFt: 12672 Square Feet
Agency: Dick Huey Real Estate
Agency Phone: (800) 733-4839

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 653 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1929
Notes: The Pere Marquette is a National Wild and Scenic River by act of Congress, a Natural River and Blue Ribbon Trout Stream in Michigan. It has been recognized as one of the few trout and salmon fishing rivers of this quality remaining in the nation! This is the largest private holding with 7 MILES of river frontage on the Pere Marquette mainstream and more than a square mile of land surrounded and protected by vast Federal forests. This may be the finest trout property east of the Mississippi. Quality hatches of mayflies, caddis, and stoneflies provide tremendous dry fly angling for resident rainbows and browns. Spring and fall steelhead and salmon run up the river from Lake Michigan. There's an Adirondacks style Lodge built in 1929 of white ash and wormy chestnut, Tackle House, Barn, Caretaker’s House, and 4 newer cabins sited along the river. A trout pond is fed by the river and shaded by large hardwoods. Mineral rights are included. Locals say the fishing is better now than it was in the 1970’s and improves every year. The Pere Marquette was the location of the first brown trout introduction in the United States (1884). Rainbow trout were planted in 1885 and these early introductions developed into a self-sustaining migratory steelhead population. Today it nurtures large populations of resident brown trout and provides world-class fishing opportunities for steelhead and salmon. This property has been owned by the Cannon family for 67 years, since the early 1950’s. Now it can be yours! MLS#1860043 includes it all. MLS#1860044 is just the heart of the property with 5,906 feet of river, 158 acres of land, the historic Lodge, Tackle House, Caretakers House and Barn. You need to visit and walk the land to experience the beauty, power, and magic of this river! And what are you doing this weekend that sounds like more fun?
MlsNumber: --
ListingId: 1860043


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