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

115 Old Camp Road
Elgin, SC 29045
Karen Yip with Yip Premier Real Estate LLC, original listing - (803) 388-8798

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,600,000
Beds: 6
Baths: Full: 5, ½: 2
Status: Active
SqFt: 5259 Square Feet
Agency: Yip Premier Real Estate LLC
Agency Phone: (803) 388-8798

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Introducing Fairway Oasis- a custom-crafted estate nestled in the prestigious gated community of Woodcreek Farms. Overlooking the #2 hole of the renowned Tom Fazio-designed golf course, this brick residence spans more than 5,200 square feet on 1.20 acres, blending timeless elegance with thoughtful functionality for those who value both luxury and comfort. Step through the grand entryway, and be captivated by the light-filled great room, where soaring ceilings and custom millwork create an inviting space that’s perfect for entertaining. Large windows frame stunning views of the sparkling saltwater pool and expansive, manicured grounds, providing a serene backdrop to everyday life. The chef’s kitchen is designed for both style and convenience, featuring high-end Thermador appliances, custom marble countertops, and an inviting gathering room with a bright eat-in area—ideal for casual mornings or hosting lively gatherings. The primary suite is a true retreat, with dual custom walk-in closets and a spacious layout that invites relaxation. Tray ceilings, elegant crown molding, and large windows infuse the room with natural light, while the spa-like ensuite features double vanities, a sleek dressing area, and high-end finishes throughout. The main level also includes a guest bedroom and an office that can double as a second guest room, providing flexibility for your needs. Upstairs, three additional guest bedrooms, each with ensuite baths and spacious closets, along with a cinema room and a gym/flex space, give you endless possibilities for relaxation and entertainment. Outside, enjoy resort-style living with a saltwater pool featuring a tanning ledge and a waterfall. The outdoor space extends to both covered and uncovered porches and a spacious patio, perfect for hosting or simply unwinding. The impeccably landscaped grounds enhance the tranquil setting, while the 3-car garage provides ample space for vehicles and storage. Fairway Oasis artfully combines luxury and comfort that’s also conveniently located near a variety of shopping and dining options, ensuring you have the best of both worlds right at your doorstep.
MlsNumber: --
ListingId: 595871


Listing Provided By: Yip Premier Real Estate LLC, original listing
Phone: (803) 546-2112
Office Phone: (803) 388-8798
Agent Name: Karen Yip
Disclaimer: Copyright © 2024 Consolidated MLS, SC. 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 = 2342 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 Karen Porter
Karen Porter
ASCIIKeller Williams Preferred
Call Today!: (803) 782-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App