Heading Text

Shopping Cart
Go To Cart

Product		Qty	Price
		Total: $0.00
		View Cart →

Rigel's Appliance

Cart $0 Item(s): 0

Home /
/
JennAir Curate Your Kitchen Rebate

JennAir Curate Your Kitchen Rebate

Receive up to $2,800 in Instant Savings with purchase of qualifying JennAir Appliance Package.

Valid From: 01/01/2023 - 06/30/2023

*Rebate information is subject to change. Please confirm rebate details and valid models by downloading the rebate form below.

Download the rebate form.

Items per page:
15
30
60
90

Page 1 of 16
12 3 4 5 6 7 8 9 10 11 12 13 14 15 [Next 10 of 16 pages] Last Page >>

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 = '1075' 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

JennAir

JennAirCarbon 18" Cuts By JennAir Leather Panel

JennAir Carbon 18" Cuts By JennAir Leather Panel

Rebates Available!

Carbon Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

CARBON18L

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 = '1075' 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

JennAir

JennAirCarbon 24" Cuts By JennAir Leather Panel

JennAir Carbon 24" Cuts By JennAir Leather Panel

Rebates Available!

Carbon Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

CARBON24L

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 = '1075' 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

JennAir

JennAirCarbon 30" Cuts By JennAir Leather Panel

JennAir Carbon 30" Cuts By JennAir Leather Panel

Rebates Available!

Carbon Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

CARBON30L

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 = '1075' 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

JennAir

JennAirCaviar 18" Cuts By JennAir Leather Panel

JennAir Caviar 18" Cuts By JennAir Leather Panel

Rebates Available!

Caviar Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

CAVIAR18L

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 = '1075' 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

JennAir

JennAirCaviar 24" Cuts By JennAir Leather Panel

JennAir Caviar 24" Cuts By JennAir Leather Panel

Rebates Available!

Caviar Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

CAVIAR24L

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 = '1075' 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

JennAir

JennAirCaviar 30" Cuts By JennAir Leather Panel

JennAir Caviar 30" Cuts By JennAir Leather Panel

Rebates Available!

Caviar Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

CAVIAR30L

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 = '1075' 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

JennAir

JennAirCognac 18" Cuts By JennAir Leather Panel

JennAir Cognac 18" Cuts By JennAir Leather Panel

Rebates Available!

Cognac Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

COGNAC18L

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 = '1075' 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

JennAir

JennAirCognac 24" Cuts By JennAir Leather Panel

JennAir Cognac 24" Cuts By JennAir Leather Panel

Rebates Available!

Cognac Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

COGNAC24L

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 = '1075' 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

JennAir

JennAirCognac 30" Cuts By JennAir Leather Panel

JennAir Cognac 30" Cuts By JennAir Leather Panel

Rebates Available!

Cognac Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

COGNAC30L

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 = '1075' 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

JennAir

JennAirCroc 18" Cuts By JennAir Leather Panel

JennAir Croc 18" Cuts By JennAir Leather Panel

Rebates Available!

Croc Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

CROC18L

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 = '1075' 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

JennAir

JennAirCroc 24" Cuts By JennAir Leather Panel

JennAir Croc 24" Cuts By JennAir Leather Panel

Rebates Available!

Croc Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

CROC24L

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 = '1075' 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

JennAir

JennAirCroc 30" Cuts By JennAir Leather Panel

JennAir Croc 30" Cuts By JennAir Leather Panel

Rebates Available!

Croc Leather Panels, Mount A Handle Of Your Choice, Pairs With JennAir® Column Refrigeration,

Request More Info Check for Special Offers

CROC30L

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 = '1075' 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

JennAir

JennAir36" Panel-Ready Built-In Bottom-Freezer Refrigerator (Left-Hand Door Swing)

JennAir 36" Panel-Ready Built-In Bottom-Freezer Refrigerator (Left-Hand Door Swing)

					out of 5. 5 review(s)

Rebates Available!

Obsidian Interior, Fully Flush, Fully Integrated Design, Style with Custom Wood Panels or Suite-Coordinating Stainless Steel Panel Kits (not included), TwinFresh™ Climate Control System, Multi-Point LED Theater Lighting

Request More Info Check for Special Offers

JB36NXFXLE

Panel Ready

Sale Price: $8,699.00

Sale Price: $8,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 = '1075' 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

JennAir

JennAir36" Panel-Ready Built-In Bottom-Freezer Refrigerator (Right-Hand Door Swing)

JennAir 36" Panel-Ready Built-In Bottom-Freezer Refrigerator (Right-Hand Door Swing)

					out of 5. 6 review(s)

Rebates Available!

Obsidian Interior, Fully Flush, Fully Integrated Design, Style with Custom Wood Panels or Suite-Coordinating Stainless Steel Panel Kits (not included), TwinFresh™ Climate Control System, Multi-Point LED Theater Lighting

Request More Info Check for Special Offers

JB36NXFXRE

Panel Ready

Sale Price: $8,699.00

Sale Price: $8,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 = '1075' 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

JennAir

JennAirRISE™ 36" Fully Integrated Built-In Bottom-Freezer Refrigerator Panel-Kit (Left-Swing)

JennAir RISE™ 36" Fully Integrated Built-In Bottom-Freezer Refrigerator Panel-Kit (Left-Swing)

Rebates Available!

Tall Stainless Steel Door, Flush to Cabinet, Pro Luxe styling,

Request More Info Check for Special Offers

JBBFL36NHL

Stainless Steel

More Information

Page 1 of 16
12 3 4 5 6 7 8 9 10 11 12 13 14 15 [Next 10 of 16 pages] Last Page >>

Rigel's Appliance

Nice choice! we love the

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

Copyright © 2009 - 2023 Rigel's Appliance All Rights Reserved.

Welcome to our website! As we have the ability to list over one million items on our website (our selection changes all of the time), it is not feasible for a company our size to record and playback the descriptions on every item on our website. However, if you are an American with a disability we are here to help you. Please call our disability services phone line at 218-233-6104 during regular business hours and one of our kind and friendly personal shoppers will help you navigate through our website, help conduct advanced searches, help you choose the item you are looking for with the specifications you are seeking, read you the specifications of any item and consult with you about the products themselves. There is no charge for the help of this personal shopper for any American with a disability. Finally, your personal shopper will explain our Privacy Policy and Terms of Service, and help you place an order if you so desire.

Your Quote
Go To Cart

Product		Qty	Price
		Total: $0.00
		View Cart →