NOT LISTED FOR SALE

4074 Treebrook Dr Hilliard, OH 43026

Estimated Value: $476,032 - $575,000

4 Beds
3.5 Baths
2,574 Sq Ft
$204/Sq Ft Est. Value

Last Sold March 20, 2015

Last sale price $255,000 $99 Per Sq Ft

Est. 106% increase in value since last sale

Current estimated payment $3,476/month

111 Days on Market

Highlights

  • Wood Flooring
  • Great Room
  • Patio
  • Hoffman Trails Elementary School Rated A-
  • 2 Car Attached Garage
  • Park

About This Home

As of March 2015

Remarkable Hoffman Farms home with 4 large bedrooms, 3. 5 baths with a professionally landscaped yard including a paver patio! Warm and inviting wood floors that run throughout the first level. A first floor flex space can be a den, dining area or living room. The kitchen, eating area and vaulted great room w/gas log fireplace are all open to one another. The lower level features even more finished space with a bar area, full bath and large laundry area. Storage area too! This house is missing nothing! Great location near the entry with view of the ponds too! What more could you want?

Last Agent to Sell the Property

Lori Hicks

Howard Hanna Real Estate Svcs Listed on: 11/12/2014

Last Buyer's Agent

Rhonda Barton

RE/MAX Resource

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,108

Year Built

  • Built in 1999

Lot Details

  • 9,583

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Brick Exterior Construction
  • Block Foundation
  • Vinyl Siding
  • Stone Exterior Construction

Interior Spaces

  • 2,574 Sq Ft Home
  • 2-Story Property
  • Gas Log Fireplace
  • Insulated Windows
  • Great Room
  • Family Room
  • Laundry on lower level

Kitchen

  • Electric Range
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Garden Bath

Basement

  • Basement Fills Entire Space Under The House
  • Recreation or Family Area in Basement

Utilities

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

Additional Features

  • Patio
  • 9,583 Sq Ft Lot

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 050-008388

Community Details

Overview

  • Property has a Home Owners Association

Recreation

  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,108

Year Built

Built in 1999

Lot Details

0

Parking

2

Listing Details

  • Type: Residential
  • Accessible Features: No
  • Year Built: 1999
  • Tax Year: 2013
  • Property Sub-Type: Single Family Residence
  • Lot Size Acres: 0.22
  • Reso Association Amenities: Park, Sidewalk
  • Co List Office Phone: 614-471-7400
  • MLS Status: Closed
  • Subdivision Name: Hoffman Farms
  • Reso Fireplace Features: Gas Log
  • Reso Interior Features: Dishwasher, Electric Range, Garden/Soak Tub, Microwave, Refrigerator
  • Unit Levels: Two
  • New Construction: No
  • Reso Window Features: Insulated All
  • Basement Basement YN2: Yes
  • Rooms LL Laundry: Yes
  • Air Conditioning Central: Yes
  • Interior Flooring Carpet: Yes
  • Interior Amenities Microwave: Yes
  • Rooms Rec RmBsmt: Yes
  • Foundation:Block: Yes
  • Exterior Vinyl Siding: Yes
  • Rooms Family RmNon Bsmt: Yes
  • Windows Insulated All: Yes
  • Interior Amenities Dishwasher: Yes
  • Exterior:Stone: Yes
  • Interior Amenities Electric Range: Yes
  • Interior Amenities GardenSoak Tub: Yes
  • CmplexSub Amenities Park: Yes
  • Exterior Brick: Yes
  • Levels Two2: Yes
  • Common Walls No Common Walls: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Upstairs Bedrooms: 4
  • Downstairs 1 Full Bathrooms: 1
  • Upstairs 1 Full Bathrooms: 2
  • Entry Level Half Bathrooms: 1
  • Basement: Full
  • Entry Level Dining Room: 1
  • Entry Level Eating Space: 1
  • Entry Level Great Room: 1
  • Recreation Room (Downstairs 1): 1
  • Utility Space (Downstairs 1): 1
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace: Yes
  • Flooring: Wood, Carpet
  • Other Rooms:Dining Room: Yes
  • Basement Description:Full: Yes
  • Other Rooms:Great Room: Yes
  • Fireplace:Gas Log: Yes

