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 14 of 16
<< First Page [Previous 10 pages] 12131415 Last Page >>

 energy star appliance Samsung Appliances26 cu. ft. French Door Refrigerator with Internal Filtered Water

Add To Compare

Samsung Appliances 26 cu. ft. French Door Refrigerator with Internal Filtered Water

Model Color Price
RF261BEAEBC Black Contact us for best price
Samsung Appliances26 cu. ft. French Door Refrigerator with Internal Filtered Water

Add To Compare

Samsung Appliances 26 cu. ft. French Door Refrigerator with Internal Filtered Water

Model Color Price
RF261BEAESP Stainless Platinum Contact us for best price
 energy star appliance Samsung Appliances26 cu. ft. French Door Refrigerator with Internal Filtered Water in Stainless Steel

Add To Compare

Samsung Appliances 26 cu. ft. French Door Refrigerator with Internal Filtered Water in Stainless Steel

Model Color Price
RF261BEAESR Stainless Steel Contact us for best price
RF261BEAESG Fingerprint Resistant Black Stainless Steel Contact us for best price
Samsung Appliances25.1 cu. ft. 3-Door French Door Refrigerator with Family Hub&trade; in Stainless Steel

Add To Compare

Samsung Appliances 25.1 cu. ft. 3-Door French Door Refrigerator with Family Hub™ in Stainless Steel

Model Color Price
RF262BEAESR Stainless Steel $2,699.00
Samsung Appliances25 cu. ft. French Door with External Water & Ice Dispenser

Add To Compare

Samsung Appliances 25 cu. ft. French Door with External Water & Ice Dispenser

Model Color Price
RF263BEAESP Stainless Platinum Contact us for best price
RF263BEAEBC Black Contact us for best price
RF263BEAEWW White Contact us for best price
RF263BEAESG Fingerprint Resistant Black Stainless Steel Contact us for best price
 energy star appliance Samsung Appliances25 cu. ft. French Door with External Water & Ice Dispenser, Dual Ice Maker

Add To Compare

Samsung Appliances 25 cu. ft. French Door with External Water & Ice Dispenser, Dual Ice Maker

Model Color Price
RF263TEAESG Fingerprint Resistant Black Stainless Steel Contact us for best price
 energy star appliance Samsung Appliances24 cu. ft. Family Hub&trade; 3-Door French Door Refrigerator in Black Stainless Steel

Add To Compare

Samsung Appliances 24 cu. ft. Family Hub™ 3-Door French Door Refrigerator in Black Stainless Steel

Model Color Price
RF265BEAESG Fingerprint Resistant Black Stainless Steel Contact us for best price
 energy star appliance Samsung Appliances26 cu. ft. 3-Door French Door Refrigerator with CoolSelect Pantry&trade; in Stainless Steel

Add To Compare

Samsung Appliances 26 cu. ft. 3-Door French Door Refrigerator with CoolSelect Pantry™ in Stainless Steel

Model Color Price
RF26J7500SR Stainless Steel Contact us for best price
Samsung Appliances26 cu. ft. 3-Door French Door Refrigerator with External Water & Ice Dispenser in Stainless Steel

Add To Compare

Samsung Appliances 26 cu. ft. 3-Door French Door Refrigerator with External Water & Ice Dispenser in Stainless Steel

Model Color Price
RF26J7510SR Fingerprint Resistant Stainless Steel $2,699.00
Samsung Appliances27 cu. ft. Large Capacity 3-Door French Door Refrigerator with External Water & Ice Dispenser in Black Stainless Steel

Add To Compare

Samsung Appliances 27 cu. ft. Large Capacity 3-Door French Door Refrigerator with External Water & Ice Dispenser in Black Stainless Steel

Model Color Price
RF27T5201SG Fingerprint Resistant Black Stainless Steel $2,221.00
RF27T5201WW White $2,199.00
Samsung Appliances27 cu. ft. Large Capacity 3-Door French Door Refrigerator with Dual Ice Maker in Black Stainless Steel

Add To Compare

Samsung Appliances 27 cu. ft. Large Capacity 3-Door French Door Refrigerator with Dual Ice Maker in Black Stainless Steel

Model Color Price
RF27T5241SG Fingerprint Resistant Black Stainless Steel Contact us for best price
Samsung Appliances26.5 cu. ft. Large Capacity 3-Door French Door Refrigerator with Family Hub&trade; and External Water & Ice Dispenser in Black Stainless Steel

Add To Compare

Samsung Appliances 26.5 cu. ft. Large Capacity 3-Door French Door Refrigerator with Family Hub™ and External Water & Ice Dispenser in Black Stainless Steel

Model Color Price
RF27T5501SG Fingerprint Resistant Black Stainless Steel $3,299.00
 energy star appliance Samsung Appliances28 cu. ft. Food Showcase 3-Door French Door Refrigerator in Stainless Steel

Add To Compare

Samsung Appliances 28 cu. ft. Food Showcase 3-Door French Door Refrigerator in Stainless Steel

Model Color Price
RF28HDEDBSR Stainless Steel Contact us for best price
RF28HDEDBSG Fingerprint Resistant Black Stainless Steel Contact us for best price

Page 14 of 16
<< First Page [Previous 10 pages] 12131415 Last Page >>

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