Piscataqua River

MLS Number 5013068

• Residential Single Family
• Full Bath 1
• Construction Existing
• Bedrooms 3
• Bathroom 3

Unparalleled Mixed-Use Opportunity on Portsmouth New Hampshire's Historic Waterfront. 54 Ceres Street is a one-of-a-kind property that is available for sale for the first time. This two-unit commercial property features an expansive waterfront commercial space currently occupied by a thriving local restaurant as well as a charming three bedroom residential unit with commanding views of the harbor and the iconic Portsmouth waterfront. Also included in the sale is a deep-water dock on the Piscataqua River for the boating enthusiast to explore the harbor, the Atlantic Ocean and beyond. The possibilities and opportunities for the future of 54 Ceres Street are endless.

Listed by Ricardo Rodriguez & Associates of Coldwell Banker Realty Portsmouth NH

MLS Number 5000815

• Residential Single Family
• Full Bath 1
• Construction Existing
• Bedrooms 1
• Bathroom 1

Motivated Sellers will entertain offers. Walk the land and you'll embrace the chance to create a home that's truly yours, in a location that's nothing short of spectacular. The very first house coming onto New Castle Island from Portsmouth, this home is Hidden in plain sight and is situated on a private half acre that has well over 300 feet on the Piscataqua River. Truly a one of a kind waterfront oasis. Don't miss this incredible opportunity to transform this waterfront property into your personal paradise. Enjoy leisurely afternoons on the water, and hosting unforgettable gatherings against the backdrop of spectacular views and boat activity. Whether you're an avid boater or a nature lover don't miss the opportunity to own and transform this unique property. The existing mooring will be transferred to the new owner, and the deep-water dock offers the potential for a rebuild to suit your needs and your boat! The heated boathouse, perched over the water at high tide, provides an additional 640 sq. ft. of space as well as a cozy vantage point and get away. Schedule your private showing today and envision the beauty and elegance of this remarkable waterfront retreat. Be sure to watch the attached video tour.

Listed by Janet Sylvester and Margaret Pesce of Great Island Realty LLC

MLS Number 5009242

• Residential Single Family
• Full Bath 2
• Construction Existing
• Bedrooms 4
• Bathroom 3

Discover an unparalleled blend of serenity, privacy, & stunning natural beauty with this rare offering, available for the first time since 1952. Set on 1.19 acres with an impressive 353 feet of water frontage along the Piscataqua River, this mid-century modern home boasts breathtaking views from every window. Situated on Frame Point, a picturesque peninsula extending into the Piscataqua River, the property provides a rare combination of privacy & panoramic water views. While the house retains its classic mid-century modern architecture, including gorgeous mahogany paneling surrounding the wood burning fireplace, it awaits your vision to bring it into today's standards. The expansive lot offers a blend of wide open grassy areas perfect for gardens or recreational activities & serene wooded spaces w/ natural ledge outcroppings. The property's generous size not only ensures privacy but also presents potential for substantial expansion or subdivision. Additionally, there may be an opportunity to add a deep water dock, enhancing the allure of this waterfront paradise. Located just a short distance from Market Square, this exceptional property is a rare find, offering both tranquil seclusion & convenient access to the vibrant heart of Portsmouth. Enjoy the added benefit of New Hampshire's tax-friendly environment, which includes no state income tax & no sales tax. Also listed for sale as land, see MLS #5009443.

Listed by Erin Proulx of KW Coastal and Lakes & Mountains Realty/Portsmouth

MLS Number 5014610

• Residential Single Family
• Full Bath 4
• Construction Pre-Construction
• Bedrooms 4
• Bathroom 6

Welcome to this exceptional to be constructed modern farmhouse, located in the prestigious Shackford Point Estates. Offering approximately 5,416 square feet of finished living space above ground, with an option to add a home theater and additional finished space in the lower level, this luxurious home is designed for both comfort and style. The property boasts a spacious 3-car garage, 4 bedrooms, and 5.5 baths, providing ample room for family and guests. Set on roughly 225 feet of stunning water frontage, this home offers breathtaking views of Great Bay, the Piscataqua River, and access to the Atlantic Ocean. With the potential to obtain permits for a deep-water dock, this property is perfect for boating enthusiasts and those who appreciate waterfront living. Experience the ultimate in privacy and elegance in one of the most exclusive communities on the seacoast.

Listed by Nick Ponte and Jim Giampa of Carey Giampa,LLC/Portsmouth