Refrigeration - Freezers - Chest

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 = 'chest-freezers' 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 2
12 Last Page >>

Element ApplianceElement 5 cu. ft. Chest Freezer, White

Add To Compare

Element Appliance Element 5 cu. ft. Chest Freezer, White

Model Color Regular Price Savings After Savings
EACF05000W ✅ In Stock $279.00 $79.05 $199.95
Element ApplianceElement 7 cu. ft. Chest Freezer, White

Add To Compare

Element Appliance Element 7 cu. ft. Chest Freezer, White

Model Color Price
EACF07000W ✅ In Stock $299.00
Element ApplianceElement 9 cu. ft. Chest Freezer, White

Add To Compare

Element Appliance Element 9 cu. ft. Chest Freezer, White

Model Color Regular Price Savings After Savings
EACF09000W ✅ In Stock $379.00 $29.05 $349.95
Element ApplianceElement 14 cu. ft. Chest Freezer, White

Add To Compare

Element Appliance Element 14 cu. ft. Chest Freezer, White

Model Color Regular Price Savings After Savings
EACF14100W ✅ In Stock $599.00 $170.00 $429.00
Amana15 Cu. Ft. Chest Freezer with 2 Baskets - White

Add To Compare

Amana 15 Cu. Ft. Chest Freezer with 2 Baskets - White

Model Color Price
AZC31T15DW White ✅ In Stock $619.00
Frigidaire 14.8 Cu. Ft. Chest Freezer

Add To Compare

Frigidaire 14.8 Cu. Ft. Chest Freezer

Model Color Price
FFFC15M4TW White ✅ In Stock $699.00
Frigidaire 19.8 Cu. Ft. Chest Freezer

Add To Compare

Frigidaire 19.8 Cu. Ft. Chest Freezer

Model Color Regular Price Savings After Savings
FFFC20M4TW White ✅ In Stock $999.00 $150.00 $849.00
DanbyDiplomat 3.5 cu.ft. Chest Freezer

Add To Compare

Danby Diplomat 3.5 cu.ft. Chest Freezer

Model Color Price
DCF035B1WM White $279.99
DanbyDanby 3.8 cu. ft. Chest Freezer

Add To Compare

Danby Danby 3.8 cu. ft. Chest Freezer

Model Color Price
DCF038A2WDB White $309.99
DanbyDanby 7.2 cu. ft. Chest Freezer

Add To Compare

Danby Danby 7.2 cu. ft. Chest Freezer

Model Color Price
DCF072A3WDB6 White Contact us for best price
DanbyDanby Diplomat 8.7 cu ft Chest Freezer

Add To Compare

Danby Danby Diplomat 8.7 cu ft Chest Freezer

Model Color Price
DCF087B1WM $529.99
Frigidaire 14.8 Cu. Ft. Chest Freezer

Add To Compare

Frigidaire 14.8 Cu. Ft. Chest Freezer

Model Color Regular Price Savings After Savings
FFCL1542AW White $699.00 $100.00 $599.00
Frigidaire 7.0 Cu. Ft. Chest Freezer

Add To Compare

Frigidaire 7.0 Cu. Ft. Chest Freezer

Model Color Price
FFCS0722AW White $379.00
Frigidaire 8.7 Cu. Ft. Chest Freezer

Add To Compare

Frigidaire 8.7 Cu. Ft. Chest Freezer

Model Color Regular Price Savings After Savings
FFCS0922AW White $469.00 $100.00 $369.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.