NOT LISTED FOR SALE

857 Hilliary Ln Aurora, OH 44202

Estimated Value: $401,000 - $514,000

3 Beds
2.5 Baths
3,548 Sq Ft
$134/Sq Ft Est. Value

Last Sold June 09, 2021

Last sale price $400,000 $113 Per Sq Ft

Est. 19% increase in value since last sale

Current estimated payment $3,137/month

3 Days on Market

Highlights

  • Colonial Architecture
  • 1 Fireplace
  • Patio
  • Leighton Elementary School Rated A
  • 2 Car Direct Access Garage
  • Home Security System

About This Home

As of June 2021

Fall in love and move right in to this gorgeous Colonial in the very desirable Villas of Bertram featuring the highly rated Aurora Schools. This home provides a perfect blend of comfort and convenience with valuable updates throughout. From the beautiful stone and vinyl exterior to the open concept living room featuring vaulted ceiling with an impressive fireplace and large windows. 1st floor powder room, dining room, laundry room and gourmet kitchen with granite countertops, full compliment of new stainless appliances, pantry and center island. Outside, you are sure to enjoy the spacious and beautifully maintained backyard with a stone patio and fire pit that are perfect for entertaining or just enjoying a quiet night. 2nd floor features 3 spacious bedrooms and 2 full baths including the owners suite with tray ceiling. Finished lower level leaves nothing to be desired. The lower level includes a spacious rec room and an abundance of additional room for storage. Do NOT miss out on this opportunity to own a gorgeous home in an excellent location!

Last Agent to Sell the Property

Ankur Dhasmana

Keller Williams Greater Metropolitan License #2017001988 Listed on: 04/05/2021

Keller Williams Greater Metropolitan

Last Buyer's Agent

Joon Yub Kim

Deleted Agent License #2016000413

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,410

Year Built

  • Built in 2015

Lot Details

  • 7,971 Sq Ft Lot
  • East Facing Home

HOA Fees

  • $45 Monthly HOA Fees

Parking

  • 2 Car Direct Access Garage

Home Design

  • Colonial Architecture
  • Asphalt Roof
  • Stone Siding
  • Vinyl Construction Material

Interior Spaces

  • 2-Story Property
  • 1 Fireplace

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Patio

Utilities

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

Community Details

  • Association fees include reserve fund
  • Villas Of Bertram Community

Listing and Financial Details

  • Assessor Parcel Number 03-015-10-00-001-010

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,410

Year Built

Built in 2015

Lot Details

0

HOA Fees

$45 per month

Listing Details

  • Property Type: Residential
  • Property Subtype: Single Family
  • Style: Colonial
  • House Faces: East
  • Price Per Square Foot: 174.52
  • Estimated Price per Sq Ft: 174.52
  • Year Built Exception: Actual YBT
  • Num Of Stories: 2.00
  • Total Sq Ft: 2292
  • Year Built: 2015
  • Court Ordered Y N: No
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2
  • Year Built: 2015

Interior Features

  • Appliances Equipment: Dishwasher, Dryer, Garbage Disposal, Humidifier, Microwave, Range, Refrigerator, Security System, Smoke Detector, Sump Pump, Washer
  • Fireplaces: 1
  • Total Bedrooms: 3
  • Total Bathrooms: 3.00
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Main Half Bathrooms: 1
  • Room Count: 8
  • Basement Detail: Finished, Full
  • Laundry On Main: 1
  • Laundry: 1
  • Sq Ft Approx Above Grade Finished: 2292.00
  • Sq Ft Approx Below Grade Finished: 1256.00
  • Sq Ft Approx Total Finished: 3548.00

Exterior Features

  • Exterior: Stone, Vinyl
  • Exterior Features: Patio
  • Roof: Asphalt/Fiberglass

Garage/Parking

  • Driveway: Paved
  • Garage Features: Access from Unit, Attached
  • Garage Num Of Cars: 2

Utilities

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

