You for sure can hear them upstairs but it isnt too bad! We run on a swing shift schedule and we never woke up to it.
The location is really convenient. We were within a 10 minute drive for most places and the bus isnt a bad walk either.
They have dishes and a small kitchen set up so its way better than being in a hotel. Also I'm always worried about beds when traveling, but their bedroom set up was very comfortable.