Well, Eric, it all depends on the area and the type of home, and the answers vary widely.
In the Richmond district (depending on whether it's inner, central, or outer richmond district),
you can get a full five for much less than that, or in the inner richmond district it would be harder to be under 1 mil. to get a home with all the bells and whistles.
In the Sunset, these are cheaper and you can get bigger houses; of course, all the properties near the beach are going for less than the properties going towards inland.
For specifics, it's best to get a complimentary consultation with an experienced realtor.
I'd be happy to help people like you.