Title Page Background
DEBUG FN args: Array ( [0] => 2315 [1] => [2] => [3] => agent ) BEFORE: Site: 2315 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2315 Igate: njhud LocID: 2315 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 = 2315 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2315 [1] => [2] => [3] => lender ) BEFORE: Site: 2315 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2315 Igate: njhud LocID: 2315 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 = 2315 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2315 [1] => [2] => [3] => other ) BEFORE: Site: 2315 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2315 Igate: njhud LocID: 2315 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 = 2315 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1245 Coleman Bridge Road
Wagener, SC 29164
Sharer Dale Team with Keller Williams Realty Aiken Partners, original listing - (803) 262-4460

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,899,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2468 Square Feet
Agency: Keller Williams Realty Aiken Partners
Agency Phone: (803) 262-4460

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 14 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Nestled on 15 +/- acres, Centerstone Stables is a 2022 Brad Kelly-built estate that seamlessly blends luxury living with world-class equestrian amenities. The 4-bedroom, 3.5-bathroom home showcases stunning craftsmanship, featuring three custom shiplap fireplaces, soaring 10-15' ceilings, and bamboo floors. Every detail has been carefully curated, with custom finishes throughout, including wood beams, designer light fixtures, and quartz countertops. The open and split floor plan is designed for both comfort and functionality, centered around a chef's kitchen with an oversized island, perfect for entertaining and everyday living.<br /> <br /> Beyond the home, this estate is designed for equestrians. The 5-stall barn includes a tack/feed room, with 4 oversized paddocks (one across the dirt road) and 2 smaller paddocks, providing ample turnout options. Additionally there are 3 stalls that are under a covered shed with runouts, making it a total of 8 stalls. A short walk from the barn is a round pen. Want to be able to ride after dark? The 190 x 300 GGT irrigated arena has full lights and is large enough to accommodate both a full dressage arena and a jumper ring, making it an exceptional training space for riders across multiple disciplines. Whether you're a competitor or simply enjoy riding at home, this farm is laid out with efficiency and versatility in mind.<br /> <br /> In addition to the equestrian amenities, the property offers incredible storage and workspace options. A 60 x 80 insulated shop features spray foam insulation in the roof gables and walls, along with four car bays, making it perfect for car enthusiasts, farm equipment, or even an EASY conversion into a custom barn. A 30 x 25 equipment shed provides additional space for hay storage, farm machinery, or other equipment, ensuring everything you need is right at your fingertips. The gated entryway and a separate side entrance allow for convenient access, whether for deliveries or horse trailers.<br /> <br /> After a long day of riding, retreat to your private backyard oasis, where a saltwater pool is surrounded by lush palm trees and additional landscaping, creating a resort-like atmosphere in your own backyard. Enjoy a covered porch with a wood burning fireplace, TV, and ample space for entertaining! This property offers the perfect balance of equestrian excellence and luxury living.<br /> <br /> Located in the heart of the 302 Equestrian Corridor, Centerstone Stables is just minutes from Meunier Polo, The Vista Schooling Center, Bruce's Field, Highfields, Stable View, Hitchcock Woods, Full Gallop, Sporting Days, and Jumping Branch. With its prime location, thoughtfully designed layout, and endless possibilities for customization, this estate is a rare opportunity to own a turnkey equestrian property that can be tailored to meet your needs.<br /> Don't miss the chance to experience Cornerstone Stables—schedule your private tour today!
MlsNumber: --
ListingId: 215874


Listing Provided By: Keller Williams Realty Aiken Partners, original listing
Phone: (803) 761-0678
Office Phone: (803) 262-4460
Agent Name: Sharer Dale Team
Disclaimer: Copyright © 2025 Aiken MLS. 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] => aiken [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: aiken State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: aiken State: SC 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 = 2315 AND i.igate IN ('nwhud','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 = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Angie Edwards
Angie Edwards
ASCIIWisteria Properties LLC
Call Today!: (843) 360-0400

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App