Great location. Plenty of parking on a nearby street, just be sure you read the signs for the time limits and street cleaning days, because I did see a ticket writer there bright and early. For nighly parking, I recommend the 2hr parking which starts at 8AM, near the green storage units.
The home is an older home with many charming details. The dogs are lovely, and the large dog knows not to jump on people. I didn't hear that much barking, and it wasn't a problem for me sleeping.
Don't expect a hotel experience, that's not what you're buying. You have shared access to the bathroom, which is the one the owners use and so has lots of personal effects already in it. Also, because it's an older home, there is not much sound proofing, so you will be able to hear stairs/hall noise and some noise from other guests in their rooms if they're loud. And also as an older home, there is a more noisy window AC unit, instead of a quiet integrated unit you would find in a hotel.
You are temporarily staying in a guest room of someone's home, so if that's not the experience you are looking for, then I recommend looking elsewhere. However, if you just want a charming place to stay in a great location for less than hotel prices, I think this is a great pick.