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

407 N Windsor Road
Windsor, SC 29856
Suzanne Haslup with Meybohm Real Estate - Aiken, original listing - (803) 648-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,195,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 2450 Square Feet
Agency: Meybohm Real Estate - Aiken
Agency Phone: (803) 648-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Live the ultimate equestrian lifestyle at Farm dé Solé in Windsor Trace in a gated 6 acre farm with access to miles of trails and dirt roads for riding and carriage driving. Enter through the Sapele African wood front door into the tasteful addition to the original home that was added in 2020 by JD Cooper, to include gourmet kitchen, great room with 16' cathedral ceiling and wet bar with Sherle Wagner sink, dining room with room to seat 12 guests, master bedroom with vaulted ceiling and large walk-in closet with W/D. Master bath has wheelchair accessible tile shower. Jacuzzi tub, double vanity and sinks. The lighted gunite 15X20 salt water pool welcomes you from the great room and the master bath and includes a stone patio, waterfall, Palmetto trees and a fabulous view of the sunset. Whole house stereo system includes the pool area.<br /> The chef's kitchen has a subzero refrigerator, Thermador appliances, Kohler farmhouse sink, wine refrigerator, Moroccan tile backsplash and Sapele wood center island with cabinetry and bar seating. Large walk-in pantry has custom shelving and drawer space.<br /> Additional living room, office/mudroom/laundry has second W/D, new cabinetry, sink and Mahogany countertop. The second bedroom has a large walk-in closet and full bath. Upstairs is a loft for an office or storage.<br /> The lovely center aisle barn has 4 stalls (2 in and out), climate-controlled tack room, feed room, storage area, fly spray system, outdoor wash stall with hot and cold water, 3 run in sheds and 3 fenced irrigated paddocks. A large, flat grass area is ideal for flat work or a turnout field. Large metal Hoover equipment shed with storage for tractors, horse trailers, etc. Additional storage shed, greenhouse with electric, and raised garden beds convey.<br /> <br /> The 6-acre property has been extensively landscaped and selectively cleared, creating the perfect balance between pastures and living areas. The entire farm is irrigated, including the paddocks, and there is no-climb wire around the perimeter for pets. The main riding trail runs alongside the property; enjoy direct access to miles of trails and dirt roads for riding and driving in Windsor Trace.
MlsNumber: --
ListingId: 213432


Listing Provided By: Meybohm Real Estate - Aiken, original listing
Phone: (803) 215-0153
Office Phone: (803) 648-7653
Agent Name: Suzanne Haslup
Disclaimer: Copyright © 2024 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

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 = 2315 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 Lujain Abusaada
Lujain Abusaada
ASCIIColdwell Banker
Call Today!: (352) 208-4334

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App