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

416 Hidden Springs Way
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: $1,194,100
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: --
Agency: Lakelands Realty, LLC
Agency Phone: (864) 543-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Absolutely Amazing Lake Greenwood Masterpiece! This is one for the books! Beautifully laid out floor plan features a main level for primary living including a phenomenal kitchen, open living room Master Suite, Two Guest Bedrooms with Jack & Jill + bath. Large laundry room with tons of storage, Powder Room and a Massive Screened Porch with lounging and dining areas overlooking spectacular sunsets shining on not only Cane Creek but long-range views of Hidden Lake as well! Upstairs you will find a phenomenal office-5th bedroom with private full bath and storage closet. Enjoy the stunning views coming from the elevated lakefront windows. But wait! The best part is yet to come! The lower Terrace Level features two extra-large Glass Clad Garage Doors that bring the outside in! Effortless entertaining abounds in this incredible space. Featuring a Kitchenette, Bar, Lounging and Dining Area and TV Game Room space as well! An Extra-Large Guest suite that features not one, but two full baths! Tons and tons of storage space in the Terrace Level as well with an extra Garage Space large enough for an additional vehicle. Would make perfect multi-generational living quarters! Outside there is a large, covered patio area with outdoor grilling space, room for lots of lounges and a Sunset Perch fit for a King and Queen! The well-Manicured Hardscape and Landscaping are Gorgeous! There is a Golf Cart path leading from the Circular Driveway all the way down to the Lake for easy delivery of Toys, Food and Beverages! Double Covered Boat Lifts on Deep, Year-Round Water! Detached Garage is equally as impressive with room for at least 4 and up to 6 Vehicles/Boats etc.! This incredible Garage features Multiple Outlets, Air Hoses, 10-foot Doors and it is also Heated and Cooled with a split unit. You have to see this home! This is your chance to own one of the most Fantastic Homes Lake Greenwood has to offer! Call today for your private appointment!
MlsNumber: --
ListingId: 132747


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