Due to a death in our organization we have temporarily changed our ordering procedures.
We are now allowing phone in orders for in-stock items only, paid with a credit card.
We are not currently accepting purchase orders.
Existing orders will be processed.
Thank you for your understanding.

Page 1 - Cast Brass Tank Crosses

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 11:52:09 PM.
Call us at 818-786-0600. We are here to help!
Laboratory Water Systems Laboratory Process Filters Laboratory Equipment Water Treatment
Home  » Categories »  Brass Tank Crosses »  Cast Brass Tank Crosses

Cast Brass Tank Crosses

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