4940 Lambs

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!

Essential Information

  • MLS® #25017378
  • Price$1,299,000
  • Bedrooms5
  • Bathrooms3
  • Full Baths3
  • Half Baths1
  • Square Footage4,312
  • Acres0.51
  • Year Built1964
  • TypeResidential
  • Sub-TypeSingle Family Detached
  • StyleTraditional
  • StatusActive

Community Information

Amenities

  • Garage Spaces0
  • ParkingOff Street

Interior

  • InteriorCeiling - Smooth, High Ceilings, Walk-In Closet(s), Ceiling Fan(s), Bonus, Eat-in Kitchen, Family, Game, Media, In-Law Floorplan, Office, Study, Sun
  • HeatingCentral
  • CoolingCentral Air
  • FireplaceYes
  • Fireplaces1
  • Stories3

Exterior

  • Exterior FeaturesDock - Existing, Dock - Floating, Lawn Irrigation, Rain Gutters, Stoop
  • RoofArchitectural
  • ConstructionBrick Veneer, Cement Siding
  • FlooringCeramic Tile, Wood

Lot Description

.5 - 1 Acre

School Information

  • ElementaryHunley Park Elementary School
  • HighStall

Additional Information

Listing Details

  • OfficeEXP Realty LLC

LISTED BY EXP Realty LLC, (888) 440-2798