Sayyiduna Abdullah bin Abbas (may Allah be pleased with them both) said: Sayyiduna Husayn (may Allah be pleased with him) was sitting in the lap of the Prophet (peace and blessings be upon him). Sayyiduna Jibril (peace be upon him) asked: "Do you love him?" The Prophet (peace and blessings be upon him) said: "How could I not love him, when he is the fruit of my heart (that is, a piece of my very being)?" Sayyiduna Jibril (peace be upon him) said: "Your Ummah will kill him. Shall I not show you the place of his grave?" Then he took a handful of earth, and it was red earth.
Imam al-Bazzar recorded it, and its narrators are thiqat (trustworthy), though there is disagreement about some of them.
Hadith Referenceمجمع الزوائد ومنبع الفوائد / كتاب المناقب / 15129