NOT LISTED FOR SALE

5412 Keswick Ct Avon, IN 46123

Estimated Value: $405,000 - $434,000

4 Beds
3 Baths
2,432 Sq Ft
$174/Sq Ft Est. Value

Last Sold November 18, 2021

Last sale price $365,000 $150 Per Sq Ft

Est. 16% increase in value since last sale

Current estimated payment $2,620/month

16 Days on Market

Highlights

  • Formal Dining Room
  • Attached Garage
  • Eat-In Kitchen
  • Avon Intermediate School West Rated A

About This Home

As of November 2021

Back on the market, this custom built 4 bedroom 3 bath, brick ranch nestled on a quiet cul-de-sac in popular Royal Troon! The large great room with wood-burning fireplace has soaring cathedral ceilings and open views of formal dining area, perfect for entertaining family and friends. Large loft area offers endless possibilities. Enjoy the beautiful views of the park-like backyard and Prestwick Golf Course from the large deck and covered patio. This home has so much to offer and won't last long!

Last Agent to Sell the Property

Patrick Davidson

The Cooper Real Estate Group License #RB14042030 Listed on: 09/24/2021

Last Buyer's Agent

Benjamin Thomas

Keller Williams Indy Metro W

Keller Williams Indy Metro W

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,094

Year Built

  • 1989

Lot Details

  • 0.42

HOA Fees

  • $27 per month

Parking

  • Attached Garage

Interior Spaces

  • Formal Dining Room
  • Eat-In Kitchen

Utilities

  • Heating System Uses Gas
  • Natural Gas Connected

Community Details

  • Property managed by H&H Management

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,094

Year Built

1989

Lot Details

0

HOA Fees

$27 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Inspection Warranties: Not Applicable
  • Transaction Type: Sale
  • Website: thecreg.com
  • Architectural Style: Ranch, TraditonalAmerican
  • Directions: South on 525E from Rockville Road. Turn left on Royal Troon Way. Left on Keswick Court to home.
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Subdivision Name: ROYAL TROON VILLAGE
  • Special Features: None
  • Year Built: 1989

Interior Features

  • Appliances: Dishwasher, Disposal, Microwave, Electric Oven, Refrigerator
  • Fireplace Features: Great Room, Woodburning Fireplce
  • Areas Interior: Great Room - 2 Story,Laundry Room Main Level
  • Eating Area: Formal Dining Room
  • Basement Full Bathrooms: 0
  • Main Level Full Bathrooms: 2
  • Sq Ft Main Upper: 2432
  • Main Level Sq Ft: 1824
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 0
  • Master Bedroom Description: Closet Walk in,Sinks Double,Sitting Room,Suite,Tub Full with Separate Shower
  • Kitchen Features: Kitchen Eat In
  • Upper Level Sq Ft: 608
  • Basement YN: No
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Fireplaces: 1
  • Interior Amenities: Attic Access, Cathedral Ceiling(s), Tray Ceiling(s), Skylight(s)
  • Other Equipment: Smoke Detector, Water-Softener Owned

Exterior Features

  • Exterior Features: Driveway Concrete, Irrigation System
  • Foundation Details: Block
  • Association Maintained Building Exterior: 0
  • Porch: Deck Main Level,Covered Porch
  • Construction Type: Brick
  • Disclosures: Not Applicable

Garage/Parking

  • Fuel: Gas
  • Garage Parking Description: Attached
  • Garage Parking Other: Garage Door Opener,Finished Garage,Service Door
  • Garage Sq Ft: 506
  • Garage Spaces: 2

Utilities

  • Cooling: Central Air
  • Heating: Forced Air
  • Solid Waste: 0
  • Utility Options: Gas Connected
  • Water Heater: Electric
  • Sewer: Sewer Connected
  • Water Source: Public

Condo/Co-op/Association

  • Management Company Name: H&H Management
  • Management Company Phone: 317-272-5688
  • Association Fee: 325
  • Association Fee Frequency: Annually

