515 Indian Ave

$8,475,000
Price
4
Beds
6,131 Sq. Ft.
$1,382 / Sq. Ft.
6,131
Sq. Ft.
$1,382
per Sq. Ft.

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...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.
  1. Listed by Alexandra Thursby • Brokerage DRE #REB.0019662 • Mott & Chace Sotheby's Intl.
    P: (401)-266-9900 alex.thursby@mottandchace.com

Property Details for 515 Indian Avenue

Subdivision Name
Indian Avenue
Architectural Style
Cabin, Historic/Antique
Waterfront Y N
Yes
Waterfront Features
Water Access, Waterfront
View
Water
LISTING UPDATED: 09/22/2025 11:34 AM

Property Details for 515 Indian Avenue

StatusActive
MLS #1394051
Days on Market109
Taxes$59,768 / year
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built1988
Lot Size1.70 AC / 74,052 SF
CountyNewport County

Location

Listing Courtesy of Mott & Chace Sotheby's Intl.
Add your commute

Building Information for 515 Indian Avenue

Stories2Year Built1988Building Size-Lot Size1.70 AC / 74,052 SF

Payment Calculator

$46,859 per month

30 year fixed, 6.28% Interest

Principal and Interest

$41,878

Property Taxes

$4,981

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 515 Indian Avenue

Summary
Location and General Information
  • City: Middletown
  • Community Features: Golf, Marina, Near Hospital, Near Schools, Recreation Area, Restaurant, Shopping, Tennis Courts
  • Postal City: Middletown
  • Postal Code: 02842
  • Postal Code Plus4: 5766
  • State Or Province: RI
  • View Y N: Yes
  • Zoning: R60
  • Human Modified Y N: Yes
Parking
  • Attached Garage Y N: Yes
  • Covered Spaces: 2
  • Garage Spaces: 2
  • Garage Y N: Yes
  • Parking Features: Attached, Garage
  • Parking Total: 10
Taxes and HOA Information
  • Tax Annual Amount: $59,768.00
  • Tax Assessed Value: 5308000
  • Tax Lot: 166
  • Tax Map Number: 129
  • Tax Year: 2024
Property
Lot Information
  • Above Grade Fin SQFT: 6131.0
  • Below Grade Finished Area: 0.0
  • Building Area Total: 6131.0
  • Living Area: 6,131.00
  • Living Area Source: Public Records
  • Lot Features: Private, Secluded, Waterfront
  • Lot Size Acres: 1.7
  • Lot Size Area: 74052.0
  • Lot Size Square Feet: 74052.0
  • Lot Size Units: Square Feet
  • Parcel Number: 515INDIANAVMDLT
  • Stories: 2
  • Stories Total: 2
  • Property Sub Type Additional: Single Family Residence
Property and Assessments
  • Business Type: Other
  • New Construction Y N: No
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Senior Community Y N: No
  • Year Built: 1988
  • C L I P: 2,323,558,176
Utilities
  • Electric: Amps200Or More
  • Sewer: Septic Tank
  • Utilities: Underground Utilities
  • Water Source: Private, Well
Interior and Exterior Features
Exterior Features
  • Accessibility Features: Accessibility Features, Accessible Full Bath, Accessible Doors
  • Exterior Features: Deck, Patio
  • Foundation Details: Concrete Perimeter
  • Pool Features: Indoor Pool
Interior Features
  • Appliances: Dryer, Dishwasher, Microwave, Oven, Oil Water Heater, Range, Refrigerator
  • Basement: Full, Interior Entry, Unfinished
  • Basement Y N: Yes
  • Bathrooms Full: 4
  • Bathrooms Half: 2
  • Bathrooms Total Integer: 6
  • Bedrooms Total: 4
  • Cooling: Central Air
  • Cooling Y N: Yes
  • Fireplace Features: Stone
  • Fireplaces Total: 3
  • Fireplace Y N: Yes
  • Flooring: Ceramic Tile, Hardwood, Carpet
  • Heating: Forced Air, Oil
  • Heating Y N: Yes
  • Interior Features: Cedar Closets
  • Levels: Two
  • Patio And Porch Features: Deck, Patio
  • Rooms Total: 15
  • Window Features: Thermal Windows
