NOT LISTED FOR SALE

400 Walnut Ridge Trail Aurora, OH 44202

Estimated Value: $456,000 - $796,000

4 Beds
2.5 Baths
4,958 Sq Ft
$131/Sq Ft Est. Value

Last Sold October 26, 2021

Last sale price $495,000 $100 Per Sq Ft

Est. 31% increase in value since last sale

Current estimated payment $4,222/month

16 Days on Market

Highlights

  • View of Trees or Woods
  • Colonial Architecture
  • Deck
  • Leighton Elementary School Rated A
  • Community Lake
  • Wooded Lot

About This Home

As of October 2021

Sophisticated 4 bed, 2.5 bath colonial in coveted Hawthorne of Aurora with timeless style! Enter through the front door and into the two-story foyer with the home office on your left and living room to your right. Hardwood floors carry you down the hall, past the powder room, and into the heart of this home. The floorplan is the perfect combination of charm and functionality with the kitchen as its center. The formal dining room is just off the kitchen with a tray ceiling and open flow into the living room. On the other side of the kitchen is your casual dining space and doors to gorgeous sunroom with panoramic views (added in 2016). Just beyond is the vaulted great room with a stunning fireplace, sliders to the deck, and wooded views via a wall made up almost entirely of glass. A conveniently located first-floor laundry/mud room and access to the attached 3 car garage complete the main floor. Upstairs is the spacious owner’s suite with cove ceilings, an extra-large walk-in closet and generous master bath. There are three additional bedrooms and a well-appointed Jack and Jill bath. The lower level offers another wonderful living space and plenty of storage! The peaceful back yard is the perfect size with wooded views and a shed. All of this plus a 2019 HVAC system, reverse osmosis, updated lighting, and more. You will love the community as much as the house! Hawthorne is packed with amenities including a private pool, tennis court, playground, pavilion, lake, and clubhouse!

Last Agent to Sell the Property

Michael Henry

EXP Realty, LLC. License #2014003328 Listed on: 08/20/2021

EXP Realty, LLC.

Last Buyer's Agent

Michael Henry

EXP Realty, LLC. License #2014003328 Listed on: 08/20/2021

EXP Realty, LLC.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,579

Year Built

  • Built in 1997

Lot Details

  • 0.46 Acre Lot
  • Wooded Lot

HOA Fees

  • $54 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Traditional Architecture
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 2-Story Property
  • 1 Fireplace
  • Views of Woods
  • Partially Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Dryer
  • Washer

Parking

  • 3 Car Direct Access Garage
  • Garage Drain
  • Garage Door Opener

Outdoor Features

  • Deck
  • Enclosed Patio or Porch
  • Shed

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas

Listing and Financial Details

  • Assessor Parcel Number 03-009-00-00-008-070

Community Details

Overview

  • Association fees include insurance, recreation, reserve fund
  • Hawthorne Aurora Community
  • Community Lake

Amenities

  • Common Area

Recreation

  • Tennis Courts
  • Community Playground
  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,579

Year Built

Built in 1997

Lot Details

0

HOA Fees

$54 per month

Listing Details

  • Property Type: Residential
  • Property Subtype: Single Family
  • Style: Colonial, Conventional
  • Price Per Square Foot: 150.46
  • Estimated Price per Sq Ft: 150.46
  • Year Built Exception: Actual YBT
  • Num Of Stories: 2.00
  • Total Sq Ft: 3290
  • Year Built: 1997
  • Court Ordered Y N: No
  • Geocode Confidence: High
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2
  • Year Built: 1997

Interior Features

  • Appliances Equipment: Dishwasher, Dryer, Microwave, Range, Refrigerator, Washer
  • Fireplaces: 1
  • Total Bedrooms: 4
  • Total Bathrooms: 3.00
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Main Half Bathrooms: 1
  • Room Count: 14
  • Basement Detail: Full, Partially Finished
  • Laundry On Main: 1
  • Laundry: 1
  • Sq Ft Approx Above Grade Finished: 3290.00
  • Sq Ft Approx Below Grade Finished: 1668.00
  • Sq Ft Approx Total Finished: 4958.00

Exterior Features

  • View: Wooded
  • Exterior: Vinyl
  • Exterior Features: Deck, Enclosed Patio/Porch, Porch, Shed
  • Roof: Asphalt/Fiberglass

Garage/Parking

  • Driveway: Paved
  • Garage Features: Access from Unit, Attached, Door Opener, Drain
  • Garage Num Of Cars: 3

Utilities

  • Cooling Type: Central Air
  • Heating Fuel: Gas
  • Heating Type: Forced Air
  • Water/Sewer: Public Water, Public Sewer

Association/Amenities

  • Amenities: Common Facility, Community, Lake, Playground, Pool, Tennis Courts

Condo/Co-op/Association

  • HOA Fees: 650.00
  • HOA Fee Frequency: Annually
  • Hoa Name: KareCondo
  • Subdivision Complex: Hawthorne Aurora

