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

4037 Old Williamston Road
Belton, SC 29627-8261
Abbey Turner with Found It , LLC (Greenville), original listing - (864) 270-1475

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: Found It , LLC (Greenville)
Agency Phone: (864) 270-1475

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: What an incredible property this is!! First, it's a Beautiful Home Place. Second, it's a Professional Canine Facility. One of the things that makes this property so amazing is that it's not overwhelmingly Big, and it's definitely not too Small. It's Tranquil, it's private, it's serene, and the pond and water feature adds just that extra "something" to the entire picture. The property is 5.49 acres (Fenced) with a 2,016 SF, 3b/2ba, 1 story house with an attic Flex Room. The floorplan is Open with Beautiful Architectural Features throughout. In preparation for listing, the Sellers have just done touch up paint throughout, they replaced some Outside and Interior Lights, and they added New SS Appliances. The Large Deck off the Great Room (20 x10) is perfect for grilling out and is made of the indestructible Trex Decking. There's an attached Carport at the house and a Detached 2 Car Garage. The Kennel is a 1740 SF Block Built structure with 30 Mason Company In/Out Runs, a Full Kitchen, a Bathing/Grooming Room, Laundry/Storage/Feed Room, and Full Bathroom. The entire Building is Heated and Cooled with an electric Heat Pump. There's a 30 x 70 x 14 Pole Barn for additional storage and RV parking that has covered access to the kennel. Adjacent to the kennel is a Tiny House that has been used for both an Assistants Quarters, and also a Guest House. It includes a main living area, a kitchen, and a full bath. It's fully electric, and on it's own Septic Tank and Well. This is a Primo location between Greenville and Anderson (but closer to Anderson), and not too far from I-85. The entire property is breathtaking and will be an amazing find for the right buyer. For Specific Questions about the property or to set up a private showing please contact Abbey Turner 864-270-1475 [email protected]
MlsNumber: --
ListingId: 1549990


Listing Provided By: Found It , LLC (Greenville), original listing
Phone: (864) 607-7134
Office Phone: (864) 270-1475
Agent Name: Abbey Turner
Disclaimer: Copyright © 2025 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => anderson [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: anderson State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: anderson 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 = 2317 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Rick Stroud
ASCIIEpique Realty - Great Homes of South Carolina
Call Today!: (864) 735-0705

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App