This 2500+ sq. ft. Farmhouse Cape perched above the Connecticut River offers tranquility and convenience and a rare opportunity to enjoy waterfront living in Hartford County! Walkout finished heated basement with full kitchen and bath, creates a seamless connection between indoor and outdoor living. The beautifully updated kitchen with Quartz countertops and wine fridge features an open floor plan layout to the living room allowing you to be fully engaged with friends and family while also enjoying the beautiful views of the river. In addition, the main level living area features beautiful bamboo floors, a separate dining room and flex room which can be used for an office, library or playroom and is connected to the living room with French doors allowing privacy or expanded entertaining space. The sunroom offers a peaceful environment for morning coffee or evening reflection. Upstairs, the primary bedroom connects to the bathroom with an oversized tub to unwind and once again enjoy beautiful views of the river. Additionally, the primary bedroom connects to a heated bonus room where options are endless. Two additional bedrooms and full bath complete the upstairs living area. Outside, the multi-tier stone walls with pretty landscaping and in ground pool make this home a secret paradise. With 175' of river frontage, you can head down to the river for boating, fishing or kayaking or simply relax by the water's edge - truly a rare find in Hartford County.