NOT LISTED FOR SALE

459 Berwick Cir Aurora, OH 44202

Estimated Value: $1,193,402 - $1,539,000

4 Beds
7 Baths
7,843 Sq Ft
$165/Sq Ft Est. Value

Last Sold March 24, 2020

Last sale price $795,200 $101 Per Sq Ft

Est. 63% increase in value since last sale

Current estimated payment $8,975/month

341 Days on Market

Highlights

  • Water Views
  • On Golf Course
  • Community Lake
  • Leighton Elementary School Rated A
  • Colonial Architecture
  • Deck

About This Home

As of March 2020

Enjoy a life of luxury in this immaculately maintained transitional home in the Barrington Golf Community. This home provides an open, inviting layout, an elegant first floor master suite, and a fabulous deck with lake views; it is just waiting for a new owner! As you step inside, you will immediately notice the gleaming hardwood floors that flow through the living and dining room. The two-story great room features a fireplace, built-ins, and a wall of windows framing the deck and golf course outside. The kitchen showcases top-of-the-line appliances including a double oven, granite countertops, and a hearth room. You will absolutely love the first floor master suite which includes a tray ceiling, walk-in closets, and a luxurious en-suite. Off of the master there is a private study/library with a fireplace. Two half bathrooms and a convenient laundry room complete the first floor. Upstairs, you will find three spacious bedrooms, each with an en-suite bathroom and a walk-in closet. The full lower level is beautifully furnished with a family room with a fireplace and a wet bar plus an office area. Outside, you are sure to enjoy entertaining on the multi-level deck and patio which overlooks a lake and the 18th fairway of Barrington’s gated Signature Jack Nicklaus golf course. Recent improvements include two newly installed furnaces and air conditioners. The community is located just off of Aurora Road, convenient to area highways. Do not wait to fall in love with this home today!

Last Agent to Sell the Property

The Young Team

Keller Williams Greater Metropolitan License #2009004440 Listed on: 02/06/2019

Keller Williams Greater Metropolitan

Last Buyer's Agent

Karen Custodio

Keller Williams Chervenic Rlty License #2016000609

Keller Williams Chervenic Rlty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,318

Year Built

  • Built in 1998

Lot Details

  • 0.84 Acre Lot
  • On Golf Course

HOA Fees

  • $200 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Asphalt Roof

Interior Spaces

  • 2-Story Property
  • 4 Fireplaces
  • Water Views
  • Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Built-In Oven
  • Cooktop
  • Dishwasher

Bedrooms and Bathrooms

  • 4 Bedrooms | 1 Main Level Bedroom

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Deck

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 03-016-00-00-143-001

Community Details

Overview

  • Association fees include insurance, landscaping, reserve fund, security staff, snow removal
  • Barrington Community
  • Community Lake

Recreation

  • Golf Course Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,318

Year Built

Built in 1998

Lot Details

0

HOA Fees

$200 per month

Listing Details

  • Property Type: Residential
  • Property Subtype: Single Family
  • Style: Colonial
  • Price Per Square Foot: 136.09
  • Estimated Price per Sq Ft: 136.09
  • Year Built Exception: Actual YBT
  • Num Of Stories: 2.00
  • Total Sq Ft: 5843
  • Year Built: 1998
  • Geocode Confidence: Unknown
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2
  • Year Built: 1998

Interior Features

  • Appliances Equipment: Cooktop, Dishwasher, Dryer, Wall Oven, Refrigerator, Washer
  • Fireplaces: 4
  • Total Bedrooms: 4
  • Bedrooms on Main Level: 1
  • Total Bathrooms: 7.00
  • Full Bathrooms: 4
  • Half Bathrooms: 3
  • Main Level Full Bathrooms: 1
  • Lower Level Half Bathrooms: 1
  • Main Half Bathrooms: 2
  • Room Count: 14
  • Basement Detail: Finished, Full
  • Laundry On Main: 1
  • Laundry: 1
  • Sq Ft Approx Above Grade Finished: 5843.00
  • Sq Ft Approx Below Grade Finished: 2000.00
  • Sq Ft Approx Total Finished: 7843.00

Exterior Features

  • View: Water View
  • Exterior: Brick
  • Exterior Features: Deck
  • Roof: Asphalt/Fiberglass

