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','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 = 2321 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 = 2321 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;

413 Spartina Lane
Charleston, SC 29492
Andrea Rogers with AgentOwned Realty Preferred Group, original listing - (843) 884-7300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,600,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: AgentOwned Realty Preferred Group
Agency Phone: (843) 884-7300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Attached
Year Built: 2021
Notes: This stunning, corner unit, 3 bedroom, 3.5 bath townhome is located in the heart of Daniel Island's waterfront district, within walking distance of restaurants, shops, offices, and Waterfront Park. Built in 2021, the unit has been used as a second home and is in ''like new'' condition. The owners had the original custom interior professionally redesigned with classic contemporary, elegant finishes. Enter the first level of the home into the foyer. To the left you'll find a flex room that can be used as office space, a den, or a rec room. Continue straight to access the stairs or elevator. Up one floor you'll find the open-concept kitchen/living/dining areas. Large windows, here and throughout, provide an abundance of natural light and views of the beautiful community courtyard and pool.The kitchen features stone countertops; white textured tile backsplash; 4-seat breakfast bar; BlueStar gas range; and white modern cabinetry with built-in appliances that include refrigerator/freezer, wine cooler, dishwasher, and drawer microwave. The primary suite, laundry room, and a guest powder room are also on the 2nd level of the home. The third level features two bedrooms -- each with an en suite bath -- as well as a den/flex room with a large wall of windows and a terrace, both overlooking the courtyard and pool and views of Daniel Island beyond. The fourth level is a rooftop terrace that runs the entire depth of the building and overlooks Daniel Island with glimpses of the Wando River. Home is on whole-home wireless smart lighting system by Lutron. Items that were added or replaced at the finishing stage of construction or post-construction include the following: Hardwood flooring throughout; 3-stop elevator; Custom modern handrails and glass panels in stairwells that allow for views; Designer lighting and fans and upgraded switches -- all compatible with and established on Lutron remote control smart home system; Nest thermostats; Upgraded plumbing fixtures; Emtek crystal doorknobs with black back plates and hinges; Custom-designed and built kitchen cabinetry and upgraded kitchen hardware, countertops, backsplash, dishwasher, and range; Built-in ice maker in kitchen island; Upgraded towel bars, robe hooks, and mirrors in all bathrooms; Designer tile accent wall in powder room; Custom frameless glass doors/walls in all full baths; Redesigned and rebuilt primary suite closet and hall closet shelving systems; Custom closets for other two bedrooms; Motorized shades in primary bedroom; Designer wallpaper; Custom-designed and built cabinets and shelves and custom countertops in laundry room; Ring cameras.<br /> <br /> HOA fees cover everything except electricity and H-6 insurance (contents). Opportunity to purchase the home furnished, subject to certain exclusions.
MlsNumber: --
ListingId: 25000152


Listing Provided By: AgentOwned Realty Preferred Group, original listing
Phone: (843) 884-7300
Office Phone: (843) 884-7300
Agent Name: Andrea Rogers
Disclaimer: Copyright © 2025 CHS Regional 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 = 2321 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 Joseph Goodale
Joseph Goodale
UTF-8Matt O’Neill Real Estate
Call Today!: (843) 725-9791

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App