NOT LISTED FOR SALE

Estimated Value: $964,000 - $1,217,000

5 Beds
4.5 Baths
3,995 Sq Ft
$281/Sq Ft Est. Value

Last Sold November 15, 2019

Last sale price $885,000 $222 Per Sq Ft

Est. 27% increase in value since last sale

Current estimated payment $7,079/month

77 Days on Market

Highlights

  • In Ground Pool
  • Waterfront
  • Fireplace in Kitchen
  • Cherry Tree Elementary School Rated A
  • 0.85 Acre Lot
  • Traditional Architecture

About This Home

As of November 2019

Entertain family & guests at this completely updated 5BR/4.5BA estate in Valleybrook w/ one of a kind walk-out basement that leads to 20x40 heated pool & waterfront backyard w/ dock! Walk-out basement offers 7 seat wetbar with 2 beer taps, separate wine bar with custom built-in display, great room w/ fireplace, game room, guest BR w/ WIC closet, and full bath! Main level Master BR retreat features private deck overlooking lake, renovated bath, and generous walk-in-closet. Other features include kitchen that opens to sunroom & breakfast room all w/ water views, executive office, grand 2 level foyer, & oversized 3 car garage. Updates include fresh paint & flooring throughout, triple-pane windows, dual zone HVAC, & tankless water heater!

Last Agent to Sell the Property

Mike Clements

CENTURY 21 Scheetz License #RB14028450 Listed on: 07/03/2019

CENTURY 21 Scheetz

Last Buyer's Agent

Stacey Sobczak

Compass Indiana, LLC License #RB14050785

Compass Indiana, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,666

Year Built

  • Built in 1989

Lot Details

  • 0.85 Acre Lot
  • Waterfront
  • Sprinkler System

HOA Fees

  • $8 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Side or Rear Entrance to Parking
  • Garage Door Opener

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Bar Fridge
  • Gas Log Fireplace
  • Thermal Windows
  • Entrance Foyer
  • Family Room with Fireplace
  • 2 Fireplaces
  • Great Room with Fireplace
  • Pull Down Stairs to Attic

Kitchen

  • Eat-In Kitchen
  • <<doubleOvenToken>>
  • Gas Cooktop
  • <<microwave>>
  • Ice Maker
  • Dishwasher
  • Wine Cooler
  • Kitchen Island
  • Fireplace in Kitchen

Flooring

  • Wood
  • Carpet
  • Ceramic Tile
  • Luxury Vinyl Plank Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

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

Outdoor Features

  • In Ground Pool
  • Multiple Outdoor Decks
  • Covered patio or porch

Schools

  • Cherry Tree Elementary School
  • Carmel Middle School

Utilities

  • Forced Air Heating System
  • Heating System Uses Gas
  • Tankless Water Heater
  • Satellite Dish

Community Details

  • Association fees include maintenance
  • Valleybrook Subdivision

Listing and Financial Details

  • Tax Lot 24
  • Assessor Parcel Number 291021134024000018

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,666

Year Built

Built in 1989

Lot Details

0

HOA Fees

$8 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: 1989
  • Building Area Total: 6222
  • Garage Y N: Yes
  • Lot Size Acres: 0.8523
  • Subdivision Name: Valleybrook
  • Inspection Warranties: Not Applicable
  • Transaction Type: Sale
  • MBR_AttributionContact: mclements@c21scheetz.com
  • Special Features: VirtualTour

Interior Features

  • Basement: Yes
  • Basement Type: Ceiling - 9+ feet, Finished, Walk Out, Egress Window(s), Sump Pump w/Backup, Sump Pump Dual
  • Appliances: Gas Cooktop, Dishwasher, Dryer, Microwave, Double Oven, Bar Fridge, Refrigerator, Ice Maker, Washer, Wine Cooler, Tankless Water Heater, Water Softener Owned
  • Levels: Two
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bathrooms: 5
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 2004
  • Fireplace Features: Family Room, Gas Log, Great Room, Kitchen
  • Fireplaces: 2
  • Interior Amenities: Attic Pull Down Stairs, Walk-in Closet(s), Hardwood Floors, Wet Bar, Windows Thermal, Eat-in Kitchen, Entrance Foyer, Center Island, Pantry
  • Living Area: 3995
  • Main Level Bedrooms: 1
  • Other Equipment: Satellite Dish Rented
  • Areas Interior: Bath Jack-n-Jill,Utility Room
  • Eating Area: Breakfast Room,Formal Dining Room
  • Basement Full Bathrooms: 1
  • Main Level Full Bathrooms: 1
  • Main Level Sq Ft: 2811
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 1
  • Upper Level Sq Ft: 1184
  • ResoLivingAreaSource: Assessor
  • Rooms Basement: 5
  • SqFt Total: 6222

