According to MLSPIN, the property you are inquiring about is showing that it is Under Agreement (Sale Pending) with an anticipated sale date of 7/29/2008. It indicates that it went under agreement on the 19th of May.
Therefore, my advice for you is to look for another house. Even though this market is pretty 'beaten up' properties do in fact Sell.
Best of luck.