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- (v. Lot) 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: $400,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: 3 acre(s)
Property Type: Land-Other
Year Built: --
Notes: This is an undeveloped building lot with 806 feet of frontage and 3.01 acres on the west bank of the Pere Marquette River between Cabin#1 and Cabin #2 at Cannon River Ranch. An easement provides access over the existing road to Mac Road, which is plowed in winter and maintained year-round by Lake County. Fishermen will enjoy the low bank access to the river for fishing. A purchaser of one of the cabins may choose to add this parcel to their purchase. The Natural Rivers Act currently requires a 150-foot setback from the river. Underground electric power runs through the parcel. Building a cabin here will require a well and septic system, and you will likely add a propane tank. You will see eagles, otter, deer, and other wildlife and hear a variety of songbirds. The Pere Marquette is a National Wild and Scenic River by an act of Congress, a Natural River with no dam, and a 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. It is the best in Michigan, and that is supported by 50 years of DNR sampling statistics.  This river was the location of the first brown trout introduction in the United States in 1884. Rainbow trout were planted in 1885, and those early introductions developed into a self-sustaining migratory steelhead population. It is one of only two rivers in Michigan where the State regulates canoe and fishing boat traffic. Today, it nurtures large populations of resident brown trout and provides world-class fishing opportunities for steelhead and Chinook salmon.
MlsNumber: --
ListingId: 1920599


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