Property Attributes
- MLS#1893150
- TypeSingle Family
- Listing Status Active
- CountyHAMILTON
- CityCincinnati
- AreaHamilton
- NeighborhoodColerain TownshipWest
- Zip45251
- StyleContemporary/Modern
- Year Built1994
- Price$ 624,900
- Bedrooms3
- Full Bathrooms4
- Half Bathrooms0
- Sqr Footage3028
- Lot Size3.2584 Acres
Data Source:
MLS of Greater Cincinnati (CABR)
Property Description
Waterfront resort style living with gorgeous pond and dock, 5 car garage, 3 bedrooms (easy to create a 4th) and 4 full bathrooms nestled on 3 private acres. First floor offers a spacious granite eat-in kitchen with island, vaulted great room with stone fireplace, office, dining room, laundry, 2 car att'd garage and no-steps primary suite with huge closet, jacuzzi tub and walk-in shower. 2 more bedrooms w/ dormers and 3rd ba upstairs, huge basement w/ rec room, 4th ba and loads of storage. Shared pond w/ gazebo and rock fountain, 2 sheds, detached oversized 3 car garage. Entertainer's dream with paver drive and patio, full width front porch - ideal for a home based business too! Showings and Offers thru Tuesday 9/15 at 3 pm - seller reserves right to accept an offer in advance of the deadline.
| Price History | |
|---|---|
| 9/10/2026 | Listed $624,900 |
General Features
| Sewer | Aerobic Septic |
|---|---|
| Heating | Electric,Forced Air,Heat Pump |
| Cooling | Central Air |
| Roof | Shingle |
| Appliances | Dishwasher,Garbage Disposal,Oven/Range,Refrigerator,Trash Compactor |
| HOA Fee | 0.0 |
| Garage Spaces | 5.0 |
| Architectural Style | Contemporary/Modern |
| Construction Materials | Vinyl Siding,Fiber Cement |
| Year Built | 1994 |
| View | Lake/Pond |
| Levels | Two |
| Property Subtype | Single Family Residence |
| County | Hamilton |
| Property Type | Residential |
| HOA | No |
| Total Rooms | 10 |
| Full Baths | 4 |
| Close Price | 0.0 |
| Status | Active |
| Directions | 275 TO N 27 (COLERAIN AVE) to West on W Kemper Rd to LEFT on Old Stone Mill Rd - house is on Right |
| City | Cincinnati |
| High School District | Northwest Local SD |
| MLS Area | Hamilton-W10 |
| Lot Size Units | Acres |
| Lot Size Square Feet | 141936.0 |
| Carport Spaces | 0.0 |
Interior Features
| Interior Amenities | Vaulted Ceiling |
|---|---|
| Basement | Full |
| Total Fireplaces | 1 |
| Fireplace Features | Stone,Wood |
| Window Features | Bay/Bow,Vinyl |
| Total Bedrooms | 3 |
Exterior Features
| Exterior Amenities | Patio,Porch |
|---|---|
| Parking Features | Driveway |
| Water Source | Public |
| Foundation Details | Poured |
| Lot Dimensions | Irr |
| Lot Size Acres | 3.2584 |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 45251
In The Neighborhood
Colerain Twp
$ 194,000
- Type
- Single Family
Listed by Darius Toney of Opendoor Brokerage LLC
Colerain Twp
$ 375,000
- Type
- Single Family
Listed by Michael Wallet of Keller Williams Seven Hills Re
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawl. Neither listing broker(s) nor SE IN BD REALTORS shall be held responsible for typographical errors, misinformation, misprints and shall be held totally harmless.