NOT LISTED FOR SALE

15274 Brownspring Dr Westfield, IN 46074

Estimated Value: $581,292 - $622,000

5 Beds
2.5 Baths
3,955 Sq Ft
$150/Sq Ft Est. Value

Last Sold August 03, 2021

Last sale price $460,000 $116 Per Sq Ft

Est. 29% increase in value since last sale

Current estimated payment $3,612/month

4 Days on Market

Highlights

  • Traditional Architecture
  • Breakfast Room
  • 3 Car Attached Garage
  • Shamrock Springs Elementary School Rated A-
  • Thermal Windows
  • Woodwork

About This Home

As of August 2021

This is M/I Homes' popular "Holcomb C" 5 bedroom 2.5 bath 3 car garage basement home plan in wonderful Westchester in Westfield! Great pond home site! Fabulous front porch and Craftsman elevation! 9' 1st floor ceilings! Luxury vinyl plank flooring throughout main level! Morning room! Beautiful 42" Kona cabinets w/crown molding in kitchen! Huge center island with breakfast bar top! Quartz kitchen counter tops! Great room features a beautiful white mantel gas log fireplace! Upstairs you will find five large bedrooms and an owner's suite with trey ceiling, double sink vanity, large oval soaking tub and walk-in tile shower! Upgrades too numerous to mention! Schedule your showing today!

Last Agent to Sell the Property

Richard Gillette

Highgarden Real Estate License #RB14039114 Listed on: 06/24/2021

Last Buyer's Agent

Tina Smith

CENTURY 21 Scheetz

CENTURY 21 Scheetz

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $300

Year Built

  • Built in 2021

Lot Details

  • 0.25 Acre Lot

HOA Fees

  • $68 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Cement Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • Woodwork
  • Gas Log Fireplace
  • Thermal Windows
  • Vinyl Clad Windows
  • Window Screens
  • Great Room with Fireplace
  • Breakfast Room
  • Basement Fills Entire Space Under The House
  • Attic Access Panel
  • Fire and Smoke Detector
  • Laundry on upper level

Kitchen

  • Gas Oven
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Gas Water Heater

Community Details

  • Association fees include home owners, insurance, maintenance, management
  • Westchester Subdivision
  • Property managed by AAM
  • The community has rules related to covenants, conditions, and restrictions

Listing and Financial Details

  • Assessor Parcel Number 15274BrownspringDrive,Westfield,IN46074

Home Details

Home Type

Single Family

Est. Annual Taxes

$300

Year Built

Built in 2021

Lot Details

0

HOA Fees

$68 per month

Parking

3

Listing Details

  • Property Sub Type: Single Family Residence
  • Architectural Style: TraditonalAmerican
  • Builder Name: M/I Homes
  • Property Type: Residential
  • New Construction: No
  • Tax Year: 2020
  • Year Built: 2021
  • Building Area Total: 3955
  • Garage Y N: Yes
  • Lot Size Acres: 0.251
  • Subdivision Name: WESTCHESTER
  • Inspection Warranties: Warranty Builders
  • Transaction Type: Sale
  • Open House Count: 0
  • Open House Public Count: 0
  • Special Features: NewHome

Interior Features

  • Basement: Yes
  • Basement Type: Full
  • Appliances: Dishwasher, Disposal, Microwave, Gas Oven
  • Levels: Two
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bathrooms: 3
  • Total Bedrooms: 5
  • Fireplace Features: Gas Log, Great Room
  • Fireplaces: 1
  • Interior Amenities: Attic Access, Walk-in Closet(s), Screens Complete, Windows Thermal, Windows Vinyl, Wood Work Painted
  • Other Equipment: Smoke Detector
  • Areas Interior: Laundry Room Upstairs
  • Eating Area: Breakfast Room
  • Basement Full Bathrooms: 0
  • Main Level Full Bathrooms: 0
  • Sq Ft Main Upper: 2721
  • Main Level Sq Ft: 1234
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 1
  • Kitchen Features: Breakfast Bar,Center Island,Pantry
  • Below Grade Sq Ft: 1234
  • Upper Level Sq Ft: 1487
  • Pct Optional Level Finished: 0-25%

Exterior Features

  • Construction Materials: Brick, Cement Siding
  • Disclosures: Not Applicable
  • Exterior Features: Driveway Concrete
  • Foundation Details: Concrete Perimeter
  • List Price: 450000
  • Association Maintained Building Exterior: 0
  • Construction Stage: Completed
  • Porch: Open Patio,Covered Porch

