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 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
80
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
Amana16 cu. ft. Upright Freezer with Energy-Saving Insulation - White

Add To Compare

Amana 16 cu. ft. Upright Freezer with Energy-Saving Insulation - White

Model Color Price
AZF33X16DW White $769.95
 energy star appliance GE&reg;17.3 Cu. Ft. Frost-Free Upright Freezer

Add To Compare

GE ®17.3 Cu. Ft. Frost-Free Upright Freezer

Model Color Price
FUF17DLRWW White $899.00
 energy star appliance GE&reg;21.3 Cu. Ft. Frost-Free Upright Freezer

Add To Compare

GE ®21.3 Cu. Ft. Frost-Free Upright Freezer

Model Color Price
FUF21DLRWW White $1,049.00
GE&reg;14.1 Cu. Ft. Frost-Free Upright Freezer

Add To Compare

GE ®14.1 Cu. Ft. Frost-Free Upright Freezer

Model Color Price
FUF14DLRWW White $799.00
GE&reg;14.1 Cu. Ft. Frost-Free Upright Freezer

Add To Compare

GE ®14.1 Cu. Ft. Frost-Free Upright Freezer

Model Color Price
FUF14SMRWW White $779.00
GE&reg;17.3 Cu. Ft. Frost-Free Upright Freezer

Add To Compare

GE ®17.3 Cu. Ft. Frost-Free Upright Freezer

Model Color Price
FUF17SMRWW White $879.00
GE&reg;21.3 Cu. Ft. Frost-Free Upright Freezer

Add To Compare

GE ®21.3 Cu. Ft. Frost-Free Upright Freezer

Model Color Price
FUF21SMRWW White $1,029.00
Sub-Zero36" Classic Freezer

Add To Compare

Sub-Zero 36" Classic Freezer

Model Color Price
BI36FSPHLH Contact us for best price
Sub-Zero36" Classic Freezer

Add To Compare

Sub-Zero 36" Classic Freezer

Model Color Price
BI36FSPHRH Contact us for best price
Sub-Zero36" Classic Freezer

Add To Compare

Sub-Zero 36" Classic Freezer

Model Color Price
BI36FSTHLH Contact us for best price
Sub-Zero36" Classic Freezer

Add To Compare

Sub-Zero 36" Classic Freezer

Model Color Price
BI36FSTHRH Contact us for best price
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
Liebherr30" Freezer for integrated use with NoFrost

Add To Compare

Liebherr 30" Freezer for integrated use with NoFrost

Model Color Regular Price Savings After Savings
MF3051 $7999.00 $650.00 $7,349.00
Liebherr36" Freezer for integrated use with NoFrost

Add To Compare

Liebherr 36" Freezer for integrated use with NoFrost

Model Color Regular Price Savings After Savings
MF3651 $8589.00 $750.00 $7,839.00
Midea17 Cu. Ft. Convertible Upright Freezer

Add To Compare

Midea 17 Cu. Ft. Convertible Upright Freezer

Model Color Price
WHS625FWEW1 $849.00
Midea21 Cu. Ft. Convertible Upright Freezer

Add To Compare

Midea 21 Cu. Ft. Convertible Upright Freezer

Model Color Price
WHS772FWEW1 $879.00
DanbyDanby Designer 16.7 cu. ft. Upright Freezer

Add To Compare

Danby Danby Designer 16.7 cu. ft. Upright Freezer

Model Color Price
DUF167A4WDD White $1,249.99
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
MieleF 2412 SF - MasterCool&trade; freezer For high-end design and technology on a large scale.

Add To Compare

Miele F 2412 SF - MasterCool™ freezer For high-end design and technology on a large scale.

Model Color Price
F2412SFSTAINLESSSTEELCLEANSTEEL Stainless Steel/cleansteel $7,299.00
MieleF 2412 Vi - MasterCool&trade; freezer For high-end design and technology on a large scale.

Add To Compare

Miele F 2412 Vi - MasterCool™ freezer For high-end design and technology on a large scale.

Model Color Price
F2412VI $6,699.00
MieleF 2472 SF - MasterCool&trade; freezer Integrated IceMaker features separate water and ice dispensers.

Add To Compare

Miele F 2472 SF - MasterCool™ freezer Integrated IceMaker features separate water and ice dispensers.

Model Color Price
F2472SFSTAINLESSSTEELCLEANSTEEL Stainless Steel/cleansteel $7,599.00
MieleF 2672 Vi - MasterCool&trade; freezer Integrated IceMaker features separate water and ice dispensers.

Add To Compare

Miele F 2672 Vi - MasterCool™ freezer Integrated IceMaker features separate water and ice dispensers.

Model Color Price
F2672VI $7,899.00
MieleF 2802 Vi - MasterCool&trade; freezer For high-end design and technology on a large scale.

Add To Compare

Miele F 2802 Vi - MasterCool™ freezer For high-end design and technology on a large scale.

Model Color Price
F2802VI $7,999.00
MieleF 2812 SF - MasterCool&trade; freezer For high-end design and technology on a large scale.

Add To Compare

Miele F 2812 SF - MasterCool™ freezer For high-end design and technology on a large scale.

Model Color Price
F2812SFSTAINLESSSTEELCLEANSTEEL Stainless Steel/cleansteel $8,499.00
MieleF 2812 Vi - MasterCool&trade; freezer For high-end design and technology on a large scale.

Add To Compare

Miele F 2812 Vi - MasterCool™ freezer For high-end design and technology on a large scale.

Model Color Price
F2812VI $7,999.00
MieleF 2902 Vi - MasterCool&trade; freezer For high-end design and technology on a large scale.

Add To Compare

Miele F 2902 Vi - MasterCool™ freezer For high-end design and technology on a large scale.

