We're local REALTORS(R) and long time Lebanon residents. That home on the corner of Mound and Mulberry was originally up for short sale, but was foreclosued and is currently a HUD home. When they brought it back on the market, they didn't come back with a Cincinnati MLS entry, but only in Dayton MLS. As of 9/26/2011, it's marked Pending (under contract) in the Dayton MLS. Unless the deal falls through, it should transfer to the new owners.
If we can help you further, please don't hesitate to contact us!
Liz and Bill
You need to find a local REALTOR to work for you as a Buyer's Agent. It doesn't cost you anything. He/she can set up a search in the local MLS and send you ACTIVE listings that fit your needs.