NOT LISTED FOR SALE

Estimated Value: $632,000 - $683,394

5 Beds
4 Baths
3,639 Sq Ft
$183/Sq Ft Est. Value

Last Sold August 21, 2019

Last sale price $415,500 $114 Per Sq Ft

Est. 60% increase in value since last sale

Current estimated payment $3,972/month

11 Days on Market

Highlights

  • Home fronts a pond
  • Vaulted Ceiling
  • Separate Formal Living Room
  • College Wood Elementary School Rated A+
  • Traditional Architecture
  • Community Pool

About This Home

As of August 2019

Well maintained & updated 5 bedroom/4 full bath home with full finished basement on private lot with pond view! Over 5000 sqft of living space! Convenient main floor guest bedroom w/full bath. Kitchen features all NEW SS appliances, granite countertops, center island, planning desk & large walk-in pantry. Stunning 2-story entry! Separate living rm, dining rm & great rm w/ fireplace. 4 oversized bedrooms & loft on 2nd level. Master suite has vaulted ceiling, sitting area & large walk-in closet. Beautiful NEW tile flooring in all bathrooms. Fresh neutral paint throughout. Full basement w/ theater rm, full bath, rec rm, 6th bedroom/exercise rm & egress window. Southern exposure, 3 car garage & irrigation system. Community pool. Carmel schools!

Last Agent to Sell the Property

Linda Yi Zhang

F.C. Tucker Company License #RB14042382 Listed on: 06/27/2019

F.C. Tucker Company

Last Buyer's Agent

Gita Kapur

Berkshire Hathaway Home

Berkshire Hathaway Home

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,818

Year Built

  • Built in 2007

Lot Details

  • 0.29 Acre Lot
  • Home fronts a pond
  • Sprinkler System
  • Landscaped with Trees

HOA Fees

  • $60 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

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

Interior Spaces

  • 2-Story Property
  • Home Theater Equipment
  • Woodwork
  • Vaulted Ceiling
  • Paddle Fans
  • Gas Log Fireplace
  • Entrance Foyer
  • Great Room with Fireplace
  • Separate Formal Living Room
  • Fire and Smoke Detector

Kitchen

  • Electric Oven
  • Range Hood
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Carpet
  • Laminate

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • 9 Foot Basement Ceiling Height
  • Sump Pump with Backup
  • Basement Window Egress

Outdoor Features

  • Covered Patio or Porch

Utilities

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

Listing and Financial Details

  • Legal Lot and Block 57 / 20
  • Assessor Parcel Number 290920010057000018

Community Details

Overview

  • Association fees include insurance, maintenance, parkplayground, management, snow removal
  • Association Phone (317) 875-5600
  • Trails At Hayden Run Subdivision
  • Property managed by CASI
  • The community has rules related to covenants, conditions, and restrictions

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,818

Year Built

Built in 2007

Lot Details

0

HOA Fees

$60 per month

Parking

3

Listing Details

  • Property Sub Type: Single Family Residence
  • Architectural Style: TraditonalAmerican
  • Property Type: Residential
  • New Construction: No
  • Tax Year: 2018
  • Year Built: 2007
  • Building Area Total: 5356
  • Garage Y N: Yes
  • Lot Size Acres: 0.29
  • Subdivision Name: Trails At Hayden Run
  • Inspection Warranties: Not Applicable
  • Transaction Type: Sale
  • MBR_AttributionContact: linda.stonehearth@gmail.com
  • Special Features: VirtualTour

Interior Features

  • Basement: Yes
  • Basement Type: Ceiling - 9+ feet, Finished, Egress Window(s), Sump Pump w/Backup
  • Appliances: Dishwasher, Dryer, Disposal, Microwave, Electric Oven, Range Hood, Refrigerator, Washer, Gas Water Heater, Water Softener Owned
  • Levels: Two
  • Full Bathrooms: 4
  • Total Bathrooms: 4
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1545
  • Fireplace Features: Gas Log, Great Room
  • Fireplaces: 1
  • Interior Amenities: Raised Ceiling(s), Vaulted Ceiling(s), Walk-in Closet(s), Wood Work Painted, Paddle Fan, Entrance Foyer, Hi-Speed Internet Availbl, In-Law Arrangement, Center Island, Pantry
  • Living Area: 3639
  • Main Level Bedrooms: 1
  • Other Equipment: Smoke Alarm, Theater Equipment
  • Areas Interior: Living Room Formal
  • Eating Area: Breakfast Room,Formal Dining Room
  • Basement Full Bathrooms: 1
  • Main Level Full Bathrooms: 1
  • Main Level Sq Ft: 1717
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 0
  • Kitchen Features: Kitchen Updated
  • Upper Level Sq Ft: 1922
  • ResoLivingAreaSource: Assessor
  • Rooms Basement: 3
  • SqFt Total: 5356

