Ibn Hajar al-'Asqalani quoted it in his commentary on the hadith of Anas ibn Malik (on where to pray dhohr on the day of tarwiyya) as a quote of Abudllah ibn 'Omar which appears in al-Fakihi's akhbar Mekka in his fath al-Bari (see here).
This fatwa says it is a saying of sahabi not a hadith and adds as sources Kitab al-Fitan of Nu'aim ibn Hammad and Gharaib al-hadith of Ibraheem al-Harbi.
Actually in al-Fakihi's akhbar Mekka there are 2 similar narrations
on the authorithy of Abudllah ibn 'Amr ibn al-'Aas 1, 2 (not ibn 'Omar).
It also appears as a narration on the authority of 'Abdullah ibn 'Amr in Mosanaf ibn abi Shaybah (see here or narration#124 here) on islamqa they consider the narrator chain as possibly acceptable for these kinds of informative narrations they also added that it appears in abu 'amr ad-Dani's as-Sunan al-Warida fil fitan and Musnad ibn al-Ja'ad and to some extent in Tarikh Dimashq of ibn 'Asakir via the same chain however in the later 'Abdullah ibn 'Amr was not quoted.
The chain of akhbar Mekka, al-Fitan of Nu'aim ibn Hammad and the tafssir of 'Aburrazaak and elsewhere has some issues in the narrator chain so one could consider it as weak.
A third chain was quoted in akhbar Mekka of al-Azraqi which has some discussed narrators.
Nevertheless on islamqa they come to the conclusion that this athar (they don't consider it a hadith or saying of the prophet at all) seems to have a source due to the multiple chains even if they have issues especially as there are sahih ahadith on the topic which you may find in that Arabic fatwa, here just the links (on the turn back of rivers and meadows in the Arabic peninsula in Sahih Muslim and on the the domlishing of al-Ka'aba a version from Sahih al-Bukhari).