Single Family Residence at 38 Aquidneck Avenue, Portsmouth
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 2 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 3 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 4 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 5 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 6 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 7 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 8 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 9 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 10 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 11 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 12 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 13 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 14 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 15 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 16 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 17 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 18 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 19 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 20 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 21 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 22 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 23 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 24 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 25 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 26 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 27 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 28 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 29 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 30 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 31 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 32 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 33 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 34 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 35 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 36 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 37 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 38 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 39 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 40 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 41 of 42
Single Family Residence at 38 Aquidneck Avenue, Portsmouth, photo 42 of 42
42 photos

$1,099,000

38 Aquidneck Avenue
Portsmouth, RI 02871
Listed by Joy Gilkeson
Bedrooms
4
Bathrooms
2
Living area
2,010 sqft
Year built
1919

About this home

Wake up to golden sunrises and refreshing sea breezes in this rare waterfront opportunity overlooking the Sakonnet River. Currently configured as a two-family investment property, the property offers sweeping, unobstructed water views, a newer 4-bedroom septic system, low maintenance siding. With potential for a dock just steps from your door, this is coastal living at its finest. Inside, a framed walk-up attic provides exciting possibilities for expansion and leads to a third-floor balcony with breathtaking panoramic river views. Whether you envision a multigenerational retreat, an income-producing investment, or a custom waterfront dream home, the flexibility here is unmatched. Set on a highly sought after street lined with elegant waterfront residences, this property blends charm, location and OPPORTUNITY. Enjoy close proximity to great restaurants, weekend polo matches, or take a short drive to Newport for its vibrant downtown and lively harbor front. Bring your vision and transform this unique property into the coastal sanctuary you've always dreamed of. Seller will consider private financing for qualified buyer.

Highlights

Waterfront

Property details

MLS #
1411595
Property type
Single Family Residence
Subdivision
Portsmouth Park Waterfront
Status
Active
Days on market
40
On market date
May 6, 2026
Stories
N/A
Total bathrooms
2
Garage spaces
N/A
Parking spaces
3
Lot size
0.1108 acres
Loading map…

Nearby schools

Within 10 miles. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card (e.g. NC Dept. of Public Instruction, SC Report Card).

Elementary
Howard Hathaway School
0.25 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
Tiverton Middle School
4.26 mi away · Grades 5-8
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
503
Student:teacher ratio
10.7:1
District
Tiverton
High
Portsmouth High School
0.62 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, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 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
Google Places 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 40 days -- 35 fewer days than Portsmouth's current average of 75 days.
For reference, the median list price across 240 active listings in Portsmouth right now is $752,000.

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
$6,768/mo
$219,800 down
$879,200 loan
Principal & interest$5,702
Property tax (est.)$916
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 June 15, 2026.

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.