Refrigeration - French Door Refrigerators - French Door: Freestanding

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 cSlug = 'french-door-bottom-freezer-refrigerators' 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 1 of 11
1234 [Next 10 of 11 pages] Last Page >>

LG Appliances27 cu. ft. InstaView&trade; Door-in-Door&reg; Refrigerator

Add To Compare

LG Appliances 27 cu. ft. InstaView™ Door-in-Door® Refrigerator

Model Color Regular Price Savings After Savings
LFCS27596S Printproof(tm) Stainless Steel ✅ In Stock $2639.00 $640.00 $1,999.00
 energy star appliance LG Appliances26 cu. ft. Smart wi-fi Enabled InstaView&trade; Door-in-Door&reg; Refrigerator

Add To Compare

LG Appliances 26 cu. ft. Smart wi-fi Enabled InstaView™ Door-in-Door® Refrigerator

Model Color Regular Price Savings After Savings
LFXS26596S Stainless Steel ✅ In Stock $3354.00 $1,055.00 $2,299.00
GE&reg;ENERGY STAR&reg; 27.0 Cu. Ft. Fingerprint Resistant French-Door Refrigerator

Add To Compare

GE ®ENERGY STAR® 27.0 Cu. Ft. Fingerprint Resistant French-Door Refrigerator

Model Color Price
GNE27EYMFS Fingerprint Resistant Stainless ✅ In Stock $1,899.00
Samsung Appliances28 cu. ft. Food Showcase 4-Door French Door Refrigerator in Black Stainless Steel

Add To Compare

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

Model Color Price
RF28R7351SG Fingerprint Resistant Black Stainless Steel ✅ In Stock 3149.00*

*See price in cart

RF28R7351DT Fingerprint Resistant Tuscan Stainless Steel 3149.00*

*See price in cart

 energy star appliance Samsung Appliances26 cu. ft. French Door Refrigerator with Filtered Ice Maker in Stainless Steel

Add To Compare

Samsung Appliances 26 cu. ft. French Door Refrigerator with Filtered Ice Maker in Stainless Steel

Model Color Price
RF260BEAESR Stainless Steel Contact us for best price
RF260BEAESG Fingerprint Resistant Black Stainless Steel Contact us for best price
Maytag19.6 cu ft French Door Refrigerator with Strongbox Door Bins Fingerprint Resistant Stainless Steel

Add To Compare

Maytag 19.6 cu ft French Door Refrigerator with Strongbox Door Bins Fingerprint Resistant Stainless Steel

Model Color Price
MFB2055FRZ Fingerprint Resistant Stainless Steel Contact us for best price
Maytag30-Inch Wide French Door Refrigerator - 20 Cu. Ft.

Add To Compare

Maytag 30-Inch Wide French Door Refrigerator - 20 Cu. Ft.

Model Color Price
MFF2055FRZ Fingerprint Resistant Stainless Steel $1,749.00
 energy star appliance Maytag33-Inch Wide French Door Refrigerator - 22 Cu. Ft.

Add To Compare

Maytag 33-Inch Wide French Door Refrigerator - 22 Cu. Ft.

Model Color Regular Price Savings After Savings
MFF2258FEZ Fingerprint Resistant Stainless Steel 2221.00*

*See price in cart

 energy star appliance Maytag36-Inch Wide French Door Refrigerator - 25 Cu. Ft.

Add To Compare

Maytag 36-Inch Wide French Door Refrigerator - 25 Cu. Ft.

Model Color Price
MFF2558FEZ Fingerprint Resistant Stainless Steel Contact us for best price
Maytag33- Inch Wide French Door Refrigerator with Beverage Chiller Compartment - 22 Cu. Ft.

Add To Compare

Maytag 33- Inch Wide French Door Refrigerator with Beverage Chiller Compartment - 22 Cu. Ft.

Model Color Price
MFI2269FRZ Fingerprint Resistant Stainless Steel $2,388.00
MFI2269FRW White $2,276.00
 energy star appliance Maytag36- Inch Wide French Door Refrigerator with PowerCold&reg; Feature - 25 Cu. Ft.

Add To Compare

Maytag 36- Inch Wide French Door Refrigerator with PowerCold® Feature - 25 Cu. Ft.

Model Color Price
MFI2570FEZ Fingerprint Resistant Stainless Steel $2,299.00
MFI2570FEW White 2299.00*

*See price in cart

 energy star appliance Maytag36-Inch Wide French Door Refrigerator - 27 Cu. Ft.

Add To Compare

Maytag 36-Inch Wide French Door Refrigerator - 27 Cu. Ft.

Model Color Price
MFT2772HEZ Fingerprint Resistant Stainless Steel $2,887.00
Maytag30-Inch Wide French Door Refrigerator with Exterior Water Dispenser- 20 Cu. Ft.

Add To Compare

Maytag 30-Inch Wide French Door Refrigerator with Exterior Water Dispenser- 20 Cu. Ft.

Model Color Price
MFW2055FRZ Fingerprint Resistant Stainless Steel $1,999.00
Beko35.74803, French Door Refrigerator with -

Add To Compare

Beko 35.74803, French Door Refrigerator with -

Model Color Price
BFFD3624XSS Fingerprint-free Stainless Steel Contact us for best price
Beko36" French Four-Door Stainless Steel Refrigerator with auto Ice Maker, Water Dispenser

Add To Compare

Beko 36" French Four-Door Stainless Steel Refrigerator with auto Ice Maker, Water Dispenser

Model Color Price
BFFD3626SS Fingerprint-free Stainless Steel $2,849.00

Page 1 of 11
1234 [Next 10 of 11 pages] Last Page >>

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