Sold for $2,435,000

$2,435,000

245 Coldstream Club Dr, Cincinnati, OH 45202

5beds

5,500sqft

Single Family Residence

Built in ----

1 Acres Lot

$2,519,700 Zestimate^®

$443/sqft

$7,747 Estimated rent

Home value

$2,519,700

$2.29M - $2.77M

$7,747/mo

Zestimate^® history

Owner options

List your home for rent

$7,747/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

$7,747/mo

Rent Zestimate^®

Refinance and save

$14,137/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

$14,137/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

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.

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

Price history

Date	Event	Price
9/2/2025	Sold	$2,435,000+9.4%$443/sqft
Source: Cincy MLS #1794066 Report a problem
4/15/2024	Pending sale	$2,225,000$405/sqft
Source: Cincy MLS #1794066 Report a problem
1/17/2024	Listed for sale	$2,225,000$405/sqft
Source: Cincy MLS #1794066 Report a problem