FREE DELIVERY ON ORDERS OVER $250*   CLICK HERE FOR DETAILS
STRETCH AND SHRINK FILMS
STRETCH FILM 14.5X1450
STRETCH FILM 17.2"X1450
12"X4000
18"X5000
STRETCH BAND-IT
20
STRETCH FILM CUTTER
30"X3250
16"X1476
STRETCH FILM 12"X9000
20" 90GA 5000
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.MasterCategoryID IN (100004) AND tblProducts.ProductCategoryID IN (154817) ORDER BY tblProducts.Featured DESC, tblProducts.QuantitySold, tblProducts.ProductID,tblProducts.ProductName