The Prophet (peace and blessings be upon him) said: "The best of your women are those who are loving, bear many children, are compliant and consoling, when they fear Allah; and the worst of women are those who display their adornment and are vain, and they are the hypocrites. None of them will enter Paradise except (as rare as) the crow with a red beak and feet."
It was also narrated with an authentic chain from Sulayman bin Yasar from the Prophet (peace and blessings be upon him) as mursal, up to his words: "when they fear Allah."
Hadith Referenceالسنن الكبرى للبيهقي / كتاب النكاح / 13478