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

121 Wonderland Drive
Cross Hill, SC 29332
Tony Curreri with Lakelands Realty, LLC, original listing - (864) 543-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $800,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: Lakelands Realty, LLC
Agency Phone: (864) 543-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Perfectly titled Wonderland! The views from this fantastic Lake Greenwood home are nothing short of spectacular, and the sunsets are indeed wonderous! You will absolutely love the flat lot and easy access to beautiful 11,400-acre Lake Greenwood. The property features a private dock, fire pit and a Kauffman forever seawall. This well laid out mostly one level home makes living easy! There is a bonus 4th bedroom with private bath upstairs for a wonderful guest suite. The main level features an open floor plan with two bedrooms and a bath on one side and the primary bedroom privately located on the other side featuring awesome views and access to the screened porch with private hot tub! The primary bath is incredibly stylish and features a free-standing tub and large walk-in closet. The large great room features a beautiful trey ceiling and seamless transition into the modern and stylish kitchen with gathering island. The office space off of the great room is perfect for working from home. The extra-large sunroom is currently set up as an amazing dining room to host breathtaking meals and gatherings with lots of friends and family. The size of this room makes it perfect for multiple uses and gazing in amazement at stunning sunsets! The home also has a whole house generator so no concerns about any power outages! This package is hard to find without any HOA fees, lots of privacy, great neighbors and views that will stir your soul. Call today for your private showing of this amazing opportunity!
MlsNumber: --
ListingId: 131897


Listing Provided By: Lakelands Realty, LLC, original listing
Phone: (864) 344-8822
Office Phone: (864) 543-7653
Agent Name: Tony Curreri
Disclaimer: Copyright © 2025 Greenwood 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App