NOT LISTED FOR SALE

15802 Spring Mill Rd Westfield, IN 46074

Estimated Value: $386,000 - $664,894

3 Beds
2 Baths
2,072 Sq Ft
$254/Sq Ft Est. Value

Last Sold October 04, 2021

Last sale price $485,000 $234 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $3,280/month

4 Days on Market

Highlights

  • Covered patio or porch
  • Detached Garage
  • Combination Kitchen and Dining Room
  • Shamrock Springs Elementary School Rated A-
  • Eat-In Kitchen
  • 2-minute walk to Mulberry Farms Playground

About This Home

As of October 2021

Quaint farmhouse sitting on 4.1 +/- acres in Westfield! Property includes two barns with with electrical and heating, and two grain storage bins. Location and acreage offers endless potential from single family, residential development, and potential commercial use. Build your dream home, or renovate and make it your own. Close proximity to downtown Westfield and Clay Terrace, as well as sits just minutes from the Carmel Arts and Design District.

Last Agent to Sell the Property

Dick Richwine

Berkshire Hathaway Home License #RB14006231 Listed on: 08/27/2021

Berkshire Hathaway Home

Co-Listed By

Sam Snell

Berkshire Hathaway Home License #RB14041918

Last Buyer's Agent

Cindy Cherf

Keller Williams Indpls Metro N

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,850

Year Built

  • 1920

Lot Details

  • 4.1

Parking

  • Detached Garage

Interior Spaces

  • Combination Kitchen and Dining Room
  • Eat-In Kitchen

Outdoor Features

  • Covered patio or porch

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,850

Year Built

1920

Lot Details

0

Parking

1

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Inspection Warranties: Not Applicable
  • Transaction Type: Sale
  • Architectural Style: National/Farmhouse
  • Co List Office Mls Id: MBRBHHS01
  • Co List Office Phone: 317-595-2100
  • Directions: From US31 and 161st St. Head West on 161st to Spring Mill Rd., Turn South. Property will be on the West side of Spring Mill Rd. just past Spring Mill Depot Dr.
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Subdivision Name: NO SUBDIVISION
  • Special Features: None
  • Year Built: 1920

Interior Features

  • Appliances: Dishwasher, Electric Oven, Refrigerator
  • Eating Area: Dining Combo/Kitchen
  • Basement Full Bathrooms: 0
  • Main Level Full Bathrooms: 1
  • Sq Ft Main Upper: 2072
  • Main Level Sq Ft: 1604
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 0
  • Kitchen Features: Kitchen Eat In
  • Upper Level Sq Ft: 468
  • Basement YN: No
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Interior Amenities: Built In Book Shelves, Windows Wood
  • Other Equipment: Smoke Detector, Water-Softener Owned

Exterior Features

  • Exterior Features: Barn Pole, Barn Storage
  • Foundation Details: Crawl Space, Block
  • Association Maintained Building Exterior: 0
  • Porch: Covered Porch
  • Construction Type: Vinyl Siding
  • Disclosures: Not Applicable

Garage/Parking

  • Fuel: Propane,Propane Owned
  • Garage Parking Description: Detached
  • Garage Spaces: 1

Utilities

  • Cooling: None
  • Heating: Baseboard
  • Solid Waste: 0
  • Water Heater: Electric
  • Sewer: Septic Tank
  • Water Source: Well

Lot Info

  • Acres: 3-5 Acres
  • Lot Number: 08091000
  • Lot Size: 178,596

Green Features

  • Green Certification Y N: 0

Tax Info

  • Semi Annual Property Tax Amt: 1925
  • Tax Exemption: HomesteadTaxExemption
  • Tax Annual Amount: 3850
  • Tax Year: 2020

