Refrigeration - Bottom Freezer Refrigerators

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 = 'bottom-freezer' 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
30
Compare Products:
  • Product List View
  • Product Grid View

Page 3 of 4
<< First Page 1234 Last Page >>

 energy star appliance Blomberg24in 13 cuft bottom freezer fridge, stainless steel

Add To Compare

Blomberg 24in 13 cuft bottom freezer fridge, stainless steel

Model Color Price
BRFB1312SS Stainless Steel Contact us for best price
 energy star appliance Blomberg28" Counter Depth Bottom-Freezer Refrigerator

Add To Compare

Blomberg 28" Counter Depth Bottom-Freezer Refrigerator

Model Color Price
BRFB1452SSN Stainless Steel Contact us for best price
 energy star appliance Blomberg27in 15 cuft bottom freezer fridge, stainless steel

Add To Compare

Blomberg 27in 15 cuft bottom freezer fridge, stainless steel

Model Color Price
BRFB1512SS Stainless Steel Contact us for best price
Bosch800 Series Free-standing fridge-freezer with freezer at bottom, glass door 23.5'' Black B10CB81NVB

Add To Compare

Bosch 800 Series Free-standing fridge-freezer with freezer at bottom, glass door 23.5'' Black B10CB81NVB

Model Color Regular Price Savings After Savings
B10CB81NVB Black $2999.00 $300.00 $2,699.00
Bosch800 Series Free-standing fridge-freezer with freezer at bottom, glass door 23.5'' White B10CB81NVW

Add To Compare

Bosch 800 Series Free-standing fridge-freezer with freezer at bottom, glass door 23.5'' White B10CB81NVW

Model Color Regular Price Savings After Savings
B10CB81NVW White $2999.00 $300.00 $2,699.00
 energy star appliance Bosch500 Series, 24" Refrigeration 11 cu ft

Add To Compare

Bosch 500 Series, 24" Refrigeration 11 cu ft

Model Color Regular Price Savings After Savings
B11CB50SSS Stainless Steel $2899.00 $300.00 $2,599.00
 energy star appliance Bosch800 Series, 24" Refrigeration 11 cu ft w/ Ice Maker

Add To Compare

Bosch 800 Series, 24" Refrigeration 11 cu ft w/ Ice Maker

Model Color Regular Price Savings After Savings
B11CB81SSS Stainless Steel $3099.00 $300.00 $2,799.00
Bosch500 Series French Door Bottom Mount Refrigerator 36'' Black stainless steel B36CD50SNB

Add To Compare

Bosch 500 Series French Door Bottom Mount Refrigerator 36'' Black stainless steel B36CD50SNB

Model Color Regular Price Savings After Savings
B36CD50SNB Black Stainless Steel $3449.00 $350.00 $3,099.00
Bosch500 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B36CD50SNS

Add To Compare

Bosch 500 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B36CD50SNS

Model Color Regular Price Savings After Savings
B36CD50SNS Stainless Steel $3299.00 $300.00 $2,999.00
Fisher & PaykelFreestanding Refrigerator Freezer, 25", 13.5 cu ft, Ice

Add To Compare

Fisher & Paykel Freestanding Refrigerator Freezer, 25", 13.5 cu ft, Ice

Model Color Regular Price Savings After Savings
RF135BDLJX4 Stainless Steel $2414.00 $115.00 $2,299.00
Fisher & PaykelFreestanding Refrigerator Freezer, 25", 13.5 cu ft, Ice

Add To Compare

Fisher & Paykel Freestanding Refrigerator Freezer, 25", 13.5 cu ft, Ice

Model Color Regular Price Savings After Savings
RF135BDRJX4 Stainless Steel $2414.00 $115.00 $2,299.00
Fisher & PaykelFreestanding Refrigerator Freezer, 32", 17.1 cu ft, Ice

Add To Compare

Fisher & Paykel Freestanding Refrigerator Freezer, 32", 17.1 cu ft, Ice

Model Color Regular Price Savings After Savings
RF170WDLJX5 Stainless Steel $2729.00 $130.00 $2,599.00
Fisher & PaykelFreestanding Refrigerator Freezer, 32", 17.1 cu ft, Ice

Add To Compare

Fisher & Paykel Freestanding Refrigerator Freezer, 32", 17.1 cu ft, Ice

Model Color Regular Price Savings After Savings
RF170WDRJX5 Stainless Steel $2729.00 $130.00 $2,599.00
Fisher & PaykelFreestanding Refrigerator Freezer, 32", 17.1 cu ft, Ice

Add To Compare

Fisher & Paykel Freestanding Refrigerator Freezer, 32", 17.1 cu ft, Ice

Model Color Regular Price Savings After Savings
RF170WLKJX6 Stainless Steel $3044.00 $145.00 $2,899.00
Fisher & PaykelFreestanding Refrigerator Freezer, 32", 17.5 cu ft, Ice & Water

Add To Compare

Fisher & Paykel Freestanding Refrigerator Freezer, 32", 17.5 cu ft, Ice & Water

Model Color Regular Price Savings After Savings
RF170WLKUX6 Stainless Steel $3149.00 $150.00 $2,999.00
Fisher & PaykelFreestanding Refrigerator Freezer, 32", 17.1 cu ft, Ice

Add To Compare

Fisher & Paykel Freestanding Refrigerator Freezer, 32", 17.1 cu ft, Ice

Model Color Regular Price Savings After Savings
RF170WRKJX6 Stainless Steel $3044.00 $145.00 $2,899.00
Fisher & PaykelFreestanding Refrigerator Freezer, 32", 17.1 cu ft, Ice & Water

Add To Compare

Fisher & Paykel Freestanding Refrigerator Freezer, 32", 17.1 cu ft, Ice & Water

Model Color Regular Price Savings After Savings
RF170WRKUX6 Stainless Steel $3149.00 $150.00 $2,999.00
MieleKF 2801 SF - MasterCool&trade; fridge-freezer with high-quality features and maximum storage space for exacting demands.

Add To Compare

Miele KF 2801 SF - MasterCool™ fridge-freezer with high-quality features and maximum storage space for exacting demands.

Model Color Price
KF2801SFSTAINLESSSTEELCLEANSTEEL Stainless Steel/cleansteel $8,799.00
MieleKF 2802 Vi - MasterCool&trade; fridge-freezer with high-quality features and maximum storage space for exacting demands.

Add To Compare

Miele KF 2802 Vi - MasterCool™ fridge-freezer with high-quality features and maximum storage space for exacting demands.

Model Color Price
KF2802VI $8,199.00
MieleKF 2812 Vi - MasterCool&trade; fridge-freezer with high-quality features and maximum storage space for exacting demands.

Add To Compare

Miele KF 2812 Vi - MasterCool™ fridge-freezer with high-quality features and maximum storage space for exacting demands.

Model Color Price
KF2812VI $8,199.00

Page 3 of 4
<< First Page 1234 Last Page >>

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