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 AND ((CommonBrandID = 'LG')) 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 2
12 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
 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
 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 Regular Price Savings After Savings
LMXS28596D Printproof(tm) Black Stainless Steel $4069.00 $740.00 $3,329.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 Regular Price Savings After Savings
LMXS28596S Printproof(tm) Stainless Steel $3849.00 $700.00 $3,149.00
 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
LMXS28626S Stainless Steel ✅ In Stock $3189.00 $290.00 $2,899.00

Page 1 of 2
12 Last Page >>

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