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

226 Lakeside Farms Drive
Duncan, SC 29334
Amy Snow with Keller Williams Grv Upst, original listing - (864) 234-7500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,650,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: --
Agency: Keller Williams Grv Upst
Agency Phone: (864) 234-7500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Welcome Home to Your CUSTOM-BUILT Modern Farmhouse with SEPARATE ADU (Accessory Dwelling Unit)! As you approach the curved cement driveway, flanked by lush landscaping, you are welcomed into this AWARD-WINNING property by Avery Construction, celebrating their 14th accolade from the Home Builders Association of South Carolina. This estate exemplifies luxury and functionality, offering a total of 6 GARAGE spaces—3 attached and 3 detached—perfect for car enthusiasts or those interested in rental or Airbnb opportunities, with the detached garage featuring a separate entrance leading to the ADU above. Upon entering through the 8- foot double MAHOGANY and wrought iron front doors, you’re greeted by a breathtaking 2-story foyer showcasing hand-scraped random width wood flooring. The main level includes 3 spacious bedrooms, EACH WITH EN-SUITE BATH, an additional half bath, a doggy room with a custom barn door, a separate office with ANTIQUE DOORS, an oversized dining room, and great room complete with a floor-to-ceiling stone gas log fireplace and LIVE-EDGE MANTEL. The kitchen is a chef's dream, equipped with CUSTOM CABINETRY featuring under-cabinet and in-cabinet lighting, along with KitchenAid Professional Series appliances, including built-in double ovens, a 36" gas cooktop, under-counter ice maker, dishwasher, and refrigerator. A stunning 9-FOOT ISLAND with LEATHERED GRANITE countertops provides additional cabinetry on the backside, creating a perfect spot for friends and family to gather while you prepare meals. Adjacent to the kitchen, you’ll find a wet bar in the butler's pantry and an oversized walk-in pantry with extra cabinetry and countertops for your small appliances. With 9–12 foot ceilings and custom designs and lighting in the living room and primary bedroom, the home feels bright and spacious. The primary bathroom features his and her sinks with thoughtful custom cabinetry, along with pull-out cabinets including outlets for your hair accessories. The highlight is the LUXURIOUS WET ROOM, adorned with marble flooring, a clawfoot soaking tub, double shower heads with handhelds, and lower back jets to help you unwind after a long day. From the primary bath, you can access a generous walk-in closet that leads directly to the laundry room for added convenience. UPSTAIRS, you’ll discover an additional bedroom, bathroom, and a versatile secondary living area that can serve as a bonus room, media room, theater, or guest quarters. This home also includes central vacuum and full irrigation systems. Outdoor living spaces feature a spacious front porch perfect for enjoying stunning sunset views, complemented by the tranquil sounds of a WATER FEATURE. The back screened porch offers serene nature views and overlooks the impressive 28,000-gallon SALTWATER INGROUND POOL with a sundeck, equipped with a programmable PentAir system, 2 customizable deck jets, and programmable LED lighting. Separated from the main house, the detached 3-car garage includes a heated/cooled outdoor bathroom, while the ADU above provides a bedroom, full bathroom, laundry room, walk-in pantry, kitchen with island (including a refrigerator, free-standing range, dishwasher, and disposal), and living room. This property beautifully combines upscale finishes, modern functionality, and ample space, making it ideal for family living and entertaining. With its luxurious amenities and award-winning craftsmanship, this home is sure to impress. Plus, you are within 10 minutes of GSP airport and 20 minutes from either downtown Greenville or Spartanburg! Schedule your appointment soon—this home won’t last long! **Agent Owned Property**
MlsNumber: --
ListingId: 1532051


Listing Provided By: Keller Williams Grv Upst, original listing
Phone: (864) 234-7500
Office Phone: (864) 234-7500
Agent Name: Amy Snow
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 = 2356 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 Anne (Annie) Nash
Anne (Annie) Nash
ASCIIeXp Realty
Call Today!: (803) 563-1056

Local Mortgage Pro

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 = 2356 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;
Real Estate Expert Photo for Shannon Humphries NMLS# 180810
Shannon Humphries NMLS# 180810
ASCIIHomebridge Financial Services
Call Today!: (864) 915-7777

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App