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 ,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) WHERE p.mhSlug = 'refrigeration' AND cgSlug = 'side-by-side' AND cSlug = 'cabinet-depth-side-by-side-refrigerators' AND mp.Available = 1 AND ((CommonBrandID = 'KTA')) 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
Professionally-Inspired Design - Combines a bold blend of professionally-inspired styling with sleek touches for the home. This beautiful side-by-side refrigeration unit features Satin Textured Handles and the KitchenAid(R) Badge, a symbol of uncompromise, LED Lighting - Illuminates the inside of the refrigerator and freezer giving for better visibility. Unlike incandescent bulbs, LED lights use less energy, are maintenance-free and never need to be replaced., Adjustable Spill Resistant Shelves - Prevents messes from spilling over into other parts of the refrigerator. In place of a lip that can trap foods, the shelf edges are nano-etched with a finely texture surface that contains spills and lets you use the wh, Exterior and Ice and Water Dispenser - Provides freshly filtered, great tasting water and ice that can be conveniently found right in the refrigerator door., Clear Door Bins with Metallic Accents - Allows you to see labels right through the bins, helping you keep condiments and other items organized. Each bin is removable, making it easy to pull out, chop up and store an amazingly fresh produce, and simply sli
Request More Info Check for Special Offers
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 ,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) WHERE p.mhSlug = 'refrigeration' AND cgSlug = 'side-by-side' AND cSlug = 'cabinet-depth-side-by-side-refrigerators' AND mp.Available = 1 AND ((CommonBrandID = 'KTA')) 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
Professionally-Inspired Design - Combines a bold blend of professionally-inspired styling with sleek touches for the home. This beautiful side-by-side refrigeration unit features Satin Textured Handles and the KitchenAid(R) Badge, a symbol of uncompromise, PrintShield Finish - resists smudges while enhancing the overall look of the refrigerator. This new feature for KitchenAid(R) takes the worry out of keeping a working kitchen beautiful., LED Lighting - Illuminates the inside of the refrigerator and freezer giving for better visibility. Unlike incandescent bulbs, LED lights use less energy, are maintenance-free and never need to be replaced., Adjustable Spill Resistant Shelves - Prevents messes from spilling over into other parts of the refrigerator. In place of a lip that can trap foods, the shelf edges are nano-etched with a finely texture surface that contains spills and lets you use the wh, Exterior and Ice and Water Dispenser - Provides freshly filtered, great tasting water and ice that can be conveniently found right in the refrigerator door.
Request More Info Check for Special Offers
Added to Brochure