Plasma Tv Furniture | Plasma TV | Bedroom Furniture | Bedroom Furniture

FREE Shipping LOW Price GuaranteeDetails »Order By Phone 1-888-727-0750

Sat. 7/4 through Sun. 7/5

WEEKEND

Home

Search Results: plasma tv furniture
Plasma TV Furniture now available at Directly Home Furniture with Free Shipping. With the advent of a new generation of home entertainment, plasma television furniture has become an essential part of the living room, familty room, rec room, and bedroom. The need to accommodate larger televisions requires unique furniture that is constructed for functionality and the size of large units. Our interior designers have hand selected a variety of plasma tv furniture to meet this need. Metal and wood tv stands are available here at Directly Home Furniture at the best prices anywhere. Order today to receive Free Shipping on all of our entertainment furniture.

1 to 2 (of 2)

select distinct IF(p.products_date_available>DATE_ADD(NOW(),INTERVAL 21 DAY),2,1) as avail, m.manufacturers_display_name, p.products_image, m.manufacturers_id, p.products_id, p.products_model, pd.products_name, IF(pd.products_short_name is not null, pd.products_short_name, pd.products_name) as products_short_name, pd.products_image_alt_txt, p.products_ordered, pd.products_description, p.products_price, p.products_regular_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_ordered, p.products_date_available, pd.products_image_alt_txt, p.special_price, p.special_price_active, p.special_price_exp, prs.average_rating, prs.full_reviews_count+prs.quick_reviews_count as review_count, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join manufacturers m using(manufacturers_id) left join power_reviews_summary prs on prs.products_id = p.products_id, products_description pd left join specials s on pd.products_id = s.products_id, categories c, categories_description cd, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and cd.categories_id = c.categories_id and c.categories_status = 1 and ((pd.products_name like '%plasma%' or m.manufacturers_name like '%plasma%' or cd.categories_name like '%plasma%') and (pd.products_name like '%tv%' or m.manufacturers_name like '%tv%' or cd.categories_name like '%tv%') ) order by avail, p.products_ordered desc, pd.products_name

Free Shipping

No Sales Tax

30 Day Price Guarantee

Shop By Brand

Shop By Collection