NOT LISTED FOR SALE

847 Old Ashbury Rd Westfield, IN 46074

Estimated Value: $2,627,000 - $3,487,000

6 Beds
8 Baths
10,207 Sq Ft
$292/Sq Ft Est. Value

Last Sold January 10, 2024

Last sale price $3,250,000 $318 Per Sq Ft

Est. 8% decrease in value since last sale

Current estimated payment $18,401/month

53 Days on Market

Highlights

  • Golf Course Community
  • Fitness Center
  • 0.64 Acre Lot
  • Monon Trail Elementary School Rated A-
  • Gated Community
  • Craftsman Architecture

About This Home

As of January 2024

Step into luxury in this exceptional custom-built home in Chatham Hills! Enjoy unique features such as a 3 level elevator (connecting to private in-law suite), 5-Car heated garage, & a perfect entertainment basement w/ 13ft ceilings. This home offers plenty of space: 6 BRs, 6/2 baths, and over 10,000sf. Beautiful custom kitchen is carefully designed w/ premium appliances, plenty of storage, & a gorgeous center island. Main level Primary suite incl. spa-like bath w/ heated floors. There are multiple options to put in a golf simulator/sport area for year-round entertainment! Step outside & find an expansive covered deck w/ full outdoor kitchen, spacious Gunite hot tub, & large, flat backyard. Home is available to be purchased fully-furnished.

Last Agent to Sell the Property

Mike Deck

Berkshire Hathaway Home Brokerage Email: mdeck@bhhsin.com License #RB14023177 Listed on: 09/29/2023

Berkshire Hathaway Home

Last Buyer's Agent

Laura Heigl

CENTURY 21 Scheetz

CENTURY 21 Scheetz

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $29,294

Year Built

  • Built in 2017

Lot Details

  • 0.64 Acre Lot
  • Corner Lot
  • Sprinkler System

HOA Fees

  • $112 Monthly HOA Fees

Parking

  • 4 Car Attached Garage

Home Design

  • Craftsman Architecture
  • Cement Siding
  • Concrete Perimeter Foundation
  • Stone

Interior Spaces

  • 1-Story Property
  • Wet Bar
  • Home Theater Equipment
  • Wired For Sound
  • Built-in Bookshelves
  • Bar Fridge
  • Woodwork
  • Cathedral Ceiling
  • Gas Log Fireplace
  • Entrance Foyer
  • Great Room with Fireplace
  • 2 Fireplaces
  • Wood Flooring

Kitchen

  • Breakfast Bar
  • Gas Oven
  • Range Hood
  • Microwave
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite
  • Dual Vanity Sinks in Primary Bathroom

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • 9 Foot Basement Ceiling Height

Home Security

  • Security System Owned
  • Fire and Smoke Detector

Outdoor Features

  • Gunite Spa
  • Deck
  • Covered Patio or Porch

Schools

  • Monon Trail Elementary School
  • Westfield Middle School
  • Westfield Intermediate School
  • Westfield High School

Utilities

  • Forced Air Heating System
  • Dual Heating Fuel
  • Heating System Uses Gas
  • Programmable Thermostat
  • Gas Water Heater

Listing and Financial Details

  • Tax Lot E14,
  • Assessor Parcel Number 290523001002000015

Community Details

Overview

  • Association fees include clubhouse, exercise room, golf, maintenance, parkplayground, snow removal, tennis court(s)
  • Chatham Hills Subdivision
  • Property managed by Chatham Hills
  • The community has rules related to covenants, conditions, and restrictions

Recreation

  • Golf Course Community
  • Tennis Courts
  • Fitness Center
  • Community Pool

Additional Features

  • Clubhouse
  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$29,294

Year Built

Built in 2017

Lot Details

0

HOA Fees

$112 per month

Parking

4

Listing Details

  • Property Sub Type: Single Family Residence
  • Architectural Style: Craftsman
  • Builder Name: Christopher Scott
  • Property Type: Residential
  • New Construction: No
  • Tax Year: 2022
  • Year Built: 2017
  • Building Area Total: 10723
  • Garage Y N: Yes
  • Lot Size Acres: 0.64
  • Subdivision Name: Chatham Hills
  • Transaction Type: Sale
  • Website: https://youtu.be/jOxS5lbJeJo?si=3YrBhyOH98Ux7QZs
  • Accessibility Features YN: No
  • MBR_AttributionContact: mdeck@bhhsin.com
  • Attribution Contact: mdeck@bhhsin.com
  • Special Features: VirtualTour

Interior Features

  • Basement: Yes
  • Basement Type: Ceiling - 9+ feet, Finished, Full, Walk Out
  • Appliances: Dishwasher, Dryer, Disposal, Microwave, Gas Oven, Range Hood, Refrigerator, Bar Fridge, Ice Maker, Washer, Gas Water Heater, Water Softener Owned
  • Levels: One
  • Full Bathrooms: 6
  • Half Bathrooms: 2
  • Total Bathrooms: 8
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 3780
  • Fireplace Features: Gas Log, Great Room, Other
  • Fireplaces: 2
  • Interior Amenities: Bath Sinks Double Main, Breakfast Bar, Built In Book Shelves, Cathedral Ceiling(s), Vaulted Ceiling(s), Center Island, Central Vacuum, Elevator, Entrance Foyer, Hardwood Floors, In-Law Arrangement, Pantry, Programmable Thermostat, Surround Sound Wiring, Walk-in Closet(s), Wet Bar, Wood Work Painted
  • Living Area: 10207
  • Other Equipment: Security Alarm Paid, Smoke Alarm, Theater Equipment
  • Spa Features: Gunite
  • Spa Y N: Yes
  • Areas Interior: Bedroom Other on Main,Great Room - 2 Story
  • Eating Area: Formal Dining Room,Dining Combo/Kitchen
  • Basement Full Bathrooms: 1
  • Main Level Full Bathrooms: 2
  • Main Level Sq Ft: 3730
  • Basement Half Bathrooms: 1
  • Main Half Bathrooms: 1
  • Kitchen Features: Kitchen Updated
  • Upper Level Sq Ft: 2697
  • ResoLivingAreaSource: Builder

