NOT LISTED FOR SALE

15657 Adagio Way Westfield, IN 46074

Estimated Value: $901,000 - $1,029,000

4 Beds
4.5 Baths
3,170 Sq Ft
$299/Sq Ft Est. Value

Last Sold March 12, 2021

Last sale price $680,000 $215 Per Sq Ft

Est. 39% increase in value since last sale

Current estimated payment $5,821/month

1 Day on Market

Highlights

  • Waterfront
  • Wood Flooring
  • Tudor Architecture
  • Shamrock Springs Elementary School Rated A-
  • Main Floor Bedroom
  • Covered Patio or Porch

About This Home

As of March 2021

A Refined Charming Cottage experience in this well appointed floor plan with luxury finishes. This MOVE-IN-Ready home is part of Estridge's Lockerbie Collection. Open spacious great room, private study & every closet a walk-in for easy storage. Chef's dream gourmet eat-in kitchen w/granite countertops, luxury sub zero SS appliances. Guest ste. & owners retreat on main level w/ ensuite featuring quartz countertops, garden tub, large glass & tile shower & large custom WIC. 2 bdrms upstairs with built-ins & large bonus room. The 9" ceilings in the lower level is open and bright for entertaining. Welcome to Serenade and experience peaceful natural beauty with architecture reflecting timeless elegance and livable sophistication.

Last Agent to Sell the Property

Justin Steill

Berkshire Hathaway Home License #RB14042626 Listed on: 02/15/2021

Berkshire Hathaway Home

Co-Listed By

Stacey Willis

Stacey Willis License #RB14039852

Last Buyer's Agent

Drew Schroeder

eXp Realty, LLC

eXp Realty, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,349

Year Built

  • Built in 2020

Lot Details

  • 7,841 Sq Ft Lot
  • Waterfront
  • Landscaped with Trees

HOA Fees

  • $125 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Side or Rear Entrance to Parking
  • Garage Door Opener

Home Design

  • Tudor Architecture
  • Brick Exterior Construction
  • Block Foundation
  • Cement Siding

Interior Spaces

  • 2-Story Property
  • Built-in Bookshelves
  • Woodwork
  • Tray Ceiling
  • Window Screens
  • Entrance Foyer
  • Great Room with Fireplace
  • Fire and Smoke Detector
  • Laundry on main level

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Double Oven
  • Gas Oven
  • Range Hood
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom

Finished Basement

  • Partial Basement
  • 9 Foot Basement Ceiling Height
  • Sump Pump with Backup
  • Basement Window Egress

Eco-Friendly Details

  • Energy-Efficient HVAC
  • Energy-Efficient Lighting
  • Energy-Efficient Insulation

Outdoor Features

  • Covered Patio or Porch

Schools

  • Shamrock Springs Elementary School
  • Westfield Middle School
  • Westfield High School

Utilities

  • Forced Air Heating System
  • Heating System Uses Gas
  • High-Efficiency Water Heater
  • Gas Water Heater

Community Details

  • Association fees include home owners
  • Serenade Subdivision
  • Property managed by Serenade Owners Association

Listing and Financial Details

  • Tax Lot 6
  • Assessor Parcel Number 0809090002005000

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,349

Year Built

Built in 2020

Lot Details

0

HOA Fees

$125 per month

Parking

3

Listing Details

  • Property Sub Type: Single Family Residence
  • Architectural Style: Tudor
  • Builder Name: Estridge
  • Property Type: Residential
  • New Construction: No
  • Tax Year: 2020
  • Year Built: 2020
  • Building Area Total: 4492
  • Co List Office Phone: 317-595-2100
  • Garage Y N: Yes
  • Green Energy Efficient: Lighting, HVAC, Insulation, Water Heater
  • Lot Size Acres: 0.18
  • Subdivision Name: Serenade
  • Inspection Warranties: Not Applicable
  • Transaction Type: Sale
  • Website: www.staceywillishomes.com
  • MBR_AttributionContact: jsteill@bhhsin.com
  • Special Features: VirtualTour

Interior Features

  • Basement: Yes
  • Basement Type: Ceiling - 9+ feet, Finished, Partial, Egress Window(s), Sump Pump w/Backup
  • Appliances: Dishwasher, Disposal, Gas Oven, Oven, Double Oven, Range Hood, Gas Water Heater
  • Levels: Two
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bathrooms: 5
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1189
  • Fireplace Features: Great Room
  • Fireplaces: 1
  • Interior Amenities: Built In Book Shelves, Tray Ceiling(s), Walk-in Closet(s), Hardwood Floors, Screens Complete, WoodWorkStain/Painted, Breakfast Bar, Bath Sinks Double Main, Eat-in Kitchen, Entrance Foyer, Hi-Speed Internet Availbl, Center Island, Pantry
  • Living Area: 3170
  • Main Level Bedrooms: 2
  • Other Equipment: Smoke Alarm
  • Areas Interior: Bedroom Other on Main
  • Eating Area: Dining Combo/Great Room,Dining Combo/Kitchen
  • Basement Full Bathrooms: 1
  • Main Level Full Bathrooms: 2
  • Main Level Sq Ft: 2235
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 1
  • Upper Level Sq Ft: 935
  • ResoLivingAreaSource: Builder
  • Rooms Basement: 2
  • SqFt Total: 4492

