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
JVM3160EFES
$178.00
GE
JVM6175DKBB
$198.00
GE
JVM6175DKWW
$198.00
GE
JVM6175EKES
$199.00
GE
JVM6175SKSS
$199.00
GE
JVM6172DKBB
$229.00
GE
JVM6172DKWW
$229.00
GE
JVM7195EKES
$248.00
GE
JVM7195SKSS
$248.00
GE
JNM3163RJSS
$269.00
GE
JVM6172SKSS
$279.00
GE
JBS10DFWW
$298.00
GE
JBS10DFBB
$298.00
GE
JBS10DFCC
$298.00
Amana
AGR4230BAW
$331.00
GE
PVM9005SJSS
$348.00
GE
JGBS10DEKBB
$348.00
GE
JGBS10DEKWW
$348.00
GE
PEM31EFES
$349.00
GE
JVM7195DKBB
$349.00
GE
JVM7195DKWW
$349.00
GE
JB255DJCC
$358.00
GE
JB255DJWW
$358.00
GE
JB250DFBB
$358.00
GE
JB250DFCC
$358.00
GE
JB250DFWW
$358.00
GE
JB255DJBB
$358.00
GE
JNM7196DKWW
$369.00
GE
JNM7196DKBB
$369.00
GE
JNM7196SKSS
$377.00
Frigidaire
FFEF3011LW
$386.00
Frigidaire
FFEF3011LB
$386.00
Amana
ACR2303MFW
$389.00
Amana
AER6303MFB
$398.00
Amana
AER6303MFS
$398.00
Amana
AER6303MFW
$398.00
GE
JGBS60DEKWW
$398.00
GE
JBS60DKWW
$398.00
GE
JBS60DKBB
$398.00
GE
JGBS60DEKCC
$398.00
GE
JGBS60DEKBB
$398.00
Whirlpool
WFC310S0ES
$398.00
Whirlpool
WFE320M0EB
$398.00
Amana
AGR6303MFS
$399.00
Amana
AGR6303MFB
$399.00
Amana
AGR6303MFW
$399.00
Amana
AGR5330BAB
$418.00
Amana
AGR5330BAW
$418.00
Catalog Loader
Loading More Items
Back To Top Button

Ranges