#24031057, Listing Office: Maven Realty
4940 Lambs Rd North Charleston, SC 29418
Property details
About 4940 Lambs Rd
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!
Highlights
Summary
- MLS Number: 25002608
- Office Name: Carolina One Real Estate
- Office Phone: (843) 779-8660
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the CHS Multiple Listing Service. Those properties marked with the CHS MLS Approved logo are provided courtesy of the CHS MLS Broker Reciprocity Database. Information being provided is 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. The data deemed reliable but not guaranteed accurate by the MLS.
Copyright © 2025 Charleston Trident Association of REALTORS®
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 4/12/2025, 12:20:58 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹

$1,599,000
4940 Lambs Rd
$10,000
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
Date | Event | Price |
---|---|---|
Jun 24, 2015 | Home Sold | $294,900 |
Apr 06, 2006 | Home Sold | $570,000 |
May 31, 2001 | Home Sold | $312,000 |
Tax history
Year | Assessment | Property Tax |
---|---|---|
2023 | $11,570 | $1,712 |
History based on county public records data.
Nearby schools
5
Hunley Park Elementary School
Public District PK-5
0.7 mi
•1000 Michigan Ave
4
Lambs Elementary School
Public District PK-5
0.8 mi
•6800 Dorchester Rd
8
Drayton Hall Elementary School
Public District PK-5
2.0 mi
•3138 Ashley River Rd
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $57,359. Residents of North Charleston, SC typically earn between $35k-100k each year. Residents typically live in married, with kids family. Residents of this area typically have post secondary degree education.
Similar homes for sale
Frequently asked questions
About 4940 Lambs Rd
This home is located at 4940 Lambs Rd in North Charleston, SC and zip code 29418. This 4,346 square foot home, which was built in 1964, sits on a 0.51 acre lot. Features: 5 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since February 1, 2025 and is currently priced at $1,599,000.
Over 18 listings were sold over their listed price in March 2025 in North Charleston, SC. In the same period over 58 listings were sold below the listed price and 24 listings were sold for the listed price. The number of listings in North Charleston, SC increased by 22.6% between February and March 2025.