• Home /
  • Search for: refrigerator

Search results for : refrigerator

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 INNER JOIN tbl_fulltextsearch AS fsearch ON (fsearch.SKU = p.SKU ) WHERE (MATCH (full_text_search) AGAINST('+refrigerator*' IN BOOLEAN MODE)) AND mp.Available = 1 AND ((CommonBrandID = 'BOSC')) 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
14
  • Product List View
  • Product Grid View

Page 1 of 1
1

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

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

LED interior lighting, Close the door on warm air., Full width chiller drawer, True counter-depth for a built-in look., Air Circulation Consistency with MultiAirFlow .

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

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

LED interior lighting, Close the door on warm air., Full width chiller drawer, True counter-depth for a built-in look., Air Circulation Consistency with MultiAirFlow .

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

Bosch 500 Series, 24" Refrigeration 11 cu ft

LED interior lighting, Close the door on warm air., True counter-depth for a built-in look., Air Circulation Consistency with MultiAirFlow ., Organized freezer drawers

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

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

LED interior lighting, Close the door on warm air., True counter-depth for a built-in look., Air Circulation Consistency with MultiAirFlow ., Easy to clean stainless steel exterior

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

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

Black stainless steel exterior, True counter-depth for a built-in look., Door ajar notification, Master your day with Home Connect, Air Circulation Consistency with MultiAirFlow .

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
 On Display in Meridian Showroom, Burlington Showroom

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

True counter-depth for a built-in look., Master your day with Home Connect, Air Circulation Consistency with MultiAirFlow ., Easy to clean stainless steel exterior, Fresh with AirFresh® filter

Model Color Regular Price Savings After Savings
B36CD50SNS Stainless Steel $3299.00 $300.00 $2,999.00
Bosch800 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B21CT80SNS

Bosch 800 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B21CT80SNS

LED interior lighting, Easy storage and a clear view., Close the door on warm air., Full width chiller drawer, True counter-depth for a built-in look.

Model Color Price
B21CT80SNS Stainless Steel Contact us for best price
Bosch800 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B36CL80ENS
 On Display in Meridian Showroom, Burlington Showroom

Bosch 800 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B36CL80ENS

Full width chiller drawer, True counter-depth for a built-in look., Dual compressors. Stronger performance., The revolutionary FarmFresh System, Adjustable FlexBar

Model Color Regular Price Savings After Savings
B36CL80ENS Stainless Steel $3749.00 $350.00 $3,399.00
Bosch800 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B36CL80SNS

Bosch 800 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B36CL80SNS

Full width chiller drawer, True counter-depth for a built-in look., Dual compressors. Stronger performance., The revolutionary FarmFresh System, Adjustable FlexBar

Model Color Regular Price Savings After Savings
B36CL80SNS Stainless Steel $3649.00 $350.00 $3,299.00
Bosch800 Series French Door Bottom Mount Refrigerator 36'' Black stainless steel B36CT80SNB

Bosch 800 Series French Door Bottom Mount Refrigerator 36'' Black stainless steel B36CT80SNB

Black stainless steel exterior, Full width chiller drawer, True counter-depth for a built-in look., Dual compressors. Stronger performance., The revolutionary FarmFresh System

Model Color Regular Price Savings After Savings
B36CT80SNB Black Stainless Steel $3549.00 $350.00 $3,199.00
Bosch800 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B36CT80SNS
 On Display in Burlington Showroom

Bosch 800 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B36CT80SNS

The revolutionary FarmFresh System, Dual compressors. Stronger performance., Interior capacity, Full width chiller drawer, Master your day with Home Connect

Model Color Regular Price Savings After Savings
B36CT80SNS Stainless Steel $3449.00 $350.00 $3,099.00
Bosch800 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B36CT81SNS
 On Display in Meridian Showroom

Bosch 800 Series French Door Bottom Mount Refrigerator 36'' Easy clean stainless steel B36CT81SNS

LED interior lighting, Close the door on warm air., Full width chiller drawer, True counter-depth for a built-in look., Door ajar notification

Model Color Regular Price Savings After Savings
B36CT81SNS Stainless Steel $3849.00 $350.00 $3,499.00
 energy star appliance Bosch300 Series Freestanding Counter-Depth Side-by-Side Refrigerator 36'' Easy clean stainless steel B20CS30SNS

Bosch 300 Series Freestanding Counter-Depth Side-by-Side Refrigerator 36'' Easy clean stainless steel B20CS30SNS

ENERGY STAR, LED interior lighting, Close the door on warm air., Air Circulation Consistency with MultiAirFlow ., Protects frozen food from defrosting.

Model Color Regular Price Savings After Savings
B20CS30SNS Stainless Steel $2449.00 $250.00 $2,199.00
 energy star appliance Bosch800 Series French Door Bottom Mount Refrigerator 36'' Stainless Steel, Easy clean stainless steel B26FT50SNS

Bosch 800 Series French Door Bottom Mount Refrigerator 36'' Stainless Steel, Easy clean stainless steel B26FT50SNS

LED interior lighting, Close the door on warm air., Air Circulation Consistency with MultiAirFlow ., Easy to clean stainless steel exterior, Protects frozen food from defrosting.

Model Color Regular Price Savings After Savings
B26FT50SNS Stainless Steel $3099.00 $300.00 $2,799.00

Page 1 of 1
1

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