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

E4836 W M28
Au Train, MI 49806
BOB SULLIVAN with NORTHERN MICHIGAN LAND BROKERS, original listing - (906) 225-5263

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,950,000
Beds: 10
Baths: Full: 4, ½: 4
Status: Active
SqFt: 4868 Square Feet
Agency: NORTHERN MICHIGAN LAND BROKERS
Agency Phone: (906) 225-5263

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1992
Notes: PINEWOOD LODGE ESTATES is a fabulous log lodge on AuTrain Bay of Lake Superior with 335 feet of sand beach and long views of AuTrain Island and the inland sea beyond. This area is famous for the bay, Lake Superior sand beaches, inland AuTrain Lake, Autrain River, Pictured Rocks National Lakeshore, Grand Island all conveniently located between Marquette and Munising. You are very near dining, a casino, a boat launch for Lake Superior and one for Autrain Lake, snowmobile trails and woodlands. The lodge is currently being used as a premier rental with VRBO but would make a wonderful private residence. It has been used as such in the past. Or the property could be used as a partial rental as a private living area would make an excellent owner residence if one wanted to continue the current business for income. This property also features a 1.2 acre lot south of the highway. The lodge features 10 bedrooms with 7 1/2 baths, two kitchens, two living rooms with stone fireplaces (currently electric but, can be converted back to propane one of which can also be converted back to wood), sauna, and a 9 seat media room with 80 inch screen. This is a full season lodge/home that would make a wonderful family retreat or year round residence. With nearly 5,000 feet of outdoor decking, gazebos, private beach, landscaped gardens and views of magnificent Lake Superior, this home is immersed in nature. The home has been meticulously cared for with upgrades yearly. The furnishings are lodge style of the highest quality and expertly adorn every room of the lodge. There are two septic systems, propane for fuel and a high end reverse osmosis water system providing excellent potable water. To reiterate, the location is very advantageous just 30 minutes to Marquette and 20 minutes to Munising. Excellent dining is just minutes away. Boat launches to Lake Superior and Autrain lake are also within a few minutes. The famous Pictured Rocks National Lakeshore is located just a few miles east. Autrain Island lies within site offshore. While a portion of the main level is below grade, this is a walkout, level with the driveway. It is mostly finished and provides wonderful living space. Please note that space when viewing the total finished square footage. The balance of this level is utility, laundry and storage. If you are looking for a spacious, well appointed water front residence in Michigan's beautiful Upper Peninsula please take advantage of this marvelous opportunity.
MlsNumber: --
ListingId: 50130202


Listing Provided By: NORTHERN MICHIGAN LAND BROKERS, original listing
Phone: (906) 361-4212
Office Phone: (906) 225-5263
Agent Name: BOB SULLIVAN
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