3D tour
$7,900,000
4 bd · 4.5 ba · 6,131 sqft · 1.70 acre lot
515 Indian Ave, Middletown, RI 02842
Single family · Built 1988 · $1,289/sqft ·
$45,370/mo est. payment
- Garage
- 2 cars
- Stories
- 2
Flood factor 1/10
About this home
WATERFRONT on INDIAN AVENUE. Cead Mile 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.
Facts and features
Bedrooms
- Bedrooms: 4
Other Rooms
- Total Rooms: 15
- Basement Features: Full, Interior Only, Unfinished, Storage Space, Utility
- Basement Description: Full
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 4
- 1/2 Bathrooms: 2
- Bathroom 1 Features: Bath w Shower Stall
- Bathroom 2 Features: Bath w Tub & Shower
Interior Features
- Wall (dry wall)
- Attic
- Cedar closet(s)
- Wet bar
- Plumbing (mixed)
- Insulation (ceiling)
- Insulation (floors)
- Insulation (walls)
Appliances
- Dishwasher
- Dryer
- Exhaust fan
- Microwave
- Oven
- Range
- Refrigerator
- Washer
Heating and Cooling
- Cooling Features: Central Air
- Fireplace Features: Brick, Stone
- Heating Features: Oil, Central Air, Forced Air
- Heating: Yes
- Number of Fireplaces: 3
Exterior and Lot Features
- Deck
- Guest house
- Patio
- Other Structures: Guest House
- Patio And Porch Features: Deck, Patio
- Patio: Yes
- Deck: Yes
Pool and Spa
- Pool Features: In Ground
Schools
- 6
Middletown High School
high · 9-12 · 2.5 mi
- 8
Joseph Gaudet Academy
elementary · 4-5 · 2.2 mi
- 7
Joseph H. Gaudet School
middle · 6-8 · 2.2 mi
Valley Community School Middletown
elementary · 2.3 mi
- 10
Aquidneck School
elementary · K-3 · 2.2 mi
James L Maher School
elementary · 4-12 · 2.5 mi
Price history
- Aug 21, 2026 · Price Changed$7,900,000
- Aug 21, 2026 · Price Changed$7,900,000
- May 2, 2026 · Listing Removed—
- May 1, 2026 · Listed$8,295,000
- May 1, 2026 · Listed$8,295,000
- Sep 10, 2025 · Listed$8,475,000
- Sep 5, 2025 · Listing Removed—
- Sep 5, 2025 · Listing Removed—
Tax history
- 2025$62,581 tax · $5,308,000 assessed
- 2023$53,947 tax · $4,284,900 assessed
- 2022$51,504 tax · $4,284,900 assessed
- 2021$51,504 tax · $4,284,900 assessed
- 2020$54,539 tax · $3,963,600 assessed
- 2018$54,500 tax · $3,963,600 assessed
- 2016$60,944 tax · $3,952,300 assessed
- 2015$59,443 tax · $3,952,300 assessed
Home value
$7,706,979
- Quantarium$7,706,979
- Cotality$7,759,600
Where it is
Listed by Alexandra Thursby · Mott & Chace Sotheby's Intl. · StateWide