The place is managed by a rental concierge service and is just as described - clean and very well lit in a quiet but walkable neighbourhood and a quick 15 minute drive from downtown. There's an unmaintained but not too shabby backyard for leisure time and a really good stereo system in the hall.
The check-in is as easy as it could get but there is no flexibility - it's just like a hotel. More over you'd have to do the dishes and put out the garbage despite the cleaning fee.