Skip main navigation
Sold for $2,435,000 on 09/02/25
    • $2,435,000

    245 Coldstream Club Dr, Cincinnati, OH 45202

    5beds
    5,500sqft
    Single Family Residence
    Built in ----
    1 Acres Lot
    $2,435,300 Zestimate®
    $443/sqft
    $8,046 Estimated rent

    Owner options

    List your home for rent

    $8,046/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

    $8,046/mo

    Rent Zestimate®

    Refinance and save

    $16,559/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

    $16,559/mo

    Est. payment

    What's special

    Under construction custom Zicka Home in Riverview Estates. First floor master with first floor guest suite / walk out lower level / rear deck & rear covered porch with fireplace / finished lower level with wet bar. Still time to make some selections.

    Zillow last checked: 7 hours ago

    Listing updated: September 02, 2025 at 07:49pm

    Listed by:

    Ralph Fruechtemeyer,

    Zicka Realty Co. 513-477-2310

    Bought with:

    Julie K Back, 0000405161

    Sibcy Cline, Inc.

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

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 7
    • Full bathrooms: 5
    • 1/2 bathrooms: 2
    Primary bedroom
    • Features: Bath Adjoins
    • Level: First
    • Area: 288
    • Dimensions: 18 x 16
    Bedroom 2
    • Level: First
    • Area: 192
    • Dimensions: 16 x 12
    Bedroom 3
    • Level: Second
    • Area: 240
    • Dimensions: 16 x 15
    Bedroom 4
    • Level: Second
    • Area: 272
    • Dimensions: 17 x 16
    Bedroom 5
    • Level: Basement
    • Area: 168
    • Dimensions: 14 x 12
    Primary bathroom
    • Features: Tile Floor
    Bathroom 1
    • Level: First
    Bathroom 2
    • Level: First
    Bathroom 3
    • Level: Second
    Bathroom 4
    • Level: Second
    Dining room
    • Area: 0
    • Dimensions: 0 x 0
    Family room
    • Area: 0
    • Dimensions: 0 x 0
    Kitchen
    • Features: Pantry
    • Area: 323
    • Dimensions: 17 x 19
    Living room
    • Area: 0
    • Dimensions: 0 x 0
    Office
    • Area: 0
    • Dimensions: 0 x 0
    Cooling
    • Central Air
    Appliances
    • Included: No Water Heater
    Features
    • Windows: Casement, Low Emissivity Windows
    • Basement: Full,Bath/Stubbed,Concrete,Finished,Walk-Out Access
    Interior area
    • Total structure area: 5,500
    • Total interior livable area: 5,500 sqft

    Property

    Parking
    • Parking features: Driveway
    • Has uncovered spaces: Yes
    Features
    • Levels: Two
    • Stories: 2
    Lot
    • Size: 1 Acres
    • Dimensions: 150 x 375
    Details
    • Parcel number: 10
    • Zoning description: Residential
    • Other equipment: Mechanical Systems (Other)

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Brick, Stone, Fiber Cement
    • Foundation: Concrete Perimeter
    • Roof: Shingle
    Condition
    • New construction: Yes
    Details
    • Builder name: Zicka Homes

    Utilities & green energy

    • Gas: Natural
    • Sewer: Public Sewer, Grinder Pump
    • Water: Public

    Community & neighborhood

    Location
    • Region: Cincinnati

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $900 annually
    • Second HOA fee: $800 monthly

    Other

    Other facts
    • Listing terms: No Special Financing,Conventional
    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
    $2,435,300

    Nearby cities