






















































$2,495,000
About this home
Rare opportunity to own a lakefront Royal Cottage within the gates of The Aquidneck Club. This exquisitely maintained 3-bedroom, 3.5-bathroom home offers multiple living areas, including a three-season screened porch overlooking Sunset Lake. First and second floor primary bedroom suites and second floor den and guest room with full bathroom. Open kitchen leads to mudroom with powder room and two-car garage. The full basement level includes a large laundry room and offers high ceilings with two access entrances to complete for media, wine or golf simulation areas. This special home offers many outdoor entertaining areas including balconies, porches and a fenced private courtyard with outdoor kitchen with a low-maintenance turf lawn. While membership is optional, this exceptional property is steps from The Aquidneck Club offering membership opportunities to include championship golf, tennis, spa, fitness, inground pool and an elegant clubhouse with fine and casual dining and a calendar of member events for all ages. Easy access to Newport, Bristol and Route 24 to connect to Boston and Cape Cod.
Highlights
Property details
- MLS
- Rhode Island Association of REALTORS
- MLS #
- 1424053
- Property type
- Single Family Residence
- Subdivision
- The Aquidneck Club
- Status
- Active
- Days on market
- 10
- On market date
- September 23, 2026
- Stories
- N/A
- Total bathrooms
- 3.5
- Garage spaces
- 2
- Parking spaces
- 6
- Lot size
- N/A
Location
Get directions →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.
- 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
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).
Market position
How this listing compares to current activity in Portsmouth, from live MLS data.
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 19 days ago.
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.







