- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
Price Drop: $395K (10/16)
Street View
$7,900,000
Monthly Est:$39,321
4 Beds
6 Baths4 full baths + 2 half baths
6,131sqft
515 Indian Ave, Middletown, RI 02842
$7,900,000
$39,321/moEst:
Get Pre-Approved
Multi Family
Built in 1988
$-- HOA
1.7 acres lot
$1,289/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 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.
- Houzeo last checked: 43 minutes ago
- Listing updated: October 29, 2026 at 2:25 am
- Listing Provided by: Alexandra Thursby (401) 266-9900 DRE #RES.0035586 | Mott & Chace Sotheby's Intl. (401) 250-0095
- Source: RI StateWide MLS-RI | MLS#: 1411471
Property Details
Status
Pending
Type
Multi Family
No. of Stories
-
County
City
Neighborhood
--
Year Built
1988
HOA Fees
-
Finished Area
6,131 sqft
Lot Size
1.7 acres lot
Basement Area
- sqft
MLS Name
RI StateWide MLS
MLS Number
1411471
MLS Status
Pending
Days on Market
188
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 6
Interior
Flooring
Ceramic Tile, Hardwood, Carpet
Exterior Features
Deck, Patio
Window Features
Thermal Windows
Interior Features
Attic, Wet Bar, Cedar Closets, Stall Shower, Tub Shower
Heating
Forced Air, Oil
Cooling
Central Air
Appliances
Dryer, Dishwasher, Exhaust Fan, Microwave, Oven, Oil Water Heater, Range, Refrigerator, Washer
Sewer
Septic Tank
Construction
Year Built
Year Built: 1988
Home type
Multi Family
Construction Materials
Drywall, Masonry
Foundation Details
Concrete Perimeter
Utilities & Energy
Pool Features
In Ground
Electric
Amps200or More
Fireplace Features
Masonry, Stone
Basement
Full, Interior Entry, Unfinished
Parking Features
Attached, Garage
Water Source
Private, Well
Utilities
Underground Utilities
Security Features
Security System Owned
Other Features
Lot Features
Private, Secluded, Waterfront
Patio And Porch Features
Deck, Patio
Community Features
Golf, Marina, Near Hospital, Near Schools, Pool, Recreation Area, Restaurant, Shopping, Tennis Courts
Price History
| Date | Event | Price |
|---|---|---|
08/21/2026 Source: | Contingent (Active Under Contract) | $7,900,000 $1,289/sqft |
08/21/2026 Source: | Pending | $7,900,000 $1,289/sqft |
08/21/2026 Source: | Listed for Sale | $7,900,000 -4.76% $1,289/sqft |
04/30/2026 Source: | Price Decreased | $8,295,000 -2.12% $1,353/sqft |
09/10/2025 Source: | Off Market | $8,475,000 $1,382/sqft |
Show more
Nearby Homes
Find Homes by Property Features in Middletown, RI
Based on information from State-Wide MLS through Nov 05, 2026, 12:45PM. Information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties that consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 State-Wide MLS, Inc. All rights reserved.
Advertising Broker: Derek Greene | The Greene Realty Group