Fee Information

  • Association Fee Includes: Entrance Common

Lot Info

  • Acres: 1/4-1/2 Acre
  • Lot Information: Cul-De-Sac,Street Lights,Tree Mature
  • Lot Number: 9
  • Lot Size: 18,626

Green Features

  • Green Certification Y N: 0

Tax Info

  • Semi Annual Property Tax Amt: 1547
  • Tax Exemption: HomesteadTaxExemption,MortageTaxExemption
  • Tax Annual Amount: 3094
  • Tax Year: 2020

MLS Schools

  • School District: Avon Community

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 24, 2021
Closed on
Nov 18, 2021
Sold by
Stewart Patrick
Bought by
Mendel Alfred Scott and Mendel Lisa Lynn
Seller's Agent
Patrick Davidson
The Cooper Real Estate Group
Buyer's Agent
Benjamin Thomas
Keller Williams Indy Metro W
Sold Price
$365,000
Current Estimated Value
$422,271

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$57,271
Avg. Annual Appreciation
4.03%
Original Mortgage
$193,000
Outstanding Balance
$179,064
Interest Rate
2.99%
Mortgage Type
New Conventional
Estimated Equity
$246,276

Purchase Details

Listed on
Sep 5, 2018
Closed on
Oct 25, 2018
Sold by
Seay David J and Seay Kandi
Bought by
Stewart Patrick
Seller's Agent
Scott Hackman
CENTURY 21 Scheetz
Buyer's Agent
Patrick Davidson
The Cooper Real Estate Group
List Price
$279,900
Sold Price
$270,500
Premium/Discount to List
-$9,400
-3.36%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.25%
Original Mortgage
$270,500
Interest Rate
4.7%
Mortgage Type
VA

Purchase Details

Closed on
Apr 7, 2015
Sold by
Howe Andrew M and Howe Michelle R
Bought by
Seay David J and Seay Kandi

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$237,500
Interest Rate
3.85%
Mortgage Type
Stand Alone First

Purchase Details

Closed on
Feb 17, 2009
Sold by
Jones Larry M and Jones Shirley M
Bought by
Debourbon Michelle R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$184,000
Interest Rate
4.91%
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
Mendel Alfred Scott $365,000 Chicago Title
Stewart Patrick $270,500 Enterprise Title
Seay David J -- --
Debourbon Michelle R -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mendel Alfred Scott $193,000
Previous Owner Stewart Patrick $270,500
Previous Owner Seay David J $237,500
Previous Owner Debourbon Michelle R $184,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/18/2021 11/18/21 Sold $365,000 +9.0% $150 / Sq Ft
10/10/2021 10/10/21 Pending -- -- --
10/07/2021 10/07/21 For Sale -- -- --
09/27/2021 09/27/21 Pending -- -- --
09/24/2021 09/24/21 For Sale $334,900 +23.8% $138 / Sq Ft
10/25/2018 10/25/18 Sold $270,500 -1.6% $111 / Sq Ft
09/18/2018 09/18/18 Pending -- -- --
09/10/2018 09/10/18 Price Changed $274,900 -1.8% $113 / Sq Ft
09/05/2018 09/05/18 For Sale $279,900 -- $115 / 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,242 $375,100 $73,100 $302,000
2023 $3,664 $326,300 $63,600 $262,700
2022 $3,610 $319,000 $62,400 $256,600
2021 $3,337 $285,400 $58,200 $227,200
2020 $3,194 $270,600 $58,200 $212,400
2019 $2,984 $257,800 $55,200 $202,600
2018 $3,022 $256,300 $55,200 $201,100
2017 $2,463 $246,300 $53,000 $193,300
2016 $2,249 $224,900 $51,500 $173,400
2014 $2,058 $205,800 $46,300 $159,500
2013 $2,227 $222,700 $48,700 $174,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: 21814953

MIBOR Broker Listing Cooperative®

APN: 32-10-09-340-009.000-022