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 3 of 11
<< First Page 1234 Last Page >>

 energy star appliance Whirlpool33-inch Wide French Door Refrigerator - 22 cu. ft. Fingerprint Resistant Sunset Bronze

Add To Compare

Whirlpool 33-inch Wide French Door Refrigerator - 22 cu. ft. Fingerprint Resistant Sunset Bronze

Model Color Price
WRFA32SMHN Fingerprint Resistant Sunset Bronze Contact us for best price
 energy star appliance Whirlpool36-inch Wide French Door Refrigerator with Crisper Drawer - 25 cu. ft. Fingerprint Resistant Sunset Bronze

Add To Compare

Whirlpool 36-inch Wide French Door Refrigerator with Crisper Drawer - 25 cu. ft. Fingerprint Resistant Sunset Bronze

Model Color Price
WRFA35SWHN Fingerprint Resistant Sunset Bronze Contact us for best price
 energy star appliance Whirlpool30-inch Wide Contemporary Handle French Door Refrigerator - 20 cu. ft. Fingerprint Resistant Sunset Bronze

Add To Compare

Whirlpool 30-inch Wide Contemporary Handle French Door Refrigerator - 20 cu. ft. Fingerprint Resistant Sunset Bronze

Model Color Price
WRFA60SMHN Fingerprint Resistant Sunset Bronze Contact us for best price
 energy star appliance Whirlpool36-Inch Wide French Door Refrigerator - 25 cu. ft.

Add To Compare

Whirlpool 36-Inch Wide French Door Refrigerator - 25 cu. ft.

Model Color Price
WRX735SDHV Black Stainless $2,599.00
WRX735SDHW White 2599.00*

*See price in cart

WRX735SDHB Black 2599.00*

*See price in cart

Whirlpool36-inch Wide 4-Door Refrigerator with Exterior Drawer - 26 cu. ft.

Add To Compare

Whirlpool 36-inch Wide 4-Door Refrigerator with Exterior Drawer - 26 cu. ft.

Model Color Price
WRX986SIHV Fingerprint Resistant Black Stainless $3,399.00
 energy star appliance LG Appliances22 cu. ft. French Door Refrigerator

Add To Compare

LG Appliances 22 cu. ft. French Door Refrigerator

Model Color Regular Price Savings After Savings
LFC22770ST Stainless Steel $1979.00 $360.00 $1,619.00
 energy star appliance LG Appliances22 cu. ft. French Door Refrigerator

Add To Compare

LG Appliances 22 cu. ft. French Door Refrigerator

Model Color Price
LFCS22520S Stainless Steel $1,699.00
 energy star appliance LG Appliances22 cu. ft. French Door Refrigerator

Add To Compare

LG Appliances 22 cu. ft. French Door Refrigerator

Model Color Regular Price Savings After Savings
LFDS22520S $2199.00 $500.00 $1,699.00
 energy star appliance LG Appliances26 cu. ft. Smart wi-fi Enabled French Door Refrigerator

Add To Compare

LG Appliances 26 cu. ft. Smart wi-fi Enabled French Door Refrigerator

Model Color Regular Price Savings After Savings
LFXS26973D Black Stainless Steel $2914.00 $530.00 $2,384.00
 energy star appliance LG Appliances28 cu. ft. Smart wi-fi Enabled InstaView&trade; Door-in-Door&reg; Refrigerator

Add To Compare

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

Model Color Price
LFXS28596D Black Stainless Steel Contact us for best price
 energy star appliance LG Appliances28 cu.ft. Smart wi-fi Enabled French Door Refrigerator

Add To Compare

LG Appliances 28 cu.ft. Smart wi-fi Enabled French Door Refrigerator

Model Color Regular Price Savings After Savings
LFXS28968S Stainless Steel ✅ In Stock $2969.00 $270.00 $2,699.00
 energy star appliance LG Appliances14.3 cu. ft. Kimchi/Specialty Food French Door Refrigerator

Add To Compare

LG Appliances 14.3 cu. ft. Kimchi/Specialty Food French Door Refrigerator

Model Color Price
LMNS14420V Platinum Silver Contact us for best price
LG Appliances23 cu. ft. French Door Counter-Depth Refrigerator

Add To Compare

LG Appliances 23 cu. ft. French Door Counter-Depth Refrigerator

Model Color Regular Price Savings After Savings
LMWC23626S Stainless Steel $2529.00 $460.00 $2,069.00
LG Appliances27 cu. ft. French Door Refrigerator

Add To Compare

LG Appliances 27 cu. ft. French Door Refrigerator

Model Color Regular Price Savings After Savings
LMWS27626S Printproof(tm) Stainless Steel $2419.00 $440.00 $1,979.00
LG Appliances22 cu ft. Smart Counter Depth Double Freezer Refrigerator

Add To Compare

LG Appliances 22 cu ft. Smart Counter Depth Double Freezer Refrigerator

Model Color Regular Price Savings After Savings
LMXC22626D Black Stainless Steel $3409.00 $310.00 $3,099.00

Page 3 of 11
<< First Page 1234 Last Page >>

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