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

Bottom-Freezer Refrigerators

Arrange By

Narrow By

Brand

Features

Width

Height

Depth

Price

81 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 'VVYFW3P494BTFPQ7IYE8D'	
								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
LG
LBN10551PS
$699.00
Amana
ABB1921BRB
$746.00
Amana
ABB1921BRW
$746.00
Amana
ABB1921BRM
$835.00
GE
GBE21DGKBB
$989.00
GE
GBE21DGKWW
$989.00

See in Store

Whirlpool
WRB119WFBM
$1,021.00
GE
GBE21DSKSS
$1,079.00
LG
LDCS24223S
$1,148.00
Maytag
MBF1958FEW
$1,169.00
Maytag
MBF2258FEW
$1,169.00

See in Store

Amana
ABB1924BRW
$1,199.00
Amana
ABB1924BRB
$1,199.00
Amana
ABB2224BRW
$1,199.00
Amana
ABB2224BRB
$1,199.00
LG
LDCS22220W
$1,259.00
Whirlpool
WRB329DMBM
$1,259.00
GE
GNE25JSKSS
$1,298.00
GE
GNE25JMKES
$1,298.00
Amana
ABB1924BRM
$1,299.00
Amana
ABB2224BRM
$1,299.00
GE
GNE25JGKBB
$1,349.00
GE
GNE25JGKWW
$1,349.00
LG
LDCS22220S
$1,349.00
LG
LDCS24223W
$1,349.00

See in Store

GE
GDE21EGKWW
$1,394.00

See in Store

GE
GNE21FMKES
$1,439.00
GE
GNE21FSKSS
$1,439.00
GE
GDE21ESKSS
$1,484.00
GE
GDE21EMKES
$1,484.00
KitchenAid
KRBR109ESS
$1,529.00
KitchenAid
KRBX109EWH
$1,529.00
KitchenAid
KRBL109ESS
$1,529.00
KitchenAid
KRBR102ESS
$1,529.00
KitchenAid
KRBL102ESS
$1,529.00
GE
GDE21EGKBB
$1,549.00
GE
GDE25ESKSS
$1,574.00
GE
GNE29GGKBB
$1,709.00
GE
GNE29GGKWW
$1,709.00
GE
GFE24JMKES
$1,798.00
GE
GFE24JSKSS
$1,798.00

See in Store

GE
GNE29GMKES
$1,799.00
GE
GNE29GSKSS
$1,799.00
GE
GFE26GGKBB
$1,889.00
GE
GFE26GGKWW
$1,889.00
Amana
AFI2539ERM
$1,899.00
Maytag
URB551WNGZ
$1,899.00
GE
GFE26GMKES
$1,979.00
Catalog Loader
Loading More Items
Back To Top Button

Bottom-Freezer Refrigerators