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.
| MLS # | 1411471 |
|---|---|
| Listing Type | For Sale |
| Sub-Type | Resale |
| Status | Active Under Contract |
| Year | 1988 |
| Days On Site | 155 |
| Listing Provided By | Mott & Chace Sotheby's Intl. | Alexandra Thursby |
| Bed(s) | 4 |
|---|---|
| Bath(s) | 6 Total |
| SQ Feet | 6,131 |
| Garage | 2 |
| Basement | Y |
| Pool | Yes |
| Units | 2 |
| Building(s) | 3 |
| Zoning | R60 |
| Acreage | 1.70 |
| Golf Course | Yes |
| Water Front | Yes |
| Property View | Water, Saltwater View |
| Rooms Total | 15 |
|---|---|
| Heating | Oil, Central Air, Forced Air |
| Heating Yes / No | Yes |
| Cooling | Central Air |
| Cooling Yes / No | Yes |
| Appliances | Dishwasher, Dryer, Exhaust Fan, Microwave, Oven, Range, Refrigerator, Washer |
| Interior Features | Wall (Dry Wall), Attic, Cedar Closet(s), Wet Bar, Plumbing (Mixed), Insulation (Ceiling), Insulation (Floors), Insulation (Walls) |
| Window Features | Insulated Windows |
| Fireplace Yes / No | Yes |
| Fireplaces Total | 3 |
| Fireplace Features | Brick, Stone |
| Exterior Features | Deck, Guest House, Patio |
|---|---|
| Foundation Details | Concrete Perimeter |
| Lot Features | Out Building, Other, Underground Utilities |
| Patio And Porch Features | Deck, Patio |
| Community Features | Golf, Hospital, Marina, Private School, Public School, Recreational Facilities, Restaurants, Schools, Shopping, Near Swimming, Tennis |
| Construction Materials | Dry Wall, Masonry |
| Attached Garage Yes / No | Yes |
|---|---|
| Garage Yes / No | Yes |
| Parking Features | Attached |
| Sewer | Septic Tank |
|---|---|
| Electric | 400 Amps |
| Community Features | Golf, Hospital, Marina, Private School, Public School, Recreational Facilities, Restaurants, Schools, Shopping, Near Swimming, Tennis |
|---|
| Tax Annual Amount | 62581 |
|---|---|
| Tax Assessed Value | 5308000 |
| Tax Lot | 166 |
| Tax Year | 2025 |
| State | RI |
|---|---|
| County | Newport |
| City | Middletown |
| Zip Code | 02842 |
| Area | Newport |
| Listing VS Median (in 02842) | |
Price: $7,900,000 low | high Med: $15,000 sqft: 6,131 low | high Med: 2,125 $ / sqft: $1,289 low | high Med: $8 On site: 155 low | high Med: 2.5 | |
| State | RI |
|---|---|
| County | Newport |
| City | Middletown |
| Zip Code | 02842 |
| Area | Newport |
| Listing VS Median (in 02842) | |
Price: $7,900,000 low | high Med: $15,000 sqft: 6,131 low | high Med: 2,125 $ / sqft: $1,289 low | high Med: $8 On site: 155 low | high Med: 2.5 | |
![]() | $7,900,000515 Indian AvenueMiddletown, RI 02842 |