Sahih Bukhari
Virtues of Madinah
Volume: 003 / Book Number: 030 / Hadith Number: 98
Narrated Abu Huraira:
I heard Allah's Apostle saying, "The people will leave Medina in spite of the best state it will have, and none except the wild birds and the beasts of prey will live in it, and the last persons who will die will be two shepherds from the tribe of Muzaina, who will be driving their sheep towards Medina, but will find nobody in it, and when they reach the valley of Thaniyat-al-Wada', they will fall down on their faces dead."