$8,475,000

515 Indian Ave Middletown, RI 02842

Estimated payment $50,135/month

Total Views 1,421
4 Beds
6 Baths
6,131 Sq Ft
$1,382 Price per Sq Ft

Highlights

  • Very Popular Property
  • Guest House
  • Indoor Pool
  • Marina
  • Golf Course Community
  • Waterfront

About This Home

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 master 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.

Listing Agent

Alexandra Thursby

Mott & Chace Sotheby's Intl. License #RES.0035586 Listed on: 09/04/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $59,768

Year Built

  • Built in 1988

Lot Details

  • 1.7 Acre Lot
  • Waterfront
  • Private Lot
  • Secluded Lot
  • Property is zoned R60

Parking

  • 2 Car Attached Garage

Home Design

  • Antique Architecture
  • Concrete Perimeter Foundation
  • Masonry

Interior Spaces

  • 6,131 Sq Ft Home
  • 2-Story Property
  • 3 Fireplaces
  • Stone Fireplace
  • Thermal Windows
  • Water Views
  • Dryer

Kitchen

  • Oven
  • Range
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Cedar Closet

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Interior Basement Entry

Accessible Home Design

  • Accessible Full Bathroom
  • Accessibility Features
  • Accessible Doors

Outdoor Features

  • Indoor Pool
  • Water Access
  • Deck
  • Patio
  • Outbuilding

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Oil
  • Underground Utilities
  • 200+ Amp Service
  • Private Water Source
  • Well
  • Oil Water Heater
  • Septic Tank

Additional Features

  • Guest House
  • Property near a hospital

Listing and Financial Details

  • Tax Lot 166
  • Assessor Parcel Number 515INDIANAVMDLT

Community Details

Overview

  • Indian Avenue Subdivision

Amenities

  • Shops
  • Restaurant

Recreation

  • Marina
  • Golf Course Community
  • Tennis Courts
  • Recreation Facilities

Home Details

Home Type

Single Family

Est. Annual Taxes

$59,768

Year Built

Built in 1988

Lot Details

0

Parking

2

Listing Details

  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Business Type: Other
  • Lot Size Acres: 1.7
  • Subdivision Name: Indian Avenue
  • Above Grade Finished Sq Ft: 6131.0
  • Architectural Style: Cabin, Historic/Antique
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Year Built: 1988
  • Property Sub Type Additional: Single Family Residence
  • Special Features: None
  • Stories: 2

Interior Features

  • Appliances: Dryer, Dishwasher, Microwave, Oven, Oil Water Heater, Range, Refrigerator
  • Accessibility Features: Accessibility Features, Accessible Full Bath, Accessible Doors
  • Has Basement: Full, Interior Entry, Unfinished
  • Basement YN: Yes
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace Features: Stone
  • Fireplaces: 3
  • Fireplace: Yes
  • Flooring: Ceramic Tile, Hardwood, Carpet
  • Interior Amenities: Cedar Closet(s)
  • Living Area: 6131.0
  • Stories: 2
  • Window Features: Thermal Windows

Exterior Features

  • Lot Features: Private, Secluded, Waterfront
  • Pool Features: Indoor
  • View: Water
  • View: Yes
  • Waterfront Features: Water Access, Waterfront
  • Waterfront: Yes
  • Construction Type: Drywall, Masonry
  • Exterior Features: Deck, Patio
  • Foundation Details: Concrete Perimeter
  • Other Structures: Guest House, Outbuilding
  • Patio And Porch Features: Deck, Patio

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2.0
  • Garage Spaces: 2.0
  • Parking Features: Attached, Garage
  • Total Parking Spaces: 10.0

Utilities

  • Cooling: Central Air
  • Cooling Y N: Yes
  • Heating: Forced Air, Oil
  • Heating Yn: Yes
  • Electric: 200+ Amp Service
  • Sewer: Septic Tank
  • Utilities: Underground Utilities
  • Water Source: Private, Well

Condo/Co-op/Association

  • Community Features: Golf, Marina, Near Hospital, Near Schools, Recreation Area, Restaurant, Shopping, Tennis Court(s)
  • Senior Community: No

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 74052.0
  • Parcel #: 515INDIANAVMDLT
  • Zoning: R60

Tax Info

  • Tax Annual Amount: 59768.0
  • Tax Lot: 166
  • Tax Map Number: 129
  • Tax Year: 2024

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/04/2025 09/04/25 For Sale $8,475,000 -- $1,382 / Sq Ft
Source: State-Wide MLS

Source: State-Wide MLS

MLS Number: 1394051

State-Wide MLS

APN: MIDD M:0129 B:00 L:166