The Villa's by Zicka Home at Coldstream Country Club. House is under construction. House is framed. Loads of custom features 10' basement and first floor walls. Finished lower level with rec room and bar.
Pending
$1,599,000
136 Coldstream Villa Dr, Anderson Township, OH 45255
4beds
--sqft
:
Get pre-qualified$12,069/mo
Single Family Residence
Built in 2025
0.32 Acres Lot
$-- Zestimate®
$--/sqft
$817/mo HOA
What's special
- 38 days |
- 58 |
- 0 |
Zillow last checked:
Listing updated:
Listed by:
Ralph Fruechtemeyer 513-477-2310,
Zicka Realty Co. 513-477-2310
Source: Cincy MLS,MLS#: 1847396
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s)
- Level: First
- Area: 255
- Dimensions: 17 x 15
Bedroom 2
- Level: First
- Area: 182
- Dimensions: 14 x 13
Bedroom 3
- Level: First
- Area: 168
- Dimensions: 14 x 12
Bedroom 4
- Level: Lower
- Area: 208
- Dimensions: 16 x 13
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: First
Bathroom 2
- Features: Full
- Level: First
Bathroom 3
- Features: Full
- Level: First
Bathroom 4
- Features: Full
- Level: Lower
Dining room
- Area: 0
- Dimensions: 0 x 0
Family room
- Features: Wood Floor
- Area: 0
- Dimensions: 0 x 0
Great room
- Features: Bookcases, Fireplace, Wood Floor
- Level: First
- Area: 306
- Dimensions: 18 x 17
Kitchen
- Features: Butler's Pantry, Pantry, Gourmet, Kitchen Island, Wood Cabinets, Marble/Granite/Slate
- Area: 225
- Dimensions: 15 x 15
Living room
- Area: 0
- Dimensions: 0 x 0
Office
- Features: French Doors, Wood Floor
- Level: First
- Area: 169
- Dimensions: 13 x 13
Heating
- Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Double Oven, Disposal, Gas Cooktop, Microwave, Refrigerator, Humidifier, Gas Water Heater
Features
- Crown Molding, Other
- Doors: French Doors, Multi Panel Doors
- Windows: Low Emissivity Windows, Double Pane Windows
- Basement: Full,Partially Finished
- Number of fireplaces: 2
- Fireplace features: Gas, Outside, Great Room
Interior area
- Total structure area: 0
Property
Parking
- Total spaces: 3
- Parking features: Concrete, Driveway
- Garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered Deck/Patio
- Exterior features: Fireplace
Lot
- Size: 0.32 Acres
- Dimensions: 75 x 185
- Features: Less than .5 Acre
- Topography: Level
Details
- Parcel number: NEW/UNDER CONST/TO BE BUILT
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Brick, Stone, Fiber Cement
- Foundation: Concrete Perimeter
- Roof: Asbestos Shingle,Metal
Condition
- New construction: Yes
- Year built: 2025
Utilities & green energy
- Electric: 220 Volts
- Gas: Natural
- Sewer: Public Sewer, Ejector Pump
- Water: Public
- Utilities for property: Cable Connected
Community & HOA
Community
- Security: Security System
- Subdivision: Villas at Coldstream Country Club
HOA
- Has HOA: Yes
- Services included: Community Landscaping
- HOA fee: $750 monthly
- Second HOA fee: $800 annually
Location
- Region: Anderson Township
Financial & listing details
- Date on market: 9/5/2025
- Listing terms: No Special Financing
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 3/31/2026 | Pending sale | $1,599,000 |
Source:  Cincy MLS #1847396 Report a problem | ||
| 9/6/2025 | Listed for sale | $1,599,000 |
Source: Cincy MLS #1847396 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 45255
Nearby schools
GreatSchools rating
- 7/10Ayer Elementary SchoolGrades: K-6Distance: 1.8 mi
- 9/10Nagel Middle SchoolGrades: 7-8Distance: 2.6 mi
- 8/10Anderson High SchoolGrades: 9-12Distance: 1.7 mi
- $265,000-- bd-- ba-- sqft140 Coldstream Villa Dr, Cincinnati, OH 45255Off Market
- $607,200-- bd4 ba2.9k sqft128 Coldstream Villa Dr, Cincinnati, OH 45255Off Market
- $275,000-- bd-- ba-- sqft133 Coldstream Villa Dr, Cincinnati, OH 45255Sold
- $363,190-- bd-- ba-- sqft190 Waterfront Way, Cincinnati, OH 45255Off Market
- $265,000-- bd-- ba-- sqft171 Coldstream Villa Dr, Cincinnati, OH 45255Off Market
- $275,000-- bd-- ba-- sqft124 Coldstream Villa Dr, Cincinnati, OH 45255Sold
- $258,000-- bd-- ba-- sqft152 Coldstream Villa Dr, Cincinnati, OH 45255Sold
- $265,000-- bd-- ba-- sqft175 Coldstream Villa Dr, Cincinnati, OH 45255Off Market
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.
Similar homes
- $982,5005 bd5 ba5.7k sqft684 Balbriggan Ct, Cincinnati, OH 45255For Sale
MLS ID #1885596, Heather R. Herr, Private Real Estate Collection. Cincy MLS - $1,065,0003 bd3 ba-- sqft7736 State Rd, Cincinnati, OH 45255New Construction
MLS ID #1884566, Micha Gleisinger, Comey & Shepherd. Cincy MLS - $1,595,0005 bd5 ba5k sqft6695 Loveland Miamiville Rd #B, Loveland, OH 45140New Construction
MLS ID #1886348, Patrick Gunning, Coldwell Banker Realty. Cincy MLS - $1,499,0004 bd4 ba6.1k sqft7708 Creekwood Ln, Cincinnati, OH 45237For Sale
MLS ID #1885718, Yanjin Ao, OwnerLand Realty, Inc.. Cincy MLS - $1,884,0004 bd6 ba4.8k sqft841 Rosewood Dr, Villa Hills, KY 41017New ConstructionMLS ID #643969, Catherine Kennard, Keller Williams Advisors. NKMLS
- $1,075,0004 bd5 ba-- sqft2121 Clough Chase Dr, Cincinnati, OH 45244New ConstructionMLS ID #1878620, Patrick Gunning, Coldwell Banker Realty. Cincy MLS
- $1,695,0004 bd4 ba2.1k sqft10810 Deerfield Rd, Cincinnati, OH 45242New ConstructionMLS ID #1874762, Micha Gleisinger, Comey & Shepherd. Cincy MLS
- $989,0004 bd5 ba5.3k sqft2440 Ashton Ct, Cincinnati, OH 45244For SaleMLS ID #1879701, Scott A. Marvin, Team Results Realty. Cincy MLS
- $1,150,0004 bd5 ba-- sqft6984 Shadow Ridge Rd, Cincinnati, OH 45230For SaleMLS ID #1884513, Kristin A Castillo, Comey & Shepherd. Cincy MLS
- $1,790,0006 bd6 ba5.7k sqft12 Linden Hill Dr, Villa Hills, KY 41017For SaleMLS ID #644339, Susan Huff, Huff Realty - Florence. NKMLS
- $1,043,6404 bd5 ba-- sqft3603 Turnberry, Amelia, OH 45102New ConstructionMLS ID #1885456, Jeff Smith, RE/MAX Victory + Affiliates. Cincy MLS
- $1,589,0005 bd6 ba4.8k sqft0 Heath Ct Lot 22, Loveland, OH 45140New ConstructionMLS ID #1864311, Michael P Hines, Coldwell Banker Realty. Cincy MLS
- $1,300,0003 bd3 ba-- sqft5749 Sanctuary Pl, Cincinnati, OH 45230For SaleMLS ID #1884167, Jeff A. Rosa, eXp Realty. Cincy MLS
- $1,195,0004 bd4 ba3.4k sqft1080 Tuscany Pl, Cincinnati, OH 45226New ConstructionMLS ID #1879421, Brian Hubert, Comey & Shepherd. Cincy MLS
- $1,776,0004 bd5 ba-- sqft425 Trailside Woods Ct Lot 18, Loveland, OH 45140New ConstructionMLS ID #1877703, Michael P Hines, Coldwell Banker Realty. Cincy MLS
- $1,500,0006 bd4 ba3k sqft6315 Belfast Rd, Goshen, OH 45122For SaleMLS ID #1885573, Zachary T. Deatherage, Keller Williams Seven Hills Re. Cincy MLS
- $1,699,0003 bd4 ba-- sqft5802 Hickory Ct #8, Cincinnati, OH 45243New ConstructionMLS ID #1763600, Julie K Back, Sibcy Cline, Inc.. Cincy MLS
- $1,650,0005 bd5 ba-- sqft7002 Dawson Rd, Cincinnati, OH 45243New ConstructionMLS ID #1877436, Rakesh Ram, Coldwell Banker Realty. Cincy MLS
- $1,525,0004 bd4 ba-- sqft2485 Riverside Dr, Cincinnati, OH 45202New ConstructionMLS ID #1850775, Deborah A Martin, Keller Williams Advisors. Cincy MLS
- $1,200,0004 bd4 ba3.8k sqft10036 Laurel Glen Dr, Loveland, OH 45140For SaleMLS ID #1886931, Sean Chmura, Robinson Sotheby's Internat'l. Cincy MLS
