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 3 of 5
<< First Page 1234 Last Page >>

Frigidaire 22.3 Cu. Ft. 33'' Standard Depth Side by Side Refrigerator

Add To Compare

Frigidaire 22.3 Cu. Ft. 33'' Standard Depth Side by Side Refrigerator

Model Color Regular Price Savings After Savings
FRSS2323AB Black $1399.00 $200.00 $1,199.00
FRSS2323AS Stainless Steel $1499.00 $200.00 $1,299.00
FRSS2323AW White $1399.00 $200.00 $1,199.00
Frigidaire 22.3 Cu. Ft. 33'' Standard Depth Side by Side Refrigerator

Add To Compare

Frigidaire 22.3 Cu. Ft. 33'' Standard Depth Side by Side Refrigerator

Model Color Regular Price Savings After Savings
FRSS2333AS Stainless Steel $1599.00 $200.00 $1,399.00
Frigidaire Gallery 22.3 Cu. Ft. 36'' Counter Depth Side by Side Refrigerator

Add To Compare

Frigidaire Gallery 22.3 Cu. Ft. 36'' Counter Depth Side by Side Refrigerator

Model Color Regular Price Savings After Savings
GRSC2352AD Black Stainless Steel $2149.00 $250.00 $1,899.00
Frigidaire Gallery 22.3 Cu. Ft. 33'' Standard Depth Side by Side Refrigerator

Add To Compare

Frigidaire Gallery 22.3 Cu. Ft. 33'' Standard Depth Side by Side Refrigerator

Model Color Regular Price Savings After Savings
GRSS2352AF Stainless Steel $1799.00 $200.00 $1,599.00
Maytag36-Inch Wide Side-by-Side Refrigerator with Exterior Ice and Water Dispenser - 25 Cu. Ft.

Add To Compare

Maytag 36-Inch Wide Side-by-Side Refrigerator with Exterior Ice and Water Dispenser - 25 Cu. Ft.

Model Color Price
MSS25C4MGW White $1,499.00
MSS25C4MGZ Fingerprint Resistant Stainless Steel $1,599.00
Whirlpool33-inch Wide Side-by-Side Refrigerator - 21 cu. ft.

Add To Compare

Whirlpool 33-inch Wide Side-by-Side Refrigerator - 21 cu. ft.

Model Color Price
WRS311SDHB Black $1,199.00
WRS311SDHW White Contact us for best price
WRS311SDHT Biscuit $1,299.00
Whirlpool36-inch Wide Side-by-Side Refrigerator - 24 cu. ft. Black

Add To Compare

Whirlpool 36-inch Wide Side-by-Side Refrigerator - 24 cu. ft. Black

Model Color Price
WRS315SDHB Black Contact us for best price
WRS315SDHM Monochromatic Stainless Steel $1,299.00
WRS315SDHT Biscuit $1,299.00
Whirlpool33-inch Wide Side-by-Side Refrigerator - 21 cu. ft.

Add To Compare

Whirlpool 33-inch Wide Side-by-Side Refrigerator - 21 cu. ft.

Model Color Price
WRS321SDHB Black $1,299.00
WRS321SDHV Black Stainless $1,499.00
WRS321SDHZ Fingerprint Resistant Stainless Steel $1,399.00
Whirlpool36-inch Wide Side-by-Side Refrigerator - 25 cu. ft.

Add To Compare

Whirlpool 36-inch Wide Side-by-Side Refrigerator - 25 cu. ft.

Model Color Price
WRS325SDHW White $1,399.00
WRS325SDHV Black Stainless $1599.00 $160.00 $1,439.00
WRS325SDHZ Fingerprint Resistant Stainless Steel $1499.00 $100.00 1399.00*

*See price in cart

 energy star appliance Whirlpool33-inch Wide Side-by-Side Refrigerator - 21 cu. ft.

Add To Compare

Whirlpool 33-inch Wide Side-by-Side Refrigerator - 21 cu. ft.

Model Color Price
WRS331SDHB Black $1,299.00
WRS331SDHM Monochromatic Stainless Steel $1,399.00
 energy star appliance Whirlpool36-inch Wide Side-by-Side Refrigerator - 25 cu. ft.

Add To Compare

Whirlpool 36-inch Wide Side-by-Side Refrigerator - 25 cu. ft.

Model Color Price
WRS335SDHB Black $1,399.00
WRS335SDHM Monochromatic Stainless Steel $1499.00 $100.00 1399.00*

*See price in cart

Whirlpool36-inch Wide Side-by-Side Refrigerator - 25 cu. ft.

Add To Compare

Whirlpool 36-inch Wide Side-by-Side Refrigerator - 25 cu. ft.

Model Color Price
WRS555SIHW White $1,499.00
WRS555SIHV Black Stainless $1,699.00
WRS555SIHZ Fingerprint Resistant Stainless Steel $1,599.00
 energy star appliance Whirlpool36-inch Wide Side-by-Side Refrigerator with Temperature Control - 26 cu. ft.

Add To Compare

Whirlpool 36-inch Wide Side-by-Side Refrigerator with Temperature Control - 26 cu. ft.

Model Color Price
WRS586FIEM Monochromatic Stainless Steel $1,799.00
Whirlpool36-inch Wide Side-by-Side Refrigerator - 28 cu. ft.

Add To Compare

Whirlpool 36-inch Wide Side-by-Side Refrigerator - 28 cu. ft.

Model Color Price
WRS588FIHW White $1,699.00
WRS588FIHV Fingerprint Resistant Black Stainless $1,899.00
WRS588FIHZ Fingerprint Resistant Stainless Steel $1,799.00
 energy star appliance LG AppliancesSTUDIOLG STUDIO 26 cu. ft. Smart wi-fi Enabled Side-by-Side Refrigerator

Add To Compare

LG Appliances STUDIO LG STUDIO 26 cu. ft. Smart wi-fi Enabled Side-by-Side Refrigerator

Model Color Regular Price Savings After Savings
LSSB2692ST Stainless Steel $9679.00 $2,680.00 $6,999.00

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

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