NOT LISTED FOR SALE

5700 Colerain Ave Cincinnati, OH 45239

Mount Airy Neighborhood

Estimated Value: $314,000 - $355,000

3 Beds
2.5 Baths
2,787 Sq Ft
$122/Sq Ft Est. Value

Sale Details

Date Sold: May 31, 2016

Last sale price $239,800 $86 Per Sq Ft

Est. 42% increase in value since last sale

Current estimated payment $2,442 / mo

15 Days on Market

Highlights

  • 0.6 Acre Lot
  • Craftsman Architecture
  • No HOA
  • Walnut Hills High School Rated A+
  • Radiant Floor
  • Formal Dining Room

About This Home

As of May 2016

Elegant, old world charm w/updated amenities. 15 minutes to town. Craftsmanship throughout, woodwork & hdwdd flrs along w/archways showcase this home. Brick & stone construction & architectural details are throughout. Enclosed solarium. Updated mechanicals. Pride of ownership is apparent. You will appreciate the condition & character of this home

Last Agent to Sell the Property

Rakesh Ram

Coldwell Banker Realty License #0000342857 Listed on: 03/14/2016

Coldwell Banker Realty

Co-Listed By

Mitchell Ram

Coldwell Banker Realty License #2015001111

Last Buyer's Agent

Andy Childs

Coldwell Banker Realty License #2015001281

Coldwell Banker Realty

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

Est. Annual Taxes

  • $3,269

Year Built

  • Built in 1931

Lot Details

  • 0.6

Parking

  • 2 Car Garage
  • Driveway
  • Assigned Parking

Home Design

  • Craftsman Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Stone

Interior Spaces

  • 2,787 Sq Ft Home
  • 2-Story Property
  • Bookcases
  • Wood Burning Fireplace
  • Gas Fireplace
  • Insulated Windows
  • Family Room
  • Living Room with Fireplace
  • Formal Dining Room
  • Partially Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Oven or Range
  • Microwave
  • Dishwasher
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Radiant Floor
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Utilities

  • Central Air
  • Hot Water Heating System
  • Heating System Uses Gas

Additional Features

  • Patio
  • 26,310 Sq Ft Lot

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,269

Year Built

Built in 1931

Lot Details

0.6 Acres

Parking

2

Listing Details

  • Suburb: Mt. Airy
  • Cross Street: Colerain at Jessup
  • Degree Complete: Completed
  • Land Description: .5 to .9 Acres
  • Broker Approved: Yes
  • Miscellaneous: Cable,Ceiling Fan
  • Census Tract Realist: 83.00
  • Cooling: Central Air
  • Heating: Gas, Hot Water, Radiant Floor
  • Lot Area Realist: 26310.00
  • Suburb S I C: Mt. Airy
  • Price Per Acre: 397019.87
  • Basement Features: Part Finished
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Dining Room Feat: Wood Floor
  • Entry Foyer: Tile Floor,Closet
  • Family Room Feat: WW Carpet,Wood Floor
  • Living Great Rm Dim: 0 x 0
  • Living Room Feat: Wood Floor,Fireplace,Bookcases
  • Single Family Desc: Single Family
  • Study Lib Den: 14x11 Level: Lower
  • Study Lib Den Dim: 14 x 11
  • Year Built: 1931
  • School 1 Type: District Phone
  • Architecture: Craftsman/Bungalow
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Bedrooms: 3
  • Directions: Colerain to Jessup
  • Lot Measurement: Acres
  • Status: Sold
  • On Market Date: 2016-03-14
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • Second Floor Area: 1315
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Bedroom 2: 14x13 Level: 2
  • Bedroom 3: 10x9 Level: 2
  • Dining Room: 16x15 Level: 1
  • Living Room: 0x0 Level: 1
  • Formal Dining Room: Yes
  • Flex Rooms: Media
  • Property Type: Residential
  • Reciprocal Listing: No
  • School Name1: Call SD 513-363-0000
  • Semi Annual Taxes: 1634.36
  • Kitchen: 17x13 Level: 1
  • Appliances: Oven/Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave
  • Kitchen Features: Marble/Granite/Slate,Eat-In,Wood Cabinets,Pantry
  • Basement: Full
  • Study Features: Bookcases
  • Entry: 12x6 Level: 1
  • Bathrooms: 3.00
  • Kitchen Dim: 17 x 13
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Partial
  • Bathroom 2 Level: 1
  • Bathroom 3: Full
  • Bathroom 3 Level: Lower
  • Laundryroom Dim: 0 x 0
  • Recreation Room Dim: 0 x 0
  • Fireplace: Wood, Gas
  • Fireplaces: 1
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 2787.00
  • Windows: Insulated
  • First Floor Family Room: Yes
  • PrimaryBedroomDim: 21 x 15
  • PrimaryBedFeat: Wood Floor,Walk-in Closet
  • P R I M A R Y B E D R O O M: 21x15 Level: 2

Exterior Features

  • Roof: Shingle
  • Construction: Brick, Stone
  • Outside Features: Patio
  • Foundation: Poured
  • Listing Price: 239800.00
  • Acres: 0.6040
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Built in,Oversized
  • Parking: Driveway, 2 Assigned

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: irregular .604
  • Lot Size Sq Ft: 26310.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

Listed on
Mar 14, 2016
Closed on
May 31, 2016
Sold by
Harmeyer Dennis M and Harmeyer Mary Kay
Bought by
Seller's Agent
Rakesh Ram
Coldwell Banker Realty
Buyer's Agent
Andy Childs
Coldwell Banker Realty
List Price
$239,800
Sold Price
$239,800
Current Estimated Value
$339,934

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$100,134
Avg. Annual Appreciation
3.45%
Original Mortgage
$191,840
Interest Rate
3.57%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 29, 1993
Sold by
Harmeyer Dennis M
Bought by
Harmeyer Dennis M
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

  • Robert Smith Real Estate Agent - Coldwell Banker Realty

    Robert Smith

    Coldwell Banker Realty

    (513) 599-1654

    328 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

    525 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

    32 Total Sales

    1 in Mount Airy

    $450,000 Price

    David Welch
     Section Image
  • Mark Schwab Real Estate Agent - OwnerLand Realty, Inc.

    Mark Schwab

    OwnerLand Realty, Inc.

    (513) 586-5203

    41 Total Sales

    1 in Mount Airy

    $130,000 Price

    Mark Schwab
     Section Image
  • Sheila Holmes Howard Real Estate Agent - OwnerLand Realty, Inc.

    Sheila Holmes Howard

    OwnerLand Realty, Inc.

    (513) 854-0224

    50 Total Sales

    1 in Mount Airy

    $144,000 Price

    Sheila Holmes Howard
     Section Image
  • Beth Silber Real Estate Agent - Coldwell Banker Realty

    Beth Silber

    Coldwell Banker Realty

    (513) 650-7552

    235 Total Sales

    1 in Mount Airy

    $270,000 Price

    Beth Silber
     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
$239,300 --
Harmeyer Dennis M -- --
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
Open $228,000
Closed Dahlberg Arthur D $191,840
Previous Owner Harmeyer Dennis M $139,217
Previous Owner Harmeyer Dennis M $37,400
Previous Owner Harmeyer Dennis M $130,000
Previous Owner Harmeyer Dennis M $125,905
Previous Owner Harmeyer Dennis M $125,905
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
09/07/2016 09/07/16 Off Market $239,800 -- --
05/31/2016 05/31/16 Sold $239,800 0.0% $86 / Sq Ft
03/29/2016 03/29/16 Pending -- -- --
03/14/2016 03/14/16 For Sale $239,800 -- $86 / 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 $6,797 $109,865 $9,940 $99,925
2023 $6,740 $109,865 $9,940 $99,925
2022 $6,658 $97,360 $8,243 $89,117
2021 $6,400 $97,360 $8,243 $89,117
2020 $6,587 $97,360 $8,243 $89,117
2019 $6,194 $83,930 $7,105 $76,825
2018 $6,204 $83,930 $7,105 $76,825
2017 $5,893 $83,930 $7,105 $76,825
2016 $3,624 $47,730 $7,728 $40,002
2015 $3,241 $47,730 $7,728 $40,002
2014 $3,258 $47,730 $7,728 $40,002
2013 $3,599 $51,881 $8,400 $43,481
Source: Public Records

Agents Affiliated with this Home

  • Rakesh Ram Real Estate Agent - Coldwell Banker Realty

    Seller's Agent in 2016

    Rakesh Ram

    Coldwell Banker Realty

    (513) 247-1802

    1 in this area

    508 Total Sales

    Rakesh Ram
    Section Image
  • Mitchell Ram Real Estate Agent - Coldwell Banker Realty

    Seller Co-Listing Agent in 2016

    Mitchell Ram

    Coldwell Banker Realty

    (513) 703-7774

    189 Total Sales

    Mitchell Ram
    Section Image
  • Andy Childs Real Estate Agent - Coldwell Banker Realty

    Buyer's Agent in 2016

    Andy Childs

    Coldwell Banker Realty

    (513) 818-5959

    93 Total Sales

    Andy Childs
    Section Image

  • JB

    Buyer Co-Listing Agent in 2016

    Jim Basquette

    Huff Referral Company

    Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1485232

MLS of Greater Cincinnati (CincyMLS)

APN: 231-0002-0043

Ohio Hamilton County Cincinnati 45239 Mount Airy

5700 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.