Experience the beauty of WATERFRONT living in this BRAND NEW Colonial Style home overlooking the scenic Piscataqua River. Offering a wonderful blend of modern design and coastal charm, this property presents an exceptional opportunity to enjoy life on the water with the potential for a dock or mooring. A bright and sunlit main level features a seamless flow between living, dining, and kitchen spaces, ideal for everyday living and entertaining. Enjoy your morning coffee on the deck or a beverage at sunset...it's the way life should be! The oak hardwood floors throughout add warmth and timeless appeal, complementing the home's fresh, contemporary style. The well-designed kitchen includes quartz counters, SS appliances, gas range, accent island and lots of cabinetry. Imagine hosting holiday celebrations or having intimate dinner parties in your dining room! The open concept dining and inviting living room are where breathtaking water views take center stage. Expansive windows fill the space with natural light while showcasing the picturesque setting. A beautiful gas fireplace serves as a warm and welcoming focal point, adding comfort and ambiance through the seasons! The 2300+ sf home offers two bedrooms, three baths, along with a versatile bonus space on the first level which can be used as a home office, or additional guest room to suit your needs. The lower level which has been partially finished can be completed for additional living space! Whether you're seeking a peaceful Seacoast retreat or a place to call home year-round, this exceptional property offers the best of both worlds. This location is a few minutes to Portsmouth, 10 minutes to Dover and 1 hour to Boston. With breathtaking sunsets, and the beauty of the Seacoast...your waterfront lifestyle begins here!