- 0
- 6
- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
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, dinin...
Continue Reading- Houzeo last checked: 6 minutes ago
- Listing updated: September 2, 2026 at 4:22 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
Active
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
Active
Days on Market
142
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 6
Interior
Sewer
Septic Tank
Exterior Features
Deck, Patio
Heating
Forced Air, Oil
Appliances
Dryer, Dishwasher, Exhaust Fan, Microwave, Oven, Oil Water Heater, Range, Refrigerator, Washer
Interior Features
Attic, Wet Bar, Cedar Closets, Stall Shower, Tub Shower
Flooring
Ceramic Tile, Hardwood, Carpet
Cooling
Central Air
Window Features
Thermal Windows
Construction
Year Built
Year Built: 1988
Home type
Multi Family
Construction Materials
Drywall, Masonry
Foundation Details
Concrete Perimeter
Utilities & Energy
Parking Features
Attached, Garage
Fireplace Features
Masonry, Stone
Electric
Amps200or More
Utilities
Underground Utilities
Water Source
Private, Well
Pool Features
In Ground
Security Features
Security System Owned
Basement
Full, Interior Entry, Unfinished
Other Features
Community Features
Golf, Marina, Near Hospital, Near Schools, Pool, Recreation Area, Restaurant, Shopping, Tennis Courts
Lot Features
Private, Secluded, Waterfront
Patio And Porch Features
Deck, Patio
Price History
| Date | Event | Price |
|---|---|---|
08/21/2026 Source: | Price Decreased | $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: | Listed for Sale | $8,475,000 $1,382/sqft |
09/10/2025 Source: | Off Market | $8,475,000 +120971.43% $1,382/sqft |
09/03/2025 Source: | Listing Removed | $7,000 -87.27% $1/sqft |
Show more
Find Homes by Property Features in Middletown, RI
Based on information from State-Wide MLS through Sep 20, 2026, 03: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
Love this home?
Here's 4 things you can do
Your local real estate expert. Speak directly with agent about the home & pricing.
Book your private tour
as early as Today at 02:00 PM
Rates starting from 6.3%. Secure financing early to move quickly when you're ready.
Fastest way to get your offer in. Speak directly with agent to negotiate the offer.
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
