Refrigeration - Side by Side 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 = 'side-by-side' 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 5
1234 Last Page >>

Maytag36- Inch Wide Counter Depth Side-by-Side Refrigerator- 21 Cu. Ft.

Add To Compare

Maytag 36- Inch Wide Counter Depth Side-by-Side Refrigerator- 21 Cu. Ft.

Model Color Price
MSC21C6MFZ Fingerprint Resistant Stainless Steel $1,799.00
 energy star appliance Beko36" Side by Side Stainless Steel Refrigerator with Auto Ice and Water Through the Door

Add To Compare

Beko 36" Side by Side Stainless Steel Refrigerator with Auto Ice and Water Through the Door

Model Color Price
BFSB3622SS Fingerprint-free Stainless Steel Contact us for best price
Cafe21.9 Cu. Ft. Counter-Depth Side-By-Side Refrigerator

Add To Compare

Cafe 21.9 Cu. Ft. Counter-Depth Side-By-Side Refrigerator

Model Color Price
CZS22MP2NS1 Stainless Steel $3,099.00
Whirlpool36-inch Wide Counter Depth 4 Door Refrigerator - 19.4 cu. ft.

Add To Compare

Whirlpool 36-inch Wide Counter Depth 4 Door Refrigerator - 19.4 cu. ft.

Model Color Price
WRQA59CNKZ Fingerprint Resistant Metallic Steel $2,199.00
Whirlpool36-inch Wide Counter Depth Side-by-Side Refrigerator - 21 cu. ft.

Add To Compare

Whirlpool 36-inch Wide Counter Depth Side-by-Side Refrigerator - 21 cu. ft.

Model Color Price
WRS571CIHW White $1,699.00
WRS571CIHV Fingerprint Resistant Black Stainless $1,899.00
WRS571CIHZ Fingerprint Resistant Stainless Steel $1799.00 $100.00 1699.00*

*See price in cart

Whirlpool36-inch Wide Side-by-Side Counter Depth Refrigerator - 20 cu. ft.

Add To Compare

Whirlpool 36-inch Wide Side-by-Side Counter Depth Refrigerator - 20 cu. ft.

Model Color Price
WRS970CIHZ Fingerprint Resistant Stainless Steel $2,499.00
Whirlpool36-inch Wide Side-by-Side Counter Depth Refrigerator - 23 cu. ft.

Add To Compare

Whirlpool 36-inch Wide Side-by-Side Counter Depth Refrigerator - 23 cu. ft.

Model Color Price
WRS973CIHV Black Stainless $2,699.00
Whirlpool36-inch Wide Contemporary Handle Counter Depth Side-by-Side Refrigerator - 21 cu. ft. Fingerprint Resistant Sunset Bronze

Add To Compare

Whirlpool 36-inch Wide Contemporary Handle Counter Depth Side-by-Side Refrigerator - 21 cu. ft. Fingerprint Resistant Sunset Bronze

Model Color Price
WRSA71CIHN Fingerprint Resistant Sunset Bronze Contact us for best price
 energy star appliance LG Appliances22 cu.ft. Smart wi-fi Enabled InstaView&trade; Door-in-Door&reg; Counter-Depth Refrigerator

Add To Compare

LG Appliances 22 cu.ft. Smart wi-fi Enabled InstaView™ Door-in-Door® Counter-Depth Refrigerator

Model Color Regular Price Savings After Savings
LSXC22396S Stainless Steel $2529.00 $230.00 $2,299.00
 energy star appliance LG Appliances22 cu. ft. Smart wi-fi Enabled Side-by-Side Counter-Depth Refrigerator

Add To Compare

LG Appliances 22 cu. ft. Smart wi-fi Enabled Side-by-Side Counter-Depth Refrigerator

Model Color Regular Price Savings After Savings
LSXC22426S Stainless Steel $1869.00 $170.00 $1,699.00
LG AppliancesLG SIGNATURE 23 cu. ft. Smart wi-fi Enabled InstaView&trade; Door-in-Door&reg; Counter-Depth Refrigerator

Add To Compare

LG Appliances LG SIGNATURE 23 cu. ft. Smart wi-fi Enabled InstaView™ Door-in-Door® Counter-Depth Refrigerator

Model Color Price
URNTC2306N $8,799.00
LG AppliancesLG SIGNATURE 31 cu. ft. Smart wi-fi Enabled InstaView&trade; Door-in-Door&reg; Refrigerator

Add To Compare

LG Appliances LG SIGNATURE 31 cu. ft. Smart wi-fi Enabled InstaView™ Door-in-Door® Refrigerator

Model Color Regular Price Savings After Savings
URNTS3106N $8799.00 $1,600.00 $7,199.00
 energy star appliance Bosch300 Series Freestanding Counter-Depth Side-by-Side Refrigerator 36'' Easy clean stainless steel B20CS30SNS

Add To Compare

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

Model Color Regular Price Savings After Savings
B20CS30SNS Stainless Steel $2449.00 $250.00 $2,199.00
Frigidaire 22.0 Cu. Ft. Counter-Depth Side-by-Side Refrigerator

Add To Compare

Frigidaire 22.0 Cu. Ft. Counter-Depth Side-by-Side Refrigerator

Model Color Regular Price Savings After Savings
FFSC2323TS Stainless Steel $1699.00 $200.00 $1,499.00
Frigidaire Gallery 22.2 Cu. Ft. Counter-Depth Side-by-Side Refrigerator

Add To Compare

Frigidaire Gallery 22.2 Cu. Ft. Counter-Depth Side-by-Side Refrigerator

Model Color Regular Price Savings After Savings
FGSC2335TF Stainless Steel $1949.00 $250.00 $1,699.00

Page 1 of 5
1234 Last Page >>

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