The residents of the property had to be evacuated in the middle of the night in an 'extremely distressing' experience