Skip main navigation
Off market
  • Zillow Home logoZestimate®
    $200,900

    817 Considine Ave, Cincinnati, OH 45205

    3beds
    3,400sqft
    Single Family Residence
    Built in ----
    -- sqft lot
    $200,900 Zestimate®
    $59/sqft
    $2,497 Estimated rent

    Home value

    $200,900

    $151,000 - $255,000

    $2,497/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $2,497/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,497/mo

    Rent Zestimate®

    Refinance and save

    $1,423/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $1,423/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Contemporary finishes throughoutSoaring ceilingsDesigner lightingStainless steel appliancesDramatic foyerLarge yardAbundant natural light

    Historic Executive Home Total Renovation Timeless Character Meets Modern Luxury. Step into this beautifully restored 3,400 sq. ft. home featuring soaring ceilings, a dramatic foyer, designer lighting, and contemporary finishes throughout. The gourmet kitchen boasts quartz countertops, stainless steel appliances, and an oversized island with seating for six with hood oven, with expansive great room ideal for entertaining, movie nights, or game nights. Three beautifully renovated spa inspired bathrooms, abundant natural light, and a large yard complete this exceptional home. Located just 10 minutes from Downtown Cincinnati, the University of Cincinnati, and the Clifton medical campuses, this home is ideal for executives, graduate students, medical professionals, travel nurses, or anyone seeking exceptional space, style, and convenience. A rare combination of historic charm and modern luxury that is truly move-in ready. Absolutely NO PETS no exceptions. The showing coordinator is a licensed real estate agent in the State of Ohio. Please schedule an appointment for a private showing. The first step is to complete the screening questions. If you pass the screening, I will contact you to schedule a 30-minute appointment for you to view the property. Please note that this is a strict no-pets property. Absolutely no pets of any kind are permitted, and there will be no exceptions. I am hosting an open house on Thursday, August 13th, starting at 6:30 p.m. Please complete the screening information in order to be scheduled for a viewing time. **LEASE TERMS** The duration of the lease is TWO years (ignore the 1 year reference below). (Lease could possibly be negotiable depending on the credit score and results of the background check.) ** Absolutely No Pets Allowed.** ** Absolutely No smoking allowed** * A non-refundable $60 application fee is required, which includes credit and a background check. * First month's rent** is due upon execution of the lease agreement. * A security deposit is due at signing equivalent to one month's rent. *Lawncare is due at sign in * Tenants will NOT be responsible for lawncare. .

    This property is not currently displayed as for sale or rent on Zillow. This may be different from what's on other websites or public sources.

    Zillow last checked:

    Listing updated:

    Source: Zillow Rentals

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 3
    Heating
    • Forced Air
    Cooling
    • Air Conditioner, Central Air
    Appliances
    • Included: Dishwasher, Freezer, Microwave Oven, Oven, Refrigerator
    • Laundry: Hookups
    Features
    • Flooring: Carpet, Hardwood, Tile
    Interior area
    • Total interior livable area: 3,400 sqft

    Property

    Parking
    • Details: Contact manager
    Details
    • Parcel number: 1750017006500

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence

    Community & HOA

    Community
    • Deposit fee: $2,500
    Location
    • Region: Cincinnati

    Financial & listing details

    • Price per square foot: $59/sqft
    • Tax assessed value: $197,430
    • Annual tax amount: $4,388
    • Date on market: 9/26/2026
    • Lease term: 1 Year

    Price history

    DateEventPrice
    10/4/2026Listing removed$2,500$1/sqft
    Source: Zillow Rentals Report a problem
    7/16/2026Price change$2,500+11.1%$1/sqft
    Source: Zillow Rentals Report a problem
    5/26/2026Price change$2,250-10%$1/sqft
    Source: Zillow Rentals Report a problem
    3/1/2026Listed for rent$2,500$1/sqft
    Source: Zillow Rentals Report a problem
    9/26/2025Listing removed$2,500$1/sqft
    Source: Zillow Rentals Report a problem
    9/5/2025Listed for rent$2,500$1/sqft
    Source: Zillow Rentals Report a problem
    8/27/2025Listing removed$360,000$106/sqft
    Source: Cincy MLS #1826219 Report a problem
    12/11/2024Listed for sale$360,000+886.3%$106/sqft
    Source: Cincy MLS #1826219 Report a problem
    12/5/2024Listing removed$2,500$1/sqft
    Source: Zillow Rentals Report a problem
    11/12/2024Listed for rent$2,500-16.7%$1/sqft
    Source: Zillow Rentals Report a problem
    10/7/2024Listing removed$3,000$1/sqft
    Source: Zillow Rentals Report a problem
    9/30/2024Listed for rent$3,000$1/sqft
    Source: Zillow Rentals Report a problem
    5/4/2018Sold$36,501+9.3%$11/sqft
    Source: Cincy MLS #1573015 Report a problem
    4/16/2018Pending sale$33,400$10/sqft
    Source: Western Hills Cincinnati #1573015 Report a problem
    3/29/2018Listed for sale$33,400+85.6%$10/sqft
    Source: Huff Realty #1573015 Report a problem
    10/12/2016Sold$18,000-74.3%$5/sqft
    Source: Public Record Report a problem
    10/8/2008Sold$70,000$21/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$4,388 +0.1%$69,101
    2024$4,382 +133.9%$69,101 +135.5%
    2023$1,873 +163%$29,344 +196.3%
    2022$712 -11.7%$9,905
    2021$806 +15.6%$9,905
    2020$698 -4.9%$9,905 +10%
    2019$734 +9.2%$9,006
    2018$672 $9,006
    2017$672 -21.5%$9,006 -31.8%
    2016$855 $13,213
    2015$855 -0.7%$13,213
    2014$861 -4.6%$13,213 -3%
    2013$903 +1.8%$13,619
    2012$887 +3.1%$13,619
    2011$860 -23.3%$13,619 -27.9%
    2010$1,121 +3.8%$18,876
    2009$1,080 +93.7%$18,876
    2008$558 +8.4%$18,876 -3%
    2007$515 -48.8%$19,460
    2006$1,006 -1.1%$19,460
    2005$1,017 -14.8%$19,460 -7.2%
    2003$1,195 +6.7%$20,965
    2002$1,120 0%$20,965 +6.6%
    2001$1,120 +2.8%$19,670
    2000$1,089 $19,670
    Find assessor info on the county website

    Neighborhood: East Price Hill

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $200,900
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $200,900