The place is more like a bare-bones college apartment than an "oasis in the city". The photos aren't inaccurate but they certainly paint the apartment in the best possible light. The place could use a deep clean and fresh coat of paint. There is also only one small glass cup and one large mug, so though there is a coffee maker, don't plan on making coffee for two.
The location is very close to many areas of the city that you'd want to visit, but the apartment itself is in a very residential area so there isn't anything immediately nearby. I'd also mention that though it is in walking distance of RiNo, a portion of the walk would feel a bit sketchy in the evening (we decided to Lyft instead), particularly for a solo female traveller. A Lyft takes less than ten minutes to most places so that works great.
If you want a place to sleep at night that is fairly close to everything, this should work great. If you want more than that, there are probably better alternatives for the price.