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

7958w Dodge Lake Rd
Manistique, MI 49854
DAVID MUXLOW with GROVER REAL ESTATE, original listing - (906) 341-2131

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 1477 Square Feet
Agency: GROVER REAL ESTATE
Agency Phone: (906) 341-2131

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Discover this stunning, two-story waterfront home on the serene shores of Island Lake in Michigan's Upper Peninsula, a region celebrated for its untouched natural beauty, trails, lakes, rivers, and waterfalls. Built in 1998, this meticulously crafted 4-bedroom, 3-bathroom home offers high-quality finishes, featuring a tasteful blend of tongue-and-groove wood and drywall accents, soaring vaulted ceilings, and lakeside windows that flood the home with natural light and frame breathtaking views. The main level includes an open concept living, dining, and kitchen area, a primary bedroom with a full bath, and convenient laundry. Upstairs, you'll find a cozy sitting area, an additional bedroom, and a full bath. The walkout lower level boasts a family room, two bedrooms, a full bath, and access to your private outdoor retreat. Step out to the large main-level deck for panoramic views or relax on the covered patio below. A charming staircase bordered by perennial gardens leads you to your private waterfront, complete with a quality dock, ideal for fishing or boating. Island Lake spans 106 acres with depths up to 60 feet and connects to the tranquil 87-acre Dodge Lake - both lakes known for excellent fishing and their peaceful, Northwoods ambiance. Additional features include LP gas hot water heating, mini split air conditioning, a zoned in-ground sprinkler system, a detached 2-car heated garage with abundant storage, and two additional storage buildings for lawn equipment and outdoor furniture. This home includes all appliances - just bring your love for nature and relaxation to enjoy lakefront living at its finest. Whole home generator and furnishings can be purchased at an additional price. Don't miss this exceptional Upper Peninsula retreat! Show period through 12 Noon on Wednesday November 6th, offers reviewed at 1:00PM
MlsNumber: --
ListingId: 50159616


Listing Provided By: GROVER REAL ESTATE, original listing
Phone: (906) 450-0184
Office Phone: (906) 341-2131
Agent Name: DAVID MUXLOW
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