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

6865 Co Rd Prb
Ishpeming, MI 49849

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: 3
Baths: 2
Status: Active
SqFt: 4015
Agency: East Central, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 60 acre(s)
Property Type: Residential
Year Built: 2009
Notes: Welcome to The Lodge, an active Airbnb retreat that transcends the ordinary and offers an experience waiting to be embraced. Nestled on 60 acres of serene land with 1,750 feet of Escanaba River frontage, this property boasts the perfect blend of tranquility and adventure. Conveniently located just 10 miles from Ishpeming, it's a haven of privacy while being close to city amenities. Step inside this haven of comfort and elegance, where the open kitchen and dining area invite you to create memories with loved ones. The grand living room, adorned with a stunning stone fireplace, radiates warmth and charm, while a wet bar and game area ensure endless entertainment for guests. Retreat to the loft above the living room or one of the additional bedrooms, offering flexibility and ample space for guests. The master suite, complete with its own gas fireplace and laundry area, provides a peaceful sanctuary. But the allure doesn't stop there. This extraordinary property operates entirely off the grid, powered by solar energy and a new propane generator. Efficient heating is ensured with a boiler and in-floor system throughout the home and pole barn. Outside, discover a wealth of amenities that enhance the experience. A 32x40 garage/pole barn with heated floors offers ample storage or workshop space, while a generator, shed and guest cottage provide versatile options for accommodations. Surrounding gardens add beauty and tranquility to the landscape, completing the picture of natural splendor. As an active Airbnb, The Lodge presents additional benefits beyond its stunning features. Guests from all over will love the opportunity to enjoy this secluded oasis in the Upper Peninsula of MI, providing not only a unique experience, but also income potential for the owner. If you're looking for a bit more activity, Marquette, with its unique shops and restaurants, Presque Isle, the Ore Dock, festivals and extensive trail system, is only a short drive away. Whether you envision it as a private retreat, hunting/fishing lodge, or an investment opportunity, The Lodge offers endless opportunities for relaxation and adventure. Seize the opportunity to own this extraordinary property where sustainable living meets natural beauty.
MlsNumber: 50140588


Listing Provided By: East Central, LLC, original listing
Name: East Central, LLC
Phone: (906) 273-1183
Office Name: KELLER WILLIAMS FIRST UP
Office Phone: (906) 273-1183
Agent Name: MICHELLE TRAWICK
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