1 / 48
MLS ID: 25002608
For Sale - $1,699,000

About this property

Bedrooms 5
Baths 3
Half Baths 1
sq2 4346
Lot Size 0.5100 acres
Year Built 1964
DOM 58

Address

Address:
4940 Lambs Road Road
Subdivision:
Lambs
Zip Code:
29418
County:
Charleston
State:
SC

Features and Amenities

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

Description

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 including plumbing and electrical, roof windows,decking, siding, Rhino Shield exterior coating and so much more, this home turnkey. An extensive list of renovations will gladly be provided upon request. As one enters, the quality of this home is self-evident. The beautiful engineered wood flooring combines with the gorgeous trimwork to make this home comfortable and inviting. 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 has been masterfully remodeled and boasts granite countertops and stunning beadboard ceiling with custom trim work and crown molding. Boasting a custom tile backsplash in addition to the shaker style cabinetry and stainless steel appliances, this wonderful kitchen is a must see. There is also a dining room area to the left of the entry foyer, allowing plenty of room for a dining table. The large and private family room is situated on the back of the home and is full of windows, encompassing all of the beauty the Ashley River has to offer. Graced with tile flooring and a beadboard ceiling, this gorgeous room is truly one of a kind. The sliding glass doors give way to an abundance of Trex decking with cable railings overlooking the river and Magnolia Plantation. The private owner's retreat is located on the back of the home and takes in all of the beautiful views of the Ashley River. Open the sliding glass doors leading to the back deck to bring in the river breezes. The master bath is very well-appointed with custom shaker style cabinetry with granite countertops, tile flooring and a large walk-in tiled shower. There are two guest bedrooms on the main level as well which share a hall bath graced with a tub with tile surround and vanity with undermount sink. Upstairs, one will find a large room overlooking the Ashley River currently used as an art studio. This room would also function well as a media room or 5th bedroom. Across the hall is the fourth guest bedroom boasting wood engineered flooring. Both upstairs have access to a half bath which can easily be converted into a full bath due to an open area behind the wall. Underneath the first level and adjacent to the basement is the full apartment/mother in law suite, adding another 880 square feet! This amazing space boasts 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 with half inch thick glass and a custom sliding door. The decking across the back of the home is the perfect place to entertain or to unwind at the end of the day watching the beautiful sunsets. 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! This gorgeous property offers the perfect opportunity to own a well cared-for home in a stunning location with deep water access!

Schools

