It is narrated from Sayyiduna Abdullah bin Abbas (may Allah be pleased with them both) that the Messenger of Allah (peace and blessings be upon him) said: "The best water on the face of the earth is the water of Zamzam; in it is the nourishment of food and a cure for sickness. And the worst water on the face of the earth is the water of the valley of Barahut, near a dome-like place in Hadramawt. Crawling creatures swarm over it (in great numbers) like the legs of locusts. In the morning it flows abundantly, and in the evening there is not even moisture in it."
Imam al-Tabarani (may Allah have mercy on him) said: "No one narrated this hadith from Ibrahim bin Abi Hurrah except Muhammad bin Muhajir, and no one from Muhammad except Miskin bin Bukayr, and al-Hasan bin Ahmad bin Abi Shu'ayb is alone in narrating it."
Hadith Referenceالمعجم الأوسط / باب الميم / 8129
Hadith Takhrij«أخرجه الضياء المقدسي فى «الأحاديث المختارة» برقم: 137، وابن أبي شيبة فى «مصنفه» برقم: 14336، 14339، والطبراني فى «الكبير» برقم: 11167، والطبراني فى «الأوسط» برقم: 3912»