4940 Lambs Road, North Charleston, SC 29418 MLS #25017378

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 2 bedrooms, 1 full bath, a full kitchen, private waterfront patio access, and separate washer & dryer. Step outside to enjoy three expansive TREX decksa 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!