$1.4 million San Francisco house snapped up for shockingly low price — but it comes with a huge headache