"Development opportunity," "selling for land value" and "as is" are phrases used in real estate listings to describe tear-downs, those homes probably destined for the proverbial wrecking ball. Mansions with multimillion-dollar price tags, former homes of famous owners and estates designed by renowned...