Abandoned houses might seem like forgotten relics, but they can offer surprising investment potential for those who know where to look.