Cooking - Ovens

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 mp.Available = 1 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
15
Compare Products:
  • Product List View
  • Product Grid View

Page 24 of 25
<< First Page [Previous 10 pages] 22232425 Last Page >>

KitchenAid27'' Slow Cook Warming Drawer, Panel-Ready Panel Ready

Add To Compare

KitchenAid 27'' Slow Cook Warming Drawer, Panel-Ready Panel Ready

Model Color Price
KEWS175BPA Panel Ready $1,449.00
KitchenAid30'' Slow Cook Warming Drawer Stainless Steel

Add To Compare

KitchenAid 30'' Slow Cook Warming Drawer Stainless Steel

Model Color Price
KOWT100ESS Stainless Steel $1,549.00
KitchenAid24'' Slow Cook Warming Drawer Stainless Steel

Add To Compare

KitchenAid 24'' Slow Cook Warming Drawer Stainless Steel

Model Color Price
KOWT104ESS Stainless Steel $1,399.00
KitchenAid27'' Slow Cook Warming Drawer Stainless Steel

Add To Compare

KitchenAid 27'' Slow Cook Warming Drawer Stainless Steel

Model Color Price
KOWT107ESS Stainless Steel $1,549.00
MieleESW 6114 - 24 inch handleless warming drawer with the low temperature cooking function - much more than a warming drawer.

Add To Compare

Miele ESW 6114 - 24 inch handleless warming drawer with the low temperature cooking function - much more than a warming drawer.

Model Color Price
ESW6114CLEANTOUCHSTEEL Clean Touch Steel $1,399.00
MieleESW 6214 - 24 inch handleless warming drawer with the low temperature cooking function - much more than a warming drawer.

Add To Compare

Miele ESW 6214 - 24 inch handleless warming drawer with the low temperature cooking function - much more than a warming drawer.

Model Color Price
ESW6214BRILLIANTWHITE Brilliant White $1,399.00
ESW6214GRAPHITEGREY Graphite Grey $1,399.00
ESW6214OBSIDIANBLACK Obsidian Black $1,399.00
MieleESW 6580 - 30 inch warming drawer with 10 13/16 inch front panel height with the low temperature cooking function - much more than a warming drawer.

Add To Compare

Miele ESW 6580 - 30 inch warming drawer with 10 13/16 inch front panel height with the low temperature cooking function - much more than a warming drawer.

Model Color Price
ESW6580CLEANTOUCHSTEEL Clean Touch Steel $2,199.00
MieleESW 6780 - 30 inch warming drawer with 10 13/16 inch front panel height with the low temperature cooking function - much more than a warming drawer.

Add To Compare

Miele ESW 6780 - 30 inch warming drawer with 10 13/16 inch front panel height with the low temperature cooking function - much more than a warming drawer.

Model Color Price
ESW6780CLEANTOUCHSTEEL Clean Touch Steel $2,199.00
MieleESW 6880 - 30 inch warming drawer with 10 13/16 inch front panel height with the low temperature cooking function - much more than a warming drawer.

Add To Compare

Miele ESW 6880 - 30 inch warming drawer with 10 13/16 inch front panel height with the low temperature cooking function - much more than a warming drawer.

Model Color Price
ESW6880BRILLIANTWHITE Brilliant White $2,199.00
ESW6880GRAPHITEGREY Graphite Grey $2,199.00
ESW6880OBSIDIANBLACK Obsidian Black $2,199.00
ThermadorWarming Drawer Stainless Steel SD30WC

Add To Compare

Thermador Warming Drawer Stainless Steel SD30WC

Model Color Regular Price Savings After Savings
SD30WC $1049.00 $100.00 $949.00
ThermadorTHD 30" Storage Drawer, 4" Height, SS Stainless Steel SDS30WC

Add To Compare

Thermador THD 30" Storage Drawer, 4" Height, SS Stainless Steel SDS30WC

Model Color Regular Price Savings After Savings
SDS30WC $749.00 $100.00 $649.00
ThermadorWarming Drawer Stainless Steel WD30W

Add To Compare

Thermador Warming Drawer Stainless Steel WD30W

Model Color Regular Price Savings After Savings
WD30W $1999.00 $100.00 $1,899.00
ThermadorWarming Drawer Stainless Steel WD30WC

Add To Compare

Thermador Warming Drawer Stainless Steel WD30WC

Model Color Regular Price Savings After Savings
WD30WC $1799.00 $100.00 $1,699.00
Wolf30" Transitional M Series Front Panel

Add To Compare

Wolf 30" Transitional M Series Front Panel

Model Color Price
823278 Contact us for best price
Wolf30" Warming Drawer

Add To Compare

Wolf 30" Warming Drawer

Model Color Price
WWD30 Contact us for best price

Page 24 of 25
<< First Page [Previous 10 pages] 22232425 Last Page >>

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