15 St Andrews Drive, North Bend, OH 45052 (MLS # 1869192)
Twitter
Facebook
Email
|
OPEN HOUSE Sunday 4/26/2016 from 1pm - 3pm. Enjoy breathtaking, panoramic views of the Ohio River and the rolling hills of Kentucky from this exceptional home in the Aston Oaks Golf Course community. Offering over 4,000 square feet of single floor plan living plus a finished lower level, this Hensley custom built home showcases award winning architectural design and craftsmanship. Features include detailed woodwork throughout, hardwood floors, and 12' and 15' ceilings. The gourmet kitchen is perfect for everyday living and entertaining, while the thoughtfully designed layout provides both comfort and functionality. This one of a kind home is being offered of the market for the first time and is ideally situated just 20 minutes from downtown.
| DAYS ON MARKET | 29 | LAST UPDATED | 4/27/2026 |
|---|---|---|---|
| YEAR BUILT | 1998 | COMMUNITY | Hamilton-W11 |
| GARAGE SPACES | 3.0 | COUNTY | Hamilton |
| STATUS | Pending | PROPERTY TYPE(S) | Single Family |
| ADDITIONAL DETAILS | |
| AIR | Central Air |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Gas Water Heater |
| AREA | Hamilton-W11 |
| BASEMENT | Finished, Full, Walk-Out Access, Yes |
| CONSTRUCTION | Brick, Stone |
| FIREPLACE | Yes |
| GARAGE | Attached Garage, Yes |
| HEAT | Forced Air, Natural Gas |
| HOA DUES | 480 |
| INTERIOR | Eat-in Kitchen, Kitchen Island, Walk-In Closet(s) |
| LOT | 1.886 acre(s) |
| LOT DIMENSIONS | IRR |
| PARKING | Oversized, Driveway, Attached |
| SEWER | Public Sewer |
| STORIES | 1 |
| STYLE | Ranch |
| UTILITIES | Natural Gas Available |
| WATER | Public |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Wendi
Sheets to contact you even if your name is on a Federal or State
"Do not call List".
Listing provided by Coldwell Banker Realty, phone# 513-922-9400, Rakesh Ram, phone# 513-608-1199
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati and the Dayton Area Board of Realtors® MLS IDX Database.
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. Information Deemed Reliable but Not Guaranteed.
Copyright© 2026 MLS of Greater Cincinnati, Inc. and Dayton Area Board of Realtors® All rights reserved.
Data last updated: 5/19/26 5:12 AM PDT
This IDX solution is (c) Diverse Solutions 2026.