Name Address Phone Type Grade
Jerry Zucker Middle School of Science 6401 Dorchester Road 8437678383 Public 6-8 SPED
Name Address Phone Type Grade
Lambs Elementary 6800 Dorchester Road 8437675900 Public PK-5 SPED
W. B. Goodwin Elementary 5501 Dorchester Road 8437675911 Public PK-5 SPED
Name Address Phone Type Grade
Palmetto Scholars Academy 7499 Dorchester Road 8433004118 Public 6-12 SPED
Name Address Phone Type Grade
R. B. Stall High 3625 Ashley Phosphate Road 8437642200 Public 9-12 SPED
subdivision
Active Listings
Avg DoM
Avg Price
accabee, North Charleston
3
148
$320,100
aichele terrace, North Charleston
1
87
$334,950
appian landing, North Charleston
2
186
$377,500
appian place, North Charleston
1
31
$375,000
archdale, North Charleston
11
101
$434,155
ashley heights, North Charleston
1
100
$202,750
ashley river commons, North Charleston
3
100
$302,625
ashley villas, North Charleston
4
96
$273,980
baker plantation, North Charleston
1
222
$367,929
baker townhouses, North Charleston
1
89
$359,950
bon aire, North Charleston
1
241
$289,900
brentwood, North Charleston
3
159
$248,457
brookdale, North Charleston
5
57
$347,567
buck run at deer park, North Charleston
1
31
$385,000
buckfield, North Charleston
2
126
$192,250
cameron terrace, North Charleston
1
93
$602,450
cedar grove, North Charleston
6
101
$534,327
charleston farms, North Charleston
11
110
$341,704
charleston park, North Charleston
6
132
$321,754
cherokee place, North Charleston
2
99
$525,800
chicora place, North Charleston
9
134
$371,975
college heights, North Charleston
1
308
$245,000
collins park villas, North Charleston
1
234
$232,500
colony north, North Charleston
7
71
$342,429
colony north ii, North Charleston
1
151
$348,333
coosaw commons, North Charleston
10
131
$271,987
14
111
$898,392
courtland square, North Charleston
1
135
$150,000
crescent view, North Charleston
2
66
$1,030,000
crossgate, North Charleston
3
191
$225,967
deer park, North Charleston
5
255
$331,923
dorchester manor, North Charleston
3
101
$341,125
dorchester terrace, North Charleston
29
105
$271,292
elms of charleston, North Charleston
8
104
$331,800
evanston estates, North Charleston
6
64
$451,889
ferndale, North Charleston
4
396
$198,140
fetteressa, North Charleston
2
53
$1,649,500
fireside, North Charleston
3
91
$205,800
forest hills, North Charleston
7
140
$282,508
glyn terrace, North Charleston
5
119
$282,750
green bay meadows, North Charleston
1
162
$337,666
happy hill, North Charleston
1
135
$330,000
horizon village, North Charleston
2
89
$401,483
howard heights, North Charleston
1
109
$289,999
hunley waters, North Charleston
1
117
$641,500
indigo fields, North Charleston
6
147
$453,723
indigo palms, North Charleston
4
98
$425,414
indigo place, North Charleston
2
79
$495,450
jericho on the ashley, North Charleston
1
79
$103,000
joppa way, North Charleston
1
86
$272,450
lake palmetto, North Charleston
5
58
$644,271
lakewood at the lakes, North Charleston
2
90
$321,000
lambs, North Charleston
2
104
$1,297,967
liberty hill, North Charleston
2
286
$404,980
liberty park, North Charleston
1
103
$308,250
magnolia pointe, North Charleston
6
184
$413,173
marsh hall, North Charleston
2
50
$428,300
midland park, North Charleston
5
198
$275,317
mixson, North Charleston
7
123
$496,713
morningside, North Charleston
2
33
$319,333
murray hill, North Charleston
1
36
$85,000
nafair, North Charleston
1
164
$212,500
north cameron terrace, North Charleston
1
72
$669,500
north charleston, North Charleston
18
92
$529,964
northpointe, North Charleston
2
38
$317,000
northwood estates, North Charleston
4
107
$315,363
northwoods estates, North Charleston
1
67
$327,450
northwoods pointe, North Charleston
2
43
$325,000
oak bluff, North Charleston
5
117
$236,252
oak grove, North Charleston
1
213
$247,167
oak leaf estates, North Charleston
1
229
$174,000
oak terrace preserve, North Charleston
3
119
$638,082
oakfield, North Charleston
1
23
$410,000
oakwood estates, North Charleston
1
131
$699,000
otranto club villas, North Charleston
3
198
$200,100
palmetto gardens, North Charleston
2
77
$471,625
park circle, North Charleston
34
135
$624,043
park circle station, North Charleston
1
155
$463,148
park hill place, North Charleston
4
28
$356,980
patriot park, North Charleston
10
60
$313,855
pepperdam offic park, North Charleston
1
163
$285,000
pepperhill, North Charleston
10
149
$287,384
pepperidge, North Charleston
2
67
$369,950
red oak, North Charleston
1
58
$350,000
regency square, North Charleston
1
10
$135,000
reverie on the ashley, North Charleston
1
180
$673,225
riverbend, North Charleston
1
138
$377,450
rivers bend, North Charleston
1
110
$199,900
runnymeade farm, North Charleston
1
13
$429,000
russelldale, North Charleston
1
107
$324,500
salamander creek, North Charleston
2
122
$310,300
shadow heights, North Charleston
1
21
$615,000
shahid row, North Charleston
1
161
$218,750
singing pines, North Charleston
2
15
$362,000
stratton capers, North Charleston
1
136
$148,300
6
154
$279,136
sunrise heights, North Charleston
1
131
$144,995
surprise, North Charleston
1
2
$220,000
taylor plantation, North Charleston
3
107
$450,650
the lakes, North Charleston
1
180
$258,500
2
117
$453,333
33
114
$280,179
4
98
$754,200
6
129
$182,329
union heights, North Charleston
16
157
$247,648
university park, North Charleston
9
132
$200,105
university place, North Charleston
1
161
$270,500
2
128
$341,200
vista park, North Charleston
3
170
$218,000
vistiana, North Charleston
1
37
$259,999
wando acres, North Charleston
1
4
$225,000
wando woods, North Charleston
4
151
$472,907
waylyn, North Charleston
23
138
$247,244
whipper barony, North Charleston
5
45
$337,557
whitehall, North Charleston
4
153
$435,010
2
84
$203,000
wildwood, North Charleston
1
136
$228,780
willow bend, North Charleston
2
135
$318,450
windsor crossing, North Charleston
5
265
$394,571
windsor hill, North Charleston
3
120
$296,563
windsor place, North Charleston
3
340
$150,000
woodhill place, North Charleston
4
75
$171,357
woodington, North Charleston
1
137
$359,600

Mortgage Calculator

$
$
%
%
Interest Rate as of: Mon, Mar. 31, 2025
$ 1,699,000 Home Price
$ 8,825 Monthly payment
$ 1,359,200 Amount Financed
$ 105,897 Annual cost of Loan
$ 3,176,922 Total of 360 Payments

Map

SEE THIS PROPERTY

James Schiller

James Schiller

Realtor, Brand Name Real Estate
Live Chat:
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Similar Listings

Previus
Next
©2025 CTMLS, 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.

Broker Logo Listing Provided by Carolina One Real Estate