Tucked away at the end of a rare double cul-de-sac, this beautiful 2.44-acre riverfront property offers estate-style living with direct access to the Chattahoochee River - right in the heart of Suwanee's most sought-after community, zoned for the award-winning Lambert High School. Enjoy ultimate privacy, serene surroundings, and all the perks of an open-concept floor plan designed for both entertaining and everyday living. This home combines flexible space, location, and lifestyle like few others. Inside, you'll find warm hardwood floors, custom iron double entry doors, elegant architectural details, and abundant natural light throughout the main living areas. The gourmet kitchen opens to a cozy fireside family room surrounded by oversized windows with treetop views. The main floor features a guest bed and full bath, laundry, and multiple options for office, dining, and sitting rooms. On the second level, the spacious primary suite includes a luxurious bathroom with travertine flooring, cherry cabinets, granite counters, a frameless shower, and a spa-style soaking champagne bubbler tub. The walk-in closet has custom cabinetry and even lock and key drawers. There are 3 additional bedrooms and a large bathroom on the upper level. The walk-out terrace level offers a full apartment with private exterior entry-complete with a bedroom, 2 full bathrooms (with HEATED floors), full-size kitchen with walk-in pantry, living room, gym space, lots of storage, and its own laundry-ideal for guests, in-laws, or long-term stays. Step outside to discover a true backyard retreat with expansive TREX decks, covered outdoor living spaces, and lush wooded views. Whether tubing down the river from your own backyard, letting the kids explore in the woods, or hosting a backyard campfire under the stars, this property delivers a sense of adventure and tranquility that's rare in a neighborhood setting. Enjoy resort-style amenities just steps from home in Olde Atlanta Club-golf course, clubhouse restaurant, six tennis courts, two pickleball courts, Olympic-size swimming pool, leisure pool, splash pad, kiddie pool, basketball court, playground, and dozens of sports and social events year-round. Located in the top-ranked Lambert school district and nestled in the heart of Suwanee-named one of Fortune Magazine's Top 50 Best Places to Live in the U.S.-you're just minutes from upscale retail, dining, Peachtree Parkway for commuting, and Lake Lanier for boating and water fun. This is more than a home. It's a private retreat, an entertainer's dream, and a rare opportunity to enjoy riverfront living in a vibrant suburban community.