Don't live in BFE Concord? Could get a 3/1 on the Peninsula for a bit more (say, 800-850). Less if you're willing to live in Daly City or EPA or something.
Single-family or townhome/condo? In the Mountain View/Sunnyvale/Los Altos area you can get a 3/1 townhome for about $800K, but if you want a single-family home with a postage-stamp yard those start at around $1.2M.
SFH. Obviously you're going to pay out the nose for MTV or Los Altos. I haven't shopped in Sunnyvale but that comparison (to the other 2) surprises me. I'd expect it to be cheaper than, say, Redwood City.
I remember back in '06, places in MTV were cheaper than Santa Clara. Should have bought back then! I remember thinking Google couldn't get any bigger, it was already a huge company. Guess I couldn't have been much more wrong.
For 1.2M you can get a decent-sized 3/2 or 4/2 of maybe 1800sqft. Not in Mountain View, obviously.