Redfin is joining Rocket

Discover how we're simplifying your journey home.

$949,000

18 N Water St Portsmouth, RI 02871

2 beds
2 full, 1 partial
1,700 sqft
0.2 acres
$558 / sqft
House

Property details

About 18 N Water St

Welcome to 18 North Water your coastal retreat with stunning views of Mount Hope Bay and the Sakonnet River from almost every window. Located in the sought-after community of Common Fence Point. This home features 2 bedrooms, 2.5 bathrooms, and a bright and airy open floor plan on the main level, perfect for relaxing or entertaining. The primary suite offers a glass shower, double sinks, and peaceful water views. Additionally, you will find a second bedroom, a full bathroom, and a dedicated office, offering flexibility for guests or remote work. Take advantage of everything this special community has to offer from the many events hosted at the community center to the several neighborhood beaches (just a short stroll from the property), and close proximity to the marina for boating and waterfront activities. This property blends comfort, functionality, and the beauty of coastal living.

Highlights

Home typeSingle Family Residence
HeatingForced Air, Propane
StatusActive
CoolingCentral Air
Size1,700 sqft
Lot size0.18 Acres
Year built2019
ParkingBuilt In
MLS #1389180
Attached garageYes
WaterfrontWaterfront
FireplaceGas
ViewWater

Summary

  • Partial Bathrooms: 1
  • Full Bathrooms: 2
  • Appliances: Dryer, Dishwasher, Gas Water Heater, Microwave, Oven, Range, Refrigerator, Tankless Water Heater
  • Basement: No
  • Flooring Type: Ceramic Tile, Hardwood
  • Interior: Stall Shower, Tub Shower, Cable TV
  • Fireplace: Gas
  • Total Bedroom Count: 2
  • Attached Garage: Yes
  • Parking: Built In
  • Waterfront: Waterfront
  • View: Water
  • Exterior: Porch, Patio
  • Architectural Style: Colonial
  • Heating: Forced Air, Propane
  • Cooling: Central Air
  • List Price: $949,000
  • Price/SqFt: $558
  • Annual Tax Amount: $8,900
  • Tax Year: 2024
  • Year Built: 2019
  • Stories: 2
  • Living Area: 1,700 SqFt
  • Lot Size: 0.18 Acres
  • MLS Number: 1389180
  • MLS Name: RIS
  • Office Name: RE/MAX River's Edge - Bristol
  • Office Phone: (401) 254-1776

Disclaimer: The data relating to real estate for sale on this web site comes in part from the IDX Program of the State-Wide Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than this broker are marked with the MLS logo and detailed information about them includes the name of the listing brokers. The purchase price of housing stock as shown on this website may vary depending on factors such as fees, commissions, price negotiations, home inspection results, market conditions, etc. This website in no way warrants or represents that submitting an offer to purchase a property for the list price will result in a sale at that price. Please consult with your REALTOR® to discuss how these variations may affect your real estate transaction. IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information Deemed Reliable, but is neither guaranteed nor independently verified. Interested parties must make their own inquiries. Copyright © 2025 State-Wide MLS, Inc. All rights reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/22/2025, 11:45:28 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Price information

Property sales

DateEventPrice
May 25, 2023
Home Sold
$850,000
Aug 16, 2019
Home Sold
$515,000
Jul 12, 2018
Home Sold
$89,000
Apr 25, 2011
Home Sold
$70,000

Tax history

YearAssessmentProperty Tax
2024$675,300$8,900
2023$675,300$8,630
2022$525,900$8,183
2021$525,900$8,052
2020$525,900$7,925
2019$138,500$2,271

History based on county public records data.

Nearby schools

6

Fort Barton Elementary School

Public District KG-4

1.7 mi

99 Lawton Ave

8

Pocasset Elementary school

Public District KG-4

2.2 mi

242 Main Rd

10

Hathaway Elementary School

Public District KG-4

2.5 mi

53 Tallman Ave

School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.

All data from GreatSchools

Neighborhood

The neighbors living near this home have an average income of $85,897. Typical income of Portsmouth, RI residents is between $100k-200k annually. Residents typically live in married, no kids family. The most common level of education of people living in this area is post secondary degree.

How much money do the neighbors make?

17%
<35k
39%
35k-100k
41%
100k-200k
3%
200k+

What level of education do the neighbors have?

