33 St Andrews Drive, North Bend, OH 45052

$1,500,000
4
BD
5
BA
3,616
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

List Price
$1,500,000
Status
ACTIVE
MLS#
1890677
Property Type
Single Family Residential
Bedrooms
4
Bathrooms
5
Baths Full
3
Half-baths
2
Bathroom Level 1
1
Lot Size
46,609
Levels
Two
County
Hamilton
Region
Hamilton-W11
Subdivision
Aston Oaks

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!

Additional Information

Year Built
1998
Lot Dimensions
irregular
Acres
1.07
Construction
Brick
Roof
Shingle
View
River
Basement Desc
Full
Garage Spaces
3
Cooling
Ceiling Fans, Central Air
Heating
Forced Air, Gas
Sewer
Public Sewer
Water
Public
Water Heating
Gas
Primary Water Source
Public
School District
Three Rivers Local S
Entry
15x15 Level: 1
Study
15 x 11
Recreation Room
15x30 Level: Lower
Laundry Room
15x10 Level: 1
Levels
Two
Foundation
Poured
Gas
Natural
Flex Rooms
3 Season Room
Entry Foyer
Closet, Tile Floor
Living Room Feat
Walkout, Wall-to-Wall Carpet, Fireplace
Family Room Feat
Bookcases, Walkout, Wall-to-Wall Carpet, Fireplace, Wet Bar
Basement Features
Finished, Fireplace, Walkout, WW Carpet
Fireplaces
2
Fireplace
Gas
Inside Features
9Ft + Ceiling, Multi Panel Doors
Land Description
1 to 4.9 Acres
Miscellaneous
220 Volt, Cable, Ceiling Fan
Appliances
Dishwasher, Dryer, Gas Cooktop, Microwave, Oven/Range, Refrigerator, Washer

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

Courtesy of Rakesh Ram with Coldwell Banker Realty

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity™ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than our company are marked with the Broker Reciprocity™ logo (the small house as shown to the left) and detailed information about them includes the name of the listing brokers. This data is up-to-date as of . Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved. Information deemed reliable but not guaranteed.