Condo/Co-op/Association

  • HOA Fees: 540.00
  • HOA Fee Frequency: Annually
  • Hoa Name: Villas of Bertram
  • Subdivision Complex: Villas of Bertram

Fee Information

  • HOA Fee Includes: Reserve Fund

Schools

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

Lot Info

  • Lot Size Units: Acres
  • Acres: 0.1830
  • Parcel Number: 03-015-10-00-001-010

Tax Info

  • Tax: 5410

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 5, 2021
Closed on
Jun 7, 2021
Sold by
Kohli Kanwarpal and Anand Ishmeeta
Bought by
Kim Jihoon and Kook Miyeon
Seller's Agent
Ankur Dhasmana
Keller Williams Greater Metropolitan
Buyer's Agent
Joon Yub Kim
Deleted Agent
List Price
$399,999
Sold Price
$400,000
Premium/Discount to List
$1
0.0%
Current Estimated Value
$477,167

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$77,167
Avg. Annual Appreciation
4.12%
Original Mortgage
$308,320
Outstanding Balance
$279,145
Interest Rate
2.9%
Mortgage Type
New Conventional
Estimated Equity
$198,022

Purchase Details

Listed on
Apr 2, 2018
Closed on
Sep 26, 2018
Sold by
Buckmaster Jerry J and Rigel Kelsey J
Bought by
Kohli Kanwarpal and Anand Ishmeeta
Seller's Agent
Kathy Kilbane
Deleted Agent
Buyer's Agent
Ankur Dhasmana
Keller Williams Greater Metropolitan
List Price
$369,900
Sold Price
$307,000
Premium/Discount to List
-$62,900
-17%

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.30%
Original Mortgage
$276,000
Interest Rate
4.5%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 21, 2014
Sold by
Villas Of Bertram Llc
Bought by
Buckmaster Jerry J and Rigel Kelsey J
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
Kim Jihoon $400,000 Cleveland Home Title
Kohli Kanwarpal $307,000 Great Cleveland Title
Buckmaster Jerry J $326,500 Nvr Title Agency Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Kim Jihoon $308,320
Previous Owner Kohli Kanwarpal $276,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
06/09/2021 06/09/21 Sold $400,000 0.0% $113 / Sq Ft
04/14/2021 04/14/21 Pending -- -- --
04/10/2021 04/10/21 For Sale $399,999 +30.3% $113 / Sq Ft
09/26/2018 09/26/18 Sold $307,000 -10.8% $87 / Sq Ft View Prior Sale
08/27/2018 08/27/18 Pending -- -- --
07/25/2018 07/25/18 Price Changed $344,000 -1.4% $97 / Sq Ft
06/17/2018 06/17/18 Price Changed $349,000 -2.8% $98 / Sq Ft
06/05/2018 06/05/18 Price Changed $359,000 -0.8% $101 / Sq Ft
05/22/2018 05/22/18 Price Changed $362,000 -1.4% $102 / Sq Ft
05/01/2018 05/01/18 Price Changed $367,000 -0.8% $103 / Sq Ft
04/02/2018 04/02/18 For Sale $369,900 +13.3% $104 / Sq Ft
02/13/2015 02/13/15 Sold $326,500 +28.0% $167 / Sq Ft View Prior Sale
09/19/2014 09/19/14 Pending -- -- --
09/02/2014 09/02/14 For Sale $255,000 -- $131 / 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 $6,843 $153,090 $17,500 $135,590
2023 $6,371 $116,030 $17,500 $98,530
2022 $5,769 $116,030 $17,500 $98,530
2021 $5,802 $116,030 $17,500 $98,530
2020 $5,410 $101,010 $17,500 $83,510
2019 $5,453 $101,010 $17,500 $83,510
2018 $5,266 $88,660 $17,500 $71,160
2017 $5,266 $88,660 $17,500 $71,160
2016 $4,744 $88,660 $17,500 $71,160
2015 -- $0 $0 $0
2014 -- $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MLS Now

MLS Number: 4267128

MLS Now

APN: 03-015-10-00-001-010