Refrigeration - Refrigerator Accessories - Refrigerator Accessories

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 = 'refrigeration' AND cgSlug = 'refrigerator-accessories' AND cSlug = 'refrigerator-accessories' AND mp.Available = 1 AND ((CommonBrandID = 'JENN')) 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
14
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

JennAirIce Machine Drain Pump Kit

Add To Compare

JennAir Ice Machine Drain Pump Kit

This product is a Factory Certified Accessory. These three words represent quality parts and accessories designed specifically for your appliance. Time tested engineering that meets our strict quality specifications, Package contains (1) Ice Machine Drain Pump Kit, Tools Needed: Multi screwdriver, standard pliers, 30-Day Return Policy,

Model Color Price
1901A Contact us for best price
JennAirEuro-Style 36" Fully Integrated Built-In Bottom-Freezer Left-Hand Door Swing Stainless Steel

Add To Compare

JennAir Euro-Style 36" Fully Integrated Built-In Bottom-Freezer Left-Hand Door Swing Stainless Steel

Tall Stainless Steel Door, Flush to Cabinet, EURO styling, Euro-Style Stainless Design, Euro Style Handles,

Model Color Price
JBBFL36NHS Stainless Steel Contact us for best price
JennAirEuro-Style 36" Fully Integrated Built-In Bottom-Freezer Right-Hand Door Swing Panel-Kit Stainless Steel

Add To Compare

JennAir Euro-Style 36" Fully Integrated Built-In Bottom-Freezer Right-Hand Door Swing Panel-Kit Stainless Steel

Tall Stainless Steel Door, Flush to Cabinet, EURO styling, Euro-Style Stainless Design, Euro Style Handles,

Model Color Price
JBBFR36NHS Stainless Steel Contact us for best price
JennAirEuro-Style 36" Fully Integrated Built-In French Door Panel-Kit Stainless Steel

Add To Compare

JennAir Euro-Style 36" Fully Integrated Built-In French Door Panel-Kit Stainless Steel

Tall Stainless Steel Door, Flush to Cabinet, EURO styling, Stainless Steel Door Panels, Euro Style Handles,

Model Color Price
JBFFS36NHS Stainless Steel Contact us for best price
JennAirEuro-Style 42" Fully Integrated Built-In French Door Panel-Kit Stainless Steel

Add To Compare

JennAir Euro-Style 42" Fully Integrated Built-In French Door Panel-Kit Stainless Steel

Euro-Style Stainless Design, Full Height Door, Fully Integrated and Flush Design, Minimal Reveal, Robust Stainless Steel Door Panel

Model Color Price
JBFFS42NHS Stainless Steel Contact us for best price
JennAirPro-Style&reg; 42" Fully Integrated Built-In Side-by-Side Panel-Kit Stainless Steel

Add To Compare

JennAir Pro-Style® 42" Fully Integrated Built-In Side-by-Side Panel-Kit Stainless Steel

Full Height Door, Fully Integrated and Flush Design, Minimal Reveal, Pro-Style® Stainless Design, Robust Stainless Steel Door Panel

Model Color Price
JBSFS42NHP Stainless Steel Contact us for best price
JennAirEuro-Style 42" Fully Integrated Built-In Side-by-Side Panel-Kit Stainless Steel

Add To Compare

JennAir Euro-Style 42" Fully Integrated Built-In Side-by-Side Panel-Kit Stainless Steel

Tall Stainless Steel Door, Flush to Cabinet, EURO styling, Full Height Door, Fully Integrated and Flush Design, Minimal Reveal, Robust Stainless Steel Door Panel

Model Color Price
JBSFS42NHS Stainless Steel Contact us for best price
JennAirPro-Style&reg; 18" Built-In Column Panel Kit - Left-Swing Pro Style Stainless

Add To Compare

JennAir Pro-Style® 18" Built-In Column Panel Kit - Left-Swing Pro Style Stainless

Pro-Style® Stainless Design, 18" Panel Kit, Left Swing, Pro-Style® Design,

Model Color Price
JKCPL181GP Pro Style Stainless Contact us for best price
JennAirEuro-Style 18" Built-In Column Panel Kit - Left-Swing Stainless Steel

Add To Compare

JennAir Euro-Style 18" Built-In Column Panel Kit - Left-Swing Stainless Steel

Euro-Style Stainless Design, 18" Panel Kit, Left Swing, Euro-Style® Design,

Model Color Price
JKCPL181GS Stainless Steel Contact us for best price
JennAirPro-Style&reg; 30" Built-In Column Panel Kit - Left-Swing Pro Style Stainless

Add To Compare

JennAir Pro-Style® 30" Built-In Column Panel Kit - Left-Swing Pro Style Stainless

Pro-Style® Stainless Design, 30" Panel Kit, Left Swing, Pro-Style® Design,

Model Color Price
JKCPL301GP Pro Style Stainless Contact us for best price
JennAirPro-Style&reg; 18" Built-In Column Panel Kit - Right-Swing Pro Style Stainless

Add To Compare

JennAir Pro-Style® 18" Built-In Column Panel Kit - Right-Swing Pro Style Stainless

Pro-Style® Stainless Design, 18" Panel Kit, Right Swing, Pro-Style® Design,

Model Color Price
JKCPR181GP Pro Style Stainless Contact us for best price
JennAirPro-Style&reg; 24" Built-In Column Panel Kit - Right-Swing Pro Style Stainless

Add To Compare

JennAir Pro-Style® 24" Built-In Column Panel Kit - Right-Swing Pro Style Stainless

Pro-Style® Stainless Design, 24" Panel Kit, Right Swing, Pro-Style® Design,

Model Color Price
JKCPR241GP Pro Style Stainless Contact us for best price
JennAirPro-Style&reg; 30" Built-In Column Panel Kit - Right-Swing Pro Style Stainless

Add To Compare

JennAir Pro-Style® 30" Built-In Column Panel Kit - Right-Swing Pro Style Stainless

Pro-Style® Stainless Design, 30" Panel Kit, Right Swing, Pro-Style® Design,

Model Color Price
JKCPR301GP Pro Style Stainless Contact us for best price
JennAirEuro-Style 30" Built-In Column Panel Kit - Right-Swing Stainless Steel

Add To Compare

JennAir Euro-Style 30" Built-In Column Panel Kit - Right-Swing Stainless Steel

Euro-Style Stainless Design, 30" Panel Kit, Right Swing, Euro-Style® Design,

Model Color Price
JKCPR301GS 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.