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

TVs

Arrange By

Narrow By

Brand

TV Type

TV Screen Size

Features

LED Remove Sort Item
39 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 'Z7H65T53RP0D3PPN7C5XN'		
								WHERE f.active='1' AND f.expired='0'      AND (f.type_u_id LIKE '%6OIYR%') 
								GROUP BY u_id
								ORDER BY available DESC, available DESC, b_title ASC, title ASC
								LIMIT 0, 48
LG
22LH4530-P
LG
75UH6550
$2,999.00
LG
24LH4530-P
LG
28LH4530-P
Samsung
UN50J5000AFXZA
Samsung
UN32J5003AFXZA
Samsung
UN28H4000AFXZA
Samsung
UN28H4500AFXZA
Samsung
UN40H5003AFXZA
Samsung
UN40H5203AFXZA
Samsung
UN60H6350AFXZA
Samsung
UN55H8000AFXZA
Samsung
UN50J5200AFXZA
Samsung
UN32J5205AFXZA
Samsung
UN50J520DAFXZA
Samsung
UN32J525DAFXZA
Samsung
UN50J5500AFXZA
Samsung
UN48J550DAFXZA
Samsung
UN65J6200AFXZA
Samsung
UN65J620DAFXZA
Samsung
UN75J6300AFXZA
Samsung
UN75J630DAFXZA
Sony
KDL40R510C
Sony
KDL48W600B
Sony
KDL48R510C
Sony
KDL50W800C
Sony
KDL55W800C
Sony
KDL60W630B/2
$699.99
Showing All Items For This Category
Catalog Loader
Loading More Items
Back To Top Button

TVs