This is a great location. It's about a 2-minute walk to bus stops and a 5-minute walk to several different metro stops. La Sagrada Familia is right down the street and if you're inclined to walk, which we are, you can visit most of the tourist spots on foot.
It's also just a couple miles from the beach. If you don't have a ton of luggage, take the Renfe train from the airport, exit at Passaig de Gracia and catch line 4 to the hospital stop. From there it's about a 5-minute walk. The transfer at Passaig de Gracia can be tough with a lot of luggage. We did it with 5 kids--two suitcases each. Fun! Fun!
The place is clean and well maintained. There's several grocery stores and anything else you'd need within a 5-minute walk. There's a good pizza place on the way to LSF--Napoli's. There's also some awesome panaderias on the way to the hospital that sell ridiculously good chocolate croissants. I'm sure there's also a ton on Gaudi street but we never ate there.