Your Cart

Shopping Cart Items: 0   Sub-Total : US$0.00    View Cart    Checkout
Shopping Cart Items: 0   Sub-Total : US$0.00
Welcome, Guest ( Login )
Celebrating 34 years providing high quality products and advice.
Our Local Time Is 4:43:22 AM.
Call us at 818-786-0600. We are here to help!
Lab Water System ON SALE NOW
Introducing the Polaris Lab Water Systems
High Purity Water Made In The USA.
Click here for more info.
Laboratory Water Systems Laboratory Process Filters Laboratory Equipment Water Treatment
Home  » Categories »  Specialty Cartridge Filters »  Tannin And Organic Removal Filters

Tannin And Organic Removal Filters

Tannin And Organic Removal Filters   New Category coming soon


select DISTINCTROW top 10 p.CatalogId,p.ccode from products p, prodcategories cc, categories c where cc.intCatalogId=p.CatalogId and cc.intcategoryid=c.categoryid and cc.intcategoryid = 933 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