,

Product		Qty	Price
	Total: $0.00
	View Cart →

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ 30" Smart Slide-In, Front-Control, Dual-Fuel Range with Warming Drawer

Rebates Available!

Built-In WiFi, Powered by SmartHQ App, Personalized Features + Upgrades, No-Preheat Air Fry, Expansive six-burner cooktop helps you entertain with ease, An attractive appearance at all times

Request More Info Check for Special Offers

Stainless Steel

C2S900P2MS1

Sale Price: $3,699.00

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ 30" Smart Slide-In, Front-Control, Dual-Fuel, Double-Oven Range with Convection

Rebates Available!

Built-In WiFi, Powered by SmartHQ App, Personalized Features + Upgrades, No-Preheat Air Fry, Expansive six-burner cooktop helps you entertain with ease, An attractive appearance at all times

Request More Info Check for Special Offers

Stainless Steel

C2S950P2MS1

Sale Price: $4,099.00

Matte White

C2S950P4MW2

Sale Price: $4,299.00

Sale Price: $4,099.00

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ 36" Smart Dual-Fuel Commercial-Style Range with 6 Burners (Natural Gas)

Rebates Available!

Caterer Oven, Superior Heat Distribution, Multi-Ring Burner, Two High-Heat Burners, Built-in WiFi

Request More Info Check for Special Offers

Stainless Steel

C2Y366P2TS1

Sale Price: $8,199.00

Matte Black

C2Y366P3TD1

Sale Price: $8,399.00

Matte White

C2Y366P4TW2

Sale Price: $8,399.00

Sale Price: $8,199.00

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ 48" Smart Dual-Fuel Commercial-Style Range with 6 Burners and Griddle (Natural Gas)

Rebates Available!

Versatile Cooktop, Caterer Oven, Color-Matched Manifold with LCD Control, Superior Heat Distribution, Multi-Ring Burner

Request More Info Check for Special Offers

Stainless Steel

C2Y486P2TS1

Sale Price: $12,599.00

Matte Black

C2Y486P3TD1

Sale Price: $12,799.00

Matte White

C2Y486P4TW2

Sale Price: $12,799.00

Sale Price: $12,599.00

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ Beverage Center

Rebates Available!

LED Light Wall, Magnum Bottle Storage, Smart Technology, Flush Installation, Articulating Door Hinges

Request More Info Check for Special Offers

Stainless Steel

CCP06BP2PS1

Sale Price: $2,799.00

Matte Black

CCP06BP3PD1

Sale Price: $2,999.00

Matte White

CCP06BP4PW2

Sale Price: $2,999.00

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ Wine Center

Rebates Available!

LED Light Wall, Magnum Bottle Storage, Smart Technology, Flush Installation, Dual Zone Temperature Control

Request More Info Check for Special Offers

Stainless Steel

CCP06DP2PS1

Sale Price: $3,099.00

Matte Black

CCP06DP3PD1

Call for price

Matte White

CCP06DP4PW2

Sale Price: $3,299.00

Sale Price: $3,099.00

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ Beverage Center in Platinum Glass

Rebates Available!

Platinum Glass Finish, LED Light Wall, Magnum Bottle Storage, Smart Technology, Flush Installation

Request More Info Check for Special Offers

Platinum Glass

CCR06BM2PS5

Sale Price: $3,099.00

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ Wine Center in Platinum Glass

Rebates Available!

Platinum Glass Finish, LED Light Wall, Magnum Bottle Storage, Smart Technology, Flush Installation

Request More Info Check for Special Offers

Platinum Glass

CCR06DM2PS5

Call for price

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ 21.3 Cu. Ft. Built-In Bottom-Freezer Refrigerator

Rebates Available!

36-Inch Built-In Model, Interchangeable Hardware, LED Lighting, Advanced Temperature Control, Sealed Snack Drawers

Request More Info Check for Special Offers

Stainless Steel

CDB36LP2PS1

Call for price

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ Dishwasher Drawer

Rebates Available!

Double Drawer, Create a Look That Matches Your Personal Style, Small Load Setting, Knock to Pause Function, Easy to Load and Unload

Request More Info Check for Special Offers

Stainless Steel

CDD420P2TS1

Sale Price: $999.00

Matte Black

CDD420P3TD1

Sale Price: $1,098.90

Matte White

