Listing Tools

Listed by Julie LaNigra of The Aland Realty Group

Listing Sold by BHHS Verani Seacoast
Nestled in the heart of historic downtown Portsmouth, this riverfront condo offers luxurious waterfront living. This extraordinary four-level residence stands as one of the finest riverfront condo ever offered for sale. From the moment you step into this abode, you're greeted by a variety of architectural beauty. The expansive wrap-around rooftop deck, an oasis of tranquility offering unparalleled views of the Piscataqua River. Marvel at breathtaking sunsets, watch ships glide by gracefully, and witness the bridge come alive with captivating illumination during the evening. The pavilion level sets the stage for entertainment, featuring a sophisticated bar and a living room/lounge adorned with a gas fireplace. The main level is a true masterpiece of design, boasting floor-to-ceiling windows that frame sweeping panoramic views of the river. The custom-built mantle with its soft curves adds a touch of timeless elegance, a large designer kitchen and coffered ceilings make the space feel open and elegant. Two en-suite bedrooms, each with custom bathrooms, luxurious showers, walk-in closets, and outdoor deck space, allowing for the perfect selection of a primary bedroom tailored to your preferences. Additionally, this property offers the luxury of two deeded parking spaces. Every inch of this residence has been meticulously curated with local artisans and the most premier materials used. A rare chance to call this exclusive riverfront home your own. This is truly one of a kind.

More Info

Tax Information

  • Tax Year2022

Building

  • Year Built2006
  • ConstructionMasonry, Brick Exterior
  • GarageNo
  • Unit Number114
  • Total Rooms9
  • FoundationBrick, Concrete, Granite

Property

  • AreaNH-Rockingham
  • Property TypeCondo
  • Road FrontageNo
  • DrivewayNone
  • Lot8
  • RoadsPaved
  • Lot DescriptionCondo Development

Utilities

  • Electric200 Amp
  • WaterPublic
  • Heating CoolingNatural Gas, Multi Zone
  • Equipment AppliancesSecurity System, Smoke Detectr-Hard Wired
  • SewerPublic
  • UtilitiesCable

Other

  • HOA Fee$1,679
  • Condo Fees$111
  • Date Price Change09/25/2023
  • Taxes$45,921
  • FrequencyMonthly
  • Unadjusted TaxesNo
  • SurveyedUnknown
  • SeasonalNo
  • Time ShareNo
  • Association AmenitiesMaster Insurance, Landscaping, Snow Removal, Trash Removal
  • Date Listed09/25/2023
  • Delayed ShowingsNo
  • View Count20

Rooms

  • Full Bath1

Location

  • TownPortsmouth
  • StateNH
  • Zip03801
  • CountyRockingham
  • ZoningCD4
  • ResortNo
  • ComplexRiversedge Condo Assoc.
  • Map106
  • DistrictPortsmouth
  • Flood ZoneYes
  • Elementary SchoolLittle Harbor School
  • Junior HighPortsmouth Middle School
  • High SchoolPortsmouth High School
  • Address117 Bow Street

Exterior

  • Exterior FeaturesDeck, Other - See Remarks
  • Exterior ColorBrick
  • RoofFlat, Membrane

Amenities

  • PricePerSqFt1030.98

Water Body

  • Water Body NamePiscataqua River
  • Water Body TypeRiver
  • Water AccessShared
  • Water ViewYes

Basic Information

  • List Price$5,800,000
  • Square Feet5,616
  • StatusSLD
  • Bedrooms3
  • Bathroom5
  • 3/4 Baths2
  • Half Bath2
  • StyleTownhouse
  • New ContructionExisting
  • MLS Number4971360
  • MLS StatusClosed

Interior

  • FloorsHardwood, Marble, Slate/Stone
  • Room 1 Dimensions18'8x14
  • Room 1 Level2
  • Room 1 TypeKitchen
  • Room 2 Dimensions28x12
  • Room 2 Level2
  • Room 2 TypeDining Room
  • Room 3 Dimensions28x21
  • Room 3 Level2
  • Room 3 TypeLiving Room
  • Interior FeaturesCentral Vacuum, Bar, Blinds, Cathedral Ceiling, Draperies, Elevator, Fireplace - Gas, Fireplaces - 2, Kitchen Island, Natural Light, Natural Woodwork, Security, Skylight, Storage - Indoor, Walk-in Closet, Wet Bar, Window Treatment, Laundry - 1st Floor, Smart Thermostat
  • Room 4 Level3
  • Room 4 TypeOffice/Study
  • Room 5 Level1
  • Room 5 TypeExercise Room
  • Room 6 Dimensions16x15
  • Room 6 Level3
  • Room 6 TypePrimary BR Suite
  • Room 7 Dimensions20x15
  • Room 7 Level4
  • Room 7 TypeBedroom with Bath
  • Room 8 Dimensions14'5x11'5
  • Room 8 Level1
  • Room 8 TypeBedroom
  • Room 9 Level4
  • Room 9 TypeLiving Room
  • Stories4

Map Location

Driving Directions

Broker Reciprocity 

Copyright 2026 PrimeMLS, Inc. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this display comes in part from the IDX Program of PrimeMLS. The information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated June 3, 2026 8:40 AM EDT

 

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from The Merrill Bartlett Group. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.