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

10367 Colmur Drive
Mecosta, MI 49332

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 5
Baths: 8
Status: Pending
SqFt: 6217
Agency: eXp Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2005
Notes: You can't miss the expansiveness of the property, which sits nestled on a dead end road on the northeast portion of Lake Mecosta - the largest of the interconnected tri-lakes boasting over 700 acres of the top all-sports and fishing action in central Michigan. Blue gills often bed in front of the recently updated seawall covering 192 feet of sandy shoreline.<br /> <br /> All of the views from both levels of the south portions of the house cater to this beautiful lake and it does so in a dazzling nature. As you walk in the front door, all of this becomes apparent with floor to ceiling windows. The lake and all of its magnificent shades of blues and greens greet you through the doorway. The water calls you in as the warmth and airiness of the house helps anyone feel right at home. Wake up each morning within the master main-level bedroom and watch the wind kiss up waves toward the house. The master bedroom has a beautiful office nook with a built-in bookcase and an equally stunning en-suite. With two spacious walk-in closets as well, there's not much more one could ask for.<br /> <br /> There are 3 additional bedrooms in the main house, each with it's own full bathroom. Also, there are guest quarters above the garage with a sitting room and it's own full bathroom. The setup and flow of the home lends perfectly to hosting and connection. <br /> <br /> With that in mind, the main kitchen's clean lines, granite countertops and white motif create a calming, soft space. The double ovens and islands empower the owners to bring people together. <br /> <br /> The lower level charms to the core with warm tones, wood features throughout and an additional kitchen. The walkout doors take you to a sprawling patio overlooking the lake and the boat house, which acts as a getaway and place to find serenity catching a sunset over the lake.<br /> <br /> The property has a 3-car heated garage with epoxy floors, built-in cabinets and a wood bench. With a detached garage that fits up to two additional cars, you'll have all the storage you will need. There is also a whole house generator for peace of mind during those power losses. The house also has 3 gas fireplaces, the one in the 4-seasons room can be converted back to wood burning for a perfect ambiance during the winter months. <br /> <br /> Nearly 1.4 acres of beautifully manicured outdoor space, each area of the yard is carefully curated towards beauty - the perennials and landscaping will take your breath away. The 26-zone sprinkler systems helps to keep everything healthy, even in the driest of summers.<br /> <br /> There are too many features to list and this home won't last long, so schedule your showing and see it all for yourself!<br /> <br /> -Check out the virtual tour
MlsNumber: 24022702


Listing Provided By: eXp Realty LLC, original listing
Name: eXp Realty LLC
Phone: (888) 501-7085
Office Name: EXP Realty LLC
Office Phone: (269) 600-4397
Agent Name: Shawn Hopkins
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1288 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;
Jack Frizzell
ASCIIFive Star Real Estate
Call Today!: (231) 598-6700

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App