Great location about 20 minutes from pretty much all the tourist attractions so you're away from the homeless population, but close enough to drive or use public transit into the city center.
Very quiet, I was worried about the nearby airport when I first booked, but the planes weren't loud at all (my wife didn't even realize there was a nearby airport until I told her).
Really nice atmosphere inside with full size fridge and oven/stove top. Washer and dryer worked well. Water pressure was a little weak, but far from unusable.
Biggest downside is the wifi is not great. The router must be kept in the main house because we only had 2 bars at best through our stay. The speed test we did was 5mbps down, 8mbps up. I suggested they add a wifi extender, so hopefully it will be improved by the time you stay. Keep in mind most hotels have way worse wifi than this unless you pay a lot.
Overall, we're very happy with our stay and would stay again.