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;

23 Quail Drive
Salem, SC 29676

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 3
Baths: 3
Status: Active
SqFt: --
Agency: Real Broker, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential
Year Built: 1989
Notes: Nestled along the serene banks of the river, this captivating riverfront home offers a seamless blend of comfort, elegance, and natural beauty. Boasting 3000 sq.ft. of meticulously designed living space, this residence provides the perfect balance of modern amenities and tranquil surroundings. As you approach the property, you are greeted by the lush landscape adorned with mountain laurel, rhododendrons, azaleas, and an array of other enchanting flora. The vibrant colors and fragrant blooms create a picturesque setting, inviting you to explore further. Stepping inside, you are welcomed by a spacious main level featuring a cozy yet refined atmosphere. The heart of the home is the inviting living area, where large windows frame panoramic views of the river, allowing natural light to flood the space. The open floor plan seamlessly connects the living area to the gourmet kitchen, complete with top-of-the-line appliances, granite countertops, and ample storage space. Adjacent to the kitchen, the dining area offers the ideal setting for intimate gatherings or festive occasions. The highlight of the main level is the luxurious master suite, thoughtfully designed to provide a private sanctuary overlooking the tranquil waters. With its plush carpeting, spa-like ensuite bathroom, and generous closet space, the master bedroom exudes comfort and sophistication. Descending to the lower level, you discover two additional bedrooms, each with its own unique charm, along with a den and a full bathroom. This level offers versatile living space, perfect for accommodating guests or creating a cozy retreat for relaxation and leisure. Ascending to the upper level, you are greeted by an attic space offering abundant storage options, as well as an unfinished area that can be tailored to suit your needs. Additionally, the upper level features a charming craft room, providing the perfect space for unleashing your creativity and pursuing your hobbies. Beyond the confines of the main residence lies a detached 375 sq.ft. workshop or cottage, heated and cooled for year-round comfort. This versatile space offers endless possibilities, whether used as a studio, home office, or guest quarters. Adjacent to the river, a captivating entertainment structure beckons with its inviting ambiance and picturesque surroundings. The pavilion features a large fireplace at one end, providing warmth and ambiance on chilly evenings. Overhead propane gas units ensure comfort in any weather, while grills, a gas top cooking stove, and a refrigerator offer convenience for outdoor entertaining. A vinyl enclosure provides protection from the elements, allowing you to enjoy the breathtaking views in any season. A spacious deck along the river provides the perfect spot for al fresco dining or simply basking in the serenity of nature. Adding to the charm of this exceptional property is an operational outhouse with running water, providing a touch of rustic charm while ensuring modern convenience. With its unparalleled blend of luxury, comfort, and natural beauty, this riverfront home is truly a must-see retreat that promises a lifestyle of serenity and sophistication.
MlsNumber: 1524774


Listing Provided By: Real Broker, LLC, original listing
Name: Real Broker, LLC
Phone: (704) 454-8820
Office Name: Real Broker, LLC
Office Phone: (855) 450-0492
Agent Name: Richard Long
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.


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