My husband and I highly enjoyed our stay at Riccardo's place. It is ideally located for sightseeing (right next to the Two Towers). Riccardo sent us a guide with good recommendations for restaurants, etc., that we made great use of.
The apartment itself is stylish, comfortable, and well-maintained. It was a great place to relax after a day of sightseeing. The bedroom is a particular highlight, with a window on each wall making you feel as though you are surrounded by the city's towers. I would reiterate what many other reviews have said- the stairs are very steep, and might not be the best choice for people with mobility issues. (I'll also note that, while there is a sink upstairs, the bathroom itself is downstairs, which might be a relevant consideration for some people.)
In all, Riccardo was extremely helpful and made us feel welcome in his place and in Bologna. His enthusiasm for the city is contagious, and we credit him and his apartment, in part, for making our stay in Bologna so enjoyable.