Together with a good friend of mine, I had a wonderful time at Franco's appartment in Bologna. The location is perfect, the rooms pretty and comfortable and everything is very clean. A friend of Franco showed us the appartment and explained everything very nice. It was one of the best city trips that I have ever made and that I can imagine.
If you want to 'live like a local in Bologna', this place is very recommandable.