FREE DELIVERY ON ORDERS OVER $250*   CLICK HERE FOR DETAILS
FULL MAILENDER CATALOG
VENTED BRUTE 20 GAL BLUE
44 GAL BRUTE LID  BLUE 4/CA
16 GAL VENTED SLIM JIM BEIGE
SPILL MOP PADS 10/PK
LID FOR 2643-60 BRUTE GRAY
SLIM JIM SWING LID BLACK
21"X17"X7" GRAY TOTE
21"X17"X7" BROWN TOTE
21"X17"X7" GRAY TOTE (EACH)
WEB FOOT WET MOP MEDIUM BLUE
ROUND STORAGE CONTAINER 6 QT
ROUND LID 8 QT
ROUND STORAGE CONTAINER 12 QT
ROUND LID 12 QT
35QT WAVEBREAK BUCKET YELLOW
5 LB SILICA SAND BLACK
Page 1 of 1
SELECT tblProducts.URL, tblProducts.QuantitySold,tblProducts.RetailPrice,tblProducts.Featured, tblProductCategory.Layout,'' AS FavoriteProduct,'' as PriceListProduct, 0 as CurrentPrice,tblSubCategory.URL as SubCategory, tblMasterCategory.URL as MasterCategory,tblProductCategory.URL as ProductCategory,tblProducts.ID,tblProducts.ProductID,tblProducts.ProductName, tblProducts.ProductImage FROM tblProducts INNER JOIN tblMasterCategory ON tblProducts.MasterCategoryID = tblMasterCategory.ID INNER JOIN tblProductCategory ON tblProducts.ProductCategoryID = tblProductCategory.ID INNER JOIN tblSubCategory ON tblProducts.SubCategoryID = tblSubCategory.ID WHERE tblProducts.Active = 'Y' AND tblProducts.MasterCatalog <> 'N' AND tblProducts.ProprietaryItem <> 'Y' AND (tblProducts.BrandName LIKE '%Rubbermaid%' OR tblProducts.VendorCode LIKE '%Rubbermaid%' OR tblProducts.VendorName LIKE '%Rubbermaid%') ORDER BY tblProducts.Featured DESC, tblProducts.QuantitySold, tblProducts.ProductID,tblProducts.ProductName