Before-and-after footage shows how a house of horrors which was turned into a makeshift dump has finally been cleared after a year of misery for neighbours.