$7,900,000
 $42,409 est/mo Sourced by Back At You

515 Indian Avenue,Middletown, RI 02842

Middletown, RI 02842

Share:

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.

Details

MLS #1411471
Listing TypeFor Sale
Sub-TypeResale
StatusActive Under Contract
Year1988
Days On Site155
Listing Provided ByMott & Chace Sotheby's Intl. | Alexandra Thursby

Features

Bed(s)4
Bath(s) 6 Total
SQ Feet6,131
Garage2
BasementY
PoolYes
Units2
Building(s)3
ZoningR60
Acreage1.70
Golf CourseYes
Water FrontYes
Property ViewWater, Saltwater View

Interior

Rooms Total15
HeatingOil, Central Air, Forced Air
Heating Yes / NoYes
CoolingCentral Air
Cooling Yes / NoYes
AppliancesDishwasher, Dryer, Exhaust Fan, Microwave, Oven, Range, Refrigerator, Washer
Interior FeaturesWall (Dry Wall), Attic, Cedar Closet(s), Wet Bar, Plumbing (Mixed), Insulation (Ceiling), Insulation (Floors), Insulation (Walls)
Window FeaturesInsulated Windows
Fireplace Yes / NoYes
Fireplaces Total3
Fireplace FeaturesBrick, Stone

Exterior

Exterior FeaturesDeck, Guest House, Patio
Foundation DetailsConcrete Perimeter
Lot FeaturesOut Building, Other, Underground Utilities
Patio And Porch FeaturesDeck, Patio
Community FeaturesGolf, Hospital, Marina, Private School, Public School, Recreational Facilities, Restaurants, Schools, Shopping, Near Swimming, Tennis
Construction MaterialsDry Wall, Masonry

Parking

Attached Garage Yes / NoYes
Garage Yes / NoYes
Parking FeaturesAttached

Utilities

SewerSeptic Tank
Electric400 Amps

Location

Community FeaturesGolf, Hospital, Marina, Private School, Public School, Recreational Facilities, Restaurants, Schools, Shopping, Near Swimming, Tennis

Taxes

Tax Annual Amount62581
Tax Assessed Value5308000
Tax Lot166
Tax Year2025

Area Information

StateRI
CountyNewport
CityMiddletown
Zip Code02842
AreaNewport
Listing VS Median (in 02842)
Price:
$7,900,000
low | high
Med:
$15,000
100% of Average
sqft:
6,131
low | high
Med:
2,125
100% of Average
$ / sqft:
$1,289
low | high
Med:
$8
100% of Average
On site:
155
low | high
Med:
2.5
100% of Average
Sourced by Back At You

Market Activity 02842

Request a showing

Request a showing

Contact


Additional Information


Showing Information


Submit Form

Required Field
By submitting, you agree to receive promotional texts and/or calls from Andrew Abu Inc at the number provided. Message/data rates may apply. Consent is not a condition of purchase, and you can opt out anytime by replying STOP.
The information is being provided by Rhode Island Association of REALTORS®. Information deemed accurate but not guaranteed. Information is provided for consumers personal, non-commercial use, and may not be used for any purpose other than the identification of potential properties for purchase. Copyright 2026 Rhode Island Association of REALTORS®. All Rights Reserved.

Contact

Learn More About This Property

StateRI
CountyNewport
CityMiddletown
Zip Code02842
AreaNewport
Listing VS Median (in 02842)
Price:
$7,900,000
low | high
Med:
$15,000
100% of Average
sqft:
6,131
low | high
Med:
2,125
100% of Average
$ / sqft:
$1,289
low | high
Med:
$8
100% of Average
On site:
155
low | high
Med:
2.5
100% of Average
Sourced by Back At You
Nearby Listings (Within 1/10 mile)
Price: $5.925M - $9.875M
sqft: 4,500 - 7,500
Nearby Listings Property ImageNearby Listings Details
515 Indian Avenue Property Photo 1
$7,900,000
515 Indian Avenue
Middletown, RI 02842
Listing Updated: September 29, 2026 at 1:07:25 PM PDT