Overall, we had a reasonable stay.
However, the in-bedroom A/C unit was unreliable (would randomly shut down). The living room one could be kind of pointed at the front bedroom though, so we made due with that. If we'd needed to use both bedrooms, we couldn't have kept it cool enough to sleep (even as is, it was only okay).
The kitchen is also quite outdated, with an old electric range. If you're working from the unit or staying for a while, you should keep that in mind.
The unit was described as old and creaky, but at the price we ended up paying (~$475/night including fees over a couple weeks), it was just not a great value. If our nightly rate had been closer to say $300, then we'd probably let the "old-house charm" slide a bit, but we also booked this place *explicitly* for the A/C to ensure reasonable sleep. If the A/C doesn't work to cool down the bedrooms reliably, then it doesn't serve the full purpose. (And we could have booked many nicer places without A/C).
For folks staying for a short period of time, not using the kitchen, or when it's not the hottest part of the summer, it's probably a better fit. It's still super central if you need to split between SLU and Fremont. But unless the A/C is replaced in the bedroom, I'd not want to rely on it.