NOT LISTED FOR SALE

5589 Madrid Dr Westerville, OH 43081

Estimated Value: $326,000 - $338,010

4 Beds
2.5 Baths
2,052 Sq Ft
$161/Sq Ft Est. Value

Last Sold July 10, 2015

Last sale price $148,250 $72 Per Sq Ft

Est. 123% increase in value since last sale

Current estimated payment $2,280/month

43 Days on Market

Highlights

  • 0.75 Acre Lot
  • Stream or River on Lot
  • Shed
  • Westerville Central High School Rated A-
  • Wooded Lot
  • Ceramic Tile Flooring

About This Home

As of July 2015

This 2 story 4 bedroom 2 1/2 bath home is in the Huber Ridge Subdivision. It is on an amazing 3/4 of an acre lot that backs up to Alum Creek. Located in the Westerville school district. Great Location.

Columbia gas energy audit completed in 2014. Attic insulated to R-49 walls spray insulated.

Side extended driveway

OPEN HOUSE SAT MAY 30th 1-3

Last Agent to Sell the Property

Lynda Pivetz

Carleton Realty, LLC Listed on: 05/01/2015

Last Buyer's Agent

Kristopher Shannon

RE/MAX Connection

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1962

Lot Details

  • 0.75 Acre Lot
  • Sloped Lot
  • Wooded Lot

Parking

  • 1 Car Garage

Home Design

  • Brick Exterior Construction
  • Vinyl Siding

Interior Spaces

  • 2,052 Sq Ft Home
  • 2-Story Property
  • Insulated Windows
  • Laundry on main level

Kitchen

  • Electric Range
  • Microwave
  • Dishwasher

Flooring

  • Carpet
  • Ceramic Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms

Outdoor Features

  • Stream or River on Lot
  • Shed
  • Storage Shed

Utilities

  • Central Air
  • Heating System Uses Gas

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 110-003485

Community Details

Overview

  • Property has a Home Owners Association
  • Property is near a ravine

Recreation

  • Bike Trail

Home Details

Home Type

Single Family

Year Built

Built in 1962

Lot Details

0

Parking

1

Listing Details

  • Type: Residential
  • Accessible Features: No
  • Year Built: 1962
  • Tax Year: 2013
  • Property Sub-Type: Single Family Residence
  • ResoLotFeatures: Ravine Lot, Stream On Lot, Wooded
  • Lot Size Acres: 0.75
  • Reso Association Amenities: Bike/Walk Path
  • Co List Office Phone: 614-891-0000
  • MLS Status: Closed
  • Subdivision Name: Huber Ridge
  • Reso Interior Features: Dishwasher, Electric Range, Microwave, Refrigerator
  • Unit Levels: Two
  • New Construction: No
  • Reso Window Features: Insulated All
  • Basement Basement YN2: No
  • Air Conditioning Central: Yes
  • Interior Flooring Carpet: Yes
  • Interior Amenities Microwave: Yes
  • Lot Characteristics Ravine Lot: Yes
  • Lot Characteristics Stream On Lot: Yes
  • Lot Characteristics Wooded: Yes
  • Interior Flooring CeramicPorcelain: Yes
  • Interior Flooring Vinyl: Yes
  • Lot Characteristics Sloped Lot: Yes
  • Exterior Vinyl Siding: Yes
  • Windows Insulated All: Yes
  • Interior Amenities Dishwasher: Yes
  • Interior Amenities Electric Range: Yes
  • CmplexSub Amenities BikeWalk Path: Yes
  • Exterior Brick: Yes
  • Rooms 1st Flr Laundry: Yes
  • Levels Two2: Yes
  • Other Structures Storage Shed: Yes
  • Common Walls No Common Walls: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Upstairs 2 Bedrooms: 4
  • Upstairs 2 Full Bathrooms: 2
  • Entry Level Half Bathrooms: 1
  • Basement YN: No
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Flooring: Carpet, Ceramic/Porcelain, Vinyl

Exterior Features

  • Home Warranty: Yes
  • Common Walls: No Common Walls
  • Other Structures: Shed(s)

Garage/Parking

  • Garage Spaces: 1.0
  • Parking Features 1 Car Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Association: Yes

Schools

  • Junior High Dist: WESTERVILLE CSD 2514 FRA CO.

Lot Info

  • Parcel Number: 110-003485
  • Lot Size Sq Ft: 32670.0

Tax Info

  • Tax Annual Amount: 4233.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 10, 2022
Sold by
Smith Ronald L
Bought by
Hamrick Renae L
Current Estimated Value
$330,253

Purchase Details

Listed on
May 1, 2015
Closed on
Jul 9, 2015
Sold by
Sehgal R Ajesh
Bought by
Smith Ronald L and Smith Debra D
Seller's Agent
Lynda Pivetz
Carleton Realty, LLC
Buyer's Agent
Kristopher Shannon
RE/MAX Connection
List Price
$154,900
Sold Price
$148,250
Premium/Discount to List
-$6,650
-4.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
8.08%
Original Mortgage
$100,000
Interest Rate
4.05%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 30, 2007
Sold by
Bertrand Andrew D and Bertrand Laurie M
Bought by
Sehgal Rajesh

Home Financials for this Owner

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

Purchase Details

Closed on
May 24, 2005
Sold by
Mosure John T and Mosure Linda S
Bought by
Bertrand Andrew D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$135,800
Interest Rate
6.07%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Aug 2, 1999
Sold by
Grace Baptist Church
Bought by
Mosure John T and Mosure Linda S

Purchase Details

Closed on
May 3, 1999
Sold by
Mosure John T and Mosure Linda S
Bought by
Mosure John T and Mosure Linda S

Purchase Details

Closed on
Mar 16, 1987
Bought by
Mosure John T and Mosure Linda S
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
Hamrick Renae L -- Studer Sheree L
Smith Ronald L $148,800 Expedient Title Ltd
Sehgal Rajesh $151,500 Fati
Bertrand Andrew D $140,000 Northwest T
Mosure John T -- Valley Title
Mosure John T -- Franklin Abstract
Mosure John T $64,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Smith Ronald L $100,000
Previous Owner Sehgal Rajesh $143,925
Previous Owner Bertrand Andrew D $135,800
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/27/2025 03/27/25 Off Market $148,250 -- --
07/10/2015 07/10/15 Sold $148,250 -4.3% $72 / Sq Ft
06/10/2015 06/10/15 Pending -- -- --
04/16/2015 04/16/15 For Sale $154,900 -- $75 / 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 $6,501 $104,860 $26,250 $78,610
2023 $6,362 $104,860 $26,250 $78,610
2022 $5,779 $71,540 $15,330 $56,210
2021 $5,852 $71,540 $15,330 $56,210
2020 $5,848 $71,540 $15,330 $56,210
2019 $4,805 $53,830 $15,330 $38,500
2018 $4,483 $53,830 $15,330 $38,500
2017 $4,625 $53,830 $15,330 $38,500
2016 $4,625 $48,800 $11,450 $37,350
2015 $4,349 $48,800 $11,450 $37,350
2014 $4,350 $48,800 $11,450 $37,350
2013 $2,132 $48,790 $11,445 $37,345
Source: Public Records

Agents Affiliated with this Home

See All Agents

Map

Source: Columbus and Central Ohio Regional MLS

MLS Number: 215012424

Columbus and Central Ohio Regional MLS

APN: 110-003485