CDD420P4TW2

Sale Price: $1,098.90

Regular Price: $1399.00

Savings: $400.00

Sale Price: $999.00

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ 5.7 Cu. Ft. Built-In Dual-Drawer Refrigerator

Rebates Available!

Consistent style from the inside out, Slide shut without making a sound, Storage options that fit your needs, Clearly see all your favorite foods, Room for all your favorite items

Request More Info Check for Special Offers

Stainless Steel

CDE06RP2NS1

Sale Price: $3,299.00

Matte Black

CDE06RP3ND1

Sale Price: $3,499.00

Matte White

CDE06RP4NW2

Sale Price: $3,499.00

Sale Price: $3,299.00

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

CafeCafÃ©™ Stainless Steel Interior Dishwasher with Sanitize and Ultra Wash & Dry

Rebates Available!

Ultra Wash & Dry, Loading Flexibility, Adjustable Upper Rack, Wash Zones, Steam + Sani

Request More Info Check for Special Offers

Stainless Steel

CDT805P2NS1

Sale Price: $899.10

Regular Price: $1199.00

Savings: $299.90

Sale Price: $899.10

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Rebates Available!

Ultra Wash & Dry, Loading Flexibility, Adjustable Upper Rack, Wash Zones, Steam + Sani

Request More Info Check for Special Offers

Stainless Steel

CDT845P2NS1

Sale Price: $1,048.50

Matte Black

CDT845P3ND1

Sale Price: $1,499.00

Matte White

CDT845P4NW2

Sale Price: $1,149.30

Regular Price: $1399.00

Savings: $350.50

Sale Price: $1,048.50

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

Cafe CafÃ©™ Smart Stainless Steel Interior Dishwasher with Sanitize and Ultra Wash & Dual Convection Ultra Dry in Platinum Glass

Rebates Available!

Platinum Glass, Ultra Wash & Dual Convection Ultra Dry, Loading Flexibility, Status Center, Steam + Sani

Request More Info Check for Special Offers

Platinum Glass

CDT875M5NS5

Sale Price: $1,899.00

More Information

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,pbm.PromotionName, pbm.PromotionType,Rebates.client_flag AS client_rebate, Rebates.PackageDescription, Rebates.Filename,pbm.PromotionDescription , DATE_FORMAT(pbm.EffectiveDate, '%m/%d/%Y')AS StartDate, pbm.PackageDescription,DATE_FORMAT(pbm.ExpirationDate, '%m/%d/%Y') AS Expires,pbm.PromotionValue,pbm.PackageDescription,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, IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS Price, IF(mp.MSRP > 0 AND mp.MSRP > mp.Sale, mp.MSRP, '') AS RegPrice , mp.quick_ship, if(bd.cart_price_message = '' OR bd.cart_price_message IS NULL,'See price in cart', cart_price_message) AS cart_message , (mp.MSRP - mp.Sale) AS Discount, if(bd.MAP = 1, 1, .90) AS MapDiscount,mp.MSRP, bd.UMRP,p.ModelStatus,p.SKU AS ProductSKU 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 PromotionsByModel AS pbm ON pbm.pkProduct = p.pkID INNER JOIN Rebates on Rebates.PromotionName = pbm.PromotionName WHERE pbm.pkPromotion = '1208' AND pbm.ExpirationDate >= NOW() and pbm.EffectiveDate <= NOW() AND (Rebates.Filename <> '' ) AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY display_sequence ASC, IF(quick_ship =1,quick_ship,999999) ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU

CafeCafÃ©™ Smart Stainless Steel Interior Dishwasher with Sanitize and Ultra Wash & Dual Convection Ultra Dry

Rebates Available!

Ultra Wash & Dual Convection Ultra Dry, Loading Flexibility, Status Center, Steam + Sani, Customizable Hardware Options

Request More Info Check for Special Offers

Stainless Steel

CDT875P2NS1

Sale Price: $1,799.00

Matte White

CDT875P4NW2

Sale Price: $1,899.00

Sale Price: $1,799.00

More Information

C2S900P2MS1	Stainless Steel

	Our Price : $3,699.00
More Detail »

C2S950P2MS1	Stainless Steel

	Our Price : $4,099.00
More Detail »
C2S950P4MW2	Matte White

	Our Price : $4,299.00
More Detail »

