Price Reduction - Water Views - Golf Course
Address
515 Indian Avenue, Middletown, RI
Price
$ 7,900,000
Property Attributes
- MLS#1411466
- TypeSingle Family
- Listing Status Active
- CountyNewport
- CityMiddletown
- Zip02842
- Style
- Year Built1988
- Taxes$ 62581
- Price$ 7,900,000
- Bedrooms4
- Full Bathrooms4
- Half Bathrooms2
- Sqr Footage6131
- Lot Size1.7 Acres
Data Source:
Rhode Island Statewide MLS (RIAR)
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.
| Price History | |
|---|---|
| 5/1/2026 | Listed $8,295,000 |
| 8/21/2026 | 5$7,900,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Forced Air,Oil |
| Cooling | Central Air |
| Utilities | Underground Utilities |
| Possession | Close Plus 45 to 90 Days,Close Through 45 Days,Negotiable |
| Zoning | R60 |
| Garage Spaces | 2 |
| Patio/Porch Features | Deck,Patio |
| Pool Features | In Ground |
| Security Features | Security System Owned |
| Construction Materials | Drywall,Masonry |
| Year Built | 1988 |
| Electric | 200+ Amp Service |
| View | Saltwater,Water |
| Stories Count | 2 |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Tax Year | 2025 |
| Waterfront Features | Beach Front,Ocean Front,Water Access,Walk to Water,Waterfront |
| Community Features | Golf,Marina,Near Hospital,Near Schools,Pool,Recreation Area,Restaurant,Shopping,Tennis Court(s) |
| County | Newport |
| New Construction | false |
| Property Type | Residential |
| Attached Garage | true |
| Garage Y/N | true |
| Other Structures | Guest House,Outbuilding |
| Total Rooms | 15 |
| Full Baths | 4 |
| Status | Active |
| City | Middletown |
| Senior Community Y/N | false |
| Lot Size Units | Square Feet |
| Lot Size Square Feet | 74052 |
| Land Lease Y/N | false |
| Tax Annual Amount | 62581 |
| Standard Status | Active |
| Tax Assessed Value | 5308000 |
| Tax Lot | 166 |
| Property Sub Type Additional | Single Family Residence |
Interior Features
| Interior Amenities | Attic,Wet Bar,Cedar Closet(s),Stall Shower,Tub Shower |
|---|---|
| Basement | Full,Interior Entry,Unfinished |
| Flooring | Ceramic Tile,Hardwood,Carpet |
| Total Fireplaces | 3 |
| Fireplace Features | Masonry,Stone |
| Total Stories | 2 |
| Basement (Y/N) | true |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Thermal Windows |
| Fireplace Y/N | true |
| Half Baths | 2 |
| Total Bedrooms | 4 |
| LivingAreaSource | Public Records |
| Total Baths | 6 |
Exterior Features
| Exterior Amenities | Deck,Patio |
|---|---|
| Parking Features | Attached,Garage |
| Lot Features | Private,Secluded,Waterfront |
| Water Source | Private,Well |
| Total Parking | 10 |
| Lot Size Area | 74052 |
| Foundation Details | Concrete Perimeter |
| Building Area Total | 6131 |
| Lot Size Acres | 1.7 |
| Waterfront Y/N | true |
| Covered Spaces | 2 |
| Door Features | Storm Door(s) |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 02842
Price
Taxes
Year Built
Massachusetts MLS Property Info Network (MLSPIN) - The property listing data and information set forth herein were provided to MLS Property Information Network, Inc. from third party sources, including sellers, lessors and public records, and were compiled by MLS Property Information Network, Inc. The property listing data and information are for the personal, non commercial use of consumers having a good faith interest in purchasing or leasing listed properties of the type displayed to them and
IDX information is provided exclusively for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed. © 2026 State-Wide Multiple Listing Service. All rights reserved.
The data relating to real estate for sale on this website appears in part through the SMARTMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SMARTMLS through a licensing agreement. Listing information is from various brokers who participate in the SMARTMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the