Exterior Features

  • Construction Materials: Cement Siding, Stone
  • Exterior Features: Clubhouse, Sprinkler System, Tennis Community
  • Foundation Details: Concrete Perimeter
  • Patio And Porch Features: Deck Main Level, Covered Porch

Garage/Parking

  • Garage Spaces: 4
  • Parking Features: Attached
  • Garage Parking Other: Finished Garage

Utilities

  • Cooling: Central Electric
  • Heating: Dual, Forced Air, Gas
  • Laundry Features: Main Level
  • Water Source: Municipal/City
  • Solid Waste: No

Condo/Co-op/Association

  • Association Amenities: Pool
  • Association Fee: 1345
  • Association Fee Frequency: Annually
  • Association YN: Yes
  • Community Features: Clubhouse, Curbs, Fitness Center, Gated, Golf, Pool, Restaurant, Sidewalks, Tennis Court(s)
  • Management Company Name: Chatham Hills
  • H O A Disclosures: Covenants & Restrictions

Fee Information

  • Association Fee Includes: Clubhouse, Entrance Common, Exercise Room, Golf, Maintenance, ParkPlayground, Snow Removal, Tennis Court(s)

Schools

  • Middle Or Junior School: Westfield Middle School
  • MBR_IntermediateSchool: Westfield Intermediate School

Lot Info

  • Lot Features: Corner Lot, Gated Community, Sidewalks
  • Property Attached Yn: No
  • Additional Parcels: No
  • Horse Amenities: None
  • Lot Size Sq Ft: 27878
  • Parcel Number: 290523001002000015
  • Acres: 1/2-1 Acre

Green Features

  • Green Certification Y N: No

Tax Info

  • Tax Annual Amount: 29294
  • Tax Lot: E14,
  • Semi Annual Property Tax Amt: 14647
  • Tax Exemption: Homestead Tax Exemption,Mortgage Tax Exemption

MLS Schools

  • Elementary School: Monon Trail Elementary School
  • High School: Westfield High School

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 29, 2023
Closed on
Jan 10, 2024
Sold by
Duerr Gordon J and Duerr Katherine R
Bought by
Martin-Long Kenneth Scot and Martin-Long Michael
Seller's Agent
Mike Deck
Berkshire Hathaway Home
Buyer's Agent
Laura Heigl
CENTURY 21 Scheetz
List Price
$3,250,000
Sold Price
$3,250,000
Views
72
Current Estimated Value
$2,984,734

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$265,266
Avg. Annual Appreciation
-4.45%
Original Mortgage
$900,000
Outstanding Balance
$827,640
Interest Rate
5.25%
Mortgage Type
New Conventional
Estimated Equity
$2,157,094

Purchase Details

Listed on
Sep 29, 2023
Closed on
Jan 9, 2024
Sold by
Duerr Gordon J and Duerr Katherine R
Bought by
Martin-Long Kenneth Scot and Martin-Long Michael
Seller's Agent
Mike Deck
Berkshire Hathaway Home
Buyer's Agent
Laura Heigl
CENTURY 21 Scheetz
List Price
$3,250,000
Sold Price
$3,250,000
Views
72

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$900,000
Outstanding Balance
$827,640
Interest Rate
5.25%
Mortgage Type
New Conventional
Estimated Equity
$2,157,094

Purchase Details

Closed on
Aug 8, 2016
Sold by
Chatham Hills Llp
Bought by
Duerr Gordon J and Duerr Katherine R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$183,750
Interest Rate
3.5%
Mortgage Type
Adjustable Rate Mortgage/ARM
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Martin-Long Kenneth Scot -- Indiana Home Title
Martin-Long Kenneth Scot $3,250,000 Indiana Home Title
Duerr Gordon J -- Chicago Title Co Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Martin-Long Kenneth Scot $900,000
Closed Martin-Long Kenneth Scot $900,000
Previous Owner Duerr Gordon J $183,750
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/10/2024 01/10/24 Sold $3,250,000 0.0% $318 / Sq Ft
11/22/2023 11/22/23 Pending -- -- --
09/29/2023 09/29/23 For Sale $3,250,000 -- $318 / 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 $30,309 $2,605,800 $243,900 $2,361,900
2023 $30,374 $2,588,400 $243,900 $2,344,500
2022 $29,361 $2,442,100 $243,900 $2,198,200
2021 $27,938 $2,243,100 $243,900 $1,999,200
2020 $28,035 $2,224,500 $243,900 $1,980,600
2019 $27,783 $2,204,900 $243,900 $1,961,000
2018 $11,386 $916,300 $243,900 $672,400
2017 $6,836 $243,900 $243,900 $0
2016 $82 $600 $600 $0
Source: Public Records

Agents Affiliated with this Home

  • Mike Deck

    Seller's Agent in 2024

    Mike Deck

    Berkshire Hathaway Home

    (317) 339-2830

    129 in this area

    667 Total Sales

    Mike Deck
    Section Image

  • L

    Buyer's Agent in 2024

    Laura Heigl

    CENTURY 21 Scheetz

    Section Image
See All Agents

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: 21945439

MIBOR Broker Listing Cooperative®

APN: 29-05-23-001-002.000-015

Indiana Hamilton County Westfield 46074

847 Old Ashbury Rd, Westfield, IN

Not Listed for Sale

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