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

6424 Brackett Road
Williamsburg, MI 49690
Audra Jackson with EXIT Northern Shores Realty-ER, original listing - (231) 264-9833

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $12,000,000
Beds: 8
Baths: Full: 7
Status: Active
SqFt: 21000 Square Feet
Agency: EXIT Northern Shores Realty-ER
Agency Phone: (231) 264-9833

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Luxury six acre gated equestrian estate adjacent to Flintfield's Horse Park, home of Traverse City Horse Shows. The property, known as Pinecone Farm, was completed in 2024 with no expense spared. Thoughtfully designed by equestrians to maximize the six acre parcel including: a main barn with 4 bedroom, 3.5 bathroom residence above, an auxiliary barn with 4 bedroom, 2 bath staff accommodation above, 250'x150' GeoFiber Riding Ring, GeoFiber longing ring and paddocks. The 11,875 sq ft main barn has twenty-four BarnWalker stalls with bamboo walls and stainless top rails and individual water fillers. The stalls are split between two wings, each with its own tack room and storage, ideal for renting. There are four wash stalls (two outdoor and two indoor) and four grooming stalls with custom cabinetry. The spacious viewing lounge overlooks the ring with plenty of space for indoor and outdoor entertaining. Lounge has a half bath, refrigerator, custom cabinetry and large covered porch. Across is a laundry room/break room with refrigerator and storage. The main tack room has integrated storage cabinets and there are multiple other storage rooms including adjoining hay and feed rooms with easy outdoor access for loading and unloading. The details of this facility from the custom woodwork and cabinetry to the oversized steel and glass doors must be seen to be appreciated. The owner's unit is accessed through a private entrance with dumbwaiter. It offers exceptional views over the ring and countryside from both the master bedroom and covered viewing deck. The auxiliary barn has extra-height garage doors to accommodate RV's, golf cart charging wall and is wired to add additional temporary stalls. Outside, you have two RV hookups and fully irrigated yard and paddocks with underground storage tanks for drainage. The property has two gated entrances from both Brackett Road and Arabian lane and a gate for horse and golf cart access just steps away from the showgrounds.
MlsNumber: --
ListingId: 1926752


Listing Provided By: EXIT Northern Shores Realty-ER, original listing
Phone: (231) 835-1650
Office Phone: (231) 264-9833
Agent Name: Audra Jackson
Disclaimer: Copyright © 2024 Northern Great Lakes Realtors MLS. 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