Exterior Features

  • Home Warranty: Yes
  • Common Walls: No Common Walls
  • Foundation Details: Block
  • Patio And Porch Features: Patio
  • Patio and Porch Features Patio: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2.0
  • Attached Garage: Yes
  • Parking Features: Garage Door Opener, Attached Garage
  • Parking Features 2 Car Garage: Yes
  • Parking Features Attached Garage: Yes

Utilities

  • Heating: Forced Air
  • Cooling: Central Air
  • Cooling Y N: Yes
  • HeatingYN: Yes
  • Heating:Forced Air: Yes
  • Heating:Gas2: Yes

Condo/Co-op/Association

  • Contact Name: TBD
  • Association Fee: 300.0
  • Phone: TBD
  • Association: Yes

Schools

  • Junior High Dist: HILLIARD CSD 2510 FRA CO.

Lot Info

  • Parcel Number: 050-008388
  • Lot Size Sq Ft: 9583.2

Tax Info

  • Tax Annual Amount: 6108.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 18, 2019
Sold by
Balson William M
Bought by
Balson Janice L
Current Estimated Value
$526,258

Purchase Details

Listed on
Nov 12, 2014
Closed on
Mar 20, 2015
Sold by
Shapiro Andrew I
Bought by
Balson William M and Balson Janice L
Seller's Agent
Lori Hicks
Howard Hanna Real Estate Svcs
Buyer's Agent
Rhonda Barton
RE/MAX Resource
List Price
$270,000
Sold Price
$255,000
Premium/Discount to List
-$15,000
-5.56%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.00%
Original Mortgage
$145,000
Outstanding Balance
$112,946
Interest Rate
3.67%
Mortgage Type
New Conventional
Estimated Equity
$407,122

Purchase Details

Closed on
Nov 12, 2014
Sold by
Shapiro Maria T
Bought by
Shaprio Andrew I

Purchase Details

Closed on
Jul 27, 2013
Sold by
Shapiro Andrew I
Bought by
Shapiro Andrew I and Shapiro Maria T

Purchase Details

Closed on
Oct 26, 2010
Sold by
Henry Hillary L
Bought by
Shapiro Andrew I

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 29, 2003
Sold by
Huss Todd and Huss Suzanne
Bought by
Shapiro Andrew I and Henry Hillary L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$227,050
Interest Rate
4.2%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Apr 15, 1999
Sold by
Dominion Homes Inc
Bought by
Huss Todd E and Schmidt Suzanne D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$157,700
Interest Rate
7.1%
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
Balson William M $255,000 First Ohio Title Ins Box
Shaprio Andrew I -- None Available
Shapiro Andrew I -- None Available
Shapiro Andrew I -- Talon Group
Shapiro Andrew I $239,000 --
Huss Todd E $197,200 Alliance Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Balson William M $145,000
Previous Owner Shapiro Andrew I $212,500
Previous Owner Shapiro Andrew I $227,050
Previous Owner Huss Todd E $157,700
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/20/2015 03/20/15 Sold $255,000 -5.6% $99 / Sq Ft
02/18/2015 02/18/15 Pending -- -- --
11/11/2014 11/11/14 For Sale $270,000 -- $105 / Sq Ft
Source: Columbus and Central Ohio Regional MLS

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,231 $122,890 $37,870 $85,020
2023 $6,702 $122,890 $37,870 $85,020
2022 $6,623 $96,640 $28,390 $68,250
2021 $6,619 $96,640 $28,390 $68,250
2020 $6,602 $96,640 $28,390 $68,250
2019 $6,777 $84,430 $24,680 $59,750
2018 $6,531 $84,430 $24,680 $59,750
2017 $6,752 $84,430 $24,680 $59,750
2016 $6,679 $77,320 $17,500 $59,820
2015 $6,308 $77,320 $17,500 $59,820
2014 $6,319 $77,320 $17,500 $59,820
2013 $3,054 $73,640 $16,660 $56,980
Source: Public Records

Agents Affiliated with this Home

See All Agents

Map

Source: Columbus and Central Ohio Regional MLS

MLS Number: 214045997

Columbus and Central Ohio Regional MLS

APN: 050-008388