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

51993 Rice Lake
Lake Linden, MI 49945
GRETCHEN JANSSEN with RE/MAX DOUGLASS R.E.-H, original listing - (906) 482-1000

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Lovely spot on Rice Lake! All the big things are done. All you have to do is finish it to your liking. Well and mound septic system installed in 2023. 30’ x 40’ insulated pole barn has a kitchen with refrigerator and range/oven, 15’ ceilings, ceiling fans, lights, automatic garage door opener, double-paned windows, window treatments, and concrete floor. The sink, toilet, and instant water heater are plumbed and usable. The entry way is a covered porch/concrete patio. The building has a metal roof and metal siding. The vehicle door is 14’ tall so you can pull in your RV. There are RV electrical hook-ups both inside and outside. There is a 2-story ‘bunkhouse’ with double-paned windows, window treatments, electricity, and vinyl siding. Nicely wooded property with a winding driveway. The power lines are buried. You’ll enjoy gorgeous sunsets over the lake! This is in the center of a sportsmen’s paradise! Fishing, kayaking, boating, swimming, blue berry picking, snowmobile/ATV trails nearby, and the Torch Lake Twp. park on Lake Superior is just a couple minutes away. The Seller uses Direct TV and Dish Network but other similar options are available. Roll-in dock and other items may be included at no additional cost and with no implied warranty. 72-hour Seller response time required for all offers. This information has been secured from sources we believe to be reliable, but we make no representation or warranties, expressed or implied, as to the accuracy of the information. References to square footage, lot size /dimensions, and age are approximate. Buyer must verify the information and bears all risk for inaccuracies. Taxes may change upon sale. More photos coming soon.
MlsNumber: --
ListingId: 50175788


Listing Provided By: RE/MAX DOUGLASS R.E.-H, original listing
Phone: (906) 370-4738
Office Phone: (906) 482-1000
Agent Name: GRETCHEN JANSSEN
Disclaimer: Copyright © 2025 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