Sayyiduna Ibn Umar (may Allah be pleased with them both) says that the Messenger of Allah (peace and blessings be upon him) said: "I know that the most beloved of lands to Allah, the Mighty and Majestic, is Makkah, and had my people not driven me out from here, I would never have left. O Allah, place in our hearts love for Madinah just as You placed in our hearts love for Makkah." And whenever the Messenger of Allah (peace and blessings be upon him) caught sight of Madinah, happiness and joy would show on his (peace and blessings be upon him) face.
Hadith Referenceالمعجم الكبير للطبراني / باب العين / 13290