FREE DELIVERY ON ORDERS OVER $250*   CLICK HERE FOR DETAILS
FULL MAILENDER CATALOG
3"X60YD MASKING TAPE
1"X60YD MASKING TAPE
1.5"X60YD MASKING TAPE
2"X60YD MASKING TAPE
3"X60YD MASKING TAPE
0.75"X60YD MASKING TAPE
2"X60YD GREEN MASKING TAPE
6"X720YD WHITE FLATBACK TAPE
6"X720YD BLUE FLATBACK TAPE
6"X720YD GREEN FLATBACK TAPE
6"X720YD ORANGE FLATBACK TAPE
6"X720YD PINK FLATBACK TAPE
6"X720YD RED FLATBACK TAPE
6"X720YD YELLOW FLATBACK TAPE
2"X60YD FLATBACK TAPE
3"X60YD FLATBACK TAPE
2"X60YD SILVER DUCT TAPE
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 '%Shurtape%' OR tblProducts.VendorCode LIKE '%Shurtape%' OR tblProducts.VendorName LIKE '%Shurtape%') ORDER BY tblProducts.Featured DESC, tblProducts.QuantitySold, tblProducts.ProductID,tblProducts.ProductName