If you're looking to move to an affordable city, buyer beware. Some urban areas are already underwater when it comes to foreclosure and delinquency rates. And that could hurt your home's value.