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

14186 S Mocking Bird Lane
Grant, MI 49327
Mitch Cripe with Schmidt Realtors, original listing - (616) 459-0400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,600,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5219 Square Feet
Agency: Schmidt Realtors
Agency Phone: (616) 459-0400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 24 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: This spectacular estate on 24 acres boasts 4 bedrooms, 3.5 baths, 6 stalls of garage (3 underneath w/spancrete), inground pool and unbelievable outbuilding that will leave you speechless. The main level primary suite has an attached sitting room with 3 walls of windows to enjoy the incredible views. Office, living room w/2story ceiling and fireplace opening to beautiful kitchen. The upstairs level has an entertaining space and sitting room, 2 bedrooms and full bath. The lower walk-out level leads to the pool for summertime fun for everyone. This level has a bedroom, full bath, and rec room with slider to pool. The property is both wooded and open so there are many uses. Outbuilding has heat/ac plumbing, half bath and RV motor home door off the back. See ''more'' for additional features. 24 Acres (with additional 6 acres available for purchase). Adjoining property is not open for hunting and is a nature preserve. In-floor heating system on all levels. Gas fired boiler runs water through floors for the in-floor heating - radiant heat in basement as well. Top of the line engineered wood floors on main and upper level. 3 stall garage with lower 3 stall spancrete garage giving you a total of 6 stalls. There is an extra driveway back to the lower garage. Epoxy decorative finish on main garage floor. The upstairs garage has stairs to the lower garage. Garages are heated with propane fire heater. Main floor laundry. Lower level stone accent wall has a flue for a pellet stove to be hooked up. Pre-plumbed chimney. House and barn are prewired for generator hook up. Hook ups are behind the outbuilding/barn so you do not hear any generator noise at the house. A boiler is used to heat the home. This can either be run on propane at the home or buyer can choose to use the outdoor wood burning boiler to heat the home. Propane lines are run to the home and the outbuilding/barn. There are two AC handling systems - one for the home and one system for the primary bedroom and sunroom. Other small outbuildings have electricity.<br /> Pool heater Thermolater - allowing you to control the water temperature up or down. The house and barn have Fiber Optic High Speed Internet and wifi. You can upgrade or downgrade your speeds. Boiler and hot water heater have both propane and wood burning options. Hot water system can be utilized thru a boiler fired water heater or standard electric hot water heater.
MlsNumber: --
ListingId: 25008321


Listing Provided By: Schmidt Realtors, original listing
Phone: (616) 292-2637
Office Phone: (616) 459-0400
Agent Name: Mitch Cripe
Disclaimer: Copyright © 2025 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 = 1296 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 Lori Brock
Lori Brock
ASCIIRiverTown Real Estate
Call Today!: (231) 250-8882

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App