Refine Search
Map
Sort by
$1,500,000
4 Beds ⋅ 5 Baths ⋅ 1890677 MLS
OPEN HOUSE SUNDAY 9/6/2026 from 12pm - 2pm. Panoramic 7 mile RIVER VIEWS highlight this exceptional home located in Aston Oaks, a 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! Showings start Tuesday 9/1/2026.

33 St Andrews Drive, North Bend
$210,000
3 Beds ⋅ 2 Baths ⋅ 1891342 MLS
Thinking of an urban condo? Consider the space, character and convenience of this roomy 1,618 sq ft Craftsman-style home! An easy-care yard, covered front porch stretching the full width of the house, porch swing & river view create a welcoming outdoor space. Inside, the open floor plan features 9ft ceilings, an equipped kitchen w/ breakfast bar, first-floor owner's suite w/ adjoining full bath, and first-floor laundry. Upstairs, a versatile study opens to a balcony with a river view. Two parking pads provide off-street parking. So much has been thoughtfully updated while preserving the character of this already beautiful home! Roof, windows, copper box gutters, downspouts, front door, porch decking & steps, range, washer & dryer (2019); furnace, humidifier & water heater (2023); refrigerator, dishwasher, microwave, first-floor and stair carpeting (2026), while original wood floors remain underneath. Centrally located just minutes from shopping, 275, and downtown Cincinnati!

400 Three Rivers Parkway, North Bend

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.