This magnificent brick colonial estate is situated on 2.5 acres of breathtaking waterfront property in Pasadena. Meticulously maintained and thoughtfully upgraded throughout, no detail has been overlooked, with custom, top-of-the-line finishes at every turn. The home features brand-new Andersen doors, new windows, new roof with conveyable warranty and a 2022 HVAC system. Upon entering, you are welcomed by an elegant herringbone-pattern luxury vinyl plank flooring that extends throughout the foyer, kitchen, and main-level bedroom. Just off the foyer, you'll find a conveniently appointed full bathroom and a spacious main-level bedroom, offering excellent flexibility for guests or a private home office. Step inside the gourmet kitchen, and prepare to be blown away. This stunning space features fully custom, top-of-the-line cabinetry, premium Wolf appliances, beautiful quartz countertops, and a striking wood-accented ceiling. Through the kitchen windows, enjoy picturesque views of the private tree line and breathtaking seasonal foliage. Two separate access points lead directly outside to a massive Trex deck that spans nearly the entire length of the home, providing an expansive outdoor living space. Perfect for entertaining, dining, or simply enjoying the peaceful surroundings. Turn the corner into the living room, where timeless character takes center stage. Beautiful parquet flooring, a classic brick wood-burning fireplace, and built-in wooden bookshelves create a warm, inviting atmosphere that gives this space so much charm. Upstairs, Brazilian Tigerwood flooring extends throughout all three bedrooms. The primary suite features a spacious walk-in closet with builts-ins and a beautifully remodeled en-suite bathroom complete with a freestanding soaking tub, double vanity, and walk-in marble-tiled shower. Two additional bedrooms round out the upper level, including an impressive secondary suite that feels like a primary of its own. Enjoy a spacious walk-in closet with custom built-ins, a private balcony, and direct access to an updated full bathroom. A conveniently located laundry room, complete with a utility sink and additional storage cabinetry, adds both practicality and convenience to the upper level. Continue up the spiral staircase to discover a hidden bonus room tucked away in the attic! The possibilities for this unique space are endless. For the past 15 years, it has been home to an incredible model train railway, which conveys with the property! Last but certainly not least, head downstairs to a basement with brand-new, LVP flooring, a full kitchen with an oversized island, and walkout-level access, this space is perfectly suited for multi-generational living or an extended-stay guest suite. The lower level also includes a private bedroom with a spacious closet, a full bathroom with accessibility features, and a brand-new washer and dryer. Whether you're looking to accommodate extended family, create a private living space, or explore the potential for rental income, this finished lower level offers tremendous possibilities! Adding even more convenience is the oversized two-car garage, complete with an EV charging station. It's rare to find a waterfront property that offers this much land while also showcasing the extensive updates and features found throughout this home. Schedule your showing today!