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

Chest Freezers

Arrange By

Narrow By

Brand

Features

Width

Height

Depth

Price

25 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 'H7UZQC6J3F6GDN27PJEYD'	
								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
GE
FCM5SKWW
$189.00
Frigidaire
FFFC05M1TW
$199.00
Frigidaire
FFFC05M1QW
$219.00
Frigidaire
FFFC07M1TW
$229.00
GE
FCM7SKWW
$229.00
Amana
AQC0501DRW
$256.00
Frigidaire
FFFC09M1RW
$269.00
GE
FCM7CKCD
$279.00
GE
FCM11PHWW
$337.00
Frigidaire
FFFC16M5QW
$398.00
Whirlpool
WZC3115DW
$399.00
Frigidaire
FFFC18M4RW
$449.00
Amana
AZC31T15DW
$549.00
Frigidaire
FFFC22M6QW
$599.00
Whirlpool
WZC5422DW
$649.00
Frigidaire
FFFC18M6QW
$701.00
Amana
AQC0701GRW
Amana
AQC0902GRW
Frigidaire
FFFC07M1QW
Frigidaire
FFFC09M1QW
Whirlpool
WZC5415DW
Whirlpool
WSZ57L18DM
Whirlpool
WZC3122DW
Showing All Items For This Category
Catalog Loader
Loading More Items
Back To Top Button

Chest Freezers