EFFECTIVE 4/1/24 FREE DELIVERY ON ORDERS OVER $350*   CLICK HERE FOR DETAILS
PAPER-HOT
20 OZ HOT PAPER CUP WORLD ART
1 OZ PAPER SOUFFLE CUP
10 OZ FOAM CUP
12 OZ FOAM CUP
12 OZ FOAM CUP
12 OZ HORIZON FOAM CUP
16 OZ FOAM CUP
2 OZ PAPER SOUFFLE CUP
20 OZ TALL FOAM CUP
24 OZ FOAM CUP
16 OZ BISTRO PAPER HOT CUP
32 OZ HORIZON FOAM CUP
32 OZ TALL FOAM CUP
44 OZ HORIZON FOAM CUP
4 OZ FOAM CUP
6 OZ FOAM CUP
8 OZ FOAM CUP
9 OZ PLASTIC TRANSLUCENT CUP
16 OZ FRENCH FRY CUP PAPER
4 OZ PAPER HOT CUP WHITE
7 OZ CLEAR PLASTIC CUP
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 (100000) AND tblProducts.ProductCategoryID IN (154848) ORDER BY tblProducts.Featured DESC, tblProducts.QuantitySold, tblProducts.ProductID,tblProducts.ProductName