NOT LISTED FOR SALE

15861 Hush Hickory Bend Westfield, IN 46074

Estimated Value: $593,000 - $702,000

3 Beds
2 Baths
3,009 Sq Ft
$209/Sq Ft Est. Value

Last Sold March 22, 2024

Last sale price $570,000 $189 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $3,847/month

27 Days on Market

Highlights

  • Vaulted Ceiling
  • 1.5-Story Property
  • Covered Patio or Porch
  • Shamrock Springs Elementary School Rated A-
  • Main Floor Bedroom
  • Breakfast Room

About This Home

As of March 2024

Welcome home to this cozy ranch in the charming community of Wilshire. This delightful home offers a peaceful primary suite retreat with a tray ceiling, luxury walk in shower, and a large walk-in closet. The heart of the home offers an open family room with kitchen and will be any cooks or entertainers dream. The stunning kitchen boasts vaulted ceilings, quartz countertops, double ovens and much more! This home offers plenty of space - two additional bedrooms, (one bedroom currently serves as an office but offers flexibility for whatever accommodations best suit your lifestyle), a large bonus room upstairs w/ huge walk in closet, and you'll enjoy the finished basement with plenty of unfinished storage. Not to mention it is plumbed for a bathroom. Outside, you'll find the covered rear porch + extended patio for all season grilling or outdoor entertaining! An oversized 3 car garage + 8' garage doors complete this NEWLY built home. Don't miss the opportunity to make this charming property your own!

Last Agent to Sell the Property

Erin Hundley

Compass Indiana, LLC Brokerage Email: erin.hundley@compass.com License #RB15000126 Listed on: 02/01/2024

Compass Indiana, LLC

Co-Listed By

Lauren Giesler

Compass Indiana, LLC Brokerage Email: erin.hundley@compass.com License #RB22001928

Last Buyer's Agent

Melissa Webb

F.C. Tucker Company

F.C. Tucker Company

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,264

Year Built

  • Built in 2020

Lot Details

  • 0.33 Acre Lot
  • Sprinkler System

HOA Fees

  • $50 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • 1.5-Story Property
  • Traditional Architecture
  • Brick Exterior Construction
  • Cement Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • Wired For Sound
  • Woodwork
  • Tray Ceiling
  • Vaulted Ceiling
  • Vinyl Clad Windows
  • Window Screens
  • Entrance Foyer
  • Breakfast Room
  • Fire and Smoke Detector
  • Laundry on main level

Kitchen

  • Double Oven
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • 2 Full Bathrooms

Finished Basement

  • Basement Fills Entire Space Under The House
  • 9 Foot Basement Ceiling Height
  • Sump Pump with Backup
  • Basement Storage
  • Basement Window Egress

Outdoor Features

  • Covered Patio or Porch

Schools

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

Utilities

  • Heating System Uses Gas
  • Programmable Thermostat
  • Electric Water Heater

Community Details

  • Association fees include home owners, parkplayground, management, snow removal
  • Association Phone (317) 706-1706
  • Wilshire Subdivision
  • Property managed by Armour Property Management
  • The community has rules related to covenants, conditions, and restrictions

Listing and Financial Details

  • Tax Lot 69
  • Assessor Parcel Number 290910019030000015

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,264

Year Built

Built in 2020

Lot Details

0

HOA Fees

$50 per month

Parking

3

Listing Details

  • Property Sub Type: Single Family Residence
  • Architectural Style: Ranch, TraditonalAmerican
  • Property Type: Residential
  • New Construction: No
  • Tax Year: 2023
  • Year Built: 2020
  • Building Area Total: 4230
  • Co List Office Phone: 317-563-5051
  • Garage Y N: Yes
  • Lot Size Acres: 0.33
  • Subdivision Name: Wilshire
  • Transaction Type: Sale
  • Accessibility Features YN: No
  • Website: https://wilshireofwestfield.com/
  • MBR_AttributionContact: erin.hundley@compass.com
  • Attribution Contact: erin.hundley@compass.com
  • Special Features: None

Interior Features

  • Basement: Yes
  • Basement Type: Ceiling - 9+ feet, Egress Window(s), Finished Ceiling, Finished Walls, Full, Roughed In, Storage Space
  • Appliances: Gas Cooktop, Dishwasher, Electric Water Heater, Disposal, Microwave, Oven, Double Oven, Range Hood, Refrigerator, Water Softener Owned
  • Levels: One and One Half
  • Full Bathrooms: 2
  • Total Bathrooms: 2
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 574
  • Interior Amenities: Tray Ceiling(s), Vaulted Ceiling(s), Center Island, Entrance Foyer, Pantry, Programmable Thermostat, Screens Complete, Surround Sound Wiring, Walk-in Closet(s), Windows Vinyl, WoodWorkStain/Painted
  • Living Area: 3009
  • Main Level Bedrooms: 3
  • Other Equipment: Smoke Alarm, Sump Pump w/Backup
  • Spa Y N: No
  • Areas Interior: Bedroom Other on Main
  • Eating Area: Breakfast Room
  • Basement Full Bathrooms: 0
  • Main Level Full Bathrooms: 2
  • Main Level Sq Ft: 1795
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 0
  • Kitchen Features: Kitchen Updated
  • Upper Level Sq Ft: 640
  • ResoLivingAreaSource: Assessor
  • Rooms Basement: 1

