Skip main navigation
For sale
  • $899,900

    4117 34th Ave, Cincinnati, OH 45209

    4beds
    8,098sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1915
    0.26 Acres Lot
    $-- Zestimate®
    $111/sqft
    $-- HOA

    What's special

    Beer tapExpansive floor planIce makerStunning stained glass windows
    Incredible single family home for those seeking a truly unique living experience! With an impressive 8,098 sq ft, this property combines architectural details + extensive renovations. Soaring 25 ft ceilings w/stunning stained glass windows create a striking atmosphere. Imagine the parties & special occasions that can take place here! Expansive floor plan provides versatile opportunities for customization, allowing for home offices, artist studios, wellness areas, cooking, or any of your hobbies. 2 Kitchen spaces w/top of the line appliances: 8 burner gas range, 60 in refrigerator/freezer, 3 dishwashers, ice maker, beer tap, wine & bev centers! Modern upgrades to plumbing, electric, HVAC, offer optimal comfort & reasonable utility costs. New 3 Car Garage with EV charger 2021. New patio w/gas fire table 2021. New Roof & Gutters 2015. New 2 person Sauna! Walkable neighborhood just a block from Homearama with $1.7 million dollar homes! 2 lots allow for additional investment opportunities.
    95 days
    |
    1,452
    |
    100
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Rick J Finn 513-702-4090,

    Coldwell Banker Realty 513-321-9944,

    Holly Finn 513-560-6513,

    Coldwell Banker Realty

    Source: Cincy MLS,MLS#: 1873364MLS LogoOriginating MLS: Cincinnati Area Multiple Listing Service

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 5
      • Full bathrooms: 2
      • 1/2 bathrooms: 3
      Primary bedroom
      • Features: Bath Adjoins, Vaulted Ceiling(s), Walk-In Closet(s), Sitting Room, Wood Floor
      • Level: Second
      • Area: 384
      • Dimensions: 24 x 16
      Bedroom 2
      • Level: Second
      • Area: 195
      • Dimensions: 15 x 13
      Bedroom 3
      • Level: Third
      • Area: 420
      • Dimensions: 21 x 20
      Bedroom 4
      • Level: Lower
      • Area: 616
      • Dimensions: 28 x 22
      Bedroom 5
      • Area: 0
      • Dimensions: 0 x 0
      Primary bathroom
      • Features: Shower, Tile Floor, Double Vanity, Tub, Marb/Gran/Slate
      Bathroom 1
      • Features: Full
      • Level: Second
      Bathroom 2
      • Features: Full
      • Level: Lower
      Bathroom 3
      • Features: Partial
      • Level: First
      Bathroom 4
      • Features: Partial
      • Level: First
      Dining room
      • Features: Chandelier, Wood Floor
      • Level: Lower
      • Area: 500
      • Dimensions: 25 x 20
      Family room
      • Features: Bookcases, Wood Floor
      • Area: 980
      • Dimensions: 35 x 28
      Great room
      • Features: Bookcases, Walkout, Wet Bar, Wood Floor
      • Level: First
      • Area: 800
      • Dimensions: 32 x 25
      Kitchen
      • Features: Pantry, Quartz Counters, Counter Bar, Eat-in Kitchen, Walkout, Gourmet, Kitchen Island, Wood Cabinets, Wood Floor, Marble/Granite/Slate
      • Area: 312
      • Dimensions: 26 x 12
      Living room
      • Features: Wood Floor, Other
      • Area: 1260
      • Dimensions: 45 x 28
      Office
      • Features: Wood Floor
      • Level: Second
      • Area: 96
      • Dimensions: 12 x 8
      Heating
      • Forced Air, Gas, Steam
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Wine Cooler, Other, Gas Water Heater
      Features
      • High Ceilings, Cathedral Ceiling(s), Natural Woodwork, Vaulted Ceiling(s), Other, Ceiling Fan(s)
      • Doors: Multi Panel Doors
      • Windows: Double Hung, Double Pane Windows, Vinyl, Insulated Windows
      • Basement: Full,Finished,Walk-Out Access,Glass Blk Wind
      • Attic: Storage
      • Number of fireplaces: 1
      • Fireplace features: Gas
      Interior area
      • Total structure area: 8,098
      • Total interior livable area: 8,098 sqft

      Property

      Parking
      • Total spaces: 3
      • Parking features: Off Street, Driveway
      • Garage spaces: 3
      • Has uncovered spaces: Yes
      Features
      • Stories: 3
      • Patio & porch: Deck, Patio, Porch
      • Fencing: Privacy,Wood
      Lot
      • Size: 0.26 Acres
      • Dimensions: 80 x 140
      • Features: Less than .5 Acre, Busline Near
      Details
      • Parcel number: 0490004021800
      • Zoning description: Residential

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Traditional
      • Property subtype: Single Family Residence
      Materials
      • Brick
      • Foundation: Stone
      • Roof: Shingle
      Condition
      • New construction: No
      • Year built: 1915

      Utilities & green energy

      • Electric: 220 Volts
      • Gas: Natural
      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Cable Connected

      Community & HOA

      Community
      • Security: Smoke Alarm
      HOA
      • Has HOA: No
      Location
      • Region: Cincinnati

      Financial & listing details

      • Price per square foot: $111/sqft
      • Tax assessed value: $55,230
      • Annual tax amount: $12,860
      • Date on market: 4/12/2026
      • Listing terms: No Special Financing

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        4/12/2026Listed for sale$899,900-5.3%$111/sqft
        Source: Cincy MLS #1873364 Report a problem
        8/30/2025Listing removed$949,900$117/sqft
        Source: Cincy MLS #1837327 Report a problem
        7/7/2025Price change$949,900-5%$117/sqft
        Source: Cincy MLS #1837327 Report a problem
        5/20/2025Price change$999,900-9.1%$123/sqft
        Source: Cincy MLS #1837327 Report a problem
        4/29/2025Listed for sale$1,100,000+378.3%$136/sqft
        Source: Cincy MLS #1837327 Report a problem
        3/14/2014Sold$230,000$28/sqft
        Source: Cincy MLS #1374160 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024$1,234 -0.2%$19,331
        2023$1,236 +49.3%$19,331 +66.8%
        2022$828 +1.9%$11,592
        2021$813 $11,592
        2020$813 +9%$11,592 +20%
        2019$746 +3.9%$9,660
        2018$718 $9,660
        2017$718 +42.4%$9,660 +31.1%
        2016$504 $7,368
        2015$504 -0.5%$7,368
        2014$507 +7.1%$7,368 +9%
        2013$473 +2.2%$6,759
        2012$463 +1.5%$6,759
        2011$456 +15.3%$6,759 +6.5%
        2010$395 +1.7%$6,349
        2009$388 +1.4%$6,349
        2008$383 +32.8%$6,349 +17%
        2007$288 +1.1%$5,425
        2006$285 -1%$5,425
        2005$288 +44%$5,425 +58.2%
        2003$200 +6.6%$3,430
        2002$188 +9.1%$3,430 +16.7%
        2001$172 $2,940
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: Oakley

        Getting around

        83 / 100
        Very Walkable
        40 / 100
        Some Transit
        59 / 100
        Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes