Language:
كتاب المناقب
61  
Virtues and Merits of the Prophet (pbuh) and his Companions
(18)
Chapter: The last of all the Prophets (Muhammad (saws))
(18)
باب خَاتِمِ النَّبِيِّينَ صلى الله عليه وسلم
Sahih al-Bukhari 3534

Narrated Jabir bin `Abdullah:

The Prophet (ﷺ) said, "My similitude in comparison with the other prophets is that of a man who has built a house completely and excellently except for a place of one brick. When the people enter the house, they admire its beauty and say: 'But for the place of this brick (how splendid the house will be)!"

حَدَّثَنَا مُحَمَّدُ بْنُ سِنَانٍ، حَدَّثَنَا سَلِيمٌ، حَدَّثَنَا سَعِيدُ بْنُ مِينَاءَ، عَنْ جَابِرِ بْنِ عَبْدِ اللَّهِ ـ رضى الله عنهما ـ قَالَ قَالَ النَّبِيُّ صلى الله عليه وسلم ‏ "‏ مَثَلِي وَمَثَلُ الأَنْبِيَاءِ كَرَجُلٍ بَنَى دَارًا فَأَكْمَلَهَا وَأَحْسَنَهَا، إِلاَّ مَوْضِعَ لَبِنَةٍ، فَجَعَلَ النَّاسُ يَدْخُلُونَهَا وَيَتَعَجَّبُونَ، وَيَقُولُونَ لَوْلاَ مَوْضِعُ اللَّبِنَةِ ‏"‏‏.‏
Reference : Sahih al-Bukhari 3534
In-book reference : Book 61, Hadith 43
USC-MSA web (English) reference : Vol. 4, Book 56, Hadith 734
  (deprecated numbering scheme)