Buy
  • Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (730)
    Mexico Listings (329)
    Central America Listings (620)
    Caribbean Islands Listings (46)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BeachHouse.com logo
Share
BeachHouse.com logo
Ad #7678342
MLS #1411598
Listing photo

Wake up to golden sunrises and refreshing sea breezes in this

38 Aquidneck Ave, Portsmouth, RI 02871
$1,099,000
4Beds
2Baths
4,552Sqft
0.11Acres

About this property

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.

Property Features

4 Beds
2 Baths
4,552 Sqft
Built in 1919
0.11 Acres
2 Stories
On Beachfront
Garage
Siding: Dry Wall, Plaster, Vinyl Siding
Oil, Baseboard
$12,647 / yr property tax
Newport County
Portsmouth Park Waterfront Community

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Joy Gilkeson

Keller Williams Realty of Newport / East Bay / North Kingstown

401-845-9200

Location

Map
Listing Agent: Joy Gilkeson 401-845-9200
Broker: Keller Williams Realty of Newport / East Bay / North Kingstown 401-845-9200 Listing Site
Copyright © 2026 State Wide MLS of Rhode Island, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BeachHouse.com
Printed Aug 12, 2026

Photo Gallery

Wake up to golden sunrises and refreshing sea breezes in this - photo 1
Wake up to golden sunrises and refreshing sea breezes in this - photo 2
Wake up to golden sunrises and refreshing sea breezes in this - photo 3
Wake up to golden sunrises and refreshing sea breezes in this - photo 4
Wake up to golden sunrises and refreshing sea breezes in this - photo 5
Wake up to golden sunrises and refreshing sea breezes in this - photo 6
Wake up to golden sunrises and refreshing sea breezes in this - photo 7
Wake up to golden sunrises and refreshing sea breezes in this - photo 8
Wake up to golden sunrises and refreshing sea breezes in this - photo 9
Wake up to golden sunrises and refreshing sea breezes in this - photo 10
Wake up to golden sunrises and refreshing sea breezes in this - photo 11
Wake up to golden sunrises and refreshing sea breezes in this - photo 12
Wake up to golden sunrises and refreshing sea breezes in this - photo 13
Wake up to golden sunrises and refreshing sea breezes in this - photo 14
Wake up to golden sunrises and refreshing sea breezes in this - photo 15
Wake up to golden sunrises and refreshing sea breezes in this - photo 16
Wake up to golden sunrises and refreshing sea breezes in this - photo 17
Wake up to golden sunrises and refreshing sea breezes in this - photo 18
Wake up to golden sunrises and refreshing sea breezes in this - photo 19
Wake up to golden sunrises and refreshing sea breezes in this - photo 20
Wake up to golden sunrises and refreshing sea breezes in this - photo 21
Wake up to golden sunrises and refreshing sea breezes in this - photo 22
Wake up to golden sunrises and refreshing sea breezes in this - photo 23
Wake up to golden sunrises and refreshing sea breezes in this - photo 24
Wake up to golden sunrises and refreshing sea breezes in this - photo 25
Wake up to golden sunrises and refreshing sea breezes in this - photo 26
Wake up to golden sunrises and refreshing sea breezes in this - photo 27
Wake up to golden sunrises and refreshing sea breezes in this - photo 28
Wake up to golden sunrises and refreshing sea breezes in this - photo 29
Wake up to golden sunrises and refreshing sea breezes in this - photo 30
Wake up to golden sunrises and refreshing sea breezes in this - photo 31
Wake up to golden sunrises and refreshing sea breezes in this - photo 32
Wake up to golden sunrises and refreshing sea breezes in this - photo 33
Wake up to golden sunrises and refreshing sea breezes in this - photo 34
Wake up to golden sunrises and refreshing sea breezes in this - photo 35
Wake up to golden sunrises and refreshing sea breezes in this - photo 36
Wake up to golden sunrises and refreshing sea breezes in this - photo 37
Wake up to golden sunrises and refreshing sea breezes in this - photo 38
Wake up to golden sunrises and refreshing sea breezes in this - photo 39
Wake up to golden sunrises and refreshing sea breezes in this - photo 40
Wake up to golden sunrises and refreshing sea breezes in this - photo 41
Wake up to golden sunrises and refreshing sea breezes in this - photo 42

$1,099,000

4
Beds
2
Baths
4,552
Sqft

38 Aquidneck Ave, Portsmouth, RI 02871

By contacting this agent you agree to these Terms and Conditions.
Home Rhode Island Portsmouth
Wake up to golden sunrises and refreshing sea breezes in this - photo 1
Wake up to golden sunrises and refreshing sea breezes in this - photo 2
Wake up to golden sunrises and refreshing sea breezes in this - photo 3
Wake up to golden sunrises and refreshing sea breezes in this - photo 4
Wake up to golden sunrises and refreshing sea breezes in this - photo 5
MLS# 1411598
Apartment For Sale

