Add me to the long list of Bay Area residents who recommend you do NOT stay in Fremont for your trip. I live in another suburb, and while it's a great place to live with a lively (for a suburb) downtown, I wouldn't recommend it to tourists as a "destination". This is a good "starter" map:

http://tinyurl.com/36hb9y