$8,295,000
About this home
WATERFRONT on INDIAN AVENUE. Céad Míle Fáilte, “One Hundred Thousand Welcomes.” An extraordinary waterfront compound located on the historic grounds of Stonybrook Estate. The property features a 4,609 square foot Manor House built in 1988, a historically significant 1,522 square foot Horace Trumbauer Gate House constructed in 1935, and a gunite pool with cabana overlooking the Sakonnet River. This gracious contemporary home was custom-designed with traditional elements including a steeply pitched slate roof, tall gables and half-timbering. Through the front door is a comfortable, open floor plan with stunning water views from nearly every room. The kitchen, living, dining and primary bedrooms all provide access to stone terraces around the pool and lush gardens with opportunities for a relaxing indoor-outdoor lifestyle. Enjoy expansive water views and meticulously landscaped grounds with specimen trees and an English Garden. This bucolic setting is on the rural and much-loved Indian Avenue, just 1.5 miles from beautiful Second and Third Beaches and 15 minutes to downtown Newport.
Highlights
Property details
- MLS #
- 1411471
- Property type
- Multi Family
- Subdivision
- N/A
- Status
- Active
- Days on market
- 10
- On market date
- N/A
- Stories
- N/A
- Garage spaces
- 2
- Lot size
- 1.7 acres
Location
Get directions →Nearby schools
Within 10 miles · public school directory data (NCES)
- Enrollment
- 317
- Student:teacher ratio
- 13.2:1
- District
- Middletown
- Enrollment
- 463
- Student:teacher ratio
- 11.3:1
- District
- Middletown
- Enrollment
- 620
- Student:teacher ratio
- 11.9:1
- District
- Middletown
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 May 11, 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.