Seller's Agent in 2025
Swapna Mandava
RE/MAX Revealty
(216) 999-1654
5 in this area
49 Total Sales
460 Berwick Cir Aurora, OH 44202
6
Beds
7
Baths
9,042
Sq Ft
1.25
Acres
Highlights
- On Golf Course
- Sauna
- Views of Trees
- Miller Elementary School Rated A-
- Gated Parking
- 1.25 Acre Lot
About This Home
As of October 2025Welcome 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 yourself in the grandeur of a perfect blend of Mediterranean charm and modern functionality home. Featuring a grand two-story foyer with travertine and marble floors, immaculate formal living and dining areas, and a light-filled family room with wall of windows, a wet bar and fireplace exudes sophistication. Expansive chef's kitchen is a culinary dream, boasting Viking appliances and a huge island. Study is conveniently tucked away with built-ins. A private first-floor master suite provides a relaxing retreat with sitting area, dual closets and a luxurious bath with 2-sided fireplace. Upstairs, find five generously sized bedrooms, including a unique in-law/teen suite with private stairs to the garage. Expansive finished lower level offers endless possibilities with rec. room, flex rooms and full bath with multi jetted steam bath; truly an entertainer's dream space. Outside, enjoy a private patio, a sprawling yard with possibility to add a future pool, and a convenient four-car garage. This house boasts impeccable quality, timeless design offering both privacy and prestige. It is more than a home; it's a lifestyle. Qualified buyers, call or message me to schedule your private showing!
Last Agent to Sell the Property
RE/MAX Revealty Brokerage Email: smandava@remax.net, 440-821-8501 License #2003018568 Listed on: 03/21/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $16,049
Year Built
- Built in 2006
Lot Details
- 1.25 Acre Lot
- On Golf Course
- East Facing Home
- Landscaped
- Private Lot
- Corner Lot
- Front and Back Yard Sprinklers
- Wooded Lot
- Few Trees
- Garden
HOA Fees
- $217 Monthly HOA Fees
Parking
- 4 Car Direct Access Garage
- Running Water Available in Garage
- Inside Entrance
- Parking Accessed On Kitchen Level
- Lighted Parking
- Rear-Facing Garage
- Garage Door Opener
- Circular Driveway
- Gated Parking
- Additional Parking
Property Views
- Trees
- Neighborhood
Home Design
- Colonial Architecture
- Fiberglass Roof
- Asphalt Roof
- Stucco
Interior Spaces
- 2-Story Property
- Open Floorplan
- Wet Bar
- Central Vacuum
- Sound System
- Built-In Features
- Crown Molding
- Tray Ceiling
- High Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Double Sided Fireplace
- Fireplace With Glass Doors
- Gas Log Fireplace
- Double Pane Windows
- Drapes & Rods
- Blinds
- Window Screens
- Entrance Foyer
- Family Room with Fireplace
- 2 Fireplaces
- Storage
- Sauna
- Finished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Viking Appliances
- Kitchen Island
- Granite Countertops
Bedrooms and Bathrooms
- 6 Bedrooms | 1 Main Level Bedroom
- Fireplace in Primary Bedroom
- Dual Closets
- In-Law or Guest Suite
- 7 Bathrooms
- Double Vanity
Outdoor Features
- Patio
- Terrace
- Front Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
Listing and Financial Details
- Assessor Parcel Number 03-016-00-00-156-000
Community Details
Overview
- Association fees include common area maintenance, insurance, reserve fund, security
- Barrington Estates Coral Company Association
- Barrington Estates Subdivision
Amenities
- Clubhouse
Recreation
- Golf Course Community
- Tennis Courts
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Mar 21, 2025
Closed on
Oct 23, 2025
Sold by
Bathla Pritam S and Bathla Kulwant K
Bought by
Sodhi Varun and Sodhi Anika
Seller's Agent
Swapna Mandava
RE/MAX Revealty
Buyer's Agent
Sebastian Neikirk
Cutler Real Estate
List Price
$1,199,500
Sold Price
$1,112,500
Premium/Discount to List
-$87,000
-7.25%
Views
240
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-0.34%
Original Mortgage
$806,500
Outstanding Balance
$806,500
Interest Rate
5.75%
Mortgage Type
New Conventional
Estimated Equity
$305,239
Purchase Details
Closed on
Nov 20, 2019
Sold by
Bathla Pritam S and Bathla Kulwant K
Bought by
Singh Parminder Kaur and Bathla Baljinder Singh
Purchase Details
Closed on
Apr 15, 2010
Sold by
Jpmorgan Chase Bank National Association
Bought by
Bathla Pritam S and Bathla Kulwant K
Purchase Details
Closed on
Dec 22, 2009
Sold by
Nelson Willie
Bought by
Jpmorgan Chase Bank National Association
Purchase Details
Closed on
Jun 29, 2006
Sold by
Breezy Point Lp
Bought by
Nelson Willie
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$150,000
Interest Rate
6.68%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Oct 10, 1991
Bought by
Breezy Point Limited
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
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $1,112,500 | Ohio Real Title | |
| Warranty Deed | -- | None Available | |
| Corporate Deed | $480,000 | Resource Title Agency Inc | |
| Sheriffs Deed | $680,000 | None Available | |
| Warranty Deed | $175,000 | Revere Title | |
| Deed | -- | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $806,500 | New Conventional | |
| Previous Owner | $150,000 | Purchase Money Mortgage |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 10/23/2025 10/23/25 | Sold | $1,112,500 | -7.3% | $123 / Sq Ft |
| 07/01/2025 07/01/25 | For Sale | $1,199,500 | +7.8% | $133 / Sq Ft |
| 06/30/2025 06/30/25 | Off Market | $1,112,500 | -- | -- |
| 06/20/2025 06/20/25 | Price Changed | $1,199,500 | -4.0% | $133 / Sq Ft |
| 03/21/2025 03/21/25 | For Sale | $1,250,000 | -- | $138 / Sq Ft |
Source: MLS Now
Tax History Compared to Growth
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 | $16,049 | $368,830 | $61,250 | $307,580 |
| 2023 | $15,549 | $292,360 | $57,750 | $234,610 |
| 2022 | $14,111 | $292,360 | $57,750 | $234,610 |
| 2021 | $14,213 | $292,360 | $57,750 | $234,610 |
| 2020 | $13,040 | $251,650 | $57,750 | $193,900 |
| 2019 | $13,129 | $251,650 | $57,750 | $193,900 |
| 2018 | $13,114 | $229,040 | $63,840 | $165,200 |
| 2017 | $13,114 | $229,040 | $63,840 | $165,200 |
| 2016 | $11,803 | $229,040 | $63,840 | $165,200 |
| 2015 | $12,152 | $229,040 | $63,840 | $165,200 |
| 2014 | $12,398 | $229,040 | $63,840 | $165,200 |
| 2013 | $12,320 | $229,040 | $63,840 | $165,200 |
Source: Public Records
Agents Affiliated with this Home
-
Swapna Mandava
-
Sebastian Neikirk
Buyer's Agent in 2025
Sebastian Neikirk
Cutler Real Estate
(330) 569-8253
1 in this area
28 Total Sales
Map
Source: MLS Now
MLS Number: 5108449
APN: 03-016-00-00-156-000
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Nearby Homes
- 85 Brighton Dr
- 398 N Chillicothe Rd
- 405 Club Dr W
- 905 Club Dr W
- 196 Chisholm Ct
- 622 Club Dr W
- 818 Hilliary Ln
- 640 Club Dr W
- 185 N Bissell Rd
- 0 Aurora Hill Dr Unit 3956102
- 752 Club Dr W
- 762 Club Dr W
- 159 Royal Oak Dr
- 805 Club Dr W
- 913 Arthur Trail
- 830 Club Dr W
- 825 Club Dr W
- S/L 3 Iris Place
- 515 Woodview Trail
- 109 S Chillicothe Rd