If your ONLY priority is location, then this place is excellent.
If cleanliness is a priority, this is not a place for you.
The house needs an extremely deep cleaning and major cosmetic touch-ups.
I would 100% get a new cleaning crew.