Title Page Background
DEBUG FN args: Array ( [0] => 1267 [1] => [2] => [3] => agent ) BEFORE: Site: 1267 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1267 Igate: njhud LocID: 1267 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1267 AND i.igate IN ('mihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1267 [1] => [2] => [3] => lender ) BEFORE: Site: 1267 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1267 Igate: njhud LocID: 1267 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1267 AND i.igate IN ('mihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1267 [1] => [2] => [3] => other ) BEFORE: Site: 1267 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1267 Igate: njhud LocID: 1267 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1267 AND i.igate IN ('mihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

8955 Braden Road
Haslett, MI 48840

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 26 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1986
Notes: Introducing your exclusive equestrian estate nestled on 26 acres with three spacious pastures, two expansive ponds, a 70x200 indoor riding arena with a well-appointed stable, and outdoor riding arena. Immerse yourself in the tranquility of walking and riding trails that wind through the estate's sprawling acreage. Step inside to discover a beautifully renovated home with a multitude of exceptional features. Unique features include metal front doors imported from Texas, a family room with maple coffered ceilings, stamped steel beams, custom wrought iron spiral staircase, and black slate floors on the main. The main master features a master bath with heated floors and a California closet dressing room. Radiant heat also warms the four season room for year round comfort. Two of the three upstairs bedrooms feature decks that overlook the serene outdoors. Horse enthusiasts will be delighted by the 70x200 indoor riding arena featuring five surrounding Dutch doors, enabling year-round riding while embracing the outdoors. The attached barn currently houses four stalls and convenient storage space for equipment. The three pastures are complete with Ramm fencing and automatic waterers, complete with insulated covers for the coldest winter days. Lean-to sheds in each pasture provide shelter during inclement weather, and a secluded outdoor arena lies beyond the pastures. The attached three-car garage is plumbed with air and vacuum lines, featuring a mechanic pit in the first stall.<br /> <br /> For year-round comfort inside the home, a Vermont Casting wood-burning stove with a catalytic converter adds a cozy ambiance. The inviting dine-in kitchen showcases a live edge dining table and island handcrafted in Traverse City. All showers in the house are equipped with modern Schluter systems, and a geothermal system enhances energy efficiency. For ultimate relaxation, a Heat'n Sweep Polar hot tub graces the second-story deck, providing a peaceful view of pastures and surrounding woods. Additionally, a screened-in gazebo with a vaulted ceiling offers an ideal setting for al fresco dining or a summer retreat. <br /> <br /> A charming garden shed graces the property beyond the field stone wall. Both the house and shed are fully equipped for custom Christmas lighting by Arbor. Brick pavers create a picturesque wraparound drive, accented by a bubbling boulder center and cherry trees.<br /> <br /> Close proximity to Michigan State Veterinary Medical Center (5 mi), Waterloo Hunt Club (40 mi), Traverse City Flintfields Horse Park (180 mi), Grand Rapids - Ford (65 mi), Chicago O'Hare (240 mi), Detroit metro (80 mi), Whole Foods (4 mi), and Costco (3 mi).
MlsNumber: --
ListingId: 23134786


Listing Provided By: Schmidt Realtors, original listing
Phone: (616) 218-0267
Office Phone: (616) 396-5221
Agent Name: Andrea Crossman
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => ingham-northwest [3] => MI [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: ingham-northwest State: MI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: ingham-northwest State: MI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1267 AND i.igate IN ('mihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Elizabeth Fleckenstein
Elizabeth Fleckenstein
ASCIIBHHS Tomie Raines REALTORS
Call Today!: (517) 881-6698

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App