Nobody wants to buy this bizarre house in a wealthy San Francisco suburb - but you can rent it for $750 a night