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

140 Windy Ridge Road
Trenton, SC 29847
Andra Armstrong with Meybohm Real Estate - Lexington, original listing -

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $460,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1890 Square Feet
Agency: Meybohm Real Estate - Lexington
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 22 acre(s)
Property Type: Residential-Manufactured On Land
Year Built: 1996
Notes: Charming 22.27-Acre Working Farm - Move-In Ready & Sustainably Managed<br /> <br /> Discover the perfect blend of function and rural charm on this 22.27-acre working farm, thoughtfully designed for both agricultural productivity and outdoor enjoyment. Conveniently located just a short drive from Augusta, GA and Aiken, SC, this property offers peaceful country living with easy access to city amenities.<br /> <br /> The farm features eight cross-fenced pens and paddocks, an eight-stall barn equipped with water and power, and two chicken coops with attached runs. A dedicated brooder barn and two run-in shelters with paddocks provide additional flexibility for livestock or equestrian use.<br /> <br /> Approximately 15 acres are cleared for pasture or cultivation, while 7 wooded acres offer abundant wildlife and game for hunting or nature walks. Mature fruit trees add to the property's agricultural appeal, and multiple ATV trails make for easy access and recreation across the grounds.<br /> <br /> A unique highlight is the aquaponic fish pond stocked with bluegill, providing a sustainable protein source and complementing the property's eco-conscious design.<br /> <br /> Outbuildings include two 8x10 storage sheds (one with power) and a spacious 12x24 building with a loft and upgraded windows—ideal for a workshop, studio, or guest quarters.<br /> <br /> The 1,890 sq ft, 4-bedroom, 2-bath mobile home features a new roof, new flooring, and 25 recently installed solar panels, offering energy efficiency and reduced utility costs. The land has been carefully maintained using rotational grazing practices with minimal to no use of herbicides or pesticides, supporting a healthy environment for both livestock and crops.<br /> <br /> This is a rare opportunity to own a turnkey farm with solid infrastructure, modern upgrades, and a commitment to sustainable living—all in a prime location close to Augusta and Aiken.
MlsNumber: --
ListingId: 217560


Listing Provided By: Meybohm Real Estate - Lexington, original listing
Phone: (706) 251-2671
Agent Name: Andra Armstrong
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App