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

1084 Rivershore Rd
Charleston, SC 29492

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: 4
Baths: 4
Status: Active
SqFt: --
Agency: Realty One Group Coastal

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: Historic Charleston with a Mid Century Modern vibe! If you are looking for a completely updated custom built home in the middle of the Charleston area you found it! There are too many upgrades to mention here. Ask your Realtor for the complete 8 page list. This home is elevated construction with garages, workshop and mother in-law suite underneath. On the first floor you will find 3 bedrooms, including the Master Bedroom, 2 full baths, gathering room with wet bar, laundry room and office space. The gathering room and first bedroom open to a large 10x25 porch with new Trex decking. The Master Bedroom has a cozy 10x10 porch with Custom Bahama Shutters. The Master Bedroom, Hallway and Gathering Room have a newly refinished gorgeous Massaranduba Brazilian Redwood floorinMoving upstairs there is a beautiful new staircase with Cable Railing and Oak Treads. You will love the contrast of the dark wood floors and the light oak stair treads. When you reach the top of the stairs you will be amazed at the completely open floor plan with a completely renovated Gourmet Kitchen with beautiful Doha White Marble Counter Tops and Island Top. The cabinets are solid cherry wood doors painted that stretch all the way to the ceiling and are lighted. The backsplash is also marble. The entire upstairs except the Guest Bath has newly refinished Massaranduba Brazilian Redwood flooring. Also on this floor is a Game Area with a fantastic pool table with new black felt and new bumpers. The family room boast a newly designed fireplace with a single slab Marble face, shiplap, custom cabinets with marble counter tops and a custom mantle and shelves. The family room opens to a large 10x25 porch with incredible views of the rising sun in the morning. If you are concerned about the kitchen being on the top floor, relax, you have an elevator that accommodates all floors. Want to add a pool? The backyard is very spacious and will easily accommodate a nice size pool with plenty of room to spare. There is a very peaceful pond with lots of wildlife in the back as well. Let's talk about the location. This home sits in the middle of everything. You are 15 to 20 minutes to downtown Charleston, West Ashley, Mt Pleasant, Summerville, North Charleston, James Island, Isle of Palms. You are also about 15 minutes to the Charleston International Airport. There is a light planned to be installed at the Clements Ferry Rd intersection and a new fire station. The neighborhood has an Olympic Size Pool, Kids Play Park, Community Dock, Clubhouse, Tennis Courts, Pickle Ball Court and Basketball Court. This is truly a fantastic place to call home.
MlsNumber: 24008461


Listing Provided By: Realty One Group Coastal, original listing
Name: Realty One Group Coastal
Phone: (843) 557-5748
Office Name: Realty One Group Coastal
Office Phone: (843) 557-5748
Agent Name: Mia Owens
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.


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 = 2321 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;
Angie Gooden
ASCIICarolina One Real Estate - The Palmetto Elite Group
Call Today!: (843) 576-9551

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App