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

Disposers

Arrange By

Narrow By

Brand

Width

Height

Price

17 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 'UFJC7VJHJE26HSJDYJKTN'	
								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
FFDI501CMS
$99.00
Frigidaire
FFDI331DMS
$109.00
Frigidaire
FFDI331CMS
$119.00
KitchenAid
KCDB250G
$129.00
KitchenAid
KCDI075B
$209.00
KitchenAid
KCDS075T
$279.00
KitchenAid
KCDS100T
$379.00
KitchenAid
KBDS100T
$429.00
Frigidaire
FFDI501DMS
Frigidaire Gallery
FGDI753DMS
Frigidaire Professional
FPDI103DMS
Frigidaire Professional
FPDI758DMS
Whirlpool
GC2000XE
Whirlpool
GC2000PE
Whirlpool
GC1000PE
Whirlpool
GC1000XE
Whirlpool
GC5000XE
Showing All Items For This Category
Catalog Loader
Loading More Items
Back To Top Button

Disposers