High School Diploma
Post Secondary Degree
Masters Degree
Doctorate

What types of families live nearby?

34%
Single, No Kids
8%
Single, with Kids
36%
Married, No Kids
22%
Married, with Kids

Are the neighbors home owners or renters?

Home Owners
Renters

How old are people in this area?

12%
<11 yrs old
7%
12-17 yrs old
24%
18-34 yrs old
43%
35-64 yrs old
14%
65+ yrs old

What do the neighbors do for fun?

  • Hiking/backpackingHiking/backpacking
  • Symphony or OperaSymphony or Opera
  • PGA/LPGAPGA/LPGA

Where do the neighbors shop?

  • Nordstrom RackNordstrom Rack
  • Chico'sChico's
  • Stein MartStein Mart

Where do the neighbors go to eat?

  • ChipotleChipotle
  • Boston MarketBoston Market
  • Bonefish GrillBonefish Grill

What do the neighbors drive?

  • MazdaMazda
  • VolvoVolvo
  • CadillacCadillac

What do the neighbors listen to?

  • RockRock
  • Talk/PersonalityTalk/Personality
  • ClassicalClassical
All data provided by Home Junction and Claritas

Similar homes for sale

Frequently asked questions

Living in Portsmouth, RI

Transportation in Portsmouth includes a network of roads that connect residents to nearby cities and amenities. Public transit options are available, with schedules that accommodate the commuting patterns of residents. The town also supports alternative transportation methods, such as biking and walking, with certain areas designed to be particularly pedestrian-friendly. While specific ride-sharing statistics are not mentioned, such services are commonly used in the area.

The community is served by a range of educational institutions, including public and private schools that cater to various educational needs. Healthcare services are accessible, with facilities providing primary care and specialized treatments. The public library system supports lifelong learning and community activities. Retail and dining options reflect the local culture, offering a blend of traditional New England fare and contemporary cuisine.

Portsmouth is known for its serene coastal charm and strong sense of community. The town prides itself on its rich history and natural beauty, with numerous parks and public spaces that encourage outdoor activities. Annual events and local traditions are a testament to the town's cultural vitality and community engagement.

Portsmouth's housing market is characterized by a diverse array of options, with single-family homes being a significant presence. Architectural styles vary, with colonial, ranch, and Cape Cod homes dotting the landscape. The market is balanced with a mix of older homes that reflect the town's historical roots and newer constructions that offer modern amenities. While the exact homeownership rate is not specified, the market suggests a healthy balance between owned and rented properties.

About 18 N Water St

The listing price of 18 N Water St property is $949,000.

The property 18 N Water St is a house located in Portsmouth, Rhode Island, 02871.

Active Listing: 18 N Water St is For Sale (Active/New) which means the seller is accepting offers.

The nearby schools for 18 N Water St are: Fort Barton Elementary School (GreatSchools Rating 6/10), Pocasset Elementary school (GreatSchools Rating 8/10), Hathaway Elementary School (GreatSchools Rating 10/10), Henry Lord Community School (GreatSchools Rating 3/10), Tiverton Middle School (GreatSchools Rating 4/10), Matthew J Kuss Middle School (GreatSchools Rating 2/10), Portsmouth High School (GreatSchools Rating 7/10), Tiverton High School (GreatSchools Rating 6/10), Mt. Hope High School (GreatSchools Rating 7/10).

According to the records, the last property tax for 2024 is $8,900 (source: MLS/based on county public records data).

The last sale was on May 25, 2023 for $850,000 (source: MLS/tax record).

The property at 18 N Water St has 2 bedrooms and 2 full and 1 half bathrooms.

The property 18 N Water St is 1,700 SqFt (source: MLS/tax record).

The year of construction for 18 N Water St is 2019.

This home is located at 18 N Water St in Portsmouth, RI and zip code 02871. This 1,700 square foot home, which was built in 2019, sits on a 0.18 acre lot. Features: 2 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since July 3, 2025 and is currently priced at $949,000.

While more than 8 listings in Portsmouth, RI in June 2025 were sold above asking price, there were more than 3 listings sold at asking price, and more than 15 were sold below. In June 2025 in Portsmouth, RI there were 15.6% more homes for sale than in May. Listings spent 43 days on the market in June 2025, and had a median list price of $706,250 during the same period.

From Rocket Homes Real Estate and based on county public records data.

More resources