You're right, the title has surprised me as I know how much you love her, but I also know you're right. This goes to not only expats though.
Renting a flat with a pet is difficult no matter where you live. You can't leave the pet at home and go om a vacation for 2 weeks. You can only go to places where dogs are accepted. Caring for a pet means extra expenses and so on. It's not easy but worth it as the love and the moments of happiness you get is something that only pets can provide.
it's a tradeoff, that is for sure. one that i don't think many people are prepared for the difficulties involved in.