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

Ranges

Arrange By

Narrow By

Brand

Features

Width

Height

Depth

Price

574 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 'DX6LI03IW10V4RAM57N34'	
								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
JVM6172DKBB
$215.00
GE
JVM6172DKWW
$215.00
GE
JVM3160EFES
$228.00
GE
JVM6175DKBB
$251.00
GE
JVM6175DKWW
$251.00
GE
JVM6172SKSS
$260.00
GE
JVM7195EKES
$269.00
GE
JVM7195SKSS
$269.00
GE
JVM6175SKSS
$279.00
GE
JVM6175EKES
$296.00
GE
PEM31EFES
$314.00
GE
JVM7195DKBB
$314.00
GE
JVM7195DKWW
$314.00
GE
JNM7196DKWW
$332.00
GE
JNM7196DKBB
$332.00
GE
JGBS10DEKBB
$359.00
GE
JGBS10DEKWW
$359.00
GE
JNM7196SKSS
$377.00
Amana
ACR4503SFW
$387.00
Amana
ACR4503SFB
$387.00
Frigidaire
FFEF3012TW
$387.00
Frigidaire
FFEF3012TB
$387.00
Amana
ACR2303MFW
$389.00
Frigidaire
FFGF3011LW
$397.00
Whirlpool
WFE320M0EB
$400.00
GE
JB250DFWW
$404.00
GE
JB250DFBB
$404.00
GE
JB250DFCC
$404.00
GE
JB255DJBB
$419.00
GE
JB255DJCC
$419.00
GE
JB255DJWW
$419.00
Amana
AGR5330BAB
$428.00
Amana
AGR5330BAS
$428.00
Amana
AGR5330BAW
$428.00
Amana
AER6303MFS
$428.00
Amana
AER6303MFW
$428.00
Amana
AER6303MFB
$428.00
Whirlpool
WFG320M0BS
$428.00
Amana
AGR4230BAB
$429.00
Amana
AGR4230BAW
$429.00
Whirlpool
WFC310S0ES
$431.00
Amana
AEP222VAW
$449.00
Frigidaire
FFEF3015PW
$449.00
Frigidaire
FFEF3015PB
$449.00
GE
PVM9005SJSS
$449.00
GE
PVM9215SKSS
$449.00
GE
PVM9005EJES
$449.00
GE
PNM9216SKSS
$467.00
Catalog Loader
Loading More Items
Back To Top Button

Ranges

Get Advice from Our Experts
(814) 695-9500

Our experts are here to help!
(814) 643-1460

Our experts are here to help!
Email Us