Exterior Features

  • Construction Materials: Brick, Cement Siding
  • Exterior Features: Sprinkler System
  • Foundation Details: Concrete Perimeter, Full
  • List Price: 569900
  • Patio And Porch Features: Covered Patio, Open Patio
  • Pool Private Y N: No
  • Waterfront: No

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Attached, Storage
  • Garage Parking Other: Finished Garage,Garage Door Opener,Keyless Entry,Service Door
  • Garage Sq Ft: 782

Utilities

  • Utilities: Cable Connected, Electricity Connected, Gas, Sewer Connected, Water Connected
  • Cooling: Central Electric
  • Heating: Gas
  • Laundry Features: Main Level
  • Water Source: Municipal/City
  • Solid Waste: No

Condo/Co-op/Association

  • Association Amenities: Playground
  • Association Fee: 300
  • Association Fee Frequency: Semi-Annually
  • Association Phone: 317-706-1706
  • Association YN: Yes
  • Management Company Name: Armour Property Management
  • H O A Disclosures: Covenants & Restrictions

Fee Information

  • Association Fee Includes: Association Home Owners, Entrance Common, ParkPlayground, Management, Snow Removal

Schools

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

Lot Info

  • Lot Features: Sidewalks
  • Property Attached Yn: No
  • Horse Amenities: None
  • Lot Size Sq Ft: 14375
  • Parcel Number: 290910019030000015
  • Acres: 1/4-1/2 Acre
  • Price Acre: 1726970

Green Features

  • Green Certification Y N: No

Tax Info

  • Tax Annual Amount: 5264
  • Tax Lot: 69
  • Semi Annual Property Tax Amt: 2632
  • Tax Exemption: Homestead Tax Exemption

MLS Schools

  • Elementary School: Shamrock Springs Elementary School
  • High School: Westfield High School

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 1, 2024
Closed on
Mar 27, 2024
Sold by
Gramelspacher Philip
Bought by
Stanley Susan K and Stanley Larry D
Seller's Agent
Erin Hundley
Compass Indiana, LLC
Buyer's Agent
Melissa Webb
F.C. Tucker Company
List Price
$569,900
Sold Price
$570,000
Premium/Discount to List
$100
0.02%
Views
83
Current Estimated Value
$629,281

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$59,281
Avg. Annual Appreciation
6.77%
Original Mortgage
$375,000
Outstanding Balance
$369,279
Interest Rate
6.77%
Mortgage Type
New Conventional
Estimated Equity
$260,002

Purchase Details

Closed on
Mar 16, 2021
Sold by
Drees Premier Homes Inc
Bought by
Gramelspacher Philip

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$418,482
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
Stanley Susan K $570,000 Ata National Title Group
Gramelspacher Philip $440,507 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Stanley Susan K $375,000
Previous Owner Gramelspacher Philip $25,000
Previous Owner Gramelspacher Philip $418,482
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/22/2024 03/22/24 Sold $570,000 0.0% $189 / Sq Ft
02/29/2024 02/29/24 Pending -- -- --
02/27/2024 02/27/24 For Sale $569,900 0.0% $189 / Sq Ft
02/19/2024 02/19/24 Off Market $570,000 -- --
02/01/2024 02/01/24 For Sale $569,900 -- $189 / 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 $5,691 $525,900 $79,300 $446,600
2023 $5,756 $499,400 $79,300 $420,100
2022 $2,594 $452,700 $79,300 $373,400
2021 $2,594 $215,800 $79,300 $136,500
2020 $80 $600 $600 $0
2019 $81 $600 $600 $0
Source: Public Records

Agents Affiliated with this Home

  • Erin Hundley

    Seller's Agent in 2024

    Erin Hundley

    Compass Indiana, LLC

    (317) 430-0866

    700 in this area

    3,435 Total Sales

    Erin Hundley
    Section Image

  • L

    Seller Co-Listing Agent in 2024

    Lauren Giesler

    Compass Indiana, LLC

    (812) 631-1913

    160 in this area

    625 Total Sales

    Lauren Giesler
    Section Image

  • M

    Buyer's Agent in 2024

    Melissa Webb

    F.C. Tucker Company

    Section Image
See All Agents

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: 21961335

MIBOR Broker Listing Cooperative®

APN: 29-09-10-019-030.000-015

Indiana Hamilton County Westfield 46074

15861 Hush Hickory Bend, Westfield, IN

This home is located at 15861 Hush Hickory Bend, Westfield, IN 46074 since 01 February 2024 and is currently estimated at $629,281, approximately $209 per square foot. This property was built in 2020. 15861 Hush Hickory Bend 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