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

A/V Receivers

Arrange By

Narrow By

Brand

Features

57 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 '2K9742ZXBA8W5EV4BXIAI'		
								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
Denon
S510BT
Denon
S530BT
Denon
S730H
Denon
S930H
Denon
X1300W
Denon
X1400H
Denon
X2300W
Denon
X2400H
Denon
X3300W
Denon
X4300H
Denon
X6300H
Denon
HEOSAVR
Sony
STRDH130
Sony
STRDH550
Sony
STRDH550
Sony
STRDN1070
Sony
STRZA1000ES
Sony
STRDN860
Sony
STRDN840
Sony
STRZA2000ES
Sony
STRDH770
Sony
STRDH770
Sony
STRDN850
Sony
STRZA3000ES
Sony
STRDN1080
Sony
STRDN1060
Sony
STRDN1060
Sony
STRDN1050
Sony
STRDN1070
Sony
STRDH750
Sony
STRDH750
Sony
STRZA1100ES
Sony
STRZA1100ES
Sony
STRZA3100ES
Sony
STRZA810ES
Sony
STRZA810ES
Sony
STRZA2100ES
Sony
STRZA2100ES
Sony
STRZA5000ES
Yamaha
CRX-N560
Yamaha
CX-A5100
Yamaha
MX-A5000
Yamaha
RX-A1060
Yamaha
RX-A1070
Yamaha
RX-A2060
Yamaha
RX-A2070
Catalog Loader
Loading More Items
Back To Top Button

A/V Receivers