Property Attributes
- MLS#1890677
- TypeSingle Family
- Listing Status Active
- CountyHAMILTON
- CityNorth Bend
- AreaHamilton
- NeighborhoodNorth Bend
- Zip45052
- StyleTraditional
- Year Built1998
- Price$ 1,395,000
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms2
- Sqr Footage3616
- Lot Size1.07 Acres
Data Source:
MLS of Greater Cincinnati (CABR)
Property Description
OPEN HOUSE SUNDAY 9/6/2026 from 12pm - 2pm. Panoramic 7-mile river views highlight this exceptional home offering over 5,500 square feet of living space, located in Aston Oaks, a premier golf course community. This impressive floor plan offers an open design with a desirable first-floor primary suite, first-floor study, and loft area, providing both value and distinction. Enjoy breathtaking river views throughout the home, two fireplaces, neutral dcor, and fresh paint throughout. The finished, multi-level lower level is ideal for entertaining and family gatherings. Additional features include a 3-car garage, and the seller is installing a new roof. A rare opportunity to own a home with spectacular views in this sought-after community!
| Price History | |
|---|---|
| 8/28/2026 | Listed $1,500,000 |
| 9/14/2026 | 4$1,450,000 |
| 9/18/2026 | 4$1,395,000 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Forced Air,Gas |
| Cooling | Ceiling Fans,Central Air |
| Roof | Shingle |
| Appliances | Dishwasher,Dryer,Gas Cooktop,Microwave,Oven/Range,Refrigerator,Washer |
| HOA Fee | 440.0 |
| Garage Spaces | 3.0 |
| Association Fee Includes | AssociationDues,LandscapingCommunity,ProfessionalMgt |
| Architectural Style | Traditional |
| Construction Materials | Brick |
| Year Built | 1998 |
| View | River |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Assoc Fee Paid Per | Annually |
| County | Hamilton |
| Property Type | Residential |
| HOA | Yes |
| Subdivision Name | Aston Oaks |
| Total Rooms | 11 |
| Full Baths | 3 |
| Close Price | 0.0 |
| Status | Active |
| Directions | Shady Lane to Aston Oaks to left on Stratford,Left on Muirfield,Right on St Andrews |
| City | North Bend |
| High School District | Three Rivers Local S |
| MLS Area | Hamilton-W11 |
| Lot Size Units | Acres |
| Lot Size Square Feet | 46609.0 |
| Carport Spaces | 0.0 |
Interior Features
| Interior Amenities | 9Ft + Ceiling,Multi Panel Doors |
|---|---|
| Basement | Full |
| Total Fireplaces | 2 |
| Fireplace Features | Gas |
| Window Features | Vinyl |
| Total Bedrooms | 4 |
Exterior Features
| Exterior Amenities | Deck,Patio |
|---|---|
| Parking Features | On Street,Driveway |
| Water Source | Public |
| Foundation Details | Poured |
| Lot Dimensions | irregular |
| Lot Size Acres | 1.07 |
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 45052
In The Neighborhood
Colerain Twp
$ 134,900
- Type
- Single Family
Listed by Michael Mcgee of Mainstay Brokerage LLC