NOT LISTED FOR SALE

5400 Colerain Ave Cincinnati, OH 45223

Mount Airy Neighborhood

Estimated Value: $115,000 - $164,242

2 Beds
1.5 Baths
1,221 Sq Ft
$117/Sq Ft Est. Value

Sale Details

Date Sold: July 3, 2015

Last sale price $30,500 $25 Per Sq Ft

Est. 368% increase in value since last sale

Current estimated payment $968 / mo

44 Days on Market

Highlights

  • Cape Cod Architecture
  • No HOA
  • Wood Frame Window
  • Walnut Hills High School Rated A+
  • Formal Dining Room
  • 2 Car Detached Garage

About This Home

As of July 2015

2 bedroom cape cod, spacious yard and a 2 car garage!

Last Agent to Sell the Property

Brian Brockman

Bang Realty, Inc. License #2009000214 Listed on: 04/29/2015

Last Buyer's Agent

Carol Roehling

Bang Realty, Inc. License #2002009602

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 Details

Home Type

  • Single Family

Year Built

  • Built in 1929

Lot Details

  • 13,852 Sq Ft Lot
  • Lot Dimensions are 70 x 199

Parking

  • 2 Car Detached Garage
  • Driveway

Home Design

  • Cape Cod Architecture
  • Block Foundation
  • Shingle Roof
  • Shingle Siding
  • Stucco

Interior Spaces

  • 1,221 Sq Ft Home
  • 1.5-Story Property
  • Non-Functioning Fireplace
  • Vinyl Clad Windows
  • Wood Frame Window
  • Formal Dining Room
  • Basement Fills Entire Space Under The House

Bedrooms and Bathrooms

  • 2 Bedrooms

Utilities

  • Forced Air Heating System
  • Heating System Uses Gas

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Year Built

Built in 1929

Lot Details

0.32 Acres

Parking

2

Listing Details

  • Suburb: Mt. Airy
  • Degree Complete: Completed
  • Broker Approved: Yes
  • Census Tract Realist: 85.01
  • Cooling: None
  • Heating: Gas, Forced Air
  • Lot Area Realist: 13852.00
  • Suburb S I C: Mt. Airy
  • Price Per Acre: 95911.95
  • Level 1 Bathroom: No
  • Level 1 Bedroom: No
  • Living Great Rm Dim: 19 x 12
  • Single Family Desc: Single Family
  • Study Lib Den Dim: 0 x 0
  • Year Built: 1929
  • School 1 Type: District Phone
  • Architecture: Cape Cod
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Bedrooms: 2
  • Directions: Colerain Ave, Just S of North Bend Rd.
  • Lot Measurement: Acres
  • Status: Sold
  • On Market Date: 2015-04-29
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Bedroom 2: 13x11 Level: 2
  • Dining Room: 13x13 Level: 1
  • Living Room: 19x12 Level: 1
  • Formal Dining Room: Yes
  • Property Type: Residential
  • Reciprocal Listing: No
  • School Name1: Call SD 513-363-0000
  • Semi Annual Taxes: of record
  • Kitchen: 13x12 Level: 1
  • Basement: Full
  • Bathrooms: 2.00
  • Kitchen Dim: 13 x 12
  • Levels: OneandOneHalf
  • Zero Selling Price: No
  • Laundryroom Dim: 0 x 0
  • Recreation Room Dim: 0 x 0
  • Fireplace: Inoperable
  • Fireplaces: 1
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 1221.00
  • Windows: Vinyl/Alum Clad, Vinyl, Wood
  • First Floor Family Room: No
  • PrimaryBedroomDim: 13 x 12
  • P R I M A R Y B E D R O O M: 13x12 Level: 2

Exterior Features

  • Roof: Shingle
  • Construction: Shingle Siding, Stucco
  • Foundation: Block
  • Listing Price: 29900.00
  • Acres: 0.3180
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Garage Detached
  • Parking: Driveway

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Fee Frequency: Other
  • HOA Yes/No: No
  • Association: Cincinnati Area Multiple Listing Service

Schools

  • District: Cincinnati City SD

Lot Info

  • Lot Dimensions: 70 x 199
  • Lot Size Sq Ft: 13852.00
  • Total Assessed Value: of record
  • ResoLotSizeUnits: Acres

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Closed on
May 8, 2014
Sold by
Bought by
Current Estimated Value
$142,811

Purchase Details

Closed on
Jun 28, 2013
Sold by
Bought by

Purchase Details

Closed on
Jul 27, 2007
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$76,696
Interest Rate
6.76%
Mortgage Type
FHA

Purchase Details

Closed on
Jul 7, 2006
Sold by
Bought by

Purchase Details

Closed on
May 30, 2006
Sold by
Bought by

Purchase Details

Closed on
Mar 10, 2005
Sold by
Bought by

Purchase Details

Closed on
Oct 16, 2001
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$64,390
Interest Rate
6.92%
Mortgage Type
FHA

Purchase Details

Closed on
Sep 26, 1996
Sold by
Bought by

Purchase Details

Closed on
Feb 2, 1994
Sold by
Bought by
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Mount Airy, OH

  • Bryan Smith Real Estate Agent - eXp Realty, LLC

    Bryan Smith

    Responds Quickly

    eXp Realty, LLC

    (513) 854-1085

    126 Total Sales

    1 in Mount Airy

    $262,000 Price

    Bryan Smith
     Section Image
  • Lakisha Scruggs Real Estate Agent - Huff Realty

    Lakisha Scruggs

    Huff Realty

    (513) 866-8529

    169 Total Sales

    4 in Mount Airy

    $201K - $410K Price Range

    Lakisha Scruggs
     Section Image
  • Tom Sturm Real Estate Agent - Coldwell Banker Realty

    Tom Sturm

    Coldwell Banker Realty

    (513) 586-4566

    237 Total Sales

    1 in Mount Airy

    $170,000 Price

    Tom Sturm
     Section Image
  • Robert Smith Real Estate Agent - Coldwell Banker Realty

    Robert Smith

    Coldwell Banker Realty

    (513) 599-1654

    327 Total Sales

    4 in Mount Airy

    $155K - $169K Price Range

    Robert Smith
     Section Image
  • Cindy Shetterly Real Estate Agent - Keller Williams Realty Service

    Cindy Shetterly

    Keller Williams Realty Service

    (513) 866-3124

    530 Total Sales

    3 in Mount Airy

    $165K - $190K Price Range

    Cindy Shetterly
     Section Image
  • David Welch Real Estate Agent - Comey & Shepherd REALTORS

    David Welch

    Comey & Shepherd REALTORS

    (513) 547-3744

    34 Total Sales

    1 in Mount Airy

    $450,000 Price

    David Welch
     Section Image
See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$36,000 None Available
-- None Available
$77,900 Title Pro Inc
-- None Available
$8,923 Lakeside Title & Escrow Agen
$46,000 None Available
$64,900 --
$45,000 --
-- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Previous Owner $76,696
Previous Owner $64,390
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
10/15/2015 10/15/15 Off Market $30,500 -- --
07/03/2015 07/03/15 Sold $30,500 -23.6% $25 / Sq Ft
06/12/2015 06/12/15 Pending -- -- --
04/29/2015 04/29/15 For Sale $39,900 -- $33 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2025 $2,195 $34,301 $12,128 $22,173
2023 $2,196 $34,301 $12,128 $22,173
2022 $916 $12,670 $10,003 $2,667
2021 $893 $12,670 $10,003 $2,667
2020 $896 $12,670 $10,003 $2,667
2019 $848 $10,675 $8,624 $2,051
2018 $829 $10,675 $8,624 $2,051
2017 $798 $10,675 $8,624 $2,051
2016 $1,258 $10,676 $9,440 $1,236
2015 $1,083 $15,884 $9,440 $6,444
2014 $1,374 $20,101 $9,440 $10,661
2013 $1,448 $21,851 $10,262 $11,589
Source: Public Records

Agents Affiliated with this Home

  • Brian Brockman Real Estate Agent - Bang Realty, Inc.

    Seller's Agent in 2015

    Brian Brockman

    Bang Realty, Inc.

    (513) 898-1551

    217 Total Sales

    Brian Brockman
    Section Image

  • C

    Buyer's Agent in 2015

    Carol Roehling

    Bang Realty, Inc.

    (513) 200-5711

    7 Total Sales

    Carol Roehling
    Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1446986

MLS of Greater Cincinnati (CincyMLS)

APN: 227-0001-0036

Ohio Hamilton County Cincinnati 45223 Mount Airy

5400 Colerain Ave, Cincinnati, OH

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.

MLS of Greater Cincinnati (CincyMLS) The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
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.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.