A fantastic view of the Sliema harbor area fro a very large terrace awaits you! The building's name is "Waterfront Place", which should not be confused with the "Waterfront Hotel" that is about 150 meters to the left when viewed from the harbor side. The entrance is hard to find, but is a bit further to the right of the Hungarian restaurant.
Be aware that low water pressure seems to be characteristic of all the domestic faucets and showers on the island. Besides that, have fun and make sure to see the Mosta Dome and spend at one day in Valleta!