We stayed a couple nights in Floriana. It's very well located, with lots of buses to go everywhere on the island, and only 10-15 minutes away from the Triton Fountain to grab buses to the airport.
There are a few grocers' and convenience shops to buy food near the flat.
Alan made sure the place was spotless and was an attentive host, and we loved the Maltese balcony!