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

15305 Stanton Street
West Olive, MI 49460
James Wiersma with Schmidt Realtors, original listing - (616) 396-5221

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3968 Square Feet
Agency: Schmidt Realtors
Agency Phone: (616) 396-5221

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Experience the ultimate in privacy with this custom-built modern home, perfectly situated on a sprawling 20.36-acre parcel. Enjoy spectacular views from every window, with interior finishes thoughtfully inspired by nature, seamlessly blending the outdoors with the indoors. This residence offers a unique sanctuary where contemporary design and function, meets natural beauty. The kitchen is a culinary dream, featuring a gigantic 10-foot island that comfortably seats six. The countertops, made from luxury quartzite, are a significant upgrade from traditional quartz or granite. This real, natural stone is imported from Italy, offering beautiful natural veining and easy maintenance. The butler's pantry is thoughtfully designed with a microwave, a custom white oak pantry area, and enough space for an additional full-size fridge. The oversized 3 stall garage is insulated, and provides ample storage, the spacious mudroom offers custom built-ins and access to the guest bath. The main floor primary bedroom is a serene retreat with a window that perfectly frames the outdoor Christmas tree spruce in the backyard. The en suite bathroom features in-floor heat, a custom walk-in shower equipped with two shower heads, a bench, and a shelf with LED lighting, creating a spa-like experience. The walk-in closet is a masterpiece of design, featuring custom-built wood shelves and drawers, along with extra storage space. The finished daylight basement is a haven of comfort and functionality, featuring in-floor heating throughout, a huge recreation space, built-in storage, a movie room with a secret locking storage room. Also on the lower level, there are three additional bedrooms with custom bunk beds, ample closet spaces, and a full bathroom with separate vanity area. Outdoor spaces abound from the quaint covered front porch, to the generous back deck, that steps down to a stone patio/fire pit area. Further back on the property, there is a sand volleyball court, trails, and even a chicken coop. The property is ideally located just two miles from the beach, with easy access to Olive Shores, Winds Nest, and the Port Sheldon Pier. Situated just off Highway 31, it offers convenient connections to both Grand Haven and Holland. Outdoor enthusiasts will appreciate being close to miles of running and bike paths, as well as being just 2.5 miles from Hemlock Crossings, a beautiful park with trails and scenic views.
MlsNumber: --
ListingId: 24060277


Listing Provided By: Schmidt Realtors, original listing
Phone: (616) 396-5221
Office Phone: (616) 396-5221
Agent Name: James Wiersma
Disclaimer: Copyright © 2024 Coldwell Banker Schmidt REALTORS. 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 = 1304 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;
Real Estate Expert Photo for Melissa Doubleday
Melissa Doubleday
ASCIIKeller Williams Realty
Call Today!: (616) 546-5242

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App