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;

2191 Summerset Bay Dr.
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: $889,500
Beds: 3
Baths: Full: 2, ½: 1
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: 2017
Notes: WOW! You have to see this amazing Lake Greenwood Gem! This home was designed and built with the future in mind. Easy one level living with views that will blow you away! Located on some of the biggest and best water 11,400-acre Lake Greenwood has to offer! Before you even walk inside you will be absolutely taken with this home! Incredible style, landscaping and function merge together to create this perfect oasis! Beautiful 12-foot-wide concrete driveway leads you to the front of the home featuring an oversized 3 car garage that is heated and cooled! The style features of this home are absolutely fantastic, and the quality of the build are evident. The entryway boasts beautiful landscaping, wonderful concrete work and a custom 12 x 20 shed that is built on an engineered slab and is finished on the inside with sheetrock walls, lights and several power outlets. Perhaps the most outstanding feature of this home is that it is built with absolutely no steps! You can go from the driveway to the dock without taking one step up or down a single stair! While all of this is amazing, the real joy comes once you enter this beautiful home! The view is absolutely stunning! An open dining room is to your right and a private office to the left. Large comfortable great room is open to the beautiful kitchen featuring Cambria quartz countertops, custom cabinets, GE Profile stainless steel appliances including a 5-burner natural gas cooktop and a large walk-in pantry. This split floorplan features two guest rooms with Jack & Jill bath. There is a pretty powder room on the opposite side of the great room and around a private corner sits the master bedroom, which also has stunning lake views, a spa like master bathroom with double vanity, custom shower and soothing freestanding tub. The master also has access to the gorgeous lakeside screened porch featuring a beautiful tongue and groove ceiling with dual fans to augment the cool evening lake breeze. Concrete walkways and patio complement each side of the screened porch with a path that leads to the ramp that will take you to your private, covered boat dock featuring two 6000lb boat lifts to keep your watercraft clean, dry and safe from boat wakes and lake waves. This home also has a 22KW Natural Gas Generac generator, a six person Sundance Cambria spa with cover, Central vac system (including 2 ports in the garage), Maytag Bravos Washer and Dryer, high end speakers throughout the home with amplifier included, 65, 50- and 40-inch wall mounted TV's, custom wood shelving in all closets and pantry, full gutter system, 220V 50A RV hook up in driveway and too many other features to list! You simply have to see this amazing home while it lasts! Contact us today for more details and to schedule your private showing of this wonderful Lake Greenwood opportunity!
MlsNumber: --
ListingId: 131716


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