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

1427 Buck Hill Landing Road
Ridgeway, SC 29130
Jeanene Campbell with Keller Williams Preferred, original listing - (803) 602-6500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 8
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4770 Square Feet
Agency: Keller Williams Preferred
Agency Phone: (803) 602-6500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 61 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: A sportsman & Lake Wateree paradise! This estate is truly remarkable with a 5 bedroom main house, 3 bedroom guest house above the detached workshop, pool house with salt water pool, RV carport, dock with covered boat slip, all nestled on more than 61 acres! Whether you are looking for a private estate, or a developer looking for your next project, this is the one! The main level features a large great room, dining area & office with built-in shelving. The gourmet kitchen is a chefs dream with quartz counters with ogee edge, tile backsplash, 6 burner gas cooktop w/ griddle, & exquisite custom cabinetry complete with toe kick drawers and pull out shelving. The main bedroom suite is also on the first level with a luxurious bathroom with claw foot tub, dual head shower and a huge walk in closet. Two additional bedrooms complete this level, each with their own walk in closet and a shared bath between. The lower level has endless possibilities with a huge central gathering space w/wood stove plus 2 more bedrooms. A 3rd room is used as an art studio with built in antique sink. A large utility room and full bath complete the downstairs. Still looking for more space? There is a complete guest house above a huge 36x56 shop! This space has 3 bedrooms, full kitchen, family room, full bath and closet with hook ups for w/d. The fully insulated shop is just below with tool bench, a half bath and 14 foot rolling door. Outdoor enthusiasts will love all the extra features that include raised garden beds, chicken coops, plus an underground greenhouse! The land and its superb location is what makes this property irreplaceable. Offering frontage on Wateree Dam Rd, Buck Hill and Ginko Trail. Keep your boat on the lift or launch it just down the street at the public landing. Ultimate privacy with rolling hills full of hardwoods, fruit trees and FULL of wildlife. Plus, Duke Energy owns all the undeveloped land across the street all the way down to the landing. Just 12 minutes to the local grocery store, 20 to Historic Camden, 35 minutes to Sandhills with all the shops you could dream of, or jump on I20 to be downtown Columbia in just 45 minutes! Disclaimer: CMLS h
MlsNumber: --
ListingId: 607328


Listing Provided By: Keller Williams Preferred, original listing
Phone: (803) 602-6500
Office Phone: (803) 602-6500
Agent Name: Jeanene Campbell
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