Hadithcore
Mishkat al-Masabih, 2751

Abu Huraira reported God’s messenger as saying, “The last of the towns of Islam to become a ruin will be Medina," Tirmidhi transmitted it, saying this is a <i>hasan gharib</i> tradition.

وَعَنْ أَبِي هُرَيْرَةَ قَالَ: قَالَ رَسُولُ اللَّهِ صَلَّى اللَّهُ عَلَيْهِ وَسَلَّمَ: «آخِرُ قَرْيَةٍ مِنْ قُرَى الْإِسْلَامِ خَرَابًا الْمَدِينَةُ» . رَوَاهُ التِّرْمِذِيُّ وَقَالَ: هَذَا حَدِيثٌ حَسَنٌ غَرِيبٌ

References1 variant
In-Book Reference
Book 10, Hadith 240