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

278 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, 15
Bose
Acoustimass300

See in Store

Bose
SoundTouch20Speaker

See in Store

Definitive Technology
dt8lcr

See in Store

Definitive Technology
Mythos ST-L

See in Store

Definitive Technology
Mythos-st-l

See in Store

Definitive Technology
pc1000

See in Store

Paradigm
Millenia 30

See in Store

Paradigm
Monitor SUB 10

See in Store

Paradigm
PW 600

See in Store

Paradigm
PW 800

See in Store

Paradigm
Stylus 470-SM

See in Store

Sonos
2roommusic

See in Store

Sonos
playbar

See in Store

Sub
Sonos
sub

See in Store

Triad
INCEILINGGOLDOMNI

See in Store

Catalog Loader
Loading More Items
Back To Top Button

Speakers