[danans]

I think the mistake you're making is thinking that the value of houses in SF is dominated by the value of their structure. Rather, it's dominated by the value of the land they occupy. In the case of the $2M sub-standard SF house in a desirable area you mentioned, if it burned down to the ground, the land would still be worth well north of a million dollars.

Edit: wording