4940 Lambs Road RoadNorth Charleston, SC 29418
Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.




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!
yesterday | Listing updated with changes from the MLS® | |
yesterday | Price changed to $1,599,000 | |
2 months ago | Listing first seen on site |

Listing information is provided by Participants of the CHS Regional MLS. IDX information is provided exclusively for 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 is deemed reliable but not guaranteed. Copyright 2025, CHS Regional MLS.
Last checked: 2025-04-04 09:03 PM UTC
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.