Alfredo's place is well-positioned in Bologna. I would say it's about 8-10 minute walk from Centrale station with bags. The street is pretty quiet at night and we had no issues with any neighbors (I think most are locals). Piazza Maggiore is probably about a 7-9 minute walk so it's also close by.
The breakfast place right around the corner, La Borbonica, is also great. I appreciate the map with recommendations.
We did have a couple of issues while there. For one, the bathroom had a musty smell and I'm not sure what was going on there. Could've been just a temporary water leak or something. Also, the showerhead was attached to the wall with an adjustable pivot. However, during our stay, the pivot was so loose that the shower head would not stay upright and just sprayed the wall below it unless we held it with one hand while showering.