I highly recommend Lucia's place. She's a really lovely host, the place is immaculate!
First, it seems quite far from the city centre but in fact, it's max 15 mins by bus! If I ever visit Bologna again, I will definitely choose this flat :)