Oh yeah, I just remembered another one. This is in Millvale, a suburb of Pittsburgh. It's a concert venue and recording studio, and it has a skate park.
The First Baptist Church in Hattiesburg, MS is building a new campus and is in the process of negotiating a deal with the City of Hattiesburg on selling the building. The city plans to use it to house there Fire, Police, and Urban Development departments. Also the main sactuary is set to be used as a new courthouse. If the sale goes through I am sure it will be interesting. The church is about 87,000 square feet.
Many chapels and churches within central Indianapolis have been converted into apartments, condos, theaters, office space, etc(most while retaining the historical interior craftsmanship.) This one used to be abandoned, and was doomed untill developers decided to re-use it. The churchtowers have had their steeples cut down in the 1960's, and I think they are trying to restore them.