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;

7349 W White Birch Avenue
Lake City, MI 49651

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $469,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1163
Agency: City2Shore Real Estate Northern Michigan

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1970
Notes: Summer is here! And what better way to enjoy it than with this summer getaway on the sandy shores of 1,880 acres all sports Lake Missaukee, the central location offers easy day trips to Traverse City, Lake Michigan & ski resorts; whether you enjoy swimming, fishing or embarking on a kayaking adventure this cottage can provide. It has everything you need for a weekend escape- located in Tom's Bay with 60 ft. of private waterfront property and a sandy beach to make sandcastles with space for lounging in the sun or hanging out by the water. The large two area deck is the perfect place for outdoor fun, with plenty of room for outdoor dining in the sun or shade and enjoying the lake views. This three bedroom, 1.5 bath cottage with a 1 stall garage starts with the first floor open kitchen, living room and dining room area, primary bedroom, full bathroom and laundry room. The large picture windows in the living room create lots of natural light and views of the water. On a cooler night start a fire in the woodstove or enjoy the newly installed central air on warmer days. Upstairs you will find two more bedrooms and a half bathroom, with larger bedroom boasting a balcony to enjoy morning coffee with a view. Sale includes all furnishings, 40 ft. of dock, power lift, paddle boat, and pontoon. 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 on July 4th to enjoy the fireworks display for the Greatest Fourth in the North celebration. If you're looking for a place to relax and recharge, this cottage is just what you need! All you need is your suitcase to start making memories with your family and friends.
MlsNumber: 1922951


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