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

Upright Freezers

Arrange By

Narrow By

Brand

Features

Width

Height

Depth

Price

35 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 'Y0I8VRV7NYT8MFVXGD3FK'	
								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
Frigidaire
FFFU06M1TW
$299.00
Frigidaire
FFFU13M1QW
$451.00
Frigidaire
FFFU13M1QW
$451.00
Frigidaire
FFFU14M1QW
$489.00
Frigidaire
FFFU14F2QW
$539.00
GE
FUF14DLRWW
$539.00
Frigidaire
FFFH17F2QW
$547.00
Amana
AZF33X16DW
$553.00
Frigidaire
FFFU17M1QW
$584.00
Frigidaire
FFFU21M1QW
$599.00
Frigidaire
FFFH17F4QW
$604.00
Frigidaire
FFFH20F2QW
$604.00
GE
FUF17DLRWW
$629.00
GE
FUF21DLRWW
$764.00
Whirlpool
WZF79R20DW
$764.00
Frigidaire
FFVU21F4QW
$854.00
Frigidaire
FFFH21F4QT
$854.00
Frigidaire
FFFH17F6QW
$890.00
Frigidaire
FFFH21F6QW
$899.00
Frigidaire
FFFH21F4QW
$899.00
Frigidaire Gallery
FGVU21F8QF
$1,079.00
Frigidaire Gallery
FGVU17F8QF
$1,100.00
Thermador
T18IF800SP
$3,799.00
Thermador
T18ID800LP
$4,399.00
Thermador
T24IF800SP
$4,399.00
Thermador
T24ID800LP
$4,999.00
Thermador
T30IF800SP
$4,999.00
Frigidaire
FFVU17F4QW
Frigidaire
FFFH17F4QT
Thermador
T18ID800RP
Thermador
T24ID800RP
Whirlpool
WZF34X16DW
Whirlpool
WZF56R16DW
Whirlpool
WZF57R16FW
Whirlpool
WZF34X18DW
Showing All Items For This Category
Catalog Loader
Loading More Items
Back To Top Button

Upright Freezers