Once buzzing oil-rich city left with abandoned office buildings, housing market in crisis...