A stunning renovation wasn’t enough to convince potential bidders to raise their hands at auction, as cautious buyers try not to pay too much in a falling market.