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 = 'FRIG')) 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
5
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

 energy star appliance Frigidaire 26.8 Cu. Ft. French Door Refrigerator

Add To Compare

Frigidaire 26.8 Cu. Ft. French Door Refrigerator

Model Color Regular Price Savings After Savings
FFHB2750TS Stainless Steel $2649.00 $300.00 $2,349.00
 energy star appliance Frigidaire 27.6 Cu. Ft. French Door Refrigerator

Add To Compare

Frigidaire 27.6 Cu. Ft. French Door Refrigerator

Model Color Regular Price Savings After Savings
FFHN2750TS Stainless Steel $2299.00 $250.00 $2,049.00
 energy star appliance Frigidaire Gallery 26.8 Cu. Ft. French Door Refrigerator

Add To Compare

Frigidaire Gallery 26.8 Cu. Ft. French Door Refrigerator

Model Color Regular Price Savings After Savings
FGHB2868TD Black Stainless Steel $3099.00 $350.00 $2,749.00
 energy star appliance Frigidaire Gallery 27.6 Cu. Ft. French Door Refrigerator

Add To Compare

Frigidaire Gallery 27.6 Cu. Ft. French Door Refrigerator

Model Color Regular Price Savings After Savings
FGHN2868TF Stainless Steel $2649.00 $300.00 $2,349.00
Frigidaire 17.4 Cu. Ft. 4 Door Refrigerator

Add To Compare

Frigidaire 17.4 Cu. Ft. 4 Door Refrigerator

Model Color Price
FRQG1721AV Brushed Steel Contact us for best price

Page 1 of 1
1

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