Refrigeration - French Door Refrigerators

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 = 'french-door' 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 12 of 16
<< First Page [Previous 10 pages] 10111213 Last Page >>

KitchenAid20 cu. Ft. 30-Inch Width Standard Depth French Door Refrigerator with Interior Dispense - White

Add To Compare

KitchenAid 20 cu. Ft. 30-Inch Width Standard Depth French Door Refrigerator with Interior Dispense - White

Model Color Price
KRFF300EWH White $2,099.00
KRFF300EBS Black Stainless Steel With Printshield(tm) Finish $2,199.00
 energy star appliance KitchenAid22 Cu. Ft. 33-Inch Width Standard Depth French Door Refrigerator with Interior Dispenser - White

Add To Compare

KitchenAid 22 Cu. Ft. 33-Inch Width Standard Depth French Door Refrigerator with Interior Dispenser - White

Model Color Price
KRFF302EWH White $2,554.00
KRFF302EBS Black Stainless Steel With Printshield(tm) Finish $2,665.00
 energy star appliance KitchenAid25 Cu. Ft. 36-Width Standard Depth French Door Refrigerator with Interior Dispense - White

Add To Compare

KitchenAid 25 Cu. Ft. 36-Width Standard Depth French Door Refrigerator with Interior Dispense - White

Model Color Price
KRFF305EWH White $2,221.00
KRFF305EBS Black Stainless Steel With Printshield(tm) Finish $2,332.00
 energy star appliance KitchenAid26.8 cu. ft. 36-Inch Width Standard Depth French Door Refrigerator with Exterior Ice and Water and PrintShield finish Stainless Steel with PrintShield&trade; Finish

Add To Compare

KitchenAid 26.8 cu. ft. 36-Inch Width Standard Depth French Door Refrigerator with Exterior Ice and Water and PrintShield finish Stainless Steel with PrintShield™ Finish

Model Color Price
KRFF507HPS Stainless Steel With Printshield(tm) Finish $3,049.00
KRFF507HBS Black Stainless Steel With Printshield(tm) Finish $3,149.00
KitchenAid25.8 Cu. Ft. 36" Multi-Door Freestanding Refrigerator with Platinum Interior Design - Stainless Steel

Add To Compare

KitchenAid 25.8 Cu. Ft. 36" Multi-Door Freestanding Refrigerator with Platinum Interior Design - Stainless Steel

Model Color Price
KRMF706ESS Stainless Steel $4,099.00
Samsung Appliances18 cu. ft. Smart Counter Depth 3-Door French Door Refrigerator in Black Stainless Steel

Add To Compare

Samsung Appliances 18 cu. ft. Smart Counter Depth 3-Door French Door Refrigerator in Black Stainless Steel

Model Color Price
RF18A5101SG Fingerprint Resistant Black Stainless Steel $1,499.00
RF18A5101WW White 1349.00*

*See price in cart

Samsung Appliances19.5 cu. ft. Smart 3-Door French Door Refrigerator in Black

Add To Compare

Samsung Appliances 19.5 cu. ft. Smart 3-Door French Door Refrigerator in Black

Model Color Price
RF20A5101B1 Black Contact us for best price
RF20A5101SR Stainless Steel $1,499.00
RF20A5101WW White $1,399.00
Samsung Appliances20 cu. ft. French Door Refrigerator

Add To Compare

Samsung Appliances 20 cu. ft. French Door Refrigerator

Model Color Price
RF20HFENBBC Black Contact us for best price
RF20HFENBSR Stainless Steel $1,599.00
RF20HFENBSP Stainless Platinum Contact us for best price
Samsung Appliances20 cu. ft. French Door Refrigerator in Black Stainless Steel

Add To Compare

Samsung Appliances 20 cu. ft. French Door Refrigerator in Black Stainless Steel

Model Color Price
RF20HFENBSG Fingerprint Resistant Black Stainless Steel $1,799.00
Samsung Appliances22 cu. ft. French Door Refrigerator

Add To Compare

Samsung Appliances 22 cu. ft. French Door Refrigerator

Model Color Price
RF220NCTABC Black Contact us for best price
Samsung Appliances22 cu. ft. French Door Refrigerator

Add To Compare

Samsung Appliances 22 cu. ft. French Door Refrigerator

Model Color Price
RF220NCTASP Stainless Platinum Contact us for best price
Samsung Appliances22 cu. ft. French Door Refrigerator in White

Add To Compare

Samsung Appliances 22 cu. ft. French Door Refrigerator in White

Model Color Price
RF220NCTAWW White $1,666.00
RF220NCTASG Fingerprint Resistant Black Stainless Steel $1,777.00
 energy star appliance Samsung Appliances22 cu. ft. Food Showcase Counter Depth 4-Door French Door Refrigerator in Black Stainless Steel

Add To Compare

Samsung Appliances 22 cu. ft. Food Showcase Counter Depth 4-Door French Door Refrigerator in Black Stainless Steel

Model Color Price
RF22R7351SG Fingerprint Resistant Black Stainless Steel 3239.00*

*See price in cart

RF22R7351DT Fingerprint Resistant Tuscan Stainless Steel 3239.00*

*See price in cart

Samsung Appliances22 cu. ft. Counter Depth 4-Door French Door Refrigerator with Touch Screen Family Hub&trade; in Tuscan Stainless Steel

Add To Compare

Samsung Appliances 22 cu. ft. Counter Depth 4-Door French Door Refrigerator with Touch Screen Family Hub™ in Tuscan Stainless Steel

Model Color Price
RF22R7551DT Fingerprint Resistant Tuscan Stainless Steel $3,999.00
RF22R7551SR Fingerprint Resistant Stainless Steel $3,899.00
Samsung Appliances23 cu. ft. Smart Counter Depth 4-Door Flex&trade; refrigerator with AutoFill Water Pitcher and Dual Ice Maker in Black Stainless Steel

Add To Compare

Samsung Appliances 23 cu. ft. Smart Counter Depth 4-Door Flex™ refrigerator with AutoFill Water Pitcher and Dual Ice Maker in Black Stainless Steel

Model Color Price
RF23A9071SG Black Stainless Steel $3,221.00

Page 12 of 16
<< First Page [Previous 10 pages] 10111213 Last Page >>

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