brooklyn in 10 years from now
Brooklyn has areas where this is common (Canarsie, for example). It's often complicated to ascertain exactly who owns the building and should handle the sales, and where money should go. I believe it's also dependent on what clauses for such eventualities were included in 501c3, and what constitutes a similar oriented organization to roll over in to.
Even in heavily Orthodox populated areas like Flatbush and Boro Park, there are many shuls whose membership has died out and moved away over the years. Shuls have a bit of a limited lifespan, and reviving the congregation can be very difficult. People like a shul with a similar demographic and age group to them, with a Rav geared towards them that they can relate to.
It gets complicated when a shul which is by its charter owned by the active members has a group of outsiders that purchase membership in hopes of taking over board in "hostile takeover" election and changing shul to suit their desires. For $20k in membership, you can effectively take over a multi million dollar existing synagogue. Some of these shuls have voted to effectively close membership to new members, and lock in voting rights to existing members only.