NOT LISTED FOR SALE

451 Berwick Cir Aurora, OH 44202

Estimated Value: $1,335,642 - $1,579,000

6 Beds
8 Baths
8,707 Sq Ft
$169/Sq Ft Est. Value

Last Sold May 27, 2020

Last sale price $990,000 $114 Per Sq Ft

Est. 48% increase in value since last sale

Current estimated payment $9,536/month

101 Days on Market

Highlights

  • Lake Front
  • On Golf Course
  • Deck
  • Leighton Elementary School Rated A
  • Spa
  • Contemporary Architecture

About This Home

As of May 2020

Chic custom built masterpiece with nearly 9000 SF of finished living space in Sought after Barrington Golf Community! The current owner has invested over a half million dollars in renovations and modern upgrades! Grand two-story foyer w/travertine floors opens to vaulted Great room with coffered ceiling, marble gas FP and wall of windows overlooking perfectly manicured backyard on 18th Green! Chef’s Dream kitchen featuring High End SS appliances, Wolf 48” range with hood & subway tile backsplash. Nice breakfast island and morning room with sliders that lead to the exterior deck, built in grill patio and fire pit. Formal Living & Dining rooms with New Hardwood Floors. Family room off of the Kitchen with trayed ceiling, built in entertainment center and 2nd Gas FP. 1st floor master has it ALL including huge walk in 2 story closet & Glamour bath with custom glass shower with 22 jets. Master has a spiral stairwell which leads to LL sitting room with 3rd FP plus an Exercise room. Vaulted Entertainment room w/full Bar, 4th FP and sliders that lead to the back deck. Open stairwell leads to loft perfect for guest/in-law suite with full bath. Upstairs has 4 bedrooms and 3 full baths. Loaded LL with Rec room, 2nd Bar for entertaining, wine cellar and movie theater. Whole house is hard wired for smart house surround sound. 3 Brand new HVAC furnaces and AC units & humidifiers and air filters have just been installed and house is energy efficient, all bulbs have been replaced with LED!

Last Agent to Sell the Property

Michael Kaim

Real of Ohio License #430767 Listed on: 01/17/2020

Last Buyer's Agent

Kim Esposito

RE/MAX Crossroads Properties License #2001005531

RE/MAX Crossroads Properties

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,875

Year Built

  • Built in 1995

Lot Details

  • 0.91 Acre Lot
  • Lot Dimensions are 97x307
  • Lake Front
  • On Golf Course
  • Wooded Lot

HOA Fees

  • $200 Monthly HOA Fees

Property Views

  • Water
  • Golf Course

Home Design

  • Contemporary Architecture
  • Asphalt Roof

Interior Spaces

  • 8,707 Sq Ft Home
  • 2-Story Property
  • Central Vacuum
  • Sound System
  • 3 Fireplaces
  • Finished Basement
  • Basement Fills Entire Space Under The House
  • Fire and Smoke Detector

Kitchen

  • Built-In Oven
  • Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms | 1 Main Level Bedroom

Parking

  • 5 Car Attached Garage
  • Heated Garage
  • Garage Door Opener

Outdoor Features

  • Spa
  • Deck
  • Patio

Utilities

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

Listing and Financial Details

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

Community Details

Overview

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

Amenities

  • Shops

Recreation

  • Golf Course Community
  • Tennis Courts
  • Community Playground
  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,875

Year Built

Built in 1995

Lot Details

0

HOA Fees

$200 per month

Listing Details

  • Property Type: Residential
  • Property Subtype: Single Family
  • Dwelling Type: Detached
  • Style: Contemporary/Modern
  • Price Per Square Foot: 113.70
  • Estimated Price per Sq Ft: 113.70
  • Year Built Exception: Actual YBT
  • Num Of Stories: 2.00
  • Total Sq Ft: 8707
  • Year Built: 1995
  • Geocode Confidence: Unknown
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2
  • Year Built: 1995

Interior Features

  • Appliances Equipment: Audio System, Central Vacuum, Dishwasher, Garbage Disposal, Microwave, Wall Oven, Range, Refrigerator, Smoke Detector, Hot Tub
  • Fireplaces: 3
  • Total Bedrooms: 6
  • Bedrooms on Main Level: 1
  • Total Bathrooms: 8.00
  • Full Bathrooms: 5
  • Half Bathrooms: 3
  • Main Level Full Bathrooms: 1
  • Lower Level Half Bathrooms: 1
  • Main Half Bathrooms: 2
  • Room Count: 9
  • Basement Detail: Finished, Full
  • Laundry On Main: 1
  • Laundry: 1
  • Sq Ft Approx Above Grade Finished: 8707.00
  • Sq Ft Approx Total Finished: 8707.00

