Got another one for this thread:
Last sale: Aug 01, 2005 - $315,000
Asking: $800,000
Looks like they slapped down some granite countertops, hardwood floors, put on a fresh coat of paint and did some landscaping. I doubt they put more than $200,000 into it. It appeared to be vacant, but staged. Here's a photo I took (note that every lamp in the house is on in the middle of the day):
Interesting side note, it's listed by our P-I Real Estate Professionals friend Susan Ryan. : "There is no real estate bubble and never will be. A decrease in acceleration is not an implosion (or even a pop)."
I can't take credit for finding this one though. I met with a guy from NPR today, and we actually did the interview standing outside that house, as a prime example of the insanity of the market. The segment should air later this week.