Cooking - Ovens - Warming Drawers

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.StandardColor, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,if(p.CustomDescription IS NOT NULL AND p.CustomDescription <> '', p.CustomDescription, p.ModelDescription) AS ModelDescription,if(p.thumb LIKE 'http%',p.thumb, concat('/uploads/products/',p.thumb)) AS thumb ,if(p.large LIKE 'http%',p.large, concat('/uploads/products/',p.large)) AS large , mp.PowerBuy, mp.quick_ship, bd.preferred ,IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS SortPrice, bd.CommonBrandID,mh.super_category, mp.ge_inv FROM tbl_store_brands AS sb INNER JOIN Brand_Data AS bd ON bd.pkID = sb.brandID+0 INNER JOIN tbl_products AS p ON sb.categoryID = p.pkCategory AND sb.brandID = p.pkBrand INNER JOIN ModelPrice AS mp ON (p.SKU = mp.SKU AND p.pkSKU = mp.pkSKU) INNER JOIN menu_heading AS mh ON mh.slug = p.mhSlug WHERE p.mhSlug = 'cooking' AND cgSlug = 'ovens' AND cSlug = 'warming-drawers' AND mp.Available = 1 AND ((CommonBrandID = 'GECAFE')) GROUP BY p.RootModelNumber ORDER BY IF(quick_ship =1,quick_ship,999999) ASC, FIELD(p.cSlug, 'grill-accessories') ASC, p.cSlug, display_sequence ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU
4
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

Cafe30" Warming Drawer

Add To Compare

Cafe 30" Warming Drawer

Model Color Price
CTW900P2NS1 $1,777.00
Cafe30" Warming Drawer

Add To Compare

Rebates Available!

Cafe 30" Warming Drawer

Model Color Price
CTW900P3ND1 Matte Black $1,999.00
CTW900P2NS1 Stainless Steel $1,777.00
CafeSeries 30" Warming Drawer

Add To Compare

Cafe Series 30" Warming Drawer

Model Color Price
CW9000SDSS Stainless Steel Contact us for best price
CafeSeries 30" Warming Drawer

Add To Compare

Cafe Series 30" Warming Drawer

Model Color Price
CW9000SJSS Stainless Steel Contact us for best price

Page 1 of 1
1

Added to Cart
Model#
Enter Zip Code*For delivery options
Final discounts, tax, and shipping costs at checkout.