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

Speakers

Arrange By

Narrow By

Brand

Features

249 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.brand_sku,
									f.brand_u_id,
									f.page,
									f.display_price,
									f.msrp_price,
									f.sale_price,
									f.sale_price_start,
									f.sale_price_end,
									f.screen_size,
									IF(fb.display_title = '', fb.title, fb.display_title) AS b_title, 
									fb.title AS origTitle,
									fc.folder AS c_f,
									fsc.folder AS sc_f,
									'electronics/' AS catalog_folder,
									'electronics' AS rtable
								FROM electronics AS f
								JOIN knorrweb_NEWcatalog.electronics AS mf ON f.u_id = mf.u_id AND mf.expired = 0 AND mf.group_item = 0
								JOIN electronics_brands AS fb ON f.brand_u_id = fb.u_id
								JOIN electronics_categories AS fc ON f.category_u_id = fc.u_id AND fc.active = 1
								JOIN electronics_categories AS fsc ON f.sub_category_u_id = fsc.u_id AND fsc.active = 1 AND fsc.u_id LIKE '7NMRWG2MEFSPYR9VJ1FVZ'		
								WHERE f.active='1' AND f.expired='0'      
								GROUP BY u_id
								ORDER BY available DESC, available DESC, b_title ASC, title ASC
								LIMIT 0, 48
A90
Definitive Technology
a90
Definitive Technology
aw5500
Definitive Technology
aw6500
Definitive Technology
BP-8040ST
Definitive Technology
bp10b
Definitive Technology
bp9020
Definitive Technology
BP9040
Definitive Technology
bp9060
Definitive Technology
bp9080x
Definitive Technology
BP6B
Definitive Technology
cs9040
Definitive Technology
cs9060
Definitive Technology
cs9080
Definitive Technology
Cube
Definitive Technology
DI55bps
Definitive Technology
di5s
Definitive Technology
di6str
Definitive Technology
di65s
Definitive Technology
DI 6.5R
Definitive Technology
DI 8R
Definitive Technology
DI 3.5R
Definitive Technology
DI 5.5LCR
Definitive Technology
DI 4.5R
Definitive Technology
dt6.5lcr
Definitive Technology
dt6.5str
Definitive Technology
dt8lcr
Definitive Technology
Incline
Definitive Technology
IWSUB10
Definitive Technology
IWSub
Definitive Technology
mythosgem
Definitive Technology
mythosgem
Definitive Technology
mythos9
Definitive Technology
mythos7
Definitive Technology
mythos6
Definitive Technology
Mythos ST-L
Definitive Technology
Mythos-st-l
Definitive Technology
mythossts
Definitive Technology
mythos10
Definitive Technology
xtr-20bp
Definitive Technology
XTR-40
Definitive Technology
Mythos XTR-50
Definitive Technology
pc1000
Definitive Technology
pc2000
Definitive Technology
pm1000
Definitive Technology
pm800
Definitive Technology
ps1000
Definitive Technology
prosub800
Definitive Technology
Sound Cylinder
Catalog Loader
Loading More Items
Back To Top Button

Speakers