If you have more than 8 p.p.m. of iron in your water then you will need to use an iron filter to remove it. You may need to measure it first with a water test kit. If your Iron is less then 8 p.p.m. you can usually use a water softener to remove iron as well as soften the water. About Rotten Egg Smells and Hydrogen Sulfide If you have iron - hard water - rotten egg smell read this. About Birm Filtration

select DISTINCTROW top 40 p.CatalogId,p.ccode from products p, prodcategories cc, categories c where cc.intCatalogId=p.CatalogId and cc.intcategoryid=c.categoryid and cc.intcategoryid = 16 and p.hide = 0 and (p.customermatch is null or p.customermatch = '') and (p.loggedin = false or p.loggedin is null) and (c.customermatch is null or c.customermatch = '') and (c.loggedin = false or c.loggedin is null) AND (higherCatalogId is null) order by p.ccode