Best Value in Seacoast Waterfront Living! Wake up to glorious sunrises across Great Bay and ever-changing water views afforded by this Moody Point waterside 2,500 sq-ft. semi-attached single-family. Several recent updates just completed; the home is move-in ready and features a flexible floor plan to meet a variety of needs. Walls of windows and a skylighted vaulted ceiling bring natural light throughout the open concept main living level highlighted by a gas fireplace and beautiful newly refinished red birch flooring. The kitchen is open to the living/dining area and is conveniently located adjacent to the large mudroom with laundry closet and half bath. The upper level hosts the primary bedroom featuring a tray ceiling, huge custom walk-in closet and ensuite bath with 5' tiled shower along with an open loft ideal for home office or library. Additional bedrooms and baths are located on both the main and lower levels. Direct access from the Family Room to your private backyard and shorefront community walking trail (leashed dogs permitted). Over-sized finished 2-car garage with custom built-ins and a large unfinished basement. New boiler, extensive LED recessed lighting, Pella windows and sliding doors, central A/C on main and upper levels. Public water and sewer! The private waterfront community also offers a shorefront pavilion, dock w/ PW launch and many neighborhood activities. Just a short walk to Newmarket's vibrant downtown and only minutes to UNH and Portsmouth.