Exterior Features

  • Construction Materials: Brick, Cement Siding
  • Disclosures: Not Applicable
  • Exterior Features: Sprinkler System
  • Foundation Details: Concrete Perimeter
  • List Price: 425000
  • Patio And Porch Features: Open Patio, Covered Porch
  • Pool Features: Community, Association
  • Waterfront Features: Pond
  • Waterfront: Yes

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Attached, Concrete, Garage Door Opener
  • Garage Parking Other: Keyless Entry

Utilities

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

Condo/Co-op/Association

  • Association Fee: 179
  • Association Fee Frequency: Quarterly
  • Association Phone: 317-875-5600
  • Association YN: Yes
  • Management Company Name: CASI
  • H O A Disclosures: Covenants & Restrictions

Fee Information

  • Association Fee Includes: Entrance Common, Insurance, Maintenance, ParkPlayground, Management, Snow Removal

Lot Info

  • Lot Features: Sidewalks, Trees-Small (Under 20 Ft)
  • Property Attached Yn: No
  • Additional Parcels: No
  • Lot Size Sq Ft: 12632
  • Parcel Number: 290920010057000018
  • Acres: 1/4-1/2 Acre

Green Features

  • Green Certification Y N: No

Tax Info

  • Tax Annual Amount: 3818
  • Tax Block: 20
  • Tax Lot: 57
  • Semi Annual Property Tax Amt: 1909
  • Tax Exemption: Homestead Tax Exemption

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 27, 2019
Closed on
Aug 20, 2019
Sold by
Hu Tianle and Liu Li
Bought by
Gupta Neeraj and Gupta Mayura
Seller's Agent
Linda Yi Zhang
F.C. Tucker Company
Buyer's Agent
Gita Kapur
Berkshire Hathaway Home
List Price
$425,000
Sold Price
$415,500
Premium/Discount to List
-$9,500
-2.24%
Current Estimated Value
$666,599

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$251,099
Avg. Annual Appreciation
7.96%
Original Mortgage
$353,175
Outstanding Balance
$309,316
Interest Rate
3.7%
Mortgage Type
New Conventional
Estimated Equity
$357,283

Purchase Details

Listed on
Sep 11, 2012
Closed on
Oct 30, 2012
Sold by
Zuffa Thomas J
Bought by
Hu Tianle and Liu Li
Seller's Agent
Jen Webster
F.C. Tucker Company
Buyer's Agent
Mabel Liu
MYL Realty, LLC
List Price
$320,000
Sold Price
$320,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.91%
Original Mortgage
$256,000
Interest Rate
3.32%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 11, 2007
Sold by
Arbor Homes Llc
Bought by
Zuffa Thomas J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$221,028
Interest Rate
6.3%
Mortgage Type
Purchase Money Mortgage
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
Gupta Neeraj -- None Available
Hu Tianle -- None Available
Zuffa Thomas J -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Gupta Neeraj $353,175
Previous Owner Hu Tianle $256,000
Previous Owner Zuffa Thomas J $221,028
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/21/2019 08/21/19 Sold $415,500 -2.2% $114 / Sq Ft
07/09/2019 07/09/19 Pending -- -- --
06/27/2019 06/27/19 For Sale $425,000 +32.8% $117 / Sq Ft
10/31/2012 10/31/12 Sold $320,000 0.0% $60 / Sq Ft View Prior Sale
09/14/2012 09/14/12 Pending -- -- --
09/11/2012 09/11/12 For Sale $320,000 -- $60 / 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,669 $430,300 $109,000 $321,300
2023 $4,734 $434,000 $109,000 $325,000
2022 $4,735 $416,300 $60,500 $355,800
2021 $4,442 $388,200 $60,500 $327,700
2020 $3,971 $352,800 $60,500 $292,300
2019 $3,778 $335,900 $54,300 $281,600
2018 $3,818 $339,000 $54,300 $284,700
2017 $3,811 $338,400 $54,300 $284,100
2016 $3,824 $344,700 $54,300 $290,400
2014 $3,176 $299,300 $54,300 $245,000
2013 $3,176 $301,900 $54,300 $247,600
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: 21650605

MIBOR Broker Listing Cooperative®

APN: 29-09-20-010-057.000-018