C2Y366P2TS1	Stainless Steel

	Our Price : $8,199.00
More Detail »
C2Y366P3TD1	Matte Black

	Our Price : $8,399.00
More Detail »
C2Y366P4TW2	Matte White

	Our Price : $8,399.00
More Detail »

C2Y486P2TS1	Stainless Steel

	Our Price : $12,599.00
More Detail »
C2Y486P3TD1	Matte Black

	Our Price : $12,799.00
More Detail »
C2Y486P4TW2	Matte White

	Our Price : $12,799.00
More Detail »

CCP06BP2PS1	Stainless Steel

	Our Price : $2,799.00
More Detail »
CCP06BP3PD1	Matte Black

	Our Price : $2,999.00
More Detail »
CCP06BP4PW2	Matte White

	Our Price : $2,999.00
More Detail »

Heading Text

Refine Your Results

by Category

by Brand

by Color

by Price

Cafe Get the Look Rebate

Receive up to a $2000 rebate with purchase of qualifying Cafe Appliances.

Cafe CafÃ©™ 30" Smart Slide-In, Front-Control, Dual-Fuel Range with Warming Drawer

Cafe CafÃ©™ 30" Smart Slide-In, Front-Control, Dual-Fuel, Double-Oven Range with Convection

Cafe CafÃ©™ 36" Smart Dual-Fuel Commercial-Style Range with 6 Burners (Natural Gas)

Cafe CafÃ©™ 48" Smart Dual-Fuel Commercial-Style Range with 6 Burners and Griddle (Natural Gas)

Cafe CafÃ©™ Beverage Center

Cafe CafÃ©™ Wine Center

Cafe CafÃ©™ Beverage Center in Platinum Glass

Cafe CafÃ©™ Wine Center in Platinum Glass

Cafe CafÃ©™ 21.3 Cu. Ft. Built-In Bottom-Freezer Refrigerator

Cafe CafÃ©™ Dishwasher Drawer

Cafe CafÃ©™ 5.7 Cu. Ft. Built-In Dual-Drawer Refrigerator

Cafe CafÃ©™ Stainless Steel Interior Dishwasher with Sanitize and Ultra Wash & Dry

Cafe CafÃ©™ Stainless Steel Interior Dishwasher with Sanitize and Ultra Wash & Dry

Cafe CafÃ©™ Smart Stainless Steel Interior Dishwasher with Sanitize and Ultra Wash & Dual Convection Ultra Dry in Platinum Glass

Cafe CafÃ©™ Smart Stainless Steel Interior Dishwasher with Sanitize and Ultra Wash & Dual Convection Ultra Dry

Tell us a little about yourself so we know where to send your special offer.

CCP06DP2PS1	Stainless Steel

	Our Price : $3,099.00
More Detail »
CCP06DP3PD1	Matte Black

Call for price
More Detail »
CCP06DP4PW2	Matte White

	Our Price : $3,299.00
More Detail »

CCR06BM2PS5	Platinum Glass

	Our Price : $3,099.00
More Detail »

CDD420P2TS1	Stainless Steel

Reg: $1399.00	On Sale : $999.00
More Detail »
CDD420P3TD1	Matte Black

Reg: $1499.00	On Sale : $1,098.90
More Detail »
CDD420P4TW2	Matte White

Reg: $1499.00	On Sale : $1,098.90
More Detail »

CDE06RP2NS1	Stainless Steel

	Our Price : $3,299.00
More Detail »
CDE06RP3ND1	Matte Black

	Our Price : $3,499.00
More Detail »
CDE06RP4NW2	Matte White

	Our Price : $3,499.00
More Detail »

CDT805P2NS1	Stainless Steel

Reg: $1199.00	On Sale : $899.10
More Detail »

CDT845P2NS1	Stainless Steel

Reg: $1399.00	On Sale : $1,048.50
More Detail »
CDT845P3ND1	Matte Black

	Our Price : $1,499.00
More Detail »
CDT845P4NW2	Matte White

Reg: $1499.00	On Sale : $1,149.30
More Detail »

CDT875M5NS5	Platinum Glass

	Our Price : $1,899.00
More Detail »

CDT875P2NS1	Stainless Steel

	Our Price : $1,799.00
More Detail »
CDT875P4NW2	Matte White

	Our Price : $1,899.00
More Detail »