Buy in haste, repent at leisure

14 Cedarwood Drive sold for $3.6 million in January, 2007, after just 81 days on the market. It was placed back up for sale in November, 2014 at $3.3 million and has stayed on the market ever since, taking successive price cuts down to today's $2.495.

Listing describes it as "a renovators dream, sold as is".  Someone's dreaming here, but probably not that hypothetical renovator.