Rental
Rental Information
  • Land Lease Y N: No

Property History for 515 Indian Avenue

DateEvent & SourcePriceAppreciation
Sep 4, 2025

Listed (Active)

Rhode Island Association of REALTORS® #1394051

$8,475,000
May 25, 2011

Permanently Off Market

Rhode Island Association of REALTORS® #967836

Jul 15, 2010

Sold (Public Record)

Public Record #293870263

$3,250,000

+7.7% / yr

May 28, 2010

Listed (Active)

Rhode Island Association of REALTORS® #967836

$6,500,000
Sep 29, 2005

Permanently Off Market

Rhode Island Association of REALTORS® #453046

Nov 17, 2004

Listed (Active)

Rhode Island Association of REALTORS® #453046

$5,250,000
Feb 6, 1998

Sold (Public Record)

Public Record #170897925

$1,287,000
Feb 6, 1998

Sold

Rhode Island Association of REALTORS® #701924

$1,287,500
Nov 30, 1997

Contract Signed

Rhode Island Association of REALTORS® #701924

Feb 1, 1997

Listed (Active)

Rhode Island Association of REALTORS® #701924

$1,350,000
DateEvent & SourcePrice
09/04/2025

Listed (Active)

Rhode Island Association of REALTORS® #1394051

$8,475,000
05/25/2011

Permanently Off Market

Rhode Island Association of REALTORS® #967836

07/15/2010

Sold (Public Record)

Public Record #293870263

$3,250,000

+7.7% / yr

05/28/2010

Listed (Active)

Rhode Island Association of REALTORS® #967836

$6,500,000
09/29/2005

Permanently Off Market

Rhode Island Association of REALTORS® #453046

11/17/2004

Listed (Active)

Rhode Island Association of REALTORS® #453046

$5,250,000
02/06/1998

Sold (Public Record)

Public Record #170897925

$1,287,000
02/06/1998

Sold

Rhode Island Association of REALTORS® #701924

$1,287,500
11/30/1997

Contract Signed

Rhode Island Association of REALTORS® #701924

02/01/1997

Listed (Active)

Rhode Island Association of REALTORS® #701924

$1,350,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 515 Indian Avenue

Taxable ValueLand$3,700,000Additions$1,608,000Total$5,308,000
Tax Record2025$62,581 ($5,215 / month)
Home Facts
Lot Size74,052 SqFtStyleMulti-Family Dwelling (2-4)ZoningR60CountyNEWPORTAPNMIDD M:0129 B:00 L:166

Schools near 515 Indian Avenue

This home is within Middletown School District.
Rating
School
Type
Grades
Distance
Public - 4 to 5
Public - 6 to 8
Public - 9 to 12
Public - PK to 3
Rating
School
Distance
Joseph Gaudet Academy
Public4 to 5

Joseph H. Gaudet School
Public6 to 8

Middletown High School
Public9 to 12

Aquidneck School
PublicPK to 3

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

515 Indian Avenue is a single family home for sale in Middletown, RI 02842. This property was listed for sale on September 4, 2025 by Mott & Chace Sotheby's Intl., it's currently listed at $8,475,000. It has been on the market for a total of 109 days and was last sold on July 15, 2010. This listing's school district is Middletown School District. Nearby schools include Joseph Gaudet Academy, Joseph H. Gaudet School and Middletown High School. 515 Indian Avenue is a 4-bed, 6-bath, 6,131 sqft single family home built in 1988.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass makes no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Mott & Chace Sotheby's Intl.

Based on information from one of the following Multiple Listing Services: Rhode Island Association of REALTORS®. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by Rhode Island Association of REALTORS® is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.