Fee Information

  • HOA Fee Includes: Association Insurance, Recreation, Reserve Fund

Schools

  • School District: Aurora CSD
  • School District: Aurora CSD

Lot Info

  • Lot Description: Wooded/Treed
  • Lot Size Units: Acres
  • Acres: 0.4580
  • Parcel Number: 03-009-00-00-008-070

Tax Info

  • Tax: 7579

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 20, 2021
Closed on
Oct 25, 2021
Sold by
Ferraro Aaron J
Bought by
Johnson Shannon M and Johnson Steven D
Seller's Agent
Michael Henry
EXP Realty, LLC.
Buyer's Agent
Michael Henry
EXP Realty, LLC.
List Price
$525,000
Sold Price
$495,000
Premium/Discount to List
-$30,000
-5.71%
Current Estimated Value
$650,263

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$155,263
Avg. Annual Appreciation
8.20%
Original Mortgage
$396,000
Outstanding Balance
$365,784
Interest Rate
2.8%
Mortgage Type
New Conventional
Estimated Equity
$307,766

Purchase Details

Listed on
Nov 18, 2019
Closed on
Jun 11, 2020
Sold by
Bergh Roger G and Bergh Barbara J
Bought by
Ferraro Aaron J
Seller's Agent
Carla Hoover
Deleted Agent
Buyer's Agent
Lisa Sisko
Keller Williams Greater Metropolitan
List Price
$498,000
Sold Price
$460,000
Premium/Discount to List
-$38,000
-7.63%

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.54%
Original Mortgage
$437,000
Interest Rate
3.2%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 27, 2014
Sold by
Hoover Barbara J
Bought by
Hoover Barbara J and Bergh Roger G

Purchase Details

Closed on
Oct 7, 2013
Sold by
Hoover Barbara J
Bought by
Hoover Barbara J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$290,000
Interest Rate
3.55%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 24, 2011
Sold by
Estate Of Curt B Hoover
Bought by
Hoover Barbara J and Curt B Hoover Trust

Purchase Details

Closed on
Apr 12, 1999
Sold by
Williams Michael and Williams Sharon J
Bought by
Hoover Curt B and Hoover Barbara J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$208,000
Interest Rate
7.7%

Purchase Details

Closed on
Oct 6, 1997
Sold by
Hawthorne Of Aurora
Bought by
Williams Michael and Williams Sharon

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$234,000
Interest Rate
7.54%
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
Johnson Shannon M $495,000 Title Professionals Group Lt
Ferraro Aaron J $460,000 Northstar Title Services Llc
Hoover Barbara J -- None Available
Hoover Barbara J -- None Available
Hoover Barbara J -- Attorney
Hoover Curt B $308,000 Midland
Williams Michael $293,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Johnson Shannon M $396,000
Closed Ferraro Aaron J $437,000
Previous Owner Hoover Barbara J $290,000
Previous Owner Hoover Curt B $242,586
Previous Owner Hoover Curt B $75,000
Previous Owner Hoover Curt B $76,500
Previous Owner Hoover Curt B $275,000
Previous Owner Hoover Curt B $74,000
Previous Owner Hoover Curt B $208,000
Previous Owner Williams Michael $234,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/26/2021 10/26/21 Sold $495,000 -2.0% $100 / Sq Ft
09/05/2021 09/05/21 Pending -- -- --
09/03/2021 09/03/21 Price Changed $505,000 -3.8% $102 / Sq Ft
08/20/2021 08/20/21 For Sale $525,000 +14.1% $106 / Sq Ft
06/15/2020 06/15/20 Sold $460,000 -1.1% $93 / Sq Ft
05/14/2020 05/14/20 Pending -- -- --
02/27/2020 02/27/20 Price Changed $465,000 -4.1% $94 / Sq Ft
02/12/2020 02/12/20 Price Changed $485,000 -1.0% $98 / Sq Ft
01/13/2020 01/13/20 Price Changed $490,000 -1.6% $99 / Sq Ft
11/18/2019 11/18/19 For Sale $498,000 -- $100 / Sq Ft
Source: MLS Now

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 $8,802 $196,910 $35,000 $161,910
2023 $8,498 $154,770 $31,500 $123,270
2022 $7,695 $154,770 $31,500 $123,270
2021 $7,739 $154,770 $31,500 $123,270
2020 $7,579 $137,760 $31,500 $106,260
2019 $7,625 $137,760 $31,500 $106,260
2018 $7,767 $127,540 $29,750 $97,790
2017 $7,767 $127,540 $29,750 $97,790
2016 $6,862 $124,710 $29,750 $94,960
2015 $7,057 $124,710 $29,750 $94,960
2014 $6,823 $117,670 $29,750 $87,920
2013 $6,753 $117,670 $29,750 $87,920
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MLS Now

MLS Number: 4309686

MLS Now

APN: 03-009-00-00-008-070