It's a great location, and the unit was very clean and spacious. There was no housekeeping during our stay and we were responsible for handling our own trash and doing our own dishes. There is very minimal outside noise, but the water heater did rattle and buzz whenever people were using hot water.
We had an issue checking in as Expedia held their welcome message with access code from us for 48 hours. Luckily they were very responsive and called us back when we were stuck outside.
You should know that the bathroom has frosted glass door, it's not quite sound proof, otherwise the unit looks like it does in the photos.