It's great if you have a short term stay, but it could use a deep clean and some upgrades