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 = 97 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 97 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 97 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;

2855 Highway 14
Landrum, SC 29356

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,975,000
Beds: 6
Baths: 4
Status: Active
SqFt: --
Agency: Greenville Central Partners LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 22 acre(s)
Property Type: Residential
Year Built: --
Notes: Nestled within 22.54 acres of serene woodlands, this remarkable property offers a rustic escape like no other. The centerpiece of this natural haven is a 3,895 sqft antique log sided cabin with authentic chinking, featuring 6 bedrooms and 4 bathrooms. Its timeless charm and warmth beckon you to embrace the tranquility of the surroundings. Picture yourself on this expansive deck, the soothing sound of raindrops dancing on the tin roof creating a peaceful melody. One unique feature of this home is the inclusion of three elevators, with one specifically designed to provide easy access to the 37x27 basement. This convenience enhances the accessibility of the property, making it suitable for a wide range of needs. Adding to the allure of this property is a 30x120' workshop that comes fully equipped with water and electricity, even boasting a complete bedroom and bathroom. This is a space where creativity and functionality meet, allowing for various possibilities. Situated a mere 10 minutes from the picturesque Lake Bowen, this property combines the best of both worlds – the solitude of the woods and the recreational allure of the lake. For those who appreciate the soothing presence of water, this property also offers walking access to the North Pacolet River, perfect for quiet moments of reflection or leisurely exploration. Additionally, a quarter-acre pond graces the landscape, adding an enchanting touch to the natural surroundings. Do not miss out on your new home! Sale includes parcels: 1-03-00-021.03 1-03-00-021.04 Call KRYSTAL OWENS for more information. 864-293-2476 ***4% buyer agent with full price offer*** *Motivated seller, priced to sell*
MlsNumber: 1511895


Listing Provided By: Greenville Central Partners LLC, original listing
Name: Greenville Central Partners LLC
Phone: (864) 400-4100
Office Name: Keller Williams Greenville Cen
Office Phone: (864) 400-4100
Agent Name: Krystal Owens
Disclaimer: Copyright © 2024 Greater Greenville 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