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 = 1274 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 1274 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 1274 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;

6117 Blue Lake Road
Kalkaska, MI 49646

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1471
Agency: Lake Homes Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1950
Notes: Nestled amidst the remnants of a bygone era, this 3 br 1.5 bath , once a bustling hub during the old logging days, now stands as a tranquil lakeside paradise on the shores of Little Blue Lake in the highly sought after Blue Lake Township in the Glacial Lake Region of Kalkaska County. With the serene expanse of Big Blue Lake accessible just beyond, the property boasts a rare luxury: a scarcely used DNR lake access site, offering effortless boat launches and idyllic swims mere steps from the comfort of home. Easy to have all sports lake activity while having 435’ of private frontage with the serenity of no wake activity on Little Blue Lake. Here, the art of fishing transcends the ordinary, as the waters teem with life, harmonized by the gentle dance of reeds in the sunlight, providing sanctuary for an array of fish species. The essence of peace pervades every corner, inviting one to bask in the simple pleasures of life. A spacious main floor living area with a hand crafted stone fireplace commands attention in the heart of the home. The master suite, adorned with rich wood floors, exudes an inviting warmth, its windows framing uninterrupted views of the serene Little Blue Lake, a constant reminder of the enduring beauty that surrounds this lakeside haven. An expansive deck creates a stage for endless hours of play and relaxation. Two-car detached garage offering plenty of shelter for your prized possessions. Third bedroom, please note is a non-conforming sleeping porch offering panoramic vistas of the glistening waters, a symphony of tranquility. NOTE: 3rd bedroom is non conforming.
MlsNumber: 1921803


Listing Provided By: Lake Homes Realty, original listing
Name: Lake Homes Realty
Phone: (231) 218-5324
Office Name: Lake Homes Realty, LLC
Office Phone: (866) 525-3466
Agent Name: Cindy Anderson
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