I think the listing is accurate, and the trade-offs you make can be very worthwhile. It is a very nicely renovated house. The neighborhood, if you’re unfamiliar, has a bad reputation, which may be exaggerated but is definitely not coming from nowhere. The house is at the end of a cul-de-sac, but the streets you’ll drive through on the way definitely aren’t the best. The tradeoff is that you’re in the city very close to a lot of things, and the rate is favorable. If that works for you, it’s a good place.
It’s also worth noting that while pretty, the house is not very soundproof, and there are some rambunctious young children. There are also some very inquisitive cats.
Having said that, my host was lovely, the house is beautiful, and I had no substantive problems during my stay. Know what you’re getting into, but I can see why this place’s calendar was quite full.