Buy
  • Alabama Alaska California Colorado 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 (752)
    Mexico Listings (331)
    Central America Listings (627)
    Caribbean Islands Listings (44)
    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 #7588988
MLS #1417976
Listing photo

One-of-a-kind pied-a terre overlooking Narragansett Bay and the

275 Depot Ave Reliance, Portsmouth, Rhode Island, 02871
$495,000
1Beds
1Baths
550Sqft
--Acres

About this property

One-of-a-kind pied-a terre overlooking Narragansett Bay and the signature 18th golf hole of The Aquidneck Club. Fully furnished and equipped for immediate occupancy. Great rental history club members and their guests. Located in the stunning Clubhouse with access to fine and casual dining, indoor and outdoor bar/grill, inground swimming pool, fitness center and spa. Club membership includes access to the championship Link-style golf course (golf membership only) tennis and marina opportunities. Social or golf membership is required for ownership. Sale is subject to the club's long-term ground lease. Please note association fee is quarterly and includes property taxes, insurance, electric, heat (gas), water, sewer, security, general maintenance and repairs and concierge. The Seller has a contractual interest in this property but is not the legal owner.

Property Features

1 Beds
1 Baths
550 Sqft
Built in 2003
0 Acres
2 Stories
Beachview
On Beachfront
Assigned
Siding: Plaster, Shingles, Wood
Has Fireplace
Natural Gas, Zoned, Forced Air
Newport County
The Aquidneck Club Community

Additional Photos

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

Contact Information

Stacie Mills

Vanderbilt Internatonal Properties Ltd

401-862-2793

Location

Map
Listing Agent: Stacie Mills 401-862-2793
Broker: Vanderbilt Internatonal Properties Ltd 401-619-3333 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 Jul 24, 2026

Photo Gallery

One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 1
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 2
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 3
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 4
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 5
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 6
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 7
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 8
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 9
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 10
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 11
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 12
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 13
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 14
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 15
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 16
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 17
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 18
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 19
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 20
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 21
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 22
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 23
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 24
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 25
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 26
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 27
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 28
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 29
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 30
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 31
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 32
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 33
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 34
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 35
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 36
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 37
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 38
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 39
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 40

$495,000

1
Beds
1
Baths
550
Sqft

275 Depot Ave Reliance, Portsmouth, Rhode Island, 02871

By contacting this agent you agree to these Terms and Conditions.
Home Rhode Island Portsmouth
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 1
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 2
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 3
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 4
One-of-a-kind pied-a terre overlooking Narragansett Bay and the - photo 5
MLS# 1417976
Condo For Sale

One-of-a-kind pied-a terre overlooking Narragansett Bay and the

$495,000

275 Depot Ave Reliance, Portsmouth, Rhode Island, 02871

1
Beds
1
Baths
550
Sqft
--
Acres
$495,000
275 Depot Ave Reliance, Portsmouth, Rhode Island, 02871
1 Beds
1 Baths
550 Sqft
-- Acres
One-of-a-kind pied-a terre overlooking Narragansett Bay and the signature 18th golf hole of The Aquidneck Club. Fully furnished and equipped for immediate occupancy. Great rental history club members and their guests. Located in the stunning Clubhouse with access to fine and casual dining, indoor and outdoor bar/grill, inground swimming pool, fitness center and spa. Club membership includes access to the championship Link-style golf course (golf membership only) tennis and marina opportunities. Social or golf membership is required for ownership. Sale is subject to the club's long-term ground lease. Please note association fee is quarterly and includes property taxes, insurance, electric, heat (gas), water, sewer, security, general maintenance and repairs and concierge. The Seller has a contractual interest in this property but is not the legal owner.
8 days
on BeachHouse.com
18
views
0
saves

Property Details

HOME DETAILS

1 Beds
1 Baths
550 Sqft
Built in 2003
0 Acres
2 Stories

BEACH & VIEW

Beachview
On Beachfront

EXTERIOR

Assigned
Siding: Plaster, Shingles, Wood

INTERIOR

Has Fireplace
Natural Gas, Zoned, Forced Air

FINANCIAL & COMMUNITY

Newport County
The Aquidneck Club Community
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7588988
Viewed
18 times
Listing Status
Active
Added
Jul 16, 2026
Last Refresh
Jul 24, 2026 04:01:17 PM

Listing Information

Data Source
State Wide MLS of Rhode Island, Inc.
Source Property ID
1417976
Listing Agent: Stacie Mills 401-862-2793
Broker: Vanderbilt Internatonal Properties Ltd 401-619-3333 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
Rare west-side waterfront land offering on Prudence Island. This - photo 1
Rare west-side waterfront land offering on Prudence Island. This - photo 2
Rare west-side waterfront land offering on Prudence Island. This - photo 3
Rare west-side waterfront land offering on Prudence Island. This - photo 4
Rare west-side waterfront land offering on Prudence Island. This - photo 5
Rare west-side waterfront land offering on Prudence Island. This - photo 6
Rare west-side waterfront land offering on Prudence Island. This - photo 7
Rare west-side waterfront land offering on Prudence Island. This - photo 8
Rare west-side waterfront land offering on Prudence Island. This - photo 9

