$495,000
About this home
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.
Highlights
Property details
- MLS #
- 1417976
- Property type
- Condominium
- Subdivision
- The Aquidneck Club
- Status
- Active
- Days on market
- 10
- On market date
- July 16, 2026
- Stories
- 2
- Total bathrooms
- 1
- Garage spaces
- N/A
- Parking spaces
- 1
- Lot size
- N/A
Location
Get directions →Nearby schools
Within 10 miles · public school directory data (NCES)
- Enrollment
- 416
- Student:teacher ratio
- 15.4:1
- District
- Portsmouth
- Enrollment
- 635
- Student:teacher ratio
- 12.2:1
- District
- Portsmouth
- 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
Similar homes you might like
Data source: Listing information provided by Rhode Island Association of REALTORS via Trestle/CoreLogic. Last updated July 27, 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.