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;

2047 Pineland Shores Circle
Cross Hill, SC 29332
Bea Walker with RE/MAX ACTION REALTY, original listing - (864) 942-0021

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: RE/MAX ACTION REALTY
Agency Phone: (864) 942-0021

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: This lovely lakefront move-in ready home with BIG OPEN WATER, long covered pier with two boatslifts awaits YOU! Situated on .475 acres, this doublewide move- in- ready home boasts of three bedrooms and two baths and a large kitchen with large pantry that is open to the great room. There is a 219 square feet screen porch facing the lake and overlooking big open views of Lake Greenwood where you can sit in the morning and enjoy coffee or to relax and enjoy sunset views in the evening. What's more is that the doublewide home has been detitled already! The entrance in back is handicap accessible with a large ramp with no steps. There is a carport on the property. The master bath in the doublewide consists of a two seated step in shower and double sinks and a walk in closet. The laundry area is located at the back door. An EXTRA bonus is that, in addition to the mobile home, there is a separate two bedroom one bath 987 square foot house, which was the former family home, on the property that has been converted into a shop/large storage building. You can easily make this into a mother in law suite, “mancave,” and the choices are yours to make this area whatever you need it to be. Enjoy approximately 88 feet of water frontage with HUGE BIG OPEN WIDE VIEWS OF LAKE GREENWOOD! This is lakefront heaven. This is approximately 45 minutes to Greenwood or to the town of Laurens. AND NO RESTRICTIONS HERE, so NO HOA fees! This has everything you need for a cozy home on Lake Greenwood!
MlsNumber: --
ListingId: 131277


Listing Provided By: RE/MAX ACTION REALTY, original listing
Phone: (864) 980-3243
Office Phone: (864) 942-0021
Agent Name: Bea Walker
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