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 = 1270 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 = 1270 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 = 1270 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 Ponozzo
Iron River, MI 49935

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,265,000
Beds: 1
Baths: 1
Status: Pending
SqFt: 1000
Agency: LANDVEST

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 722 acre(s)
Property Type: Residential
Year Built: 1993
Notes: Little Wolf Lake Estate. We are pleased to offer this 722-acre Little Wolf Lake estate in the western end of Michigan's Upper Peninsula. This unique property includes a small rustic cabin, two lakes in their entirety, and abuts the Ottawa National Forest. Located only 14 miles north of Iron River and US-2, a year-round road bisects the western portion of the property and provides reliable access. Little Wolf Lake, the largest of the two lakes, is approximately 13 acres in size and 15 feet deep, with fish species that include pike and panfish. The lake also offers abundant wildlife viewing as it draws numerous animals that include white tail deer, ducks, geese, loons, swans, muskrat, beaver, bear, and even moose, which roam the shoreline. Similar opportunities are found on Bonny Lake, which totals 7 acres in size. The terrain is relatively level, with subtle hills and ridgelines scattered throughout. The forest cover has been managed throughout the years. There are two mature northern hardwood stands that provide desirable wildlife habitat and pleasing aesthetics. The areas that have been harvested over the years have dense hardwood and aspen regeneration that provide excellent grouse habitat. The sprawling property is easily navigated by a well-established interior trail system that provides access to most areas of the property. The rustic cabin features cedar shake exterior, asphalt shingle roof, deck, and crawl space. The interior features tongue and groove, wood floors, kitchen, living room, bathroom, bedroom, loft, and field stone fireplace. Basic wiring and plumbing have been installed throughout. The cabin is serviced by propane gas and ready for generator or solar hook up. The cabin sits on the southern bank of Little Wolf Lake. This property offers a unique opportunity to own a secluded estate with two private lakes in Michigan’s Upper Peninsula. This could be your opportunity to start making “UP” memories.
MlsNumber: 50122891


Listing Provided By: LANDVEST, original listing
Name: LANDVEST
Phone: (207) 233-4950
Office Name: LANDVEST
Office Phone: (207) 233-4950
Agent Name: DANIEL SCHUMMER
Disclaimer: Copyright © 2024 Upper Peninsula Association of Realtors. 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