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

Page 1 of 1
1

ThermadorBuilt-in Panel Ready Freezer Column 18'' T18ID905LP

Add To Compare

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

Diamond Ice made with twist tray technology provides unique shaped ice, The Thermador Ice and Water in door dispenser with intuitive touch controls, capacitive touch, and stunning lighting makes getting water and ice easier than ever., Filtered Automatic Ice Maker, Cool Air Flow technology evenly distributes cold air throughout all parts of the unit., New All-Leg Leveling can save professionals up to 30 minutes on installation.

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

Diamond Ice made with twist tray technology provides unique shaped ice, The Thermador Ice and Water in door dispenser with intuitive touch controls, capacitive touch, and stunning lighting makes getting water and ice easier than ever., Filtered Automatic Ice Maker, Cool Air Flow technology evenly distributes cold air throughout all parts of the unit., New All-Leg Leveling can save professionals up to 30 minutes on installation.

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

 On Display in Meridian Showroom, Burlington Showroom

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

Diamond Ice made with twist tray technology provides unique shaped ice, Filtered Automatic Ice Maker, Cool Air Flow technology evenly distributes cold air throughout all parts of the unit., New All-Leg Leveling can save professionals up to 30 minutes on installation., SoftClose® door hinges enable ultra-smooth closing.

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

Diamond Ice made with twist tray technology provides unique shaped ice, The Thermador Ice and Water in door dispenser with intuitive touch controls, capacitive touch, and stunning lighting makes getting water and ice easier than ever., Filtered Automatic Ice Maker, Cool Air Flow technology evenly distributes cold air throughout all parts of the unit., SoftClose® door hinges enable ultra-smooth closing.

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

Diamond Ice made with twist tray technology provides unique shaped ice, The Thermador Ice and Water in door dispenser with intuitive touch controls, capacitive touch, and stunning lighting makes getting water and ice easier than ever., Filtered Automatic Ice Maker, Cool Air Flow technology evenly distributes cold air throughout all parts of the unit., New All-Leg Leveling can save professionals up to 30 minutes on installation.

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

 On Display in Meridian Showroom

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

Diamond Ice made with twist tray technology provides unique shaped ice, Filtered Automatic Ice Maker, Cool Air Flow technology evenly distributes cold air throughout all parts of the unit., New All-Leg Leveling can save professionals up to 30 minutes on installation., SoftClose® door hinges enable ultra-smooth closing.

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

Diamond Ice made with twist tray technology provides unique shaped ice, Filtered Automatic Ice Maker, Cool Air Flow technology evenly distributes cold air throughout all parts of the unit., New All-Leg Leveling can save professionals up to 30 minutes on installation., SoftClose® door hinges enable ultra-smooth closing.

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

Diamond Ice made with twist tray technology provides unique shaped ice, Filtered Automatic Ice Maker, Cool Air Flow technology evenly distributes cold air throughout all parts of the unit., New All-Leg Leveling can save professionals up to 30 minutes on installation., SoftClose® door hinges enable ultra-smooth closing.

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.