I had a fantastic stay at Aaron's place and cannot recommend the space enough. The manager of the building picked me up at the airport and drove me to the flat, which was super convenient. The flat itself is very modern and upscale with all the amenities you could need - kitchen has everything, wireless internet, air conditioning, and just an overall luxurious feel for a great price. Also a small balcony which I really enjoyed.
The location is excellent - just a 2 minute walk around the corner and you are on the Sliema waterfront. Also very accessible walk to St Julian's, Paceville, and down to the ferry to hop over to Valletta. A good variety of restaurants and bars, especially along the waterfront. The flat is also close to bus stops, as I did not need to walk far at all to catch the bus to Mdina one day and the bus to the ferry to Gozo another day.
The neighborhood itself I would say is residential. It is quiet but not does not lack liveliness. There is a good grocery store and pharmacy a few minutes up the street. Never had any issues with noise or disturbances.
If I returned to Malta, I would definitely book this flat again!