We had a great time!
We squeezed 4 adults in (2 on the futon, 2 on the bed), but I wouldn't necessarily suggest it. The kitchen dining set accommodates 2, and the bathroom isn't huge, but if you're willing to sit on the floor/futon to eat (we were) and have otherwise low-maintenance friends (we are), 3 or 4 is fine and makes for a really good deal.
The neighborhood was great: walking distance to bars, restaurants, Safeway, Walgreens, etc. Beautiful 100+ year-old homes all around.