FYI this is really a large room (with bathroom), with its own private entrance attached to a house (you enter through the backyard), not really a studio.
The room itself is pretty clean, but not super thoroughly. Most of the surfaces were clean, but there was some leftover trash under the bed/couches.
In terms of location, you’ll definitely want to have a car, as you’ll need to drive to get to downtown or the other places you want to go. This isn’t a super big deal, just something to set expectations for.