$239,900
Opportunity meets character in this spacious ranch featuring a unique mid-century inspired design and an impressive great room addition you won’t find just anywhere. With 4 bedrooms and 1.5 baths on the main level, this home offers a flexible layout with room to grow, entertain, and make your own.
The heart of the home is the stunning great room, showcasing vaulted ceilings, rich wood paneling, and a striking fireplace crafted from rare Blue Diamond stone imported from New Mexico—creating a warm, lodge-like atmosphere perfect for gatherings. A second living area at the front of the home adds even more versatility for entertaining or everyday living.
The kitchen offers ample cabinet space and flows into the dining area, while the attached four-season room provides a bright and relaxing space to enjoy year-round.
Downstairs, the partially finished basement expands your options with additional living space, a bathroom with shower (in need of finishing touches), and plenty of storage.
Outside, you’ll find a solid brick exterior, attached garage, and a nicely sized yard ready for outdoor enjoyment.
This home has been well cared for over the years and offers the perfect opportunity for a buyer to update and personalize while building equity. If you’re looking for space, character, and something truly unique, this is it. Skylights recently replaced and now feature remote-controlled shades, enhancing natural light and convenience. Fireplace updated with a new gas insert. Additional updates include a new garage door opener and a newer boiler unit. Water heater approximately 2010.
4
Beds
⋅
3
Baths
⋅
954645
MLS
819 Waldrun Avenue, Riverside
Courtesy of Sherry Couch and Coldwell Banker Heritage
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.