Exterior Features

  • View: Golf Course, Water View
  • Exterior Features: Deck, Patio
  • Roof: Asphalt/Fiberglass

Garage/Parking

  • Driveway: Paved
  • Garage Features: Attached, Door Opener, Electric, Heated, Water Available
  • Garage Num Of Cars: 5

Utilities

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

Association/Amenities

  • Amenities: Golf Available, Playground, Pool, Shopping/Mall, Tennis Courts

Condo/Co-op/Association

  • HOA Fees: 600.00
  • HOA Fee Frequency: Quarterly
  • Hoa Name: Barrington Mstr Assoc
  • Subdivision Complex: Barrington

Fee Information

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

Schools

  • School District: Aurora CSD

Lot Info

  • Lot Dimensions: 97x307
  • Lot Description: Golf Course Frontage, Lake Front, Wooded/Treed
  • Lot Size Units: Acres
  • Acres: 0.9070
  • Parcel Number: 03-016-00-00-145-001

Tax Info

  • Tax: 15875

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 17, 2020
Closed on
May 26, 2020
Sold by
Hair Jeffrey L and The Jeffrey L Hair Living Trus
Bought by
Patel Ajay P and Patel Asmitaben A
Seller's Agent
Michael Kaim
Real of Ohio
Buyer's Agent
Kim Esposito
RE/MAX Crossroads Properties
List Price
$995,900
Sold Price
$990,000
Premium/Discount to List
-$5,900
-0.59%
Current Estimated Value
$1,469,661

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$479,661
Avg. Annual Appreciation
7.43%
Original Mortgage
$490,000
Outstanding Balance
$244,674
Interest Rate
3.3%
Mortgage Type
New Conventional
Estimated Equity
$1,224,987

Purchase Details

Listed on
Feb 5, 2015
Closed on
Mar 30, 2016
Sold by
Huntington National Bank The
Bought by
Hair Jeffrey L
Seller's Agent
Heather Lutz Neal
Century 21 Goldfire Realty
Buyer's Agent
Rich Lubinski
Howard Hanna
List Price
$809,900
Sold Price
$575,000
Premium/Discount to List
-$234,900
-29%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.92%
Interest Rate
3.71%

Purchase Details

Closed on
Dec 4, 2014
Sold by
Eggett Thomas J and Eggett Thomas
Bought by
The Huntington National Bank

Purchase Details

Closed on
Nov 9, 2000
Sold by
Eggett Thomas J
Bought by
Eggett Thomas J and Eggett Joanna L

Purchase Details

Closed on
Oct 20, 1997
Sold by
Dillman Harold L
Bought by
Eggert 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
$668,850
Interest Rate
6.75%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Patel Ajay P $990,000 Ohio Real Title
Hair Jeffrey L $575,000 --
The Huntington National Bank $612,000 None Available
Eggett Thomas J -- Guardian Title
Eggert Thomas J $955,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Patel Ajay P $490,000
Previous Owner Hair Jeffrey L --
Previous Owner Eggert Thomas J $668,850
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/27/2020 05/27/20 Sold $990,000 -0.6% $114 / Sq Ft
04/27/2020 04/27/20 Pending -- -- --
01/17/2020 01/17/20 For Sale $995,900 +73.2% $114 / Sq Ft
03/28/2016 03/28/16 Sold $575,000 -29.0% $69 / Sq Ft View Prior Sale
03/24/2016 03/24/16 Pending -- -- --
02/05/2015 02/05/15 For Sale $809,900 -- $97 / 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,546 $437,260 $87,500 $349,760
2023 $18,739 $341,290 $70,000 $271,290
2022 $16,970 $341,290 $70,000 $271,290
2021 $17,066 $341,290 $70,000 $271,290
2020 $15,773 $294,210 $70,000 $224,210
2019 $15,899 $294,210 $70,000 $224,210
2018 $19,519 $328,380 $127,720 $200,660
2017 $19,519 $328,380 $127,720 $200,660
2016 $17,572 $328,380 $127,720 $200,660
2015 $19,542 $328,380 $127,720 $200,660
2014 $18,580 $328,380 $127,720 $200,660
2013 $19,269 $328,380 $127,720 $200,660
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: 4160908

MLS Now

APN: 03-016-00-00-145-001