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

167 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'      
								GROUP BY u_id
								ORDER BY available DESC, available DESC, b_title ASC, title ASC
								LIMIT 0, 15
LG
43LH5000

See in Store

LG
43LH5700

See in Store

LG
43UJ6300

See in Store

LG
43UH6100

See in Store

LG
55UJ7700
$799.00

See in Store

LG
55UJ7700
$799.00

See in Store

LG
60UJ7700
$999.00

See in Store

LG
65UJ6300
$799.00

See in Store

LG
75UH6550

See in Store

LG
49UH6030

See in Store

LG
OLED55C7P
$1,699.00

See in Store

LG
OLED65C7P

See in Store

LG
32LJ500B

See in Store

LG
32LH500B

See in Store

LG
55UH7700

See in Store

Catalog Loader
Loading More Items
Back To Top Button

TVs

Get Advice from Our Experts
(814) 695-9500

Our experts are here to help!Email Us