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

320 Adams Lane
Gilbert, SC 29054
Hope Derrick with Keller Williams Realty, original listing - (803) 772-5858

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $980,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1328 Square Feet
Agency: Keller Williams Realty
Agency Phone: (803) 772-5858

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: THERE IS SO MUCH TO SAY AND NOT SO MUCH ROOM. PLEASE SEE THE FULL PROPERTY IN THE DOCUMENTS SECTION!<br /> Come home to beautiful views with stunning sunsets over the lake, mature shady trees & the fragrance of gorgeous gardenia blooms that surround you in your fully-fenced horse Estate at Driftwood Point. The Estate at Driftwood Point includes a nicely upgraded 3 bed/2 bath chic farmhouse with screened porch, 5.88 acres - fenced & cross-fenced, 5,000 sq. ft. barn, full size lighted riding arena with viewing gazebo, lighted round pen, 5 pastures with mature shade trees, 5 paddock areas, secure equipment and hay storage, extra-large garage/shop with apartment - 2 bed w/loft/1 bath with large covered porch. Split-level entertainment deck with gazebo & wood-burning stone fireplace with big screen TV above fireplace. and NO HOA!! The automated entry gate opens to your slice of paradise & ensures that, rain or shine, you can stay in your vehicle until you arrive at the front door. The main house boasts an open floor plan, energy efficient windows with newer honeycomb blinds that open top and bottom, kitchen center island with storage, stainless steel sink with a high-arc pull down faucet, granite countertops throughout, tile backsplash, updated cabinets/hardware/under cabinet lighting. <br /> The cozy family room stays toasty warm in the winters with the custom-built stone-tile propane fireplace with a big screen TV area above. The living room picture window looks out over the marina cove & onto the screened porch with outdoor ceiling fans, lighting and TV. In the summertime, the house stays extra cool with lighted remote ceiling fans in every room (even the bathrooms!) and a new 5-ton air conditioning/heating unit. The reclaimed wood-plank style porcelain tile floors are cool in the summer and super easy to keep clean even when your furry friends use the large size doggy door to hang out with you indoors. There is a safe yard for the pups when you are away with doggy door access. The primary bath was recently remodeled with a new shower enclosure, soft close vanity with granite countertop, new sink and upgraded faucet, new tall height toilet, mirrored deep vanity cabinet, LVP flooring, lighted ceiling fan with Bluetooth (to play your favorite songs while you get ready for your adventures of the day), designer mirror and lighting. Primary and 2nd bedrooms have mirrored closet doors and lighted remote ceiling fans. The 3rd bedroom has a good-sized walk-in closet and a lighted remote ceiling fan. All closets and the laundry room have professional closet organizers and shelving and large ''skylight'' lighting for easy viewing. All bedrooms have upgraded carpet and pad. Both bathrooms have barn door privacy doors that add to the comfortable farmhouse feel. Revel at the ease of doing your laundry with the all-in-one LG Heavy duty, large capacity washer/dryer - YES - the washer and dryer is all in one unit and can be programmed from start to finish! It will ping your phone to let you know your laundry is ready for you to fold - no wrinkles! <br /> The 2 bedroom, 1 bath apartment has a lighted loft with a custom-made ladder for an extra sleeping area or storage. The bedroom has upgraded carpet and pad and mirrored closet doors. There is a dedicated bedroom window air/heat unit and a lighted ceiling fan. The second bedroom (or tack room) has direct access to the shop and barn and has upgraded waterproof LVP flooring. This room can be used as a bedroom or as an a/c-controlled tack room. <br /> The approximately 5,000 sq ft. barn has 20 stalls that are currently configured to have (12) 10' x 12' stalls and (4) 10' x 20' stalls. The 15'-6''' wide lighted barn aisle and the stalls have ¾'' thick Great Mats - interlocking rubber mats to aid in sanitation and cushion/comfort for the horses and high-powered fans to keep them cool while they enjoy their extraordinary barn. <br /> PLEASE SEE THE DOCUMENTS SECTION FOR A FULL WRITE UP!
MlsNumber: --
ListingId: 214287


Listing Provided By: Keller Williams Realty, original listing
Phone: (803) 606-6699
Office Phone: (803) 772-5858
Agent Name: Hope Derrick
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 = 2346 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;
Cicely Walker
ASCIIColdwell Banker Realty
Call Today!: (803) 354-2051

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App