The host was amazing in communication, and the location sits outside Prague but near wonderful restaurants and bars. I would focus more on the trams as there are a couple of trams that are super close that goes throughout Prague. As for the metro, that is also quite close goes straight to / from the bus point to the airport.
The trains do make a noise every now and then but for us it was quite soothing and we welcomed it, but at night it can be loud enough to wake you up of your window is open. But again, we found it really soothing!
We chose this place primarily because of the gym, which was sufficient - bench, free weights, and cardio machines.
Other good points: the place is perfect for a short stay! It has everything you need and more, and it's very spacious! I have never slept like that in my life, the bed was totally comfortable to the max!