MLS Schools

  • School District: Westfield-Washington

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 27, 2021
Closed on
Oct 1, 2021
Sold by
Vj & Hm Properties Llc
Bought by
Koester Justin T
Seller's Agent
Dick Richwine
Berkshire Hathaway Home
Buyer's Agent
Cindy Cherf
Keller Williams Indpls Metro N
List Price
$495,000
Sold Price
$485,000
Premium/Discount to List
-$10,000
-2.02%
Total Days on Market
4
Current Estimated Value
$526,974

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$41,974
Avg. Annual Appreciation
-2.15%
Original Mortgage
$436,500
Outstanding Balance
$404,893
Interest Rate
2.8%
Mortgage Type
New Conventional
Estimated Equity
$42,863

Purchase Details

Closed on
Mar 29, 2013
Sold by
Davis Nancy S
Bought by
Vj & Hm Properties Llc

Purchase Details

Closed on
Apr 17, 2008
Sold by
Davis Helen M
Bought by
Davis Helen M and Davis Nancy

Purchase Details

Closed on
Nov 28, 2005
Sold by
Davis Vesser John and Davis Helen M
Bought by
Davis Vesser John and Vesser John Davis Revocable Trust
Source: Public Records

Similar Homes in Westfield, IN

  • 107 W Columbine Ln, Westfield, IN 46074

    $575,000

    • 4 Beds
    • 2.5 Baths
    • 4,161 Sq Ft
    • 107 W Columbine Ln
    • Westfield, IN

    Cannonball into summer with this 4 bed, 2.5 bath gem-featuring a sparkling in-ground pool with a fountain, new heater, newer chlorinator, and a patio so spacious, it practically begs for a backyard bash. Step inside to a show-stopping, fully remodeled kitchen that's as functional as it is fabulous-quartz counters, brand-new appliances, and cabinetry so nice you might just start cooking for fun.

    Scott White @properties

    Section Image
  • 19283 Donelson Ln, Westfield, IN 46062

    $499,900

    • 3 Beds
    • 3 Baths
    • 2,676 Sq Ft
    • 19283 Donelson Ln
    • Westfield, IN

    Gorgeous 3 bed 3 bath ranch with loft and 3 car garage in Scofield Farms. Your new home has a wide open floor plan. The gourmet kitchen is a chef's dream with double ovens, a center island and plenty of prep space. The living room is perfect for entertaining and includes a gas fireplace. The 3 bedrooms are thoughtfully separated from the living area by a custom barn door. The primary suite has a

    Jason Kraus RE/MAX Advanced Realty

    Section Image
  • 358 W Tansey Crossing, Westfield, IN 46074

    $500,000

    • 5 Beds
    • 2.5 Baths
    • 3,911 Sq Ft
    • 358 W Tansey Crossing
    • Westfield, IN

    Welcome to your dream home! This exceptionally spacious 5-bedroom residence offers far more than meets the eye. The stunning open-concept layout seamlessly connects the gourmet kitchen, breakfast nook, and family room—perfect for entertaining and family gatherings. Enjoy the formal dining room with an extra living space, ensuring room for everyone. Don't miss the cozy den complete with a

    Gina Key The Hardie Group

    Section Image
  • 15409 Heath Cir, Westfield, IN 46074

    $480,000

    • 4 Beds
    • 2.5 Baths
    • 2,832 Sq Ft
    • 15409 Heath Cir
    • Westfield, IN

    Tucked away on a quiet cul-de-sac, this warm and welcoming 4BR/2.5BA traditional home offers the perfect blend of timeless charm and everyday functionality. Inside, you'll love the light-filled, open layout featuring a soaring two-story great room and an updated kitchen with brand-new countertops-ideal for gathering with family and friends. Upstairs, four spacious bedrooms include a generous

    Lauren Blake Berkshire Hathaway Home

    Section Image
  • 45 E Wisteria Way, Westfield, IN 46074

    $422,000

    • 4 Beds
    • 2.5 Baths
    • 2,096 Sq Ft
    • 45 E Wisteria Way
    • Westfield, IN

    Yes to this house! Welcome to this beautiful 4-bedroom, 2.5-bath home that's ready for its new owners! The kitchen is a standout, featuring high-end stainless steel appliances, granite countertops, and a large island with cabinet storage-perfect for entertaining or everyday use. Relax in the cozy family room with a gas fireplace, or enjoy meals in the formal dining room. A flexible front room

    Karen O'Neill Hoosier, REALTORS®

    Section Image
  • 16247 Countryside Blvd, Westfield, IN 46074

    $499,999

    • 5 Beds
    • 3.5 Baths
    • 3,590 Sq Ft
    • 16247 Countryside Blvd
    • Westfield, IN

    Nestled in Westfield, Indiana, at 16247 Countryside Boulevard, Hamilton County, this single-family residence presents an attractive property in great condition. Imagine preparing culinary delights in the kitchen, where the backsplash adds a touch of elegance, and the large kitchen island becomes a central hub for both preparation and conversation. The open floor plan seamlessly integrates this

    Ehab Abdalla MyHomeIndy.com

    Section Image
  • 15515 Alameda Place, Westfield, IN 46074

    $595,000

    • 4 Beds
    • 3.5 Baths
    • 4,167 Sq Ft
    • 15515 Alameda Place
    • Westfield, IN

    Your search for the perfect home ends here! Nestled in sought-after Centennial in Westfield, this 4,000+ sq ft home has it all. With 4 generously sized bedrooms, 3.5 baths and a finished basement, there's plenty of room to entertain or just enjoy family night. The open kitchen has beautiful granite countertops, a center island, planning desk, plus abundant cabinet & prep space. Work from

    Rob Newkirk Newkirk Realty

    Section Image
  • 936 Plunkett Ave, Westfield, IN 46074

    $485,000

    • 3 Beds
    • 2.5 Baths
    • 2,406 Sq Ft
    • 936 Plunkett Ave
    • Westfield, IN

    Welcome home to this stunning ranch-style home in the highly desirable Maple Knoll community of Westfield! Oversized 3+ Car Garage! Featuring a split floor plan with 3 bedrooms, 2.5 baths, and an open-concept layout, this home is designed for both comfort and functionality. The spacious kitchen boasts a large island with seating, a breakfast room, and seamless flow into the family room, creating

    Stephanie Evelo Keller Williams Indy Metro NE

    Section Image
  • 15329 Smithfield Dr, Westfield, IN 46074

    $450,000

    • 4 Beds
    • 2.5 Baths
    • 2,590 Sq Ft
    • 15329 Smithfield Dr
    • Westfield, IN

    Welcome to this spacious 4-bedroom, 2.5-bath home located in the highly sought-after Centennial neighborhood. With large rooms throughout, a partial basement for added flexibility, and an extended patio perfect for outdoor gatherings, this home offers comfort, space, and convenience.

    Miranda Payne Carpenter, REALTORS®

    Section Image

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
Koester Justin T $485,000 Enterprise Title
Vj & Hm Properties Llc -- None Available
Davis Helen M -- None Available
Davis Vesser John -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Koester Justin T $436,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/04/2021 10/04/21 Sold $485,000 -2.0% $234 / Sq Ft
08/31/2021 08/31/21 Pending -- -- --
08/27/2021 08/27/21 For Sale $495,000 -- $239 / 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 $3,859 $294,100 $156,500 $137,600
2023 $3,874 $250,400 $120,800 $129,600
2022 $3,745 $241,400 $120,400 $121,000
2021 $3,729 $222,700 $120,200 $102,500
2020 $3,834 $217,300 $120,200 $97,100
2019 $3,512 $194,700 $86,600 $108,100
2018 $3,684 $189,300 $86,700 $102,600
2017 $3,409 $184,900 $86,900 $98,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: 21809783

MIBOR Broker Listing Cooperative®

APN: 29-09-10-000-018.000-015