Model Color Price
F2902VI $8,199.00
MieleF 2912 SF - MasterCool&trade; freezer For high-end design and technology on a large scale.

Add To Compare

Miele F 2912 SF - MasterCool™ freezer For high-end design and technology on a large scale.

Model Color Price
F2912SFSTAINLESSSTEELCLEANSTEEL Stainless Steel/cleansteel $8,599.00
MieleF 2912 Vi - MasterCool&trade; freezer For high-end design and technology on a large scale.

Add To Compare

Miele F 2912 Vi - MasterCool™ freezer For high-end design and technology on a large scale.

Model Color Price
F2912VI $8,199.00
Perlick24" ADA Compliant Freezer

Add To Compare

Perlick 24" ADA Compliant Freezer

Model Color Price
HA24FB41L $3,079.00
Perlick24" ADA Compliant Freezer

Add To Compare

Perlick 24" ADA Compliant Freezer

Model Color Price
HA24FB41R $3,079.00
Perlick24" ADA Compliant Freezer

Add To Compare

Perlick 24" ADA Compliant Freezer

Model Color Price
HA24FB42L $2,945.00
Perlick24" ADA Compliant Freezer

Add To Compare

Perlick 24" ADA Compliant Freezer

Model Color Price
HA24FB42R $2,945.00
Perlick24" ADA Compliant Freezer

Add To Compare

Perlick 24" ADA Compliant Freezer

Model Color Price
HA24FB45 $3,697.00
Perlick24" ADA Compliant Freezer

Add To Compare

Perlick 24" ADA Compliant Freezer

Model Color Price
HA24FB46 $3,563.00
Perlick24" Oudoor Freezer

Add To Compare

Perlick 24" Oudoor Freezer

Model Color Price
HP24FO41L $4,181.00
Perlick24" Oudoor Freezer

Add To Compare

Perlick 24" Oudoor Freezer

Model Color Price
HP24FO41R $4,181.00
Perlick24" Oudoor Freezer

Add To Compare

Perlick 24" Oudoor Freezer

Model Color Price
HP24FO42L $4,047.00
Perlick24" Oudoor Freezer

Add To Compare

Perlick 24" Oudoor Freezer

Model Color Price
HP24FO42R $4,047.00
Perlick24" Oudoor Freezer

Add To Compare

Perlick 24" Oudoor Freezer

Model Color Price
HP24FO45 $4,799.00
Perlick24" Oudoor Freezer

Add To Compare

Perlick 24" Oudoor Freezer

Model Color Price
HP24FO46 $4,665.00
Perlick24" Undercounter Freezer

Add To Compare

Perlick 24" Undercounter Freezer

Model Color Price
HP24FS41L $3,913.00
Perlick24" Undercounter Freezer

Add To Compare

Perlick 24" Undercounter Freezer

Model Color Price
HP24FS41R $3,913.00
Perlick24" Undercounter Freezer

Add To Compare

Perlick 24" Undercounter Freezer

Model Color Price
HP24FS42L $3,780.00
Perlick24" Undercounter Freezer

Add To Compare

Perlick 24" Undercounter Freezer

Model Color Price
HP24FS42R $3,780.00
Perlick24" Undercounter Freezer

Add To Compare

Perlick 24" Undercounter Freezer

Model Color Price
HP24FS45 $4,531.00
Perlick24" Undercounter Freezer

Add To Compare

Perlick 24" Undercounter Freezer

Model Color Price
HP24FS46 $4,398.00
ThermadorBuilt-in Panel Ready Freezer Column 18'' T18ID905LP

Add To Compare

Thermador Built-in Panel Ready Freezer Column 18'' T18ID905LP

Model Color Regular Price Savings After Savings
T18ID905LP $6599.00 $300.00 $6,299.00
ThermadorBuilt-in Panel Ready Freezer Column 18'' T18ID905RP

Add To Compare

Thermador Built-in Panel Ready Freezer Column 18'' T18ID905RP

Model Color Regular Price Savings After Savings
T18ID905RP $6599.00 $300.00 $6,299.00
ThermadorBuilt-in Panel Ready Freezer Column 18'' T18IF905SP

Add To Compare

Thermador Built-in Panel Ready Freezer Column 18'' T18IF905SP

Model Color Regular Price Savings After Savings
T18IF905SP $6049.00 $250.00 $5,799.00
ThermadorBuilt-in Panel Ready Freezer Column 24'' T24ID905LP

Add To Compare

Thermador Built-in Panel Ready Freezer Column 24'' T24ID905LP

Model Color Regular Price Savings After Savings
T24ID905LP $7299.00 $400.00 $6,899.00
ThermadorBuilt-in Panel Ready Freezer Column 24'' T24ID905RP

Add To Compare

Thermador Built-in Panel Ready Freezer Column 24'' T24ID905RP

Model Color Regular Price Savings After Savings
T24ID905RP $7299.00 $400.00 $6,899.00
ThermadorBuilt-in Panel Ready Freezer Column 24'' T24IF905SP

Add To Compare

Thermador Built-in Panel Ready Freezer Column 24'' T24IF905SP

Model Color Regular Price Savings After Savings
T24IF905SP $6599.00 $300.00 $6,299.00
ThermadorBuilt-in Panel Ready Freezer Column 30'' T30IF905SP

Add To Compare

Thermador Built-in Panel Ready Freezer Column 30'' T30IF905SP

Model Color Regular Price Savings After Savings
T30IF905SP $7299.00 $400.00 $6,899.00
ThermadorBuilt-in Panel Ready Freezer Column 36'' T36IF905SP

Add To Compare

Thermador Built-in Panel Ready Freezer Column 36'' T36IF905SP

Model Color Regular Price Savings After Savings
T36IF905SP $8049.00 $450.00 $7,599.00

Page 1 of 1
1

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