Listing Details

Waterfront Luxury Meets Historic Charm! Nestled on a quiet stretch of the Ashley River, this home offers a rare opportunity to own a fully renovated, multi-level *deep-water* estate + Additional Dwelling Unit (ADU) with captivating views of Magnolia Plantation's preserved, undevelopable land. This exquisite property blends luxury, privacy (No HOA), and versatility--with over 4,300 square feet of total living space, including a beautifully finished 1 bedroom / 1 bath apartment (ADU) on the lower level. The main residence spans 3,414 sq ft, featuring 4 spacious bedrooms and 2.5 designer baths. Enjoy custom touches throughout, including built-in closet systems, a gas-log fireplace, and refined finishes like ceramic-tiled bathrooms, beadboard ceilings, wainscoting, and soft-close cabinetry in the stunning gourmet kitchen. Granite countertops, stainless steel appliances, a beverage fridge, and a sleek vent hood elevate the culinary space, all lit by abundant recessed lighting. -- A discreet door disguised as a bookshelf in the downstairs ADU adds character and privacy, *separating the upper home from the fully equipped lower-level apartment* (approx. 900 sq ft) perfect for guests, extended family, or rental income (previously leased for $2,500/month). This versatile space includes 1 bedroom, 1 full bath, a full kitchen, private waterfront patio access, and separate washer & dryer. -- Step outside to enjoy three expansive TREX decks a smaller one off the upstairs gallery / den, another that's accessible from both the sunroom and the master bedroom, and a side-yard-facing deck for shaded relaxation. The short private dock (14-foot deep water at low tide) is ideal for boating enthusiasts who value both ease and access. Additional highlights include: -- New roof (2021) & gutters -- replaced plumbing -- replaced electrical system -- HVAC (2015) -- replaced insulation -- Hurricane-rated windows -- Low flood insurance (~$2,300/year) -- No HOA or restrictions -- Whole-house Generator -- Room to build a garage or further customize the grounds With limited yard maintenance and unbeatable waterfront views, this home offers the best of Charleston's lowcountry living in a peaceful, tucked-away location only 2 miles from recreation activities at Collins Park has (tennis, pickleball, swimming pool, baseball field, and playground), 8 miles from vibrant shops and dining in park circle, 3 miles from Hwy 526, 4 miles to Hwy I-26, 23 miles from dipping your toes in the sand at Folly Beach, and only 12 miles from all the world-class amenities that downtown Charleston has to offer! Book your showing today for your chance to own this special piece of Lowcountry paradise!

 
Carriage Properties

Listed by: EXP Realty LLC
(888) 440-2798

Info

  • Address4940 Lambs
  • City, ZIPNorth Charleston, SC 29418
  • AreaNorth Charleston/Summerville Outside I-526
  • MLS #25017378
  • StatusActive
  • Price$1,299,000
  • KindResidential
  • Property Subtype:Single Family Detached
  • Sq Ft4,312 Square Feet
  • Acres0.51 Acres
  • Beds:5
  • Baths full:3
  • Baths half:1
  • Year Built:1964
  • Levels:3 Stories
  • SubdivisionLambs
  • Sq Ft4312
  • Acres0.51
  • Architectural
    Style:
    Traditional
  • Construction
    Materials:
    Brick Veneer, Cement Siding
  • Interior
    Features:
    Ceiling - Smooth, High Ceilings, Walk-In Closet(s), Ceiling Fan(s), Bonus, Eat-in Kitchen, Family, Game, Media, In-Law Floorplan, Office, Study, Sun
  • Fireplace
    eatures:
    Gas Log, Living Room, One
  • Heating:Central
  • Cooling:Central Air
  • Exterior
    Features:
    Dock - Existing, Dock - Floating, Lawn Irrigation, Rain Gutters, Stoop
  • Parking:Off Street
  • Patio
    And Porch
    Features:
    Deck, Front Porch, Porch - Full Front, Porch
  • Community
    Features:
    Trash
  • Waterfront
    Features:
    River Access, River Front, Waterfront - Deep, Seawall
  • Virtual Tour
    Video:
    View Virtual Tour

The Finest Real Estate
in Town and County

Our Latest
From Instagram

@CARRIAGEPROP