Fantastic location, in the dead centre of Bologna right next to the towers and you can't even hear the buzz from outside. However, I have to mention that it's not dead quiet either with neighbours shouting on the staircase or hosting a late party. We stayed a week and it didn't bother us very much as it wasn't constant.
The bed is super comfy and it's a spacious studio for 2 people. The kitchen has the basics but you'll need to buy basic ingredients for your stay, if you plan to use it.
The studio was warm (in October) and no issues with hot water. Overall great stay.