This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$1,850,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
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.
Full Property Details
Full Property Details for 15 St Andrews Dr
General
- Sold For: $1,850,000
- HOA FEE: $40/month
- HOA FEE FREQ.: Annually
- Status: Closed
- Type: Single Family
- Source: Cincinnati
- MLS ID: 1869192
- Added to Site: 81 day(s) ago
Interior
- Number of Rooms: 12
- Rooms/Areas: Exercise Room
- Fireplace: Yes
- Number of Fireplaces: 2
- Fireplace(s): Gas
Rooms
Bathrooms
- Total Bathrooms: 6
- Full Bathrooms: 4
- Half Bathrooms: 2
- Primary Bathroom: Built-In Shower Seat, Shower, Tile Floor, Tub, Jetted Tub, Marb/Gran/Slate
- Bathroom 1: Full, Level 1
- Bathroom 2: Full, Level 1
- Bathroom 3: Full, Level 1
- Bathroom 4: Partial, Level 2
Bedrooms
- Total Bedrooms: 4
- Primary Bedroom: Adjoining Bathroom, Walk-In Closet, Walk-Out, Fireplace, Sitting Room, 28 x 15, Level 1, 420 Sq. Ft.
- Bedroom 2: 18 x 13, Level 1, 234 Sq. Ft.
- Bedroom 3: 19 x 12, Lower, 228 Sq. Ft.
- Bedroom 4: 20 x 15, Lower, 300 Sq. Ft.
Other Rooms
- Foyer/Entry: Open Foyer, Tile Floor, Other, Level 1, 252 Sq. Ft.
- Living Room: Other, 16 x 13, Level 1, 208 Sq. Ft.
- Family Room: Fireplace, Wet Bar, Wood Floor, 27 x 22, Level 1, 594 Sq. Ft.
- Kitchen: Counter Bar, Eat-In, Gourmet, Island, Wood Floor, Marble/Granite/Slate, 24 x 18, 24x18, 432 Sq. Ft.
- Dining Room: Wood Floor, Other, 16 x 13, Level 1, 208 Sq. Ft.
- Office/Den/Study: 18 x 13, Level 1, 234 Sq. Ft.
- Office: Wall-to-Wall Carpet, French Doors
- Rec Room: 48 x 28, Lower
- Laundry: 13 x 8, Level 1, 104 Sq. Ft.
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 3
- Parking: Driveway
- Garage Description: Oversized, Side, Garage Attached
Location
- Area: North Bend
- County: Hamilton
- Township: North Bend Vlg
- Suburb: North Bend
- Driving Directions: Shady Ln to Aston Oaks Dr to left on Stratford Ln to left on Muirfield Dr to right on St Andrews Dr. House on the left
School Information
- School District: Three Rivers Local S
- High School District: Three Rivers Local S
Community
- Association: Yes
- Home Owners Assn.: True
- Assoc. Name: L&B Managament Firm
- Mgmt. Company: L&B Managament Firm
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Forced Air, Gas
- Heating Fuel: Natural
- Water Heater: Gas
Utilities
- Sewer: Public Sewer
- Water: Public
Structural Information
- Architectural Style: One Story Ranch
- Exterior Const.: Brick, Stone
- Basement: Yes
- Basement Desc.: Full, Finished, Walk-Out, Wall-to-Wall Carpet
- Foundation: Poured
- Roof: Shingle
- Windows: Aluminum, Wood
- Stories/Levels: One
- Square Feet: 6,088
- Lower: 4,088 Sq. Ft.
- Year Built: 1998
Lot Features
- Lot Size (Acres): 1.886
- Lot Dimensions: IRR
Financial Considerations
- Sub Lease Exp.: 1800-01-01T00:00:00-05:00
- Association Fee: $480
- Assoc Fee Freq.: Annually
- Semi-Annual Taxes: $917
Disclosures and Reports
- APN: 573-0009-0015-00
- Property ID: 573-0009-0015-00
Get Pre-Approved Today
Schools
Schools serving 15 St Andrews Dr
School District:Three Rivers Local School District
| Name | Grades | Distance |
|---|---|---|
Three Rivers Elementary 56 Cooper Avenue, Cleves, OH 45002 | PK-4 | 1.7 mi |
Taylor Middle School, Cleves, OH 56 Cooper Road, Cleves, OH 45002 | 5-8 | 1.8 mi |
Taylor High School, Cleves, OH 56 Cooper Road, Cleves, OH 45002 | 9-12 | 1.8 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 15 St Andrews Dr
Date
Details
Price
Change
Source
5/15/2026
Sold
$1,850,000
5.71%
MLS
4/24/2026
Listed
$1,750,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
15 St Andrews Drive, North Bend, OH 45052 (MLS# 1869192) is a Single Family property that was sold at $1,850,000 on May 15, 2026. This property was listed by Rakesh Ram from our Ohio Indiana West Regional Office.Want to learn more about 15 St Andrews Drive? Do you have questions about finding other Single Family real estate for sale in North Bend? You can browse all North Bend real estate or contact a Coldwell Banker agent to request more information.