$499,000

0.39 Acres | Lot for sale

0675 Broadway, Portsmouth, RI, 02872

Rare west-side waterfront land offering on Prudence Island. This

Added: 06/06/2026 • Updated: 06/26/2026
For Sale
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 1
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 2
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 3
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 4
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 5
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 6
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 7
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 8
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 9
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 10
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 11
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 12
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 13
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 14
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 15
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 16
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 17
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 18
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 19
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 20
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 21
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 22
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 23
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 24
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 25
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 26
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 27
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 28
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 29
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 30
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 31
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 32
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 33
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 34
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 35
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 36
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 37
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 38
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 39
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 40
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 41
Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a - photo 42

$495,000

2 Beds | 1.0 Baths | 784 Sqft

65 King Phillip St, Portsmouth, RI, 02871

Welcome to 65 King Philip Street, Portsmouth, Rhode Island-a

Added: 06/23/2026 • Updated: 06/27/2026
For Sale
Built in 2010 on nearly half an acre surrounded by state and - photo 1
Built in 2010 on nearly half an acre surrounded by state and - photo 2
Built in 2010 on nearly half an acre surrounded by state and - photo 3
Built in 2010 on nearly half an acre surrounded by state and - photo 4
Built in 2010 on nearly half an acre surrounded by state and - photo 5
Built in 2010 on nearly half an acre surrounded by state and - photo 6
Built in 2010 on nearly half an acre surrounded by state and - photo 7
Built in 2010 on nearly half an acre surrounded by state and - photo 8
Built in 2010 on nearly half an acre surrounded by state and - photo 9
Built in 2010 on nearly half an acre surrounded by state and - photo 10
Built in 2010 on nearly half an acre surrounded by state and - photo 11
Built in 2010 on nearly half an acre surrounded by state and - photo 12
Built in 2010 on nearly half an acre surrounded by state and - photo 13
Built in 2010 on nearly half an acre surrounded by state and - photo 14
Built in 2010 on nearly half an acre surrounded by state and - photo 15
Built in 2010 on nearly half an acre surrounded by state and - photo 16
Built in 2010 on nearly half an acre surrounded by state and - photo 17
Built in 2010 on nearly half an acre surrounded by state and - photo 18
Built in 2010 on nearly half an acre surrounded by state and - photo 19
Built in 2010 on nearly half an acre surrounded by state and - photo 20
Built in 2010 on nearly half an acre surrounded by state and - photo 21
Built in 2010 on nearly half an acre surrounded by state and - photo 22
Built in 2010 on nearly half an acre surrounded by state and - photo 23
Built in 2010 on nearly half an acre surrounded by state and - photo 24
Built in 2010 on nearly half an acre surrounded by state and - photo 25
Built in 2010 on nearly half an acre surrounded by state and - photo 26
Built in 2010 on nearly half an acre surrounded by state and - photo 27
Built in 2010 on nearly half an acre surrounded by state and - photo 28
Built in 2010 on nearly half an acre surrounded by state and - photo 29
Built in 2010 on nearly half an acre surrounded by state and - photo 30
Built in 2010 on nearly half an acre surrounded by state and - photo 31
Built in 2010 on nearly half an acre surrounded by state and - photo 32

$480,000

2 Beds | 1.0 Baths | 911 Sqft

033 Alden Ave, Portsmouth, RI, 02871

Built in 2010 on nearly half an acre surrounded by state and

Added: 07/16/2026 • Updated: 07/16/2026
For Sale
Build your dream home on this buildable lot located near a - photo 1
Build your dream home on this buildable lot located near a - photo 2
Build your dream home on this buildable lot located near a - photo 3
Build your dream home on this buildable lot located near a - photo 4
Build your dream home on this buildable lot located near a - photo 5
Build your dream home on this buildable lot located near a - photo 6
Build your dream home on this buildable lot located near a - photo 7
Build your dream home on this buildable lot located near a - photo 8
Build your dream home on this buildable lot located near a - photo 9
Build your dream home on this buildable lot located near a - photo 10

$399,000

0.47 Acres | Lot for sale

249 Middle Rd, Portsmouth, RI, 02871

Build your dream home on this buildable lot located near a

Added: 07/16/2026 • Updated: 07/16/2026
View more View More
SEARCH STATES
Alabama Alaska California Colorado 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.07.24
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
  • 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 Colorado 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.07.24
Terms & Policy