EFFECTIVE 4/1/24 FREE DELIVERY ON ORDERS OVER $350*   CLICK HERE FOR DETAILS
FLOOR SIGNS
9 VOLT BATTERY 12/BX
LINERMATE FOR CLASSIC SERIES
METAL FLAT TOP LID BLACK
LID FOR 2643-60 BRUTE GRAY
SLIM JIM SWING LID BLACK
PUTTY KNIFE 3"
PURELL BODY FLUID SPILL KIT
POT & PAN BRUSH
3M LINT ROLLER 60 SHEETS
BAG VACUUM ROYAL B
BAG FILTER HEPA 6/PK
WEB FOOT WET MOP MEDIUM BLUE
ADVANCE VACUUM BAG
PRO DUSTER 50/PK
Page 1 of 2
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.MasterCategoryID IN (100001) AND tblProducts.ProductCategoryID IN (154834) ORDER BY tblProducts.Featured DESC, tblProducts.QuantitySold, tblProducts.ProductID,tblProducts.ProductName