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

110 Warpaint Lane
Westminster, SC 29693

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,000
Beds: 5
Baths: 4
Status: Active
SqFt: --
Agency: Clardy Real Estate, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: Welcome to this picturesque waterfront log home on nearly a full acre of wooded land nestled in the lovely community of Chickasaw Point. As you step into this 5-bedroom, 3-1/2-bath home, you will immediately be greeted by vibrant lighting that warmly fills the space. The home's focal point is its impressive high vaulted wood-beamed ceiling with a stunning wood-burning stone stucco fireplace. Adjacent to the inviting open kitchen is a delightful dining area, perfect for gatherings and culinary delights. The kitchen is a chef's dream, boasting granite counters, a top-of-the-line Thermador 5-burner gas stove with downdraft, a wine cooler, wall convection double oven, walk-in pantry, and beautifully crafted cabinetry. Additionally, a separate bar room with sink offers versatility and can double as an office space. Retreat to the main ensuite bedroom conveniently located on the main floor, featuring vaulted ceilings and a private entry to the back deck, which is ideal for enjoying morning coffee amidst peaceful surroundings. The master bath has a double vanity, separate water closet, step-in shower, and spacious walk-in closet. The upper level boasts two bedrooms off a lovely balcony overlooking the great room and a full bathroom with a tub/shower combination. The terrace level includes two additional bedrooms, with outdoor access for guest privacy. The terrace level rooms offer great flexibility to be home offices, fitness rooms, bonus rooms, etc… as well as a full bath with a tub/shower combination. Storage areas abound on this lower level. Step outside to the all-season sunroom/screen porch and savor the tranquility of nature, or venture onto the expansive deck for outdoor entertaining. Descend to the flagstone patio with a custom wood-fired oven, perfect for cooking whatever your heart desires. A charming screened gazebo offers additional seating against the breathtaking backdrop of panoramic views of Lake Hartwell. For a closer look, take a walk to the covered dock with power and water to fully immerse in what Lake life is about. This meticulously maintained property is equipped with modern conveniences, including a Generac home generator and a new 2022 roof, ensuring peace of mind for years to come.<br /> Additionally, a 16’x16' outdoor two-story shed conveys with the home, providing ample storage space for all your needs."Many furnishings available for additional sale. Inquire for details."
MlsNumber: 20272205


Listing Provided By: Clardy Real Estate, Inc, original listing
Name: Clardy Real Estate, Inc
Phone: (864) 882-4864
Office Name: Clardy Real Estate
Office Phone: (864) 882-4864
Agent Name: Linda Farkas Fey
Disclaimer: Copyright © 2024 Western Upstate 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.


Local Real Estate Expert

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 = 2351 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;
Real Estate Expert Photo for Silvana Baez
Silvana Baez
ASCIIKeller Williams Seneca
Call Today!: (864) 873-7430

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App