This amazing colonial was transformed into a modern beautiful home in 2024. The original structure was lifted off the ground and placed back down on a brand-new foundation, new joists and sub-floor, and a new great room addition. White cabinet kitchen with crown moldings, black granite countertops, stainless steel appliances, hardwood flooring, high ceilings, wood stove hook-up, and open to a dining area. The great room offers cathedral ceilings, a half-bath, and sliding door to a private rear deck. The first floor offers a bedroom/primary suite with direct access to the first floor, fully tiled bath. Go up the center stairway to two large bedrooms with wide pine original floorings, a bonus room ideal for office or dressing room and an additional full tile bath. Third floor attic space with windows and extra storage. Go down to the lower level to find functional space with laundry area, utility room, rough plumbed half bath and huge open room with potential for additional living area. New windows, doors, drywall, fiberglass insulation, decks, boiler, etc. Brand new, oversized 2-car garage. House sits well back from street with a massive lawn. Lot has 47' frontage on the Piscataqua River. Convenient location with easy access to shopping, restaurants, the turnpike, and all Portland has to offer.