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

140 Windy Ridge Road
Trenton, SC 29847
Kourtney O'hara with Big A Homes, original listing - (803) 381-2802

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1890 Square Feet
Agency: Big A Homes
Agency Phone: (803) 381-2802

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 22 acre(s)
Property Type: Residential-Other
Year Built: 1996
Notes: Escape the hustle and bustle and embrace the beauty of wide-open spaces with this fully fenced 22-acre property, perfect for horse lovers, nature enthusiasts, or anyone looking to live off the land. This rare homestead offers a harmonious blend of modern comfort and rural charm, complete with new HVAC, solar panels, TWO septic tanks, hydroponic pond stocked with bluegill, multiple outbuildings, chicken coop, and a fully equipped barn with power and water. Experience exploring your land on the horse/ATV trails surrounding the home. If you work up an appetite don’t worry, there are fruit trees, muscadine grapes, and various berry bushes planted throughout. Hunters will be happy to know that this property also is a host to a variety of game, so make sure to bring your tree stand!Come inside and enjoy the recently upgraded LVP flooring throughout this spacious farm house.The utility room allows for you to kick off your boots before entering into the main hall. Whether you prefer to cozy up with a good book in the den, or entertain in front of a roaring fire in the formal living room, you’ll have plenty of space in this open floor plan. Needing solitude? With three bedrooms and an office it’s easy to sneak away to find a relaxing spot. The primary suite is filled with natural light, and it boasts a large on suite with garden soaking tub, double vanity and water closet.Look forward to making fresh sourdough in your own country kitchen. Canning and preserving is made easier with ample amounts of storage in the kitchen and butler’s pantry. Whether you're looking for an equestrian retreat, a sustainable homestead, or a peaceful rural getaway, this property has it all. Don't miss the chance to own a slice of paradise! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
MlsNumber: --
ListingId: 602372


Listing Provided By: Big A Homes, original listing
Phone: (803) 381-2802
Office Phone: (803) 381-2802
Agent Name: Kourtney O'hara
Disclaimer: Copyright © 2025 Consolidated MLS, SC. 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