Exterior Features

  • Construction Materials: Brick, Cement Siding
  • Disclosures: Not Applicable
  • Foundation Details: Block, Block
  • List Price: 684000
  • Patio And Porch Features: Covered Patio, Covered Porch
  • Waterfront: Yes
  • Construction Stage: Completed
  • New Construction: Yes

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Attached, Concrete, Garage Door Opener, Rear/Side Entry
  • Garage Parking Other: Keyless Entry
  • Garage Sq Ft: 765

Utilities

  • Utilities: Cable Available, Gas Nearby, Gas
  • Cooling: Central Electric
  • Heating: Forced Air, High Efficiency (90%+ AFUE ), Gas
  • Laundry Features: Main Level
  • Water Source: Municipal/City
  • Solid Waste: No

Condo/Co-op/Association

  • Association Fee: 1500
  • Association Fee Frequency: Annually
  • Association YN: Yes
  • Management Company Name: Serenade Owners Association

Fee Information

  • Association Fee Includes: Association Home Owners, Entrance Common

Schools

  • Middle Or Junior School: Westfield Middle School

Lot Info

  • Lot Features: Sidewalks, Street Lights, Trees-Small (Under 20 Ft)
  • Property Attached Yn: No
  • Additional Parcels: No
  • Lot Size Sq Ft: 0.18
  • Parcel Number: 0809090002005000
  • Acres: <1/4 Acre

Green Features

  • Green Certification Y N: No

Tax Info

  • Tax Lot: 6
  • Semi Annual Property Tax Amt: 0
  • Tax Exemption: None

MLS Schools

  • Elementary School: Shamrock Springs Elementary School
  • High School: Westfield High School
  • Schools: SHAMROCK SPRINGS ELEMENTARY,WESTFIELD HIGH,WESTFIELD MIDDLE,WWIS1000

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 15, 2021
Closed on
Mar 12, 2021
Sold by
Show Case Homes Llc
Bought by
Simpson Brian Rutledge and Simpson Katie Diane
Seller's Agent
Justin Steill
Berkshire Hathaway Home
Buyer's Agent
Drew Schroeder
eXp Realty, LLC
List Price
$684,000
Sold Price
$680,000
Premium/Discount to List
-$4,000
-0.58%
Current Estimated Value
$946,960

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$266,960
Avg. Annual Appreciation
7.58%
Original Mortgage
$544,000
Outstanding Balance
$488,764
Interest Rate
2.7%
Mortgage Type
New Conventional
Estimated Equity
$458,196

Purchase Details

Listed on
Feb 15, 2021
Closed on
Mar 11, 2021
Sold by
Estridge Homes
Bought by
Simpson Brian Rutledge and Simpson Katie Diane
Seller's Agent
Justin Steill
Berkshire Hathaway Home
Buyer's Agent
Drew Schroeder
eXp Realty, LLC
List Price
$684,000
Sold Price
$680,000
Premium/Discount to List
-$4,000
-0.58%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$544,000
Outstanding Balance
$488,764
Interest Rate
2.7%
Mortgage Type
New Conventional
Estimated Equity
$458,196

Purchase Details

Closed on
Oct 7, 2019
Sold by
Ccd Serenade Llc
Bought by
Show Case Homes Llc and Estridge Homes
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Simpson Brian Rutledge -- Near North Title Group
Simpson Brian Rutledge -- Near North Title Group
Show Case Homes Llc -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Simpson Brian Rutledge $544,000
Closed Simpson Brian Rutledge $544,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/12/2021 03/12/21 Sold $680,000 -0.6% $215 / Sq Ft
02/17/2021 02/17/21 Pending -- -- --
02/15/2021 02/15/21 For Sale $684,000 -- $216 / Sq Ft
Source: MIBOR Broker Listing Cooperative®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $8,349 $803,600 $105,000 $698,600
2023 $8,384 $727,800 $105,000 $622,800
2022 $7,926 $706,900 $105,000 $601,900
2021 $7,926 $654,000 $105,000 $549,000
Source: Public Records

Agents Affiliated with this Home

  • Justin Steill

    Seller's Agent in 2021

    Justin Steill

    Berkshire Hathaway Home

    (317) 538-5705

    225 in this area

    635 Total Sales

    Justin Steill
    Section Image
  • Stacey Willis

    Seller Co-Listing Agent in 2021

    Stacey Willis

    Stacey Willis

    (317) 431-3154

    40 in this area

    145 Total Sales

    Stacey Willis
    Section Image

  • D

    Buyer's Agent in 2021

    Drew Schroeder

    eXp Realty, LLC

    Section Image
See All Agents

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: 21765785

MIBOR Broker Listing Cooperative®

APN: 29-09-09-002-005.000-015

Indiana Hamilton County Westfield 46074

15657 Adagio Way, Westfield, IN

This home is located at 15657 Adagio Way, Westfield, IN 46074 since 15 February 2021 and is currently estimated at $946,960, approximately $298 per square foot. This property was built in 2020. 15657 Adagio Way is a home located in Hamilton County with nearby schools including Shamrock Springs Elementary School, Westfield Intermediate School, and Westfield Middle School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

MIBOR Broker Listing Cooperative® Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website.

Nearby Homes