Refrigeration - Freezers - Upright: Frost Free

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 = 'freezers' AND cSlug = 'upright-frost-free-freezers' 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
7
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

Frigidaire 16 Cu. Ft Upright Freezer

Add To Compare

Frigidaire 16 Cu. Ft Upright Freezer

Model Color Regular Price Savings After Savings
FFFU16F2VW White ✅ In Stock $919.00 $227.00 $692.00
Frigidaire 20.0 Cu. Ft Upright Freezer

Add To Compare

Frigidaire 20.0 Cu. Ft Upright Freezer

Model Color Regular Price Savings After Savings
FFFU20F2VW White ✅ In Stock $1049.00 $150.00 $899.00
Frigidaire 13 Cu. Ft Upright Freezer

Add To Compare

Frigidaire 13 Cu. Ft Upright Freezer

Model Color Regular Price Savings After Savings
FFFU13F2VW White $819.00 $150.00 $669.00
Frigidaire 20.0 Cu. Ft Upright Freezer

Add To Compare

Frigidaire 20.0 Cu. Ft Upright Freezer

Model Color Price
FFFH20F3WW White Contact us for best price
Frigidaire 20.0 Cu. Ft Upright Freezer

Add To Compare

Frigidaire 20.0 Cu. Ft Upright Freezer

Model Color Regular Price Savings After Savings
FFFU20F4VN Carbon $1099.00 $150.00 $949.00
Frigidaire 6 Cu. Ft. Upright Freezer

Add To Compare

Frigidaire 6 Cu. Ft. Upright Freezer

Model Color Price
FFUM0623AW White Contact us for best price
Frigidaire Professional 19 Cu. Ft. Single-Door Freezer

Add To Compare

Frigidaire Professional 19 Cu. Ft. Single-Door Freezer

Model Color Regular Price Savings After Savings
FPFU19F8WF Stainless Steel $3249.00 $350.00 $2,899.00

Page 1 of 1
1

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