FREE DELIVERY ON ORDERS OVER $250*   CLICK HERE FOR DETAILS
FULL MAILENDER CATALOG
SMART FOAM UNIT 10 GAL
XTREME WASH & WAX (5GAL)
THE CLEANER (55GAL)
ANTISEPTIC HAND CLEANER
FOAMING ACID CLEANER FP
FRYER CLEANER FP
1PA BODY SHAMPOO (1GAL)
SPARCLEAN SURE STEP #23
CLEAN BY PEROXY 15 (2L)
X-EFFECT DISINFECTANT
SPARSAN Q GERMICIDAL
CR-2 ROACH & ANT KILLER
SINK MASTER DISPENSER
3 SINK SYSTEM DISPENSER
DRAIN PLUG ASSEMBLY
LABEL FOR CLEAN BY PEROXY
SDS RACK 10026-SP2
KITCHEN KIT
1 GALLON JUG PUMP
FOAM GUN MODEL 481
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 '%Spartan%' OR tblProducts.VendorCode LIKE '%Spartan%' OR tblProducts.VendorName LIKE '%Spartan%') ORDER BY tblProducts.Featured DESC, tblProducts.QuantitySold, tblProducts.ProductID,tblProducts.ProductName