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

202 Fairway Drive
New Ellenton, SC 29809

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $227,000
Beds: 6
Baths: 3
Status: Active
SqFt: 2080
Agency: Starnes Realty International Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1962
Notes: Welcome to your future home at 202 Fairway Dr, New Ellenton. This beautiful brick property, nestled on the picturesque New Ellenton Golf Course with views of the #1 hole truly serves as a tranquil retreat and a perfect space for both relaxation and entertainment. With an impressive 2,006 sqft of interior space, this home boasts 6 bedrooms and 3 bathrooms, accommodating a range of needs, whether for a growing family, room for guests, or designated office space for remote working professionals.<br /> <br /> The house is designed with an partial open concept in mind, featuring real hardwood flooring and LVP flooring that flows perfectly throughout the home, Your spacious kitchen flows seamlessly into the formal living room, making it ideal for gatherings.The formal dining room adds an elegant touch to your dinner parties and family meals. The expansive owner's suite comes equipped with its own private bath. Further peace of mind knowing your roof was installed in 2015, HVAC installed in 2022 and your water heater installed in 2024!<br /> <br /> Step outside to discover the outdoor space that truly sets this property apart. The large fenced backyard is a versatile area ready for your landscaping dreams or a secure play space for pets and children. Enjoy South Carolina's beautiful weather on the covered back porch or the adjoining deck, ideal for BBQs or a quiet morning coffee. The fire pit area provides a cozy gathering spot for chilly evenings.<br /> <br /> Not to be overlooked, the property includes a huge workshop with upstairs storage, a dream for hobbyists, or those in need of ample storage space.<br /> <br /> Conveniently located, this home is within easy reach of essential community features. Greendale Elementary School and Silver Bluff High School are just a short drive away, ensuring your educational needs are well catered for. Plus, being close to town provides great professional opportunities as well as dining and shopping. <br /> <br /> 202 Fairway Dr is more than just a house; it's a place to call home. Don't miss out on owning this impeccable property where comfort meets convenience in a warm community setting.
MlsNumber: 211244


Listing Provided By: Starnes Realty International Inc, original listing
Name: Starnes Realty International Inc
Phone: (706) 526-3030
Office Name: SRI Properties, INC
Office Phone: (803) 335-4667
Agent Name: Garrett Starnes
Disclaimer: Copyright © 2024 Aiken MLS. 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 = 2315 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;
Jordan Stella
ASCIIRE/MAX True Advantage
Call Today!: (706) 799-1149

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App