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

11839 Jug
Baraga, MI 49908

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,000
Beds: 4
Baths: 2
Status: Active
SqFt: 2155
Agency: NORTHERN MICHIGAN LAND BROKERS - H

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 100 acre(s)
Property Type: Residential
Year Built: 2001
Notes: Spectacular 4BR 2BA Log lodge/home nestled on 100 beautifully wooded-secluded acres in Baraga County! You'll be impressed with this masterpiece as soon as you walk in as the interior is so warm, bright and inviting! The main level consists of a huge open concept with the living area having 27-foot cathedral ceilings, a beautiful stone fireplace and pine/maple flooring throughout. The rustic birch kitchen features Legacy Cabinets, modern appliances being a 17-cu ft gas refrigerator, 5 burner stainless oven-range, and a tastefully done 6 stool stone bar. Two bedrooms, a full bath and full laundry room make up the rest of the main level. The upper level features a 9x30 loft sitting/family area that lead to two large bedrooms with 15' cathedral ceilings and a jack-n-jill full bath! The lodge has state of the art utilities that include a 540-watt solar system, 12000-watt generator with remote start, a 15000-watt hour battery system and a 2000-gallon propane storage tank. Tanks are rented. There is gas and electric lighting. You'll absolutely love the huge wrap around covered porch, perfect for enjoying all nature has to offer! There are two storage sheds for your lawn/toys. This amazing property is totally off grid and offers Seasonal Access Only. The southern border is adjacent to thousands of acres of Copper Country State Forests and access to thousands of acres in the Ottawa National Forest! There are trails throughout the property and Snowmobile trail #15 is right nearby. There is a combination of terrain being flat to mostly diverse. Hunting in the area for Whitetail Deer, Black Bear, Grouse, prove to be outstanding! If you're in the market for a piece of God's Country, where privacy is high on your priority list, you'll definitely want to check this one out! Call for an appointment today!
MlsNumber: 50136281


Listing Provided By: NORTHERN MICHIGAN LAND BROKERS - H, original listing
Name: NORTHERN MICHIGAN LAND BROKERS - H
Phone: (906) 523-5575
Office Name: NORTHERN MICHIGAN LAND BROKERS - H
Office Phone: (906) 523-5575
Agent Name: DALE GORDON
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