At the end of a quiet cul-de-sac in the heart of Concord, this exceptional waterfront property blends privacy, recreation, and modern amenities. On the 1.23 acre lot, enjoy year round outdoor activities, including swimming, kayaking, fishing, and ice skating- all steps from the back door. The gourmet kitchen features abundant cabinetry with Miele and Sub-Zero appliances, and easy flow out to a wraparound deck. The first floor offers two large living rooms, formal dining room, two home offices, and a separate access en-suite/ADU currently generating rental income. Second floor includes a primary ensuite retreat with dressing room and two walk in closets, and three additional bedrooms with two attached studies. Finished basement offers home theater for family movie nights and spacious flex space. With its large backyard, two firepits, screened-in gazebo with outdoor shower, and easy access to tennis courts and sandy beach- this is more than a home - it's where lifelong memories are made.