WATERFRONT on INDIAN AVENUE. Céad Míle Failte, “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.
For sale
Price cut: $180K (5/1)
$8,295,000
515 Indian Ave, Middletown, RI 02842
4beds
6,131sqft
Single Family Residence
Built in 1988
1.7 Acres Lot
$-- Zestimate®
$1,353/sqft
$-- HOA
What's special
Extraordinary waterfront compoundWaterfront on indian avenueExpansive water viewsTall gables and half-timberingLush gardensComfortable open floor planSteeply pitched slate roof
- 68 days |
- 3,037 |
- 174 |
Zillow last checked:
Listing updated:
Listed by:
Alexandra Thursby 401-266-9900,
Mott & Chace Sotheby's Intl.
Source: StateWide MLS RI,MLS#: 1411466
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Bathroom
- Features: Bath w Shower Stall, Bath w Tub & Shower
Heating
- Oil, Central Air, Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Exhaust Fan, Microwave, Oven/Range, Refrigerator, Washer
Features
- Wall (Dry Wall), Cedar Closet(s), Wet Bar, Plumbing (Mixed), Insulation (Ceiling), Insulation (Floors), Insulation (Walls), Ceiling Fan(s)
- Flooring: Ceramic Tile, Hardwood, Carpet
- Doors: Storm Door(s)
- Windows: Insulated Windows
- Basement: Full,Interior Entry,Unfinished,Storage Space,Utility
- Number of fireplaces: 3
- Fireplace features: Brick, Stone
Interior area
- Total structure area: 6,131
- Total interior livable area: 6,131 sqft
- Finished area above ground: 6,131
- Finished area below ground: 0
Property
Parking
- Total spaces: 10
- Parking features: Attached
- Attached garage spaces: 2
Accessibility
- Accessibility features: Extra Wide Shower, Flat Thresholds, Accessible Doors
Features
- Patio & porch: Deck, Patio
- Pool features: In Ground
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Waterfront, Access, Ocean Front, Saltwater Front, Walk to Salt Water, Walk To Water
Lot
- Size: 1.7 Acres
- Features: Secluded
Details
- Additional structures: Guest House, Outbuilding
- Parcel number: MIDDM0129B00L166
- Zoning: R60
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Tudor
- Property subtype: Single Family Residence
Materials
- Dry Wall, Masonry
- Foundation: Concrete Perimeter
Condition
- New construction: No
- Year built: 1988
Utilities & green energy
- Electric: 400 Amps
- Sewer: Septic Tank
- Water: Private, Well
- Utilities for property: Underground Utilities
Community & HOA
Community
- Features: Golf, Hospital, Marina, Private School, Public School, Recreational Facilities, Restaurants, Schools, Near Shopping, Near Swimming, Tennis
- Security: Security System Owned
HOA
- Has HOA: No
Location
- Region: Middletown
Financial & listing details
- Price per square foot: $1,353/sqft
- Tax assessed value: $5,308,000
- Annual tax amount: $62,581
- Date on market: 5/1/2026
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/1/2026 | Price change | $8,295,000-2.1%$1,353/sqft |
Source:  StateWide MLS RI #1411471 Report a problem | ||
| 9/10/2025 | Listed for sale | $8,475,000+41.4%$1,382/sqft |
Source: StateWide MLS RI #1394051 Report a problem | ||
| 6/11/2025 | Listing removed | $55,000$9/sqft |
Source: Zillow Rentals Report a problem | ||
| 5/21/2025 | Listed for rent | $55,000-15.4%$9/sqft |
Source: Zillow Rentals Report a problem | ||
| 12/16/2024 | Listing removed | $65,000$11/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/20/2024 | Listed for rent | $65,000$11/sqft |
Source: Zillow Rentals Report a problem | ||
| 5/27/2011 | Listing removed | $5,995,000+84.5%$978/sqft |
Source: Lila Delman Real Estate, Ltd. #967836 Report a problem | ||
| 7/15/2010 | Sold | $3,250,000-45.8%$530/sqft |
Source: Public Record Report a problem | ||
| 6/11/2010 | Price change | $5,995,000-7.8%$978/sqft |
Source: Lila Delman Real Estate, Ltd. #967836 Report a problem | ||
| 5/30/2010 | Listed for sale | $6,500,000$1,060/sqft |
Source: Lila Delman Real Estate, Ltd. #967836 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $59,768 | $5,308,000 |
| 2024 | $59,768 +16% | $5,308,000 +23.9% |
| 2023 | $51,504 | $4,284,900 |
| 2022 | $51,504 | $4,284,900 |
| 2021 | $51,504 -5.6% | $4,284,900 +8.1% |
| 2020 | $54,539 +0.1% | $3,963,600 |
| 2018 | $54,500 -10.6% | $3,963,600 +0.3% |
| 2016 | $60,944 +2.5% | $3,952,300 |
| 2015 | $59,443 +42.4% | $3,952,300 +52.1% |
| 2014 | $41,756 +2.3% | $2,598,400 |
| 2013 | $40,821 +2% | $2,598,400 |
| 2012 | $40,015 -15.3% | $2,598,400 -26.5% |
| 2011 | $47,222 -7.1% | $3,534,600 -7.1% |
| 2010 | $50,825 +0.9% | $3,804,300 |
| 2009 | $50,369 +20.7% | $3,804,300 +0.4% |
| 2007 | $41,722 +3.9% | $3,789,500 |
| 2006 | $40,169 -13.1% | $3,789,500 +34% |
| 2005 | $46,230 +6.5% | $2,827,500 |
| 2004 | $43,402 | $2,827,500 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 02842
Nearby schools
GreatSchools rating
- 8/10Joseph Gaudet AcademyGrades: 4-5Distance: 2.2 mi
- 6/10Joseph H. Gaudet SchoolGrades: 6-8Distance: 2.2 mi
- 6/10Middletown High SchoolGrades: 9-12Distance: 2.5 mi
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Rhode Island
- Newport County
- Middletown
- 02842
- 515 Indian Ave
Nearby cities
Nearby zip codes
Other Middletown Topics