Garage/Parking

  • Driveway: Paved
  • Garage Features: Attached
  • 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: Community, Golf Available, Lake

Condo/Co-op/Association

  • HOA Fees: 600.00
  • HOA Fee Frequency: Quarterly
  • Hoa Name: Barrington Master Association
  • Subdivision Complex: Barrington

Fee Information

  • HOA Fee Includes: Association Insurance, Landscaping, Reserve Fund, Security Staff, Snow Removal

Schools

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

Lot Info

  • Lot Description: Golf Course Frontage
  • Lot Size Units: Acres
  • Acres: 0.8430
  • Parcel Number: 03-016-00-00-143-001

Tax Info

  • Tax: 15318

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 20, 2022
Sold by
Barner Iv Albert F and Barner Reva M
Bought by
Albert And Reva Barner Joint Family Trust
Total Days on Market
341
Current Estimated Value
$1,294,851

Purchase Details

Listed on
Feb 6, 2019
Closed on
Mar 23, 2020
Sold by
Heigel Kevin R and Heigel Linda M
Bought by
Barner Albert F and Barner Reba M
Seller's Agent
The Young Team
Keller Williams Greater Metropolitan
Buyer's Agent
Karen Custodio
Keller Williams Chervenic Rlty
List Price
$849,900
Sold Price
$795,200
Premium/Discount to List
-$54,700
-6.44%

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.70%
Original Mortgage
$636,160
Interest Rate
2.87%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 1, 2000
Sold by
Krueger Kenneth W
Bought by
Heigel Kevin R and Heigel Linda M

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 26, 1999
Sold by
Payne Ken Builders An Ohio Corporation
Bought by
Krueger Kenneth W and Krueger Joan E

Purchase Details

Closed on
Apr 29, 1994
Bought by
Payne Ken Builders An
Source: Public Records

Similar Home in Aurora, OH

  • 460 Berwick Cir, Aurora, OH 44202

    $1,199,500

    • 6 Beds
    • 7 Baths
    • 9,042 Sq Ft
    • 460 Berwick Cir
    • Aurora, OH

    Welcome to this exceptional property nestled in Barrington of Aurora, a true gem in the gated community complete with a Jack Nicklaus-designed golf course. This stunning custom home offers a rare opportunity to enjoy high-end living without the wait of new construction. Nestled on a sprawling 1.26-acre lot with a grand circular driveway and tranquil fountain, an inviting front porch immerse

    Swapna Mandava RE/MAX Traditions

    Section Image

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
Albert And Reva Barner Joint Family Trust $125 Russell Monica E
Barner Albert F $795,075 Village Title Agency Llc
Heigel Kevin R $868,000 Midland Title Security Inc
Krueger Kenneth W $989,000 Midland
Payne Ken Builders An $170,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Barner Albert F $636,160
Previous Owner Heigel Kevin R $350,000
Previous Owner Heigel Kevin R $502,000
Previous Owner Heigel Kevin R $643,000
Previous Owner Heigel Kevin R $650,000
Closed Heigel Kevin R $44,400
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/24/2020 03/24/20 Sold $795,200 0.0% $101 / Sq Ft
01/27/2020 01/27/20 Off Market $795,200 -- --
01/13/2020 01/13/20 Pending -- -- --
06/20/2019 06/20/19 For Sale $849,900 0.0% $108 / Sq Ft
06/06/2019 06/06/19 Pending -- -- --
05/06/2019 05/06/19 Price Changed $849,900 -5.5% $108 / Sq Ft
02/06/2019 02/06/19 For Sale $899,000 -- $115 / 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 $19,082 $426,870 $83,130 $343,740
2023 $18,149 $330,540 $66,500 $264,040
2022 $16,435 $330,540 $66,500 $264,040
2021 $16,528 $330,540 $66,500 $264,040
2020 $15,249 $284,730 $66,500 $218,230
2019 $15,372 $284,730 $66,500 $218,230
2018 $15,318 $295,650 $100,350 $195,300
2017 $17,559 $295,650 $100,350 $195,300
2016 $15,821 $295,650 $100,350 $195,300
2015 $16,269 $295,650 $100,350 $195,300
2014 $16,600 $295,650 $100,350 $195,300
2013 $16,495 $295,650 $100,350 $195,300
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS Now

MLS Number: 4066581

MLS Now

APN: 03-016-00-00-143-001