I know it’s hard, I have been in the same boat, I hate doing it, but at the end of the day, I am running a business, not a half-way house. That rent is my livelihood.
Look frankly if the tenant can’t afford to pay market rent they are better off renting in a cheaper location.
Why not tell the tenant you’re increasing the rent in line with market prices but like them so much you’re willing to buy a place in their rental bracket & rent it to them – they get to pick the house they want (within certain defined limits).
We’re looking at doing that with one tenant later this year. She’s a a fantastic tenant but needs to change areas cause of kids’ schooling.