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

822 Poplar Springs Road
Westminster, SC 29693
Pat McNamara with Joan Herlong Sotheby's Int'l, original listing - (864) 238-5111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $10,000,693
Beds: 8
Baths: Full: 8, ½: 3
Status: Active
SqFt: --
Agency: Joan Herlong Sotheby's Int'l
Agency Phone: (864) 238-5111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 172 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Call Pat McNamara @ 864-270-8726 for a tour or additional information regarding this 172-acre Country and Equestrian Estate, nestled in the foothills of Upstate South Carolina. A legacy property, this extraordinary property provides the perfect canvas within the base of the Blue Ridge Mountains to create your legacy. With complete privacy, the 16,000 +/- sf main house, including a self-sufficient in-law apartment, boasts 8 bedrooms, 8 full baths and 3 half baths, a chef’s kitchen, multiple sprawling entertaining areas on the main level, a billiards and movie room on the lower level, a fitness facility, 6-person sauna, and much more. The in-law apartment can be accessed externally by a separate staircase or internally via a staircase or the 3-story elevator. The outdoor kitchen with a large patio and pool overlooks a stocked and peaceful 3.5-acre pond. For both serious equestrians and relaxed riding, a little over 100 yards away is a world-class horse barn with 11 stalls, a misting system, an air-conditioned office and tack room, a laundry room, and a bathroom. On the second floor of the barn is a caretaker’s apartment complete with a full kitchen. This is all surrounded by approximately 110 acres of gorgeous pastures framed by a 4-board fence plus acres of woodlands and approximately 1.25 miles of frontage on Coneross Creek. Tucked away and private, yet access to this property is a breeze. 2 hours from Atlanta, GA, 2 hours from Charlotte, NC, 1.5 hours from Asheville, NC, and 1 hour from Greenville, SC. Clemson, SC is 20 minutes, while charming Seneca, SC main street, shopping, and dining are less than 10 minutes. Oconee County Airport, complete with a 5000’ runway, is only 20 minutes door to door. 10 minutes to 1-85, providing easy access to major Southern cities. Multiple activities are at your back door – providing the ultimate in relaxed, outdoor southern living. Access to one of South Carolina’s best lakes, Lake Keowee is only 15 minutes. Here you can boat, fish or enjoy paddle sports. Additionally, there are numerous areas in which to hike and enjoy the beautiful mountains of SC, GA, and NC within 1 hour. Enjoy South Carolina’s mild winters, long fall and spring seasons, and warm (but not too hot) temperatures in the summer months. Breathe in the fresh air, take in the mountain views, experience unspoiled nature, and embrace all life has for you and your loved ones at this spectacular farm.
MlsNumber: --
ListingId: 1538923


Listing Provided By: Joan Herlong Sotheby's Int'l, original listing
Phone: (864) 238-5111
Office Phone: (864) 238-5111
Agent Name: Pat McNamara
Disclaimer: Copyright © 2024 Greater Greenville Association of 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 = 2351 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 Distinguished Realty of South Carolina
Distinguished Realty of South Carolina
Call Today!: (864) 818-7653

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App