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

51848 Rice Lake
Lake Linden, MI 49945

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $224,900
Beds: 1
Baths: Full: 1
Status: Active
SqFt: 919 Square Feet
Agency: RE/MAX DOUGLASS R.E.-H
Agency Phone: (906) 482-1000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Tucked away in the heart of the Keweenaw Peninsula, this custom-built 900+ sq ft Hemlock Log Cabin is a true gem for nature lovers and adventurers alike. The cabin exudes warmth and charm, featuring hickory wood floors, tongue-in-groove ceilings, copper sinks, and stunning custom tile work. At its center, a wood-burning stove with a handcrafted stone chimney offers cozy nights, while electric heat and propane wall heaters provide additional comfort. The spacious kitchen and dining area are perfect for gatherings, and the new 22' x 40' barn-style garage with electricity, a concrete floor, and approach provides ample storage for vehicles, gear, or hobbies. Attached to the garage is a 12' x 40' covered lean-to for additional storage. The cabin sits on over 13 acres of beautifully wooded land, offering several cleared guest campsites, a homestead garden, and acres of wild blueberries for foraging. Relax and unwind in the outdoor wood-fired sauna or climb the lookout tower for breathtaking views of the surrounding landscape. The property also includes two storage sheds and a rustic guest cabin. For water enthusiasts, a separate waterfront lot with 25' of frontage on Rice Lake offers the perfect spot for a dock and boat access. This is an outdoor lover’s dream, with easy year-round access to nearby 675-acre Rice Lake, Lake Superior, and the skiing and recreational areas of Mt. Bohemia, Lac La Belle, and Copper Harbor. This unique Upper Peninsula retreat combines rustic charm with modern amenities, making it the perfect year-round getaway! NOTICE: All information believed accurate but not warranted. It is the Buyers obligation to inspect the property and verify all information. The buyer bears all risks for any inaccuracies. Tax information is subject to change. Taxes are not 0. References to square footage, lot size/dimensions, and age are approximate.
MlsNumber: --
ListingId: 50154500


Listing Provided By: RE/MAX DOUGLASS R.E.-H, original listing
Phone: (616) 799-1038
Office Phone: (906) 482-1000
Agent Name: ADAM SHIREY
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