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 - 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 35 years providing high quality products and advice.
Our Local Time Is 2:42:52 AM.
Call us at 818-786-0600. We are here to help!
Laboratory Dish Glassware Washers Need a new Laboratory Glassware Washer?
We got you covered.
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