WATERFRONT on INDIAN AVENUE. Céad Míle Failte, “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.
For sale
$8,475,000
515 Indian Ave, Middletown, RI 02842
4beds
6,131sqft
Est.:
Single Family Residence
Built in 1988
1.7 Acres Lot
$-- Zestimate®
$1,382/sqft
$-- HOA
What's special
Stunning water viewsExpansive water viewsStone terracesManor houseOpen floor planEnglish gardenMeticulously landscaped grounds
- 104 days |
- 3,016 |
- 112 |
Zillow last checked: 8 hours ago
Listing updated: September 22, 2025 at 08:34am
Listed by:
Alexandra Thursby 401-266-9900,
Mott & Chace Sotheby's Intl.
Source: StateWide MLS RI,MLS#: 1394051
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Heating
- Oil, Central Air, Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator
Features
- Wall (Dry Wall), Cedar Closet(s), Plumbing (Mixed), Insulation (Ceiling), Insulation (Floors), Insulation (Walls)
- Flooring: Ceramic Tile, Hardwood, Carpet
- Windows: Insulated Windows
- Basement: Full,Interior Entry,Unfinished
- Number of fireplaces: 3
- Fireplace features: Stone
Interior area
- Total structure area: 6,131
- Total interior livable area: 6,131 sqft
- Finished area above ground: 6,131
- Finished area below ground: 0
Property
Parking
- Total spaces: 10
- Parking features: Attached
- Attached garage spaces: 2
Accessibility
- Accessibility features: Extra Wide Shower, Flat Thresholds, Accessible Doors
Features
- Patio & porch: Deck, Patio
- Pool features: Indoor
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Waterfront, Access
Lot
- Size: 1.7 Acres
- Features: Secluded
Details
- Additional structures: Guest House, Outbuilding
- Parcel number: MIDDM0129B00L166
- Zoning: R60
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cottage
- Property subtype: Single Family Residence
Materials
- Dry Wall, Masonry
- Foundation: Concrete Perimeter
Condition
- New construction: No
- Year built: 1988
Utilities & green energy
- Electric: 400 Amps
- Sewer: Septic Tank
- Water: Private, Well
- Utilities for property: Underground Utilities
Community & HOA
Community
- Features: Golf, Hospital, Marina, Private School, Public School, Recreational Facilities, Restaurants, Schools, Near Shopping, Near Swimming, Tennis
- Subdivision: Indian Avenue
HOA
- Has HOA: No
Location
- Region: Middletown
Financial & listing details
- Price per square foot: $1,382/sqft
- Tax assessed value: $5,308,000
- Annual tax amount: $59,768
- Date on market: 9/10/2025
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 9/10/2025 | Listed for sale | $8,475,000+41.4%$1,382/sqft |
Source:  StateWide MLS RI #1394051 Report a problem | ||
| 6/11/2025 | Listing removed | $55,000$9/sqft |
Source: Zillow Rentals Report a problem | ||
| 5/21/2025 | Listed for rent | $55,000-15.4%$9/sqft |
Source: Zillow Rentals Report a problem | ||
| 12/16/2024 | Listing removed | $65,000$11/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/20/2024 | Listed for rent | $65,000$11/sqft |
Source: Zillow Rentals Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $59,768 | $5,308,000 |
| 2024 | $59,768 +16% | $5,308,000 +23.9% |
| 2023 | $51,504 | $4,284,900 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$41,479/mo
Principal & interest
$32863
Property taxes
$5650
Home insurance
$2966
Climate risks
Neighborhood: 02842
Nearby schools
GreatSchools rating
- 5/10Joseph Gaudet AcademyGrades: 4-5Distance: 2.2 mi
- 8/10Joseph H. Gaudet SchoolGrades: 6-8Distance: 2.2 mi
- 5/10Middletown High SchoolGrades: 9-12Distance: 2.5 mi
- Loading
- Loading
