4940 Lambs Road Road
North Charleston, SC 29418
- 6 beds
- 3.5 baths
- 4,346 sqft
- ~1/2 acre lot
- $321 per sqft
- 1964 build
- – on site
New Listing and New Price 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 in 2015 including plumbing 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!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated May 4, 2025
•
MLS# 25012315 —
The Building
-
Year Built:1964
-
New Construction:false
-
Architectural Style:Traditional
-
Roof:Architectural
-
Foundation Details:Basement
-
Levels:Two
-
Exterior Features:Dock - Existing
-
Window Features:Thermal Windows/Doors
-
Construction Materials:Brick Veneer
-
Patio And Porch Features:Deck
-
Building Area Total:4346
-
Building Area Units:Square Feet
Interior
-
Stories:2
-
Interior Features:Ceiling - Smooth
-
Flooring:Ceramic Tile
-
Fireplace:true
-
Fireplaces Total:1
-
Fireplace Features:Gas Log
-
Laundry Features:Electric Dryer Hookup
Financial & Terms
-
Listing Terms:Cash
Location
-
Directions:Dorchester Road To Lambs Rd, House Is On The Right
-
Latitude:32.882475
-
Longitude:-80.076661
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Detached
-
Property Attached:false
-
Other Structures:No
-
Lot Size Acres:0.51
-
Lot Size Area:0.51
-
Lot Size SqFt:22215.6
-
Lot Size Units:Acres
-
Fencing:Fence - Metal Enclosed
-
Waterfront:true
-
Waterfront Features:River Access
Listing Agent
- Contact info:
- No listing contact info available
Beds
-
Bedrooms Total:6
-
Master Bedroom Level:Lower
-
Master Bedroom Features:Ceiling Fan(s), Outside Access, Walk-In Closet(s)
Baths
-
Full Baths:3
-
Half Baths:1
Heating & Cooling
-
Cooling:true
-
Cooling:Central Air
-
Heating:Electric
-
Heating:true
Utilities
-
Utilities:Charleston Water Service
-
Sewer:Public Sewer
-
Water Source:Public
Schools
-
Community Features:Trash
-
Elementary School:Hunley Park Elementary School
-
Middle Or Junior School:Zucker
-
High School:Stall
The Community
-
Subdivision Name:Lambs
Parking
-
Garage:false
-
Carport:false
-
Parking Features:Off Street
Any use of search facilities of CTMLS data on this site, other than by a consumer looking to purchase real estate, is prohibited. Properties provided courtesy of the Charleston Trident 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. Data deemed reliable but not guaranteed accurate by the MLS.
Monthly cost estimate

Asking price
$1,399,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$7,491
|
Taxes | N/A |
Insurance | $384 |
Utilities | $298 See report |
Total | $8,173/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
5/3/25
May 3, 2025
|
Listed / Active | CTAR | $1,399,000 | |
4/3/25
Apr 3, 2025
|
Price Changed | CTAR | ||
2/1/25
Feb 1, 2025
|
Listed / Active | CTAR |