I am quite not sure how it would be expensive for existing residents even after sale to so called foreign investor. As far as I understand, in Germany, rents are fixed for existing residents and landlord can not evict them (few exception exists, probably won't work for investors).

That 10% increase rule is only for new tenants.