No photos available for this listing

$1,099,000

38 Aquidneck Avenue
Portsmouth, RI 02871
Listed by Joy Gilkeson
Bedrooms
4
Bathrooms
2
Living area
N/A
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 /deck/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. Rents are below market values and leases expire 5/31/26 so tenants will be on month-to-month basis. Seller will consider private financing for qualified buyer.

Highlights

Waterfront

Property details

MLS #
1411598
Property type
Apartment,Multi Family
Subdivision
Portsmouth Park Waterfront
Status
Active
Days on market
40
On market date
N/A
Stories
2
Garage spaces
N/A
Lot size
0.1108 acres
Loading map…

Nearby schools

Within 10 miles · public school directory data (NCES)

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

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.