Hadithcore
Mishkat al-Masabih, 3272

Abu Huraira told that when God’s Messenger was asked which woman was best he replied, “The one who pleases [her husband] when he looks at her, obeys him when he gives a command, and does not go against his wishes regarding her person or property by doing anything of which he disapproves.” Nasa’i and Baihaqi, in <i>Shu'ab al-iman</i>, transmitted it.

وَعَنْ أَبِي هُرَيْرَةَ قَالَ: قِيلَ لِرَسُولِ اللَّهِ صَلَّى اللَّهُ عَلَيْهِ وَسَلَّمَ: أَيْ النِّسَاءِ خَيْرٌ؟ قَالَ: «الَّتِي تَسُرُّهُ إِذَا نَظَرَ وَتُطِيعُهُ إِذَا أَمَرَ وَلَا تُخَالِفُهُ فِي نَفْسِهَا وَلَا مَالِهَا بِمَا يَكْرَهُ» . رَوَاهُ النَّسَائِيُّ وَالْبَيْهَقِيُّ فِي شُعَبِ الْإِيمَان

References1 variant
In-Book Reference
Book 13, Hadith 188