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

6959 W Redman Drive
Lake City, MI 49651

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $756,900
Beds: 3
Baths: 3
Status: Active
SqFt: 2235
Agency: City2Shore Real Estate Northern Michigan

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: Welcome to a perfect blend of comfort, tranquility, and lakefront living located on the sandy shores of our beautiful 1,880 all-sports Lake Missaukee, providing a haven for outdoor enthusiasts, whether you enjoy fishing or embarking on a kayaking adventure. This lake's clear waters and sandy shoreline is perfect for swimming and with the city dock located downtown, take a short boat ride and unload to enjoy the restaurants, shopping, and the famous Tasty Treat for ice cream. Enjoy the west end of our lake at the sandbar or watch from your boat July 4th to enjoy the fireworks display for the Greatest Forth in the North celebration. Our Northern Michigan town has so many events to enjoy all four seasons; the famous Greatest 4th in the North, snowmobiling and Orving on the miles of trails that can be drove right from the cottage to trail system. This charming waterfront home offers 50 ft. of private sandy frontage tuck into a no wake bay for quiet enjoyment to sink your toes into or wade in for a swim. At the water's edge is a new build patio and 56 ft. of dock. This very well maintained home features 3 bedrooms and 3 baths, an attached finished garage; master bedroom with ensuite with walk-in closet, air conditioning and all the modern conveniences. As you walk into the home you are greeted with grand views of the water thru the large windows from floor to ceiling, the well appointed windows let in lots of natural light while enjoying the open concept kitchen, dining and living room, gas fireplace and sliders off the the living room to the expansive deck are great for outdoor dining and entertaining. The mudroom has laundry and 1/2 bath as you walk in from the garage for convenience. Climb the steps to the upper level where cathedral ceilings allow you to enjoy the views from your loft office. Also, there are two more guest bedrooms, full bath and a large bonus family room to meet all the needs of games/movie nights or extra sleeping quarters for more guests.
MlsNumber: 1923026


Listing Provided By: City2Shore Real Estate Northern Michigan, original listing
Name: City2Shore Real Estate Northern Michigan
Phone: (231) 839-0077
Office Name: City2Shore Real Estate Northern Michigan
Office Phone: (231) 839-0077
Agent Name: Tamara McLeod Helsel
Disclaimer: Copyright © 2024 Northern Great Lakes Realtors MLS. 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