Nestled between the Hartford Yacht Club and the Glastonbury Yacht Club, you will find this quaint property with the MOST GORGEOUS WATERVIEW! While property address is technically Portland, the mailing address is listed in South Glastonbury, Walking into the foyer, the upper level features a cozy living room with fireplace, an office space which could easily be used as a bedroom (with a great water view!) and the Primary Bedroom with beautiful water views and direct access to a deck. Lower level has a large room with a kitchen and entertaining area. The kitchen has granite countertops, a large island, large pantry and plenty of room for entertaining. This kitchen/dining area walks right out to the beautiful stone patio with a built in fire pit and just a short walk to the water. The lower level also has an additional room, which could easily be used as a bedroom or work out room. House has a mini split system for cooling, new shed, fresh exterior paint and an electric fence for pets, The star of the show, however, is the stunning .9 acre direct waterfront lot with direct access (and launch area) to the Connecticut River. Launch or moor your boat, stroll in to take a dip or simply watch the eagles fly by! Get ready for summertime fun on the river!