Exterior Features

  • Construction Materials: Brick
  • Disclosures: Not Applicable
  • Exterior Features: Sprinkler System, Dock
  • Fencing: Fence Full Rear
  • Foundation Details: Concrete Perimeter
  • List Price: 895000
  • Patio And Porch Features: Multiple Decks, Covered Porch
  • Pool Features: Below Ground
  • Waterfront: Yes

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Attached, Garage Door Opener, Side Load Garage
  • Garage Parking Other: Keyless Entry,Service Door
  • Garage Sq Ft: 872

Utilities

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

Condo/Co-op/Association

  • Association Fee: 95
  • Association Fee Frequency: Annually
  • Association YN: Yes
  • Management Company Name: -

Fee Information

  • Association Fee Includes: Maintenance

Schools

  • Middle Or Junior School: Carmel Middle School

Lot Info

  • Property Attached Yn: No
  • Additional Parcels: No
  • Lot Size Sq Ft: 37127
  • Parcel Number: 291021134024000018
  • Acres: 1/2-1 Acre

Green Features

  • Green Certification Y N: No

Tax Info

  • Tax Annual Amount: 7666
  • Tax Lot: 24
  • Semi Annual Property Tax Amt: 3833
  • Tax Exemption: Homestead Tax Exemption,Mortage Tax Exemption

MLS Schools

  • Elementary School: Cherry Tree Elementary School
  • Schools: CARMEL HIGH,CARMEL MIDDLE,CHERRY TREE ELEMENTARY

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Apr 9, 2019
Sold by
Duncan Kenneth and Duncan Karen
Bought by
Duncan Kenneth G
Current Estimated Value
$1,122,208

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$607,500
Interest Rate
3.87%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Listed on
Mar 29, 2016
Closed on
Aug 12, 2016
Sold by
Melcho Damon T and Melcho Cynthia L
Bought by
Duncan Kenneth and Duncan Karen
Seller's Agent
Heather Schaller
eXp Realty, LLC
Buyer's Agent
Mike Clements
CENTURY 21 Scheetz
List Price
$819,900
Sold Price
$700,000
Premium/Discount to List
-$119,900
-14.62%

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 15, 2015
Sold by
Duncan Kenneth G
Bought by
Webster Aaron M and Webster Rachel M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$484,350
Interest Rate
3.5%

Purchase Details

Closed on
Jul 29, 2005
Sold by
Sullivan David A and Sullivan Sara E
Bought by
Melcho Damon T and Melcho Cynthia L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$600,000
Interest Rate
5.93%
Mortgage Type
Fannie Mae Freddie Mac
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
Duncan Kenneth G -- Chicago Title Company Llc
Duncan Kenneth -- None Available
Webster Aaron M -- Mtc
Melcho Damon T -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Webster Aaron M $250,000
Open Webster Aaron M $482,000
Closed Webster Aaron M $250,000
Previous Owner Duncan Kenneth G $607,500
Previous Owner Duncan Kenneth $560,000
Previous Owner Duncan Kenneth $69,300
Previous Owner Webster Aaron M $484,350
Previous Owner Melcho Damon T $600,000
Previous Owner Melcho Damon T $75,000
Previous Owner Melcho Damon T $600,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/15/2019 11/15/19 Sold $885,000 -1.1% $222 / Sq Ft
09/19/2019 09/19/19 Pending -- -- --
07/03/2019 07/03/19 For Sale $895,000 +27.9% $224 / Sq Ft
08/12/2016 08/12/16 Sold $700,000 0.0% $175 / Sq Ft
07/11/2016 07/11/16 Off Market $700,000 -- --
07/06/2016 07/06/16 Price Changed $740,000 -2.6% $185 / Sq Ft
07/01/2016 07/01/16 Price Changed $760,000 -1.9% $190 / Sq Ft
06/24/2016 06/24/16 Price Changed $775,000 -1.9% $194 / Sq Ft
05/09/2016 05/09/16 Price Changed $789,900 -3.7% $198 / Sq Ft
03/29/2016 03/29/16 For Sale $819,900 -- $205 / 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 $10,257 $891,700 $263,800 $627,900
2023 $10,257 $891,700 $263,800 $627,900
2022 $9,335 $808,600 $132,400 $676,200
2021 $8,628 $754,100 $132,400 $621,700
2020 $8,727 $761,300 $132,400 $628,900
2019 $7,716 $676,200 $132,500 $543,700
2018 $7,667 $677,800 $132,500 $545,300
2017 $7,264 $642,800 $132,500 $510,300
2016 $7,869 $706,200 $132,500 $573,700
2014 $7,377 $662,500 $132,500 $530,000
2013 $7,377 $662,500 $132,500 $530,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: 21651299

MIBOR Broker Listing Cooperative®

APN: 29-10-21-134-024.000-018