Wake up to golden sunrises and refreshing sea breezes in this

$1,099,000

38 Aquidneck Ave, Portsmouth, RI 02871

4
Beds
2
Baths
4,552
Sqft
0.11
Acres
$1,099,000
38 Aquidneck Ave, Portsmouth, RI 02871
4 Beds
2 Baths
4,552 Sqft
0.11 Acres
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.
97 days
on BeachHouse.com
66
views
0
saves

Property Details

HOME DETAILS

4 Beds
2 Baths
4,552 Sqft
Built in 1919
0.11 Acres
2 Stories

BEACH & VIEW

On Beachfront

EXTERIOR

Garage
Siding: Dry Wall, Plaster, Vinyl Siding

INTERIOR

Oil, Baseboard

FINANCIAL & COMMUNITY

$12,647 / yr property tax
Newport County
Portsmouth Park Waterfront Community
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7678342
Viewed
66 times
Listing Status
Active
Added
May 06, 2026
Last Refreshed
Jul 03, 2026 06:17:28 PM

Listing Information

Data Source
State Wide MLS of Rhode Island, Inc.
Source Property ID
1411598
Listing Agent: Joy Gilkeson 401-845-9200
Broker: Keller Williams Realty of Newport / East Bay / North Kingstown 401-845-9200 Listing Site
Copyright © 2026 State Wide MLS of Rhode Island, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 1
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 2
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 3
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 4
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 5
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 6
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 7
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 8
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 9
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 10
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 11
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 12
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 13
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 14
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 15
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 16
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 17
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 18
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 19
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 20
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 21
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 22

$1,100,000

3 Beds | 3.0 Baths | 2,100 Sqft

163 Revolution Way, Portsmouth, RI 02871

Waterview New Construction in Spyglass Ridge at Prescott Point -

Added: 07/09/2026 • Updated: 07/09/2026
For Sale
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 1
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 2
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 3
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 4
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 5
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 6
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 7
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 8
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 9
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 10
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 11
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 12
Waterview New Construction in Spyglass Ridge at Prescott Point - - photo 13

$1,100,000

3 Beds | 3.0 Baths | 2,100 Sqft

Revolution Way, Portsmouth, RI 02871

Waterview New Construction in Spyglass Ridge at Prescott Point -

Added: 06/24/2026 • Updated: 07/05/2026
For Sale
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 1
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 2
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 3
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 4
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 5
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 6
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 7
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 8
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 9
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 10
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 11
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 12
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 13
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 14
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 15
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 16
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 17
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 18
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 19
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 20
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 21
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 22
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 23
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 24
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 25
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 26
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 27
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 28
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 29
Welcome to 55 Sloop Drive, a beautifully maintained Colonial - photo 30

$1,049,000

3 Beds | 4.0 Baths | 2,080 Sqft

55 Sloop Dr, Portsmouth, RI 02871

Welcome to 55 Sloop Drive, a beautifully maintained Colonial

Added: 07/06/2026 • Updated: 07/09/2026
For Sale
New home build in Prescott Point. Move in ready for August 2026 - photo 1
New home build in Prescott Point. Move in ready for August 2026 - photo 2
New home build in Prescott Point. Move in ready for August 2026 - photo 3
New home build in Prescott Point. Move in ready for August 2026 - photo 4
New home build in Prescott Point. Move in ready for August 2026 - photo 5
New home build in Prescott Point. Move in ready for August 2026 - photo 6
New home build in Prescott Point. Move in ready for August 2026 - photo 7
New home build in Prescott Point. Move in ready for August 2026 - photo 8
New home build in Prescott Point. Move in ready for August 2026 - photo 9
New home build in Prescott Point. Move in ready for August 2026 - photo 10
New home build in Prescott Point. Move in ready for August 2026 - photo 11
New home build in Prescott Point. Move in ready for August 2026 - photo 12
New home build in Prescott Point. Move in ready for August 2026 - photo 13
New home build in Prescott Point. Move in ready for August 2026 - photo 14
New home build in Prescott Point. Move in ready for August 2026 - photo 15
New home build in Prescott Point. Move in ready for August 2026 - photo 16

$899,000

3 Beds | 3.0 Baths | 1,700 Sqft

Revolution Way, Portsmouth, RI 02871

New home build in Prescott Point. Move in ready for August 2026

Added: 06/28/2026 • Updated: 07/09/2026
SEARCH STATES
Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.08.11
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Portsmouth

Read more
Sort By:
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Portsmouth Real Estate Agent Info

About Portsmouth

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.08.11
Terms & Policy