I lived in San Pablo, CA for 2 years, and I have to say it was not that pleasant. I needed a city that was close enough to Oakland where I was working, and I unfortunately chose San Pablo. While the cost of living was low, the amount of trouble that seemed to be everywhere was overwhelming.
There were quite a few people that were living there to commute to work in San Francisco or Oakland like I was. Mainly because there weren't really any employment opportunities in San Pablo. It was the amount of crime that eventually sealed the deal for me. My car was broken into while it was parked in front of my house, and neighbors had even scarier stories to tell.
The one thing I did enjoy was the weather. Even in the summer time, it rarely got over 100 degrees. Likewise the location was close to San Francisco, which was easily accessible by taking the BART train. Would I ever go back? No. But at least I can say I experienced life in San Pablo, CA.