1650 Colonial Dr, Cincinnati, OH, 45238
About This Home
Frank Lloyd Wright-Inspired Contemporary Estate! One of Green Township's most iconic homes, this 4BR, 3.5+BA masterpiece sits on 1.4+ acres with panoramic views of double ponds and lush landscaping. A private bridge leads to your own ecosystem alive with wildlife, flowering plants, and mature trees-a true gardener's paradise. Inside, enjoy spacious living areas, an eat-in kitchen, formal dining room, and brick WBFP. The finished lower level features a family room with WBFP, wet bar, and hidden wine room. Outdoors, a 40'x20' heated pool awaits with summer house including kitchenette, great room, WBEP, and 24'x24' covered patio. Bath house with shower and changing rooms, plus firepit, shed, and serene water views.
Getting Around
Car-Dependent
Some Transit
Somewhat BikeableSchools
Construction
Condition
- Year built: 1939
Materials
- Foundation: Block,Concrete Perimeter
- Roof: Membrane
- Construction materials: Other
Type & Style
- Home type: SingleFamily
- Architectural style: Contemporary/Modern
- Property subType: Single Family Residence
Interior
Appliances
- Appliances included: Convection Oven,Dishwasher,Electric Cooktop,Gas Cooktop,Microwave,Refrigerator,Trash Compactor,Wine Cooler,Gas Water Heater
- Laundry features: Laundry Chute
Basement
- Has basement: Yes
- Basement: Full,Walk-Out Access,WW Carpet
Bathroom1
- Features: Full
- Level: Second
Bathroom2
- Features: Full
- Level: Second
Bathroom3
- Features: Full
- Level: First
Bathroom4
- Features: Partial
- Level: First
Bedroom2
- Level: Second
- Area: 252
Bedroom3
- Level: Second
- Area: 140
Bedroom4
- Level: Second
- Area: 120
Bedroom5
- Area: 0
Bedrooms & Bathrooms
- Bedrooms: 4
- Bathrooms: 6
- Full bathrooms: 3
- 1/2 bathrooms: 3
Dining Room
- Features: Chandelier,WW Carpet
- Level: First
- Area: 196
Family Room
- Features: Walkout,Fireplace,Wet Bar
- Area: 350
Features
- Other,Ceiling Fan(s)
- Window features: Vinyl,Other
- Number of fireplaces: 3
- Fireplace features: Brick,Wood Burning,Basement,Family Room
- Fireplace: Yes
Great Room
- Features: Wet Bar
- Level: Lower
- Area: 693
Heating & Cooling
- Heating features: Hot Water
- Cooling features: Wall Unit(s)
Interior Area
- Total structure area: 2,340
- Total interior livable area: 2,340 sqft
Kitchen
- Features: Eat-in Kitchen,Gourmet,Kitchen Island,Wood Cabinets
- Area: 275
Living Room
- Area: 350
Master Bathroom
- Features: Bidet,Double Shower,Tile Floor,Jetted Tub
Master Bedroom
- Features: Bath Adjoins,Wall-to-Wall Carpet
- Level: Second
- Area: 238
Office
- Area: 0
Property
Details
- Parcel number: 5500041060100
- Zoning description: Residential
Features
- Levels: Two
- Stories: 2
- Private pool: Yes
- Pool features: Heated,In Ground,Slide
- Patio & porch: Covered Deck/Patio,Deck
- Exterior features: Balcony,Fire Pit
- Fencing: Wood
- Has view: Yes
- View description: Lake/Pond
- Has water view: Yes
- Water view: Lake/Pond
- On waterfront: Yes
- Waterfront features: Lake/Pond
- Topography of land: Cleared,Lake/Pond
- Residential vegetation: Fruit,Oak,Pine
Lot
- Features: Sprinklers,1 to 4.9 Acres
Parking
- Total spaces: 2
- Parking features: Driveway
- Has garage: Yes
- Attached garage spaces: 2
- Covered spaces: 2
- Has uncovered spaces: Yes
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Heat Wave
- Tornado
- Cold Wave
- Lightning
- Strong Wind
- Winter Weather
How This Home’s Risks Compare
FEMA Declared Disasters Across Ohio Counties
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $4,040 | $48,480 |
| Home Insurance * | $434 | $5,208 |
| Property Taxes | $1,005 | $12,060 |
| Electricity | $250 | $3,011 |
| Total | $5,729 | $68,748 |
Income You'd Need if You Spent...
Ohio FAIR Plan Programs
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
Price History
| Date | Event | Price |
|---|---|---|
| 2025-11-05 | Listed for sale | $849,000 |
| 2025-09-25 | Listing removed | $849,900 |
| 2025-04-21 | Listed for sale | $849,900 |
| 2024-11-05 | Listing removed | -- |
| 2024-07-29 | Listed for sale | $890,900 |
| 2024-06-17 | Listing removed | -- |
| 2024-04-18 | Price change | $899,900 |
| 2024-03-07 | Listed for sale | $890,900 |
| 2024-02-29 | Listing removed | -- |
| 2024-02-06 | Listing removed | -- |
| 2024-01-19 | Listed for rent | $4,250 |
| 2023-12-05 | Listed for sale | $899,900 |
| 2021-03-24 | Listing removed | -- |
| 2018-05-06 | Listing removed | $780,000 |
| 2018-02-05 | Price change | $780,000 |
| 2017-10-31 | Listed for sale | $698,000 |
| 2017-09-19 | Listing removed | $880,000 |
| 2017-08-16 | Listed for sale | $880,000 |
| 2015-10-17 | Listing removed | $880,000 |
| 2015-05-27 | Listing removed | $3,000 |
| 2015-05-13 | Listed for rent | $3,000 |
| 2015-05-07 | Listed for sale | $880,000 |
View on Zillow