Date
Details
Price
Change
Source
9/04/2025
Listed
$8,475,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/49
$8,475,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/49
Property Description
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.
Full Property Details
Full Property Details for 515 Indian Ave
General
- Price: $8,475,000
- Taxes: $59,768 (2024)
- Status: Active
- Type: Single Family
- Source: STWMLS
- MLS ID: 1394051
- Updated: 9/22/2025
- Added to Site: 134 day(s) ago
Business
- Business Type: Other
Interior
- Number of Rooms: 15
- Interior Features: Cedar Closet(s)
- Fireplace: Yes
- Number of Fireplaces: 3
- Fireplace(s): Stone
- Appliances: Dryer, Dishwasher, Microwave, Oven, Oil Water Heater, Range, Refrigerator
- Flooring: Ceramic Tile, Hardwood, Carpet
Rooms
Bathrooms
- Total Bathrooms: 6
- Full Bathrooms: 4
- Half Bathrooms: 2
Bedrooms
- Total Bedrooms: 4
Additional Information
- Pool: Yes
- Pool Description: Indoor
- Tennis: Yes
Exterior
- Exterior Features: Deck, Patio
- Porch/Patio/Deck: Deck, Patio
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 2
- Covered Spaces: 2
- Total Spaces: 10
- Parking Features: Attached, Garage
Location
- County: Newport
- Subdivision: Indian Avenue
Heating & Cooling
- Central air: Yes
- Air Conditioning: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Forced Air, Oil
Utilities
- Sewer: Septic Tank
- Water: Private, Well
- Well: Yes
- Utility Description: Underground Utilities
Structural Information
- Architectural Style: Cabin, Historic/Antique
- Detached/Attached: Detached
- Construction: Drywall, Masonry
- Basement: Yes
- Basement Desc.: Full, Interior Entry, Unfinished
- Windows: Thermal Windows
- Stories/Levels: 2
- Building Size: 6131
- Square Feet: 6,131
- Living Area: 6,131 Sq. Ft.
- Finished Total: 6,131 Sq. Ft.
- Finished Above Grnd: 6,131 Sq. Ft.
- Year Built: 1988
Additional Structures
- Other Structures: Guest House, Outbuilding
Lot Features
- Property View: Water
- Lot Size (Acres): 1.7
- Lot Size (Sq. Ft.): 74,052
- Lot Size: 74052
- Lot Features: Private, Secluded, Waterfront
Water Features
- Water Front: Yes
- Water View: Yes
- Water Front Desc.: Water Access, Waterfront
Financial Considerations
- Tax Amount: $59,768
- Tax Year: 2024
Disclosures and Reports
- Property ID: 515INDIANAVMDLT
- Lot Number: 166
Listed by Mott & Chace Sotheby's Intl.
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 515 Indian Ave —
Mott & Chace Sotheby's Intl.
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 515 Indian Ave
School District:Middletown School District
| Name | Grades | Distance |
|---|---|---|
Middletown High School 130 Valley Road, Middletown, RI 02842 | 9-12 | 2.5 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 515 Indian Ave
Tax History
Tax History for 515 Indian Ave
Year
Property Taxes
Change
Tax Assessment
Change
2025
$62,581
5%
$5,308,000
—
2024
$59,768
11%
$5,308,000
24%
2023
$53,947
5%
$4,284,900
—
2022
$51,504
—
$4,284,900
—
2021
$51,504
-6%
$4,284,900
8%
2020
$54,539
—
$3,963,600
—
2018
$54,500
-11%
$3,963,600
—
2016
$60,944
3%
$3,952,300
—
2015
$59,443
42%
$3,952,300
52%
2014
$41,756
2%
$2,598,400
—
2013
$40,821
—
$2,598,400
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 515 Indian Ave
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 3 hours ago
- 6Beds
- 6Total Baths
- 4,927Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 22 hours ago
- 2Beds
- 2Total Baths
- 1,152Sq. Ft.
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 4Total Baths
- 3,660Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 6 hours ago
- 3Beds
- 1Total Bath
- 1,500Sq. Ft.
- Single Family
- Active
- Updated 5 hours ago
- 7Beds
- 4Total Baths
- 3,818Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
515 Indian Avenue, Middletown, RI 02842 (MLS# 1394051) is a Single Family property with 4 bedrooms, 4 full bathrooms and 2 partial bathrooms. 515 Indian Avenue is currently listed for $8,475,000 and was received on September 04, 2025. Want to learn more about 515 Indian Avenue? Do you have questions about finding other Single Family real estate for sale in Middletown? You can browse all Middletown real estate or contact a Coldwell Banker agent to request more information.