When you've moved a sim to another house, do not demolish the house the sim used to live in. Instead sell the rooms by going to the build mode and pressing the 'Rooms' button, press the room you want to sell and, well, just sell it. Sell every room. You'll still get 'rent' by doing that.