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

Collection

Price

682 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
$228.00
GE
JVM6175DKBB
$228.00
GE
JVM6175DKWW
$228.00
GE
JVM6172DKBB
$229.00
GE
JVM6172DKWW
$229.00
GE
JVM6175EKES
$278.00
GE
JVM6175SKSS
$278.00
GE
JVM6172SKSS
$279.00
GE
JVM7195EKES
$348.00
GE
JVM7195SKSS
$348.00
GE
PEM31EFES
$349.00
GE
JVM7195DKCC
$349.00
GE
JVM7195DKWW
$349.00
GE
JVM7195DKBB
$349.00
Whirlpool
WFC310S0EB
$359.00
Whirlpool
WFC310S0EW
$359.00
GE
RB526DHCC
$362.00
GE
RB526DHWW
$362.00
GE
JNM7196DKCC
$369.00
GE
JNM7196DKWW
$369.00
GE
JNM7196DKBB
$369.00
GE
JNM7196SKSS
$377.00
Frigidaire
FFEF3011LW
$386.00
Amana
AGR5330BAW
$387.00
Amana
AGR5330BAB
$387.00
Amana
AGR4230BAB
$387.00
Amana
AGR4230BAW
$387.00
GE
PVM9005SJSS
$398.00
Whirlpool
WFE320M0EW
$400.00
Whirlpool
WFE320M0EB
$400.00
Whirlpool
WFG320M0BW
$400.00
Whirlpool
WFG320M0BB
$400.00
GE
JB250DFBB
$404.00
GE
JB250DFCC
$404.00
GE
JB250DFWW
$404.00
GE
RB720DHWW
$404.00
GE
PVM9005DJWW
$405.00
GE
PVM9215DKBB
$405.00
GE
JB255DJWW
$419.00
GE
JB255DJBB
$419.00
GE
JB255DJCC
$419.00
Whirlpool
WFG320M0BS
$422.00
GE
JBS60DKWW
$448.00
GE
JBS60DKBB
$448.00
Amana
AEP222VAW
$449.00
Frigidaire
FFEF3015PW
$449.00
Frigidaire
FFGF3011LW
$449.00
Frigidaire
FFEF3015PB
$449.00
Catalog Loader
Loading More Items
Back To Top Button

Ranges