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

Price

138 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
Maytag
MFF2055FRB
$1,259.00
Whirlpool
WRF560SMYW
$1,259.00
Whirlpool
WRF535SMBM
$1,271.00
Whirlpool
WSR57R18DM
$1,394.00
Frigidaire
FFHB2750TS
$1,413.00
Frigidaire
FFHB2740PS
$1,448.00
Whirlpool
WRF535SMHZ
$1,454.00
Frigidaire
FFHB2740PE
$1,498.00
LG
LFCS22520S
$1,529.00
LG
LFC22770SW
$1,529.00
LG
LFC22770SB
$1,529.00
Maytag
MFF2258FEZ
$1,529.00
Maytag
MFF2558FEZ
$1,529.00
Whirlpool
WRF532SMBB
$1,600.00
LG
LFC22770ST
$1,619.00
LG
LFC24770SB
$1,619.00
LG
LFC24770SW
$1,619.00
Whirlpool
WRF560SEYM
$1,619.00
Frigidaire
FFHN2750TS
$1,664.00
Frigidaire Gallery
FGHF2366PF
$1,699.00
KitchenAid
KRFF300ESS
$1,709.00
LG
LFCS25426D
$1,709.00
LG
LFC24770ST
$1,709.00
Frigidaire Gallery
FGHB2867TD
$1,727.00
Frigidaire Gallery
FGHB2866PF
$1,727.00
Frigidaire Gallery
FGHF2367TD
$1,798.00
Amana
AFI2539ERB
$1,799.00
Amana
AFI2539ERW
$1,799.00
KitchenAid
KRFF302ESS
$1,799.00
KitchenAid
KRFF305ESS
$1,799.00
Maytag
MFI2269FRB
$1,799.00
Maytag
MFI2570FEW
$1,799.00
Whirlpool
WRF555SDFZ
$1,799.00
Frigidaire
FFHN2740PS
$1,850.00
KitchenAid
KRFF302EBS
$1,889.00
KitchenAid
KRFF305EBS
$1,889.00
LG
LFX25974SB
$1,889.00
LG
LFX25974SW
$1,889.00
LG
LFC28768ST
$1,889.00
Maytag
MFC2062FEZ
$1,889.00
Whirlpool
WRF555SDHV
$1,889.00
Frigidaire Gallery
FGHN2866PF
$1,934.00
Frigidaire
FFHG2250TS
$1,949.00
KitchenAid
KRFF300EBS
$1,979.00
KitchenAid
KRFC300ESS
$1,979.00
LG
LFC21776D
$1,979.00
LG
LFX25974ST
$1,980.00
Catalog Loader
Loading More Items
Back To Top Button

French Door Refrigerators