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

2255 Mariners Ferry
Charleston, SC 29414

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $634,000
Beds: 4
Baths: 3
Status: Active
SqFt: --
Agency: AgentOwned Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1990
Notes: Welcome to your LAKEFRONT paradise in Forest Lakes Extension of West Ashley, complete with no HOA fees! The seller is offering $12,750 in incentives to be used to buy down the rate, reduce the price and/or help with closing cost with the use of preferred lender. This exquisite 2-story home features 4 bedrooms and 3 full bathrooms, offering an ideal combination of space, elegance, and contemporary living. Witness the beauty of a comprehensive renovation that has elevated this home to new levels of luxury. Upon entering, you'll be greeted by a seamlessly connected open floor plan on the first floor, linking the kitchen and dining area, providing stunning views of the lake. The kitchen boasts organic wood cabinets that harmonize perfectly with the tranquil backyard, adorned withmajestic live oaks and draped in Spanish moss. Step out onto the delightful deck off the kitchen, where you can bask in the mesmerizing lake vistas. The first-floor bedroom with a fireplace and full bathroom adds to the allure of this magnificent residence. The spacious family room, also with a fireplace, ensures cozy evenings and cherished family moments. Enjoy the convenience of all-new features including a roof, garage door, windows, HVAC system, and luxury vinyl plank flooring on the first floor, along with new carpeting throughout the second floor. The expansive master suite is a sanctuary in itself, featuring a beautifully tiled bathroom with a large walk-in shower, dual closets, and dual vanities, offering ample storage and comfort. Two additional bedrooms share a hall bathroom on the second floor. Nestled amidst nature, this picturesque lakefront property invites adventure enthusiasts to explore its inviting waters right from the backyard. Imagine the serenity of paddling through the calm waters on a kayak or paddleboard, surrounded by the breathtaking beauty of the landscape. The backyard oasis provides a perfect retreat to unwind and escape from the stresses of everyday life. Nearby West Ashley Park enhances the appeal with recreational activities such as baseball, basketball, football, and a playground, as well as access to the lake's pristine island for enchanting hiking experiences. Conveniently located with easy access to shopping, dining, and the highway, this meticulously renovated and thoughtfully designed home is a true gem in Forest Lakes Extension. Don't miss the opportunity to make it yours and experience the epitome of lakefront living.
MlsNumber: 24004058


Listing Provided By: AgentOwned Realty, original listing
Name: AgentOwned Realty
Phone: (843) 769-5100
Office Name: AgentOwned Realty Charleston Group
Office Phone: (843) 769-5100
Agent Name: Irina Bordyn
Disclaimer: Copyright © 2024 Charleston Trident 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App