The Sacred Territory of Medina. May God most high protect it - Section 2 Mishkat al-Masabih 2751
Arabic hadith text
وَعَنْ أَبِي هُرَيْرَةَ قَالَ: قَالَ رَسُولُ اللَّهِ صَلَّى اللَّهُ عَلَيْهِ وَسَلَّمَ: «آخِرُ قَرْيَةٍ مِنْ قُرَى الْإِسْلَامِ خَرَابًا الْمَدِينَةُ» . رَوَاهُ التِّرْمِذِيُّ وَقَالَ: هَذَا حَدِيثٌ حَسَنٌ غَرِيبٌ
Translation
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.