APSWater.com is updating it checkout. Please call in or Email your orders. Thank you for your patience while we improve our systems.

Page 1 - Female Elbows

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 35 years providing high quality products and advice.
Our Local Time Is 12:13:36 PM.
Call us at 818-786-0600. We are here to help!
Laboratory Fume and Biological Hood Enclosures We Offer Huge Savings
on Fume Hoods and Enclosures for your laboratory.
Laboratory Water Systems Laboratory Process Filters Laboratory Equipment Water Treatment
Home  » Categories »  Commercial and Residential Water Purification Products »  Mineral Tanks and Accessories »  Barbed Drain Line Fittings »  Female Elbows

Female Elbows

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 = 372 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