Mishkat al-Masabih
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 hasan gharib tradition.
وَعَنْ أَبِي هُرَيْرَةَ قَالَ: قَالَ رَسُولُ اللَّهِ صَلَّى اللَّهُ عَلَيْهِ وَسَلَّمَ: «آخِرُ قَرْيَةٍ مِنْ قُرَى الْإِسْلَامِ خَرَابًا الْمَدِينَةُ» . رَوَاهُ التِّرْمِذِيُّ وَقَالَ: هَذَا حَدِيثٌ حَسَنٌ غَرِيبٌ
Reference