Skip main navigation
Sold for $620,000 on 10/30/25
  • $620,000

    542 Davenport Ave APT D, Cincinnati, OH 45204

    2beds
    2,576sqft
    Condominium
    Built in 2002
    -- sqft lot
    $620,100 Zestimate®
    $241/sqft
    $2,838 Estimated rent

    Owner options

    List your home for rent

    $2,838/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,838/mo

    Rent Zestimate®

    Refinance and save

    $4,454/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

    $4,454/mo

    Est. payment

    What's special

    These panoramic river and city views are the best in town! 2567 sqft of quality & custom amenities throughout. Almost completely renovated in 2022! Enjoy the views from the stunning kitchen, which includes high end appliances, copper hood with brick veneer wall, huge island, new hard wood floors & walk-in pantry. The primary suite, which has also been completely renovated, includes a beautiful primary bath, walk-in closet, it's own personal laundry, custom remote blinds, sitting area and private laundry room. This home is located at the end of a private dead-end street. Enjoy your own private elevator, 2 covered porches with brand new custom railings, and new HVAC system. Come and see for yourself these breathtaking views up and down the river, NKY, and straight into downtown! Very low HOA fee, only 4 units in total.

    Zillow last checked: 8 hours ago

    Listing updated: October 31, 2025 at 10:28am

    Listed by:

    Stacie A Schoeplein 513-237-9623,

    Sibcy Cline, Inc. 513-321-9922

    Bought with:

    Lisa McCarthy, 2005016661

    Coldwell Banker Realty

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

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 2
    • Bathrooms: 4
    • Full bathrooms: 2
    • 1/2 bathrooms: 2
    Primary bedroom
    • Features: Bath Adjoins, Walk-In Closet(s), Walkout, Window Treatment, Sitting Room, Wood Floor
    • Level: Third
    • Area: 378
    • Dimensions: 27 x 14
    Bedroom 2
    • Level: Third
    • Area: 182
    • Dimensions: 14 x 13
    Bedroom 3
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 4
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 5
    • Area: 0
    • Dimensions: 0 x 0
    Primary bathroom
    • Features: Built-In Shower Seat, Tile Floor, Double Vanity
    Bathroom 1
    • Features: Full
    • Level: Third
    Bathroom 2
    • Features: Full
    • Level: Third
    Bathroom 3
    • Features: Partial
    • Level: Second
    Bathroom 4
    • Features: Partial
    • Level: First
    Dining room
    • Features: Chandelier, Walkout, Wood Floor
    • Level: Second
    • Area: 208
    • Dimensions: 16 x 13
    Family room
    • Area: 0
    • Dimensions: 0 x 0
    Kitchen
    • Features: Butler's Pantry, Pantry, Quartz Counters, Counter Bar, Eat-in Kitchen, Gourmet, Kitchen Island, Wood Cabinets, Wood Floor
    • Area: 304
    • Dimensions: 16 x 19
    Living room
    • Features: Walkout, Fireplace
    • Area: 304
    • Dimensions: 16 x 19
    Office
    • Features: Wet/Dry Bar, French Doors, Wood Floor
    • Level: Second
    • Area: 165
    • Dimensions: 15 x 11
    Heating
    • Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Double Oven, Gas Cooktop, Microwave, Refrigerator, Gas Water Heater
    Features
    • Elevator, Ceiling Fan(s), Recessed Lighting
    • Doors: French Doors, Multi Panel Doors
    • Windows: Double Hung, Vinyl
    • Basement: None
    • Number of fireplaces: 1
    • Fireplace features: Electric, Living Room
    Interior area
    • Total structure area: 2,576
    • Total interior livable area: 2,576 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: On Street
    • Garage spaces: 2
    • Has uncovered spaces: Yes
    Features
    • Stories: 3
    • Patio & porch: Covered Deck/Patio, Deck
    • Exterior features: Balcony, Other
    • Has view: Yes
    • View description: City, River
    • Has water view: Yes
    • Water view: River
    • Waterfront features: River
    Lot
    • Features: Cul-De-Sac, Less than .5 Acre
    Details
    • Parcel number: 1510001017300
    • Zoning description: Residential

    Construction

    Type & style
    • Home type: Condo
    • Architectural style: Transitional
    • Property subtype: Condominium
    Materials
    • Brick, Vinyl Siding
    • Foundation: Concrete Perimeter
    • Roof: Shingle
    Condition
    • New construction: No
    • Year built: 2002

    Utilities & green energy

    • Electric: 220 Volts
    • Gas: Natural
    • Sewer: Public Sewer
    • Water: Public

    Community & neighborhood

    Security
    • Security features: Smoke Alarm
    Location
    • Region: Cincinnati

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $500 monthly
    • Services included: Insurance, Water, Community Landscaping

    Other

    Other facts
    • Listing terms: No Special Financing,Other
    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
    $620,100