Date
Details
Price
Change
Source
4/30/2026
Listed
$8,295,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/50
$8,295,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/50
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,295,000
- Taxes: $62,581 (2025)
- Status: Active
- Type: Multi-Family
- Source: STWMLS
- MLS ID: 1411471
- Updated: 4/30/2026
- Added to Site: 2 day(s) ago
Business
- Business Type: Other
Interior
- Number of Rooms: 15
- Interior Features: Attic, Wet Bar, Cedar Closet(s), Stall Shower, Tub Shower
- Fireplace: Yes
- Number of Fireplaces: 3
- Fireplace(s): Masonry, Stone
- Appliances: Dryer, Dishwasher, Exhaust Fan, Microwave, Oven, Oil Water Heater, Range, Refrigerator, Washer
- 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: In Ground
- Tennis: Yes
- Security/Safety: Security System Owned
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
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
- # Buildings: 3
- Detached/Attached: Detached
- Construction: Drywall, Masonry
- Basement: Yes
- Basement Desc.: Full, Interior Entry, Unfinished
- Windows: Thermal Windows
- Doors: Storm Door(s)
- Stories/Levels: 0
- Building Size: 6131
- 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: Saltwater, 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.: Beach Front, Ocean Front, Water Access, Walk to Water, Waterfront
Financial Considerations
- Tax Amount: $62,581
- Tax Year: 2025
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 |
|---|---|---|
Joseph Gaudet Academy 1113 Aquidneck Avenue, Middletown, RI 02842 | 4- | 2.2 mi |
Aquidneck School 70 Reservoir Road, Middletown, RI 02842 | PK-3 | 2.2 mi |
Joseph H. Gaudet School 1113 Aquidneck Avenue, Middletown, RI 02842 | 5-8 | 2.2 mi |
Middletown High School 130 Valley Road, Middletown, RI 02842 | 9-12 | 2.5 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions 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 1 day ago
- 12Beds
- 13Total Baths
- 16,601Sq. Ft.
- Single Family
- Active
- Updated 1 day ago
- 3Beds
- 2Total Baths
- 1,363Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 4 days ago
- 2Beds
- 2Total Baths
- 1,015Sq. Ft.
- Single Family
- Active
- Updated 4 days ago
- 3Beds
- 3Total Baths
- 1,596Sq. 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# 1411471) is a Multi-Family property with 2 units containing 4 bedrooms, 4 full bathrooms and 2 partial bathrooms. 515 Indian Avenue is currently listed for $8,295,000 and was received on April 30, 2026. Want to learn more about 515 Indian Avenue? Do you have questions about finding other Multi-Family real estate for sale in Middletown? You can browse all Middletown real estate or contact a Coldwell Banker agent to request more information.