Mishkat al-Masabih 10 The Rites of Pilgrimage كتاب المناسك 240

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

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.