Welcome to 25 Aviva Court, a stunning two-family center hall colonial nestled in a serene private waterfront cul-de-sac. This custom home sits on a large 11,410 square foot lot, offering over 4,800 square feet of luxurious living space, not including the finished basement. The main residence boasts 4 spacious bedrooms and 3 beautifully appointed bathrooms. In the heart of the home, is the custom kitchen, featuring top-of-the-line Viking and Sub-Zero appliances. Gleaming hardwood floors, custom crown molding, and elegant finishes adorn the interiors, while large Andersen windows flood the space with natural light. gorgeous family room, complete with a fireplace. The finished basement provides additional space for recreation , and the oversized garage ensures ample parking and convenience. Step outside to your private oasis—a huge backyard with a gorgeous inground pool, perfect for entertaining or relaxing. This home truly has it all, blending luxury, comfort, and style in a coveted location, near a park, restaurants, transportation, shopping and great schools.