Set on the end of desirable Linbrook Road in the highly sought-after Bugbee Elementary School district and Horseshoe neighborhood, this impressive 4,139 sq ft colonial offers a rare combination of location, setting, and updated interior living space with tranquil views of the Trout Brook. The setting alone is exceptional, with peaceful water views enjoyed from multiple rooms, creating a daily sense of retreat while still being close to West Hartford Center. The heart of the home is the beautifully redesigned designer kitchen completed in 2023, showcasing quartz and granite countertops, a large center island with breakfast bar seating, extensive custom cabinetry, and top-of-the-line stainless steel appliances. Thoughtfully designed for both everyday living and entertaining, the kitchen flows seamlessly into the adjacent family room, creating a comfortable and connected main living space. A spacious formal dining room offers direct access to a private patio, ideal for indoor-outdoor gatherings, while a stunning great room just steps away provides an additional expansive area for entertaining, relaxing, or hosting larger occasions. The second level features four generously sized bedrooms plus a dedicated office space, offering flexibility for work-from-home needs. The primary suite is a true highlight, capturing serene water views along with a spa-inspired bath featuring radiant heated floors, double sinks, a large walk-in shower, and a spacious walk in closet.