New Listing and New Price well 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 i 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!
Active
Price cut: $200K (5/3)
$1,399,000
4940 Lambs Rd, North Charleston, SC 29418
6beds
4,346sqft
Est.:
Single Family Residence
Built in 1964
0.51 Acres Lot
$1,334,700 Zestimate®
$322/sqft
$-- HOA
What's special
Custom brick fireplacePrivate dockPrivate family roomEat-in kitchenStainless appliancesCustom shaker style cabinetryCustom range hood
- 20 days
- on Zillow |
- 897 |
- 53 |
Zillow last checked: 7 hours ago
Listing updated: May 20, 2025 at 02:37pm
Listed by:
Carolina One Real Estate 843-779-8660
Source: CTMLS,MLS#: 25012315

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Rooms
- Room types: Bonus Room, Family Room, Game Room, Media Room, Office
Heating
- Electric, Heat Pump
Cooling
- Central Air
Appliances
- Laundry: Electric Dryer Hookup, Washer Hookup
Features
- Ceiling - Smooth, High Ceilings, Walk-In Closet(s), Ceiling Fan(s), Eat-in Kitchen, In-Law Floorplan
- Flooring: Ceramic Tile, Wood
- Windows: Thermal Windows/Doors
- Has basement: Yes
- Number of fireplaces: 1
- Fireplace features: Gas Log, Living Room, One
Interior area
- Total structure area: 4,346
- Total interior livable area: 4,346 sqft
Property
Parking
- Parking features: Off Street
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Front Porch, Porch
- Exterior features: Dock, Stoop
- Fencing: Perimeter
- Waterfront features: River Access, River Front, Waterfront, Seawall
Lot
- Size: 0.51 Acres
Details
- Parcel number: 4060100004
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Brick Veneer, Cement Siding
- Foundation: Crawl Space
- Roof: Architectural
Condition
- New construction: No
- Year built: 1964
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Charleston Water Service, Dominion Energy
Community & HOA
Community
- Features: Trash
- Subdivision: Lambs
Location
- Region: North Charleston
Financial & listing details
- Price per square foot: $322/sqft
- Tax assessed value: $441,100
- Annual tax amount: $1,745
- Date on market: 5/3/2025
- Listing terms: Cash,Conventional
- Loading
- Loading