Garage/Parking

  • Garage Spaces: 3
  • Fuel: Gas
  • Garage Parking Description: Attached
  • Garage Parking Other: Garage Door Opener

Utilities

  • Sewer: Sewer Connected
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Solid Waste: 0
  • Utility Options: Cable Available,Gas Connected
  • Water Heater: Gas

Condo/Co-op/Association

  • Association Fee: 410
  • Association Fee Frequency: Semi-Annually
  • Management Company Name: AAM
  • Management Company Phone: 248-382-4001
  • H O A Disclosures: Covenants & Restrictions

Fee Information

  • Association Fee Includes: Association Home Owners, Insurance, Maintenance, Management

Lot Info

  • Property Attached Yn: No
  • Parcel Number: 15274BrownspringDrive,Westfield,IN46074
  • Acres: 1/4-1/2 Acre
  • Lot Information: Sidewalks,Storm Sewer
  • Lot Number: 15
  • Lot Size: 10,935

Green Features

  • Green Certification Y N: 0

Tax Info

  • Tax Annual Amount: 300
  • Semi Annual Property Tax Amt: 150
  • Tax Exemption: None

MLS Schools

  • School District: Westfield-Washington

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 24, 2021
Closed on
Aug 3, 2021
Sold by
Casteel Mark W
Bought by
Hernandez Jonathan and Hernandez Adrian
Seller's Agent
Richard Gillette
Highgarden Real Estate
Buyer's Agent
Tina Smith
CENTURY 21 Scheetz
List Price
$450,000
Sold Price
$460,000
Premium/Discount to List
$10,000
2.22%
Current Estimated Value
$592,573

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$132,573
Avg. Annual Appreciation
6.25%
Original Mortgage
$359,805
Outstanding Balance
$327,662
Interest Rate
3%
Mortgage Type
New Conventional
Estimated Equity
$264,911

Purchase Details

Listed on
Feb 17, 2021
Closed on
Feb 19, 2021
Sold by
Mi Homes Of Indiana Lp
Bought by
Casteel Mark W and Mullen Courtney M
Seller's Agent
Non-BLC Member
MIBOR REALTOR® Association
Buyer's Agent
Richard Gillette
Highgarden Real Estate
List Price
$387,765
Sold Price
$396,455
Premium/Discount to List
$8,690
2.24%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
39.15%
Original Mortgage
$317,164
Interest Rate
2.7%
Mortgage Type
New Conventional
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
Hernandez Jonathan $4,600 None Available
Casteel Mark W $396,455 Transohio Res Ttl Agcy Ltd
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hernandez Jonathan $359,805
Previous Owner Casteel Mark W $317,164
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/03/2021 08/03/21 Sold $460,000 +2.2% $116 / Sq Ft
06/28/2021 06/28/21 Pending -- -- --
06/24/2021 06/24/21 For Sale $450,000 +13.5% $114 / Sq Ft
02/19/2021 02/19/21 Sold $396,455 +2.2% $145 / Sq Ft View Prior Sale
02/18/2021 02/18/21 Pending -- -- --
02/17/2021 02/17/21 For Sale $387,765 -- $142 / 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 $4,674 $472,200 $93,000 $379,200
2023 $4,709 $411,300 $93,000 $318,300
2022 $2,914 $381,800 $93,000 $288,800
2021 $2,914 $244,400 $93,000 $151,400
Source: Public Records

Agents Affiliated with this Home

  • Richard Gillette

    Seller's Agent in 2021

    Richard Gillette

    Highgarden Real Estate

    (317) 716-5255

    17 in this area

    148 Total Sales

    Richard Gillette
    Section Image

  • N

    Seller's Agent in 2021

    Non-BLC Member

    MIBOR REALTOR® Association

    Non-BLC Member
    Section Image

  • T

    Buyer's Agent in 2021

    Tina Smith

    CENTURY 21 Scheetz

    Section Image
See All Agents

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: 21791051

MIBOR Broker Listing Cooperative®

APN: 29-09-16-010-015.000-015

Indiana Hamilton County Westfield 46074

15274 Brownspring Dr, Westfield, IN

This home is located at 15274 Brownspring Dr, Westfield, IN 46074 since 24 June 2021 and is currently estimated at $592,573, approximately $149 per square foot. This property was built in 2021. 15274 Brownspring Dr 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