NOT LISTED FOR SALE

15577 Frankel Ln Westfield, IN 46074

Estimated Value: $845,550 - $874,000

4 Beds
4.5 Baths
3,591 Sq Ft
$238/Sq Ft Est. Value

Last Sold February 22, 2023

Last sale price $776,540 $216 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $5,354/month

Highlights

  • Craftsman Architecture
  • Vaulted Ceiling
  • Double Convection Oven
  • Shamrock Springs Elementary School Rated A-
  • Covered patio or porch
  • In-Law or Guest Suite

About This Home

As of February 2023

Live like you are on vacation at Kimblewick by Del Webb. Nestled at 151st Street, this age-restricted community offers new homes with impressive included upgrades tucked away on streets sprinkled with trails, parks and amenities. Resort-style perks await at Kimblewick with a 13,000 sq. clubhouse, indoor/outdoor pool, fitness center and athletic courts. And while our facilities are eye-catching, Kimblewick stands out for its famous Del Webb Lifestyle where you all find that no day is the same. Enjoy everything about the single-story Renown new home design with the gathering room, cafe and kitchen all in one open living space.

Last Agent to Sell the Property

Mike Scheetz

CENTURY 21 Scheetz License #RB14043396 Listed on: 01/24/2023

CENTURY 21 Scheetz

Last Buyer's Agent

Betsy Beasley

CENTURY 21 Scheetz License #RB14043438

CENTURY 21 Scheetz

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $600

Year Built

  • Built in 2023

Lot Details

  • 0.35

HOA Fees

  • $302 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Garage Door Opener

Home Design

  • Craftsman Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Cement Siding
  • Stone

Interior Spaces

  • Tray Ceiling
  • Vaulted Ceiling
  • Gas Log Fireplace
  • Window Screens
  • Living Room with Fireplace
  • Combination Kitchen and Dining Room
  • Fire and Smoke Detector

Kitchen

  • Double Convection Oven
  • Gas Cooktop
  • Range Hood
  • Recirculated Exhaust Fan
  • Microwave
  • Dishwasher
  • Wine Cooler
  • ENERGY STAR Qualified Appliances
  • Disposal

Flooring

  • Carpet
  • Luxury Vinyl Plank Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • In-Law or Guest Suite

Schools

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

Additional Features

  • Covered patio or porch
  • 15,211 Sq Ft Lot
  • Heating System Uses Gas

Community Details

  • Association fees include builder controls, clubhouse, exercise room, irrigation, lawncare, ground maintenance, maintenance, management
  • Association Phone (800) 354-0257
  • Kimblewick Subdivision
  • Property managed by AAM

Listing and Financial Details

  • Tax Lot 213
  • Assessor Parcel Number 15577FRANKELLN

Home Details

Home Type

Single Family

Est. Annual Taxes

$600

Year Built

Built in 2023

Lot Details

0

HOA Fees

$302 per month

Parking

3

Listing Details

  • Property Sub Type: Single Family Residence
  • Architectural Style: Craftsman
  • Builder Name: Pulte
  • Property Type: Residential
  • New Construction: Yes
  • Tax Year: 2023
  • Year Built: 2023
  • Building Area Total: 3591
  • Garage Y N: Yes
  • Lot Size Acres: 0.24
  • Subdivision Name: Kimblewick
  • Inspection Warranties: Warranty Builders
  • Transaction Type: Sale
  • Website: www.scheetzteam.com
  • Accessibility Features YN: No
  • Website: www.pulte.com
  • MBR_AttributionContact: mm@ScheetzTeam.com
  • Special Features: NewHome

Interior Features

  • Basement: No
  • Appliances: Convection Oven, Gas Cooktop, Double Oven, Dishwasher, ENERGY STAR Qualified Appliances, Disposal, Kitchen Exhaust, Microwave, Range Hood, Wine Cooler
  • Levels: One Leveland + Loft
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bathrooms: 5
  • Total Bedrooms: 4
  • Fireplace Features: Gas Log, Living Room
  • Fireplaces: 1
  • Interior Amenities: Screens Complete, In-Law Arrangement, Raised Ceiling(s), Tray Ceiling(s)
  • Living Area: 3591
  • Main Level Bedrooms: 3
  • Other Equipment: Smoke Alarm
  • Areas Interior: Bath Jack-n-Jill,Bedroom Other on Main
  • Eating Area: Dining Combo/Kitchen
  • Basement Full Bathrooms: 0
  • Main Level Full Bathrooms: 3
  • Main Level Sq Ft: 2755
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 1
  • Upper Level Sq Ft: 836
  • ResoLivingAreaSource: Builder
  • Rooms Basement: 0

Exterior Features

  • Construction Materials: Brick, Cement Siding, Stone
  • Foundation Details: Slab
  • List Price: 772740
  • Patio And Porch Features: Covered Patio
  • Construction Stage: Trim Stage

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Garage Door Opener
  • Fuel: No Fuel Source
  • Garage Parking Other: Garage Door Opener,Keyless Entry
  • Garage Sq Ft: 677

Utilities

  • Utilities: Cable Connected, Gas
  • Cooling: Central Electric
  • Heating: Gas
  • Water Source: Municipal/City
  • Solid Waste: No

Condo/Co-op/Association

  • Association Amenities: Pool
  • Association Fee: 302
  • Association Fee Frequency: Monthly
  • Association Phone: 800-354-0257
  • Association YN: Yes
  • Management Company Name: AAM
  • H O A Disclosures: 55+ Community,Covenants & Restrictions

Fee Information

  • Association Fee Includes: Association Builder Controls, Clubhouse, Exercise Room, Irrigation, Lawncare, Maintenance Grounds, Maintenance, Management

Schools

  • Middle Or Junior School: Westfield Middle School

Lot Info

  • Lot Features: Sidewalks
  • Property Attached Yn: No
  • Additional Parcels: No
  • Lot Size Sq Ft: 15211
  • Parcel Number: 15577FRANKELLN
  • Acres: <1/4 Acre
  • Price Acre: 3235583.33333333

Green Features

  • Green Certification Y N: No

Tax Info

  • Tax Annual Amount: 600
  • Tax Lot: 213
  • Semi Annual Property Tax Amt: 300

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
Jan 24, 2023
Closed on
Feb 22, 2023
Sold by
Pulte Homes Of Indiana Llc
Bought by
Haugh Michael J and Haugh Patricia
Seller's Agent
Mike Scheetz
CENTURY 21 Scheetz
Buyer's Agent
Betsy Beasley
CENTURY 21 Scheetz
List Price
$772,740
Sold Price
$776,540
Premium/Discount to List
$3,800
0.49%
Current Estimated Value
$852,480

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$75,940
Avg. Annual Appreciation
3.01%
Original Mortgage
$584,000
Outstanding Balance
$569,460
Interest Rate
6.33%
Mortgage Type
New Conventional
Estimated Equity
$265,765
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
Haugh Michael J $776,540 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Haugh Michael J $584,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/22/2023 02/22/23 Sold $776,540 +0.5% $216 / Sq Ft
01/24/2023 01/24/23 Pending -- -- --
01/24/2023 01/24/23 For Sale $772,740 -- $215 / 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,622 $729,300 $89,600 $639,700
2023 $4,657 $406,800 $89,600 $317,200
2022 $49 $600 $600 $0
Source: Public Records

Agents Affiliated with this Home

  • Mike Scheetz

    Seller's Agent in 2023

    Mike Scheetz

    CENTURY 21 Scheetz

    (317) 587-8600

    159 in this area

    731 Total Sales

    Section Image
  • Betsy Beasley

    Buyer's Agent in 2023

    Betsy Beasley

    CENTURY 21 Scheetz

    (317) 294-0473

    7 in this area

    45 Total Sales

    Section Image
See All Agents

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: 21902566

MIBOR Broker Listing Cooperative®

APN: 29-09-17-005-011.000-015

Indiana Hamilton County Westfield 46074

15577 Frankel Ln, Westfield, IN

This home is located at 15577 Frankel Ln, Westfield, IN 46074 since 24 January 2023 and is currently estimated at $854,888, approximately $238 per square foot. This property was built in 2023. 15577 Frankel Ln 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