This site refreshes every 15 minutes, so the listings are always live, fresh, and current from all SC major market MLS boards with the newest properties
$1,599,000

Status: For Sale

Price Drop (-5.89%)
Waterfront
Property type: Detached House
Year built: 1964
List Date: 2025-02-01
Lot Size: 0.5100 acres
Area
4346 ft2
Bedrooms
5
Half Baths
1
Full Baths
3
Days For Sale
74

Amenities

  • .5 - 1 Acre
  • Architectural
  • Bonus
  • Ceiling - Smooth
  • Ceiling Fan(s)
  • Central Air
  • Ceramic Tile
  • Charleston Water Service
  • Dock - Existing
  • Dock - Floating
  • Dominion Energy
  • Eat-in Kitchen
  • Electric Dryer Hookup
  • Entrance Foyer
  • Family
  • Forced Air
  • Formal Living
  • Game
  • Gas Log
  • High Ceilings
  • In-Law Floorplan
  • Living Room
  • Living/Dining Combo
  • Marshfront
  • Media
  • Natural Gas
  • One
  • Outside Access
  • River Access
  • River Front
  • Seawall
  • Separate Dining
  • Thermal Windows/Doors
  • Traditional
  • Trash
  • Walk-In Closet(s)
  • Walk-In Closet(s)
  • Washer Hookup
  • Waterfront - Deep
  • Wood

Description

Over $100,000 below recently appraised value! Deep Water with 5-6 bedrooms, 3 full baths and 1 half bath, including ADU! Welcome to this rare opportunity to own a gorgeous deep water generational home overlooking the Ashley River and across from beautiful and pristine Magnolia Plantation! Take in the beautiful sunsets each day or take the boat out from your own private dock. With a separate full apartment/ mother in law suite overlooking the Ashley River boasting a family room, full kitchen, master bedroom and bath, the possibilities are endless. This apartment can function as living quarters for another family member or can also be rented as an ADU. With the ADU included, the total square footage of this property is 4,346 Square feet!The house was completely remodeled in 2015 includingplumbing and electrical, roof windows,decking, siding, Rhino Shield exterior coating and so much more, this home turnkey. As one enters, the quality of this home is self-evident. A large living room is the perfect welcome and is graced with wood flooring and recessed lighting as well as a large custom brick fireplace with mantle. The eat-in kitchen boasts granite countertops and stunning beadboard ceiling with custom trim work and crown molding. The large and private family room is situated on the back of the home encompassing all of the beauty the Ashley River has to offer. The private owner's retreat has beautiful views of the Ashley River. The master bath is very well-appointed with custom shaker style cabinetry with granite countertops, tile flooring and a large walk-in tiled shower. Two guest bedrooms are on the main level as well which share a hall bath. Upstairs, one will find a large room overlooking the Ashley River currently used as an art studio. Across the hall is the fourth guest bedroom.Underneath the first level is the full apartment/mother in law suite with a full eat-in kitchen with granite countertops, stainless appliances and custom range hood. This space also boasts its own family room, private bedroom and gorgeous bath graced with tile flooring and a beautiful very large tiled shower.There is plenty of room in the backyard for a pool or courtyard. This home comes complete with a full home generator! New Roof installed in 2020. A private, deep water dock with floater provides boat access to the Ashley River, Charleston Harbor, the beaches and more!

What's YOUR Home Worth?

Price Change History

  1. $1,699,000 $391/SqFt

  2. $1,599,000 $368/SqFt

Schools

6-12 SPED Schools in 29418

Name
Address
Phone
Type
Grade
7499 Dorchester Road
8433004118
Public
6-12 SPED

6-8 SPED Schools in 29418

Name
Address
Phone
Type
Grade
6401 Dorchester Road
8437678383
Public
6-8 SPED

9-12 SPED Schools in 29418

Name
Address
Phone
Type
Grade
3625 Ashley Phosphate Road
8437642200
Public
9-12 SPED

PK-5 SPED Schools in 29418

Name
Address
Phone
Type
Grade
6800 Dorchester Road
8437675900
Public
PK-5 SPED
5501 Dorchester Road
8437675911
Public
PK-5 SPED

Show on the map:
Road Map
Fly by view
Street view

James Schiller

Realtor, Brand Name Real Estate

Happy Clients

SEE THIS PROPERTY



    ©2025CTMLS,GGMLS,CCMLS& CMLS

    The information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS boards of the SC Realtors.

    Listing Provided by Carolina One Real Estate

    4940 Lambs Road Road, North Charleston, SC 29418
    MLS #29418
    $1,599,000
    SHARE

    SC mortgage interest rates live. View the latest and most current home loan mortgage interest rates in South Carolina.