Condominium at 297 Water Street UNIT A2, Portsmouth
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 2 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 3 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 4 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 5 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 6 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 7 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 8 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 9 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 10 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 11 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 12 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 13 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 14 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 15 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 16 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 17 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 18 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 19 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 20 of 21
Condominium at 297 Water Street UNIT A2, Portsmouth, photo 21 of 21
21 photos

$814,900

297 Water Street UNIT A2
Portsmouth, RI 02871
Listed by Russell Guerriero
Bedrooms
2
Bathrooms
2.5
Living area
2,684 sqft
Year built
1982

About this home

Extraordinary location and opportunity to own this first time on the market unit since built in 1982. This unit has 2 beds with 2 1/2 baths with the basement that could expand living options. The Condo is 1 of only 8 units in complex with a Master suite deck,which faces East. Unit has whole house generator. Enjoy the pool, tennis courts and water access.

Highlights

Fireplace

Property details

MLS #
1421249
Property type
Condominium
Subdivision
N/A
Status
Active
Days on market
25
On market date
August 21, 2026
Stories
3
Total bathrooms
2.5
Garage spaces
2
Parking spaces
6
Lot size
N/A
Loading map…

Nearby schools

Within 10 miles · public school directory data (NCES)

Elementary
Howard Hathaway School
0.55 mi away · Grades 0-4
Nearest school -- attendance-zone data not available here
3.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
416
Student:teacher ratio
15.4:1
District
Portsmouth
Middle
Portsmouth Middle School
4.35 mi away · Grades 5-8
Nearest school -- attendance-zone data not available here
4.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
635
Student:teacher ratio
12.2:1
District
Portsmouth
High
Portsmouth High School
0.46 mi away · Grades 9-12
Nearest school -- attendance-zone data not available here
5.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
824
Student:teacher ratio
11.8:1
District
Portsmouth

Walkability

Blended score for Portsmouth's center: EPA's National Walkability Index (street network, transit, land-use mix) combined with nearby-amenity density. 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).

73
Walkable
out of 100
EPA National Walkability Index
14.8 / 20 -- Above average walkable
Nearby-amenity density
70 / 100
Restaurants & cafes6
Grocery stores1
Parks4
Schools6
Transit stops20
Pharmacies2

Market position

How this listing compares to current activity in Portsmouth, from live MLS data.

On the market 25 days -- 49 fewer days than Portsmouth's current average of 74 days.
For reference, the median list price across 238 active listings in Portsmouth right now is $699,450.

Mortgage calculator

Estimate only - actual rate and payment depend on your lender, credit, and loan program.

$
%
%
Adjust tax / insurance estimates
% / yr
$
/mo
Est. monthly payment
$5,057/mo
$162,980 down
$651,920 loan
Principal & interest$4,228
Property tax (est.)$679
Home insurance (est.)$150

Similar homes you might like

Data source: Listing information provided by Rhode Island Association of REALTORS via Trestle/CoreLogic. Last updated 10 days ago.

Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.