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

5858 E Deer Road
Fountain, MI 49410
Brock Carlston with Nexes Realty Muskegon, original listing - (231) 739-3501

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,900
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 4252 Square Feet
Agency: Nexes Realty Muskegon
Agency Phone: (231) 739-3501

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Welcome to this beautifully appointed home, offering a blend of modern amenities and classic comforts. With thoughtful design and high-quality features, this property provides a superior living experience.<br /> Key Features: Spacious Design: Enjoy the airy feel of 9-foot ceilings on both the main floor and basement, creating an open and inviting atmosphere. Energy Efficiency: Benefit from triple-pane windows, 2x6 exterior walls, and foam insulation, ensuring optimal energy efficiency and comfort year-round. Versatile Pole Barn: A generous 30x60 pole barn with foam insulation, heating and two post lift is perfect for storage or projects, featuring two garage door openers for convenience. Comfortable Living Spaces: The home boasts 3 well-sized bedrooms and 2 full baths, including a main floor laundry room for added convenience. Elegant Kitchen: The kitchen is designed for both function and style, featuring a central island with ample storage, ideal for meal preparation and entertaining. Expansive Entertainment Area: Relax or entertain on the large wrap-around deck, providing ample space for outdoor gatherings and enjoying the view. Cozy Ambiance: A wood-burning stove in the living area adds warmth and charm, creating a cozy environment for all seasons/ A spacious walk out full basement has an apartment with kitchen, 2 bedrooms, and a full bathroom and living room. <br /> This home seamlessly combines modern efficiency with classic comforts, providing a perfect setting for both relaxation and active living. Discover a place where every detail has been thoughtfully considered for your utmost enjoyment. Home is not a part of Blue Lake Association - No other rentals allowed on Blue Lake. Buyer and buyer's agent to verify all information.6191 N Larson and 5858 E Deer Rd to be sold together. Website link: https://www.bluelakeresort.com/
MlsNumber: --
ListingId: 24042618


Listing Provided By: Nexes Realty Muskegon, original listing
Phone: (231) 739-3501
Office Phone: (231) 739-3501
Agent Name: Brock Carlston
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App