FREE DELIVERY ON ORDERS OVER $250*   CLICK HERE FOR DETAILS
FOAM
3/16"X48"X350
24"X6"X5.5" 1.7LB BLACK PE WATERJET CUT
15"X7.25"X1.5" PE FOAM END CAP SET
1"X4.875"X132" PE FOAM
23.5"X20.5"X1"&2" BOTTOM SET LAM TOGETHER
3"X2"X1" EPS FOAM BLOCK
3"X3"X3" .75" EPS MOLDED CORNERS
48"X4"X2" 4# BLACK DIE CUT PE FOAM
48"X4"X2" 4# BLACK DIE CUT PE FOAM
48"X5"X2" 4# BLACK DIE CUT PE FOAM
48"X6.5"X2" 4# BLACK DIE CUT PE FOAM
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 (154812) ORDER BY tblProducts.Featured DESC, tblProducts.QuantitySold, tblProducts.ProductID,tblProducts.ProductName