> A lot of detached homes in Vancouver at the $900k price range look like they are in bad condition and reflect the land value.

So much so, that a game has been made about this, Crack Shack or Mansion [0].

[0] http://www.crackshackormansion.com/index.html