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

204 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
Definitive Technology
BP-8040ST
Definitive Technology
Cube
Definitive Technology
DI 3.5R
Definitive Technology
DI 5.5LCR
Definitive Technology
DI 4.5R
Definitive Technology
DI 6.5R
Definitive Technology
DI 8R
Definitive Technology
Incline
Definitive Technology
Mythos ST-L
Definitive Technology
Mythos XTR-50
Definitive Technology
Sound Cylinder
Definitive Technology
Studio Monitor 45
Definitive Technology
StudioMonitor 55
Definitive Technology
StudioMonitor 65
Definitive Technology
SuperCube2000
Definitive Technology
SuperCube4000
Definitive Technology
SuperCube6000
Denon
heos1
Denon
heos1go
Denon
heos3
Denon
heos5
Denon
heos7
Denon
heosextend
Denon
heoshome
LG
PBS-C510 Silver
Paradigm
A2 Stand
Paradigm
Atom Monitor v7
Paradigm
BD1 Bluetooth Receiver
Paradigm
CI Elite E65-R
Paradigm
CI Elite E80-A
Paradigm
CI Elite E80-IW
Catalog Loader
Loading More Items
Back To Top Button

Speakers