** OPEN HOUSE CANCELLED ** LUXURY WATERFRONT CONDO RETREAT - These direct waterfront units don't come available that often. Experience COASTAL LIVING at its finest in this expansive end-unit townhouse on the Bellamy River. Located in a serene CUL-DE-SAC community, this home blends waterfront tranquility with modern luxury, offering panoramic river views and STUNNING SUNSETS every day on ALL 3 FLOORS. Spread across three beautifully finished floors, the main level features an open-concept kitchen and living area with stainless steel appliances, GRANITE COUNTERTOPS, a gas fireplace, and oversized sliders that flood the space with natural light. Step out onto the back patio for EASY OUTDOOR LIVING AND VIEWS. The 2nd floor is anchored by a luxurious primary suite featuring a WATERVIEW BALCONY, 2nd gas fireplace and a brand-new SPA-LIKE ENSUITE w/ a large walk-in shower, double granite vanity, custom HEATED FLOORS, and a walk-in closet with a hidden cedar closet. Two additional bedrooms, an UPDATED full bath, and a convenient laundry room complete the level. The top floor offers a spacious family room with a CUSTOM BAR and an OUTDOOR BALCONY with a wood-paneled ceiling - the perfect spot for SUNSETS. Enjoy additional COMMUNITY PERKS like a shared dock, paddleboard/kayak racks, and the option to apply for a boat mooring & tennis court. Located just minutes from UNH, Route 95, and downtown Portsmouth, this condo combines convenience w/ a secluded, VACATION-LIKE ATMOSPHERE.