Pin It
457 Lesesne Street, Charleston, SC 29492 | MLS ID 26007659 - Hardcastle Realty
Columbiana County OH homes for sale
Salem OH homes for sale
Property Search | Agents & Offices | Info for Buyers | Info for Sellers | Community Information | Contact Us | Home New Waterford OH homes for sale
Property Search Compliments of
Hardcastle Realty


Get Printable Flyer

Ask Realtor Questions




$4,975,000

< Find More Homes in this Area >



The Unicorn. Enjoy sunset views for miles across the marsh in this re-imagined and fully renovated elevated coastal masterpiece set on a large lot in the prestigious, sought after Ralston Grove section of Daniel Island Park. Slip through the wide foyer and high ceilings to get immediately drawn through to the expansive decks of Nano doors. Enjoy light bright open concept living, over-sized first floor master, gourmet scullery, bar and designer on- trend color drenched office/lounge. This exceptional home has 3 en suite bedrooms on the second level with new baths, extraordinary media room/entertainment space and upper porch. Enjoy 2 laundry spaces, elevator and huge 3 car garage with bonus temperature controlled space.Storage is not an after-thought with ample closets and space. Sample Pool plan included in pictures. This one will not last, do not miss this opportunity to enjoy a slice of paradise on Daniel Island. A limited golf membership is available for purchase. For all club membership questions, contact the Daniel Island Club. Listing agent believes all information in the MLS to be correct, however buyer should verify all information important to them. If square footage is important, MEASURE! all information including, but not limited to HOA info, acreage, taxes, flood zone info a schools is soley subject to independent verification. Buyer pays a one-time neighborhood enchancement fee of .5% x sales price to Daniel Island Community Fund at closing.

Information
Address:
 <map>
457 Lesesne Street
Charleston, SC 29492
Bedrooms:  4
Bathrooms:  4 full 1 partial
Square Feet:  4651
Type:  Traditional
Subdivision:  Daniel Island Park
MLS ID:  26007659
Status:  Active



77 total images
click here to view




Features
Garage: 3 car attached
Roof Type: Metal
Exterior: Cement Siding
Lot Size: 0.41 Acres
Lot Dimensions: 0.41 acre(s)
Heating: Heat Pump
Cooling: Central Air
Year Built: 2018
Fireplaces: 1
Water: Public
Sewer: Public Sewer
Stories: 3.0
Building Area Total: 4651
Community Features: Boat Ramp,Clubhouse,Club Membership Available,Fitness Center,Golf Course,Park,Pool,Tennis Court(s),Trash,Walk/Jog Trails
Elevator: Y
Exterior Features: Lawn Irrigation
Fireplace Features: Gas Log,Great Room,One
Fireplace Y/N: Yes
Flooring: Carpet,Ceramic Tile,Wood
GarageY/N: Yes
HeatingY/N: 1
Interior Features: Beamed Ceilings,Ceiling - Cathedral/Vaulted,Ceiling - Smooth,High Ceilings,Elevator,Kitchen Island,Walk-In Closet(s),Wet Bar,Wine Cellar,Bonus,Eat-in Kitchen,Entrance Foyer,Great,Loft,Office,Pantry,Separate Dining,Utility
Laundry: Electric Dryer Hookup,Washer Hookup
Lot Features: 0 - .5 Acre,Marshview
Other Structures: No
Parking Features: 3 Car Garage,Attached
Patio And Porch: Deck,Front Porch
Utilities: Charleston Water Service,Dominion Energy
Waterfront Features: Marshfront


School Information
High School: Philip Simmons
Middle School: Daniel Island
Elementary School: Daniel Island


Mortgage Information


Home Price:
Down Payment: , or
%
Loan Term: months, or
years.
Interest Rate: %
Estimated Monthly Payment (prin & int):

Agency/Agent Information
Shown By:
  Agency Name: Hardcastle Realty
  Agency Phone:

Listed By
   Carolina One Real Estate

IDX logo
Leetonia OH real estate for sale
LIsbon OH homes for sale Quick Home Search mls # address zip code
Calcutta OH real estate for sale
my portfolio  No username/email found for this public user email password
Ohio homes and real estate for sale
DeltaNet Login

Ohio cities with listings for sale | Ohio counties with listings for sale
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 06/03/2026. The listing information on this page last changed on 06/03/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Wed 06/03/2026 1:10:26 PM EST) or MLS NOW (last updated Wed 06/03/2026 1:07:57 PM EST). Real estate listings held by brokerage firms other than Hardcastle Realty may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility

Agency License Information: This Brokerage is licensed in the State of Ohio.