NOT LISTED FOR SALE

3111 Celeron Ave Cincinnati, OH 45209

Oakley Neighborhood

Estimated Value: $295,000 - $337,289

2 Beds
1 Bath
828 Sq Ft
$374/Sq Ft Est. Value

Sale Details

Date Sold: October 1, 2021

Last sale price $237,500 $287 Per Sq Ft

Est. 30% increase in value since last sale

Current estimated payment $2,142 / mo

12 Days on Market

Highlights

  • View of Trees or Woods
  • Craftsman Architecture
  • Wooded Lot
  • Walnut Hills High School Rated A+
  • Deck
  • Wood Flooring

About This Home

As of October 2021

Picture Perfect Bungalow On Quiet Dead End Street In Oakley! 2 Beds, 1 Bath Ranch w/ Tons Of Character! Large Updated Kitchen w/ Walk-Out To Rear Deck & Private Fenced In Wooded Lot! HDWD Flooring Throughout & French Doors. Full Unfinished Basement Which Adds Extra Space! Newer Roof. Great Location Blocks From Shopping, Dining & Schools!

Last Agent to Sell the Property

Tyler Smith

RE/MAX United Associates License #2013002705 Listed on: 08/19/2021

RE/MAX United Associates

Last Buyer's Agent

Brad Felblinger

Redfin Corporation License #2017005056

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 1918

Lot Details

  • 5,750 Sq Ft Lot
  • Lot Dimensions are 35x153
  • Wood Fence
  • Sloped Lot
  • Wooded Lot

Parking

  • On-Street Parking

Home Design

  • Craftsman Architecture
  • Ranch Style House
  • Poured Concrete
  • Shingle Roof
  • Aluminum Siding

Interior Spaces

  • 828 Sq Ft Home
  • Woodwork
  • Crown Molding
  • Ceiling height of 9 feet or more
  • Double Hung Windows
  • Wood Frame Window
  • French Doors
  • Views of Woods
  • Storm Windows

Kitchen

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

Flooring

  • Wood
  • Concrete

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 1 Full Bathroom

Unfinished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Outdoor Features

  • Deck
  • Patio

Utilities

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

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Year Built

Built in 1918

Lot Details

5,750 Sq Ft Lot

Listing Details

  • Suburb: Oakley
  • Cross Street: Gilmore
  • Land Description: Less than .5 Acre
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: Attic Storage,Busline Near,Cable,Ceiling Fan,Recessed Lights
  • Census Tract Realist: 53.01
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 5750.00
  • Property Ownership: Consumer
  • Suburb S I C: Oakley
  • Price Per Acre: 1799242.42
  • Basement Features: Concrete Floor,Glass Blk Wind,Unfinished,Walkout
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Entry Dim: 0 x 0
  • Entry Foyer: Transom/Sidelit,Wood Floor
  • Living Great Rm Dim: 15 x 14
  • Living Room Feat: Wood Floor
  • Single Family Desc: Single Family
  • Study Lib Den Dim: 0 x 0
  • Water Heating: Gas
  • Year Built: 1918
  • Architecture: Craftsman/Bungalow, Ranch
  • Full Bathrooms: 1
  • Bedrooms: 2
  • Directions: Madison to Gilmore to Celeron Avenue
  • Lot Measurement: Acres
  • Status: Sold
  • On Market Date: 2021-08-21
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • On Market: No
  • Third Party Approval Required: No
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Crown Molding, French Doors, Natural Woodwork
  • Bedroom 2: 13x12 Level: 1
  • Breakfast Room: 8x10 Level: 1
  • Living Room: 15x14 Level: 1
  • Formal Dining Room: No
  • Property Type: Residential
  • Bathrooms Display: 1 (1 0)
  • Reciprocal Listing: No
  • School Name1: Call SD 513-363-0000
  • Semi Annual Taxes: Of Record
  • Kitchen: 14x12 Level: 1
  • Appliances: Dishwasher, Garbage Disposal, Microwave, Oven/Range, Refrigerator
  • Kitchen Features: Eat-In,Pantry,Walkout,Wood Cabinets,Wood Floor
  • Basement: Full
  • Bathrooms: 1.00
  • Kitchen Dim: 14 x 12
  • Levels: One
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Laundryroom Dim: 0 x 0
  • Recreation Room Dim: 0 x 0
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 828.00
  • Windows: Double Hung, Storm, Wood
  • First Floor Family Room: No
  • PrimaryBedroomDim: 13 x 12
  • Primary Bathrooms: Tile Floor,Tub w/Shower
  • PrimaryBedFeat: Bath Adjoins,Wood Floor
  • P R I M A R Y B E D R O O M: 13x12 Level: 1

Exterior Features

  • View: Woods
  • Fencing: Wood
  • Roof: Shingle
  • Construction: Aluminum Siding
  • Outside Features: Deck, Patio, Wooded Lot
  • Foundation: Poured
  • Listing Price: 250000.00
  • Acres: 0.1320
  • New Construction: No
  • TopographyDetails: Sloped

Garage/Parking

  • Garage Carport: None
  • Parking: On Street

Utilities

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

Condo/Co-op/Association

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

Schools

  • District: Cincinnati City SD

Lot Info

  • Lot Dimensions: 35x153
  • Lot Size Sq Ft: 5750.00
  • Total Assessed Value: Of Record
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: No

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
Aug 19, 2021
Closed on
Oct 1, 2021
Sold by
Martin Mackenzie J
Bought by
Seller's Agent
Tyler Smith
RE/MAX United Associates
Buyer's Agent
Brad Felblinger
Redfin Corporation
Sold Price
$237,500
Current Estimated Value
$309,322

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$71,822
Avg. Annual Appreciation
5.47%
Original Mortgage
$170,000
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Listed on
May 10, 2020
Closed on
Jun 10, 2020
Sold by
Cappel John Timothy
Bought by
Martin Mackenzie J
Seller's Agent
Michael McCafferty
Sibcy Cline, Inc.
Buyer's Agent
Tyler Smith
RE/MAX United Associates
List Price
$210,000
Sold Price
$215,000
Premium/Discount to List
$5,000
2.38%

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.89%
Original Mortgage
$204,250
Interest Rate
3.1%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 30, 2015
Sold by
Argadine Michael D and Argadine Whitney M
Bought by
Cappel John Timothy and Cappell Cynthia H

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$123,400
Interest Rate
4%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Jun 15, 2007
Sold by
Whiting Andrew and Whiting Nicole
Bought by
Argadine Michael D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$31,000
Interest Rate
6.26%
Mortgage Type
Stand Alone Second

Purchase Details

Closed on
Jun 14, 2006
Sold by
West Philip and West Amy
Bought by
West Nicole and Whiting Andrew

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$100,000
Interest Rate
4.99%
Mortgage Type
Unknown

Purchase Details

Closed on
Mar 1, 2006
Sold by
Oconnell Mike and Oconnell Margaret June
Bought by
West Philip and West Amy

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$59,900
Interest Rate
5.5%
Mortgage Type
Unknown
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Oakley, OH

  • Patrick Gunning Real Estate Agent - Coldwell Banker Realty

    Patrick Gunning

    Responds Quickly

    Coldwell Banker Realty

    (513) 780-5066

    96 Total Sales

    8 in Oakley

    $225K - $1.4M Price Range

    Patrick Gunning
     Section Image
  • Shawn Bosse Real Estate Agent - Coldwell Banker Realty, Anders

    Shawn Bosse

    Coldwell Banker Realty, Anders

    (513) 586-5923

    115 Total Sales

    1 in Oakley

    $323,250 Price

    Shawn Bosse
     Section Image
  • Patrick Lach Real Estate Agent - Sibcy Cline, Inc.

    Patrick Lach

    Responds Quickly

    Sibcy Cline, Inc.

    (513) 952-8835

    108 Total Sales

    1 in Oakley

    $380,000 Price

    Patrick Lach
     Section Image
  • Hillary Justice Real Estate Agent - Coldwell Banker Realty

    Hillary Justice

    Coldwell Banker Realty

    (513) 647-6201

    180 Total Sales

    6 in Oakley

    $315K - $675K Price Range

    Hillary Justice
     Section Image
  • Terri Cofskey Real Estate Agent - Coldwell Banker Realty

    Terri Cofskey

    Coldwell Banker Realty

    (513) 854-3766

    62 Total Sales

    1 in Oakley

    $465,000 Price

    Terri Cofskey
     Section Image
  • Cindy Jo Holmes Real Estate Agent - Sibcy Cline, Inc.

    Cindy Jo Holmes

    Sibcy Cline, Inc.

    (513) 586-1903

    22 Total Sales

    5 in Oakley

    $300K - $875K Price Range

    Cindy Jo Holmes
     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
$237,500 None Available
Martin Mackenzie J $215,000 None Available
Cappel John Timothy $154,250 Attorney
Argadine Michael D $155,000 American Homeland Title Agen
West Nicole $125,000 Royal Land Title Agency Ltd
West Philip -- None Available
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 $170,000
Previous Owner Martin Mackenzie J $204,250
Previous Owner Cappel John Timothy $123,400
Previous Owner Argadine Michael D $158,631
Previous Owner Argadino Michael D $161,680
Previous Owner Argadine Michael D $31,000
Previous Owner Argadine Michael D $124,000
Previous Owner West Nicole $100,000
Previous Owner West Philip $59,900
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 Prior Sale
10/01/2021 10/01/21 Sold $237,500 -5.0% $287 / Sq Ft
09/01/2021 09/01/21 Pending -- -- --
08/21/2021 08/21/21 For Sale -- -- --
08/19/2021 08/19/21 For Sale $250,000 +16.3% $302 / Sq Ft
09/08/2020 09/08/20 Off Market $215,000 -- --
06/10/2020 06/10/20 Sold $215,000 +2.4% $260 / Sq Ft View Prior Sale
05/12/2020 05/12/20 Pending -- -- --
05/10/2020 05/10/20 For Sale $210,000 -- $254 / 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 $5,119 $83,125 $37,268 $45,857
2023 $5,076 $83,125 $37,268 $45,857
2022 $4,411 $64,786 $22,362 $42,424
2021 $4,245 $64,786 $22,362 $42,424
2020 $4,503 $64,786 $22,362 $42,424
2019 $4,122 $53,988 $18,634 $35,354
2018 $4,126 $53,988 $18,634 $35,354
2017 $3,974 $53,988 $18,634 $35,354
2016 $2,388 $48,363 $14,154 $34,209
2015 $2,030 $48,363 $14,154 $34,209
2014 $2,044 $48,363 $14,154 $34,209
2013 $1,908 $44,370 $12,985 $31,385
Source: Public Records

Agents Affiliated with this Home

  • Tyler Smith Real Estate Agent - RE/MAX

    Seller's Agent in 2021

    Tyler Smith

    RE/MAX

    (513) 293-8971

    2 in this area

    269 Total Sales

    Tyler Smith
    Section Image

  • MM

    Seller's Agent in 2020

    Michael McCafferty

    Sibcy Cline, Inc.

    (513) 662-8800

    1 in this area

    27 Total Sales

    Michael McCafferty
    Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1712755

MLS of Greater Cincinnati (CincyMLS)

APN: 039-0003-0078

Ohio Hamilton County Cincinnati 45209 Oakley

3111 Celeron 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.