Park Home - Shop Furniture, Appliances, Mattresses in PA
Park Home Tagline
Phone Icon

Welcome to

Welcome to Park Home


Get updates on our latest styles & savings!

We will never sell your information. Opt-Out anytime. Offer valid for new email addresses only. See store for details.

No Thanks

French Door Refrigerators

Arrange By

Narrow By

Brand

Features

Width

Height

Depth

Collection

Price

202 Items
SELECT f.u_id, 
									f.id,
									IF(f.display_title = '', f.title, f.display_title) AS title, 
									IF(f.retail_sku = '', f.brand_sku, f.retail_sku) AS public_sku, 
									IF(f.on_display = '1', '1', '0') AS available,						
									f.page,
									f.display_price,
									f.msrp_price,
									f.sale_price,
									f.sale_price_start,
									f.sale_price_end,
									IF(ab.display_title = '', ab.title, ab.display_title) AS b_title, 
									ac.folder AS c_f,
									a_sc.folder AS sc_f,								
									'appliances/' AS catalog_folder,
									'appliance' AS rtable
								FROM appliance AS f
								JOIN knorrweb_NEWcatalog.appliance AS ma ON f.u_id = ma.u_id  AND ma.active='1' AND ma.expired='0'
								JOIN appliance_brands AS ab ON f.brand_u_id = ab.u_id
								JOIN appliance_categories AS ac ON f.category_u_id = ac.u_id AND ac.active = 1
								JOIN appliance_categories AS a_sc ON f.sub_category_u_id = a_sc.u_id AND a_sc.active = 1 AND a_sc.u_id LIKE 'VS70M0F001V8X13OFHDJP'	
								WHERE f.active='1' AND f.expired='0' 
								       
								ORDER BY f.display_price = 0.00, display_price ASC, b_title ASC, title ASC
								LIMIT 0, 48
Whirlpool
WRR56X18FW
$764.00
Whirlpool
WRF560SMYW
$1,074.00
Whirlpool
WRF560SMYB
$1,074.00
Whirlpool
WRF535SMBM
$1,198.00
Whirlpool
WRF535SMBB
$1,201.00
Whirlpool
WRF535SMBW
$1,201.00
Maytag
MFF2055FRB
$1,259.00
Maytag
MFF2055FRW
$1,259.00
Amana
AFI2539ERB
$1,298.00
Amana
AFI2539ERW
$1,298.00
LG
LFC22770ST
$1,298.00
Whirlpool
WRF560SEYM
$1,298.00
Frigidaire
FFHB2740PS
$1,299.00
Maytag
MFF2055FRZ
$1,349.00
Whirlpool
WRF560SMYE
$1,349.00
Whirlpool
WRF560SMYH
$1,349.00
Whirlpool
WRF560SMYM
$1,349.00
Whirlpool
WSR57R18DM
$1,394.00
LG
LFC21776ST
$1,398.00
Maytag
MFF2558FEW
$1,439.00
Maytag
MFF2558FEB
$1,439.00
Whirlpool
WRF532SMBB
$1,439.00
Whirlpool
WRF532SMBW
$1,439.00
Frigidaire
FFHB2740PE
$1,498.00
Frigidaire
FFHB2740PP
$1,498.00
LG
LFC24770ST
$1,498.00
Maytag
MFI2570FEZ
$1,498.00
Whirlpool
WRF736SDAM
$1,498.00
LG
LFC22770SW
$1,529.00
LG
LFC22770SB
$1,529.00
Maytag
MFF2258FEZ
$1,529.00
Maytag
MFF2558FEZ
$1,529.00
Whirlpool
WRF560SEYB
$1,529.00
Whirlpool
WRF532SMBM
$1,529.00
Whirlpool
WRF535SWBB
$1,529.00
Whirlpool
WRF535SWBW
$1,529.00
Whirlpool
WRF560SEYW
$1,530.00
Frigidaire
FFHN2740PE
$1,574.00
LG
LFX25974ST
$1,598.00
Whirlpool
WRX735SDBH
$1,598.00
Whirlpool
WRX735SDBM
$1,598.00
Whirlpool
WRX735SDBE
$1,598.00
KitchenAid
KRFF300EBS
$1,618.00
KitchenAid
KRFF302ESS
$1,618.00
LG
LFC24770SB
$1,619.00
LG
LFC24770SW
$1,619.00
Whirlpool
WRF535SWBM
$1,619.00
KitchenAid
KFFS20EYBL
$1,620.00
Catalog Loader
Loading More Items
Back To Top Button

French Door Refrigerators