Lugaford Living Room Collection | DH Signature | Bedroom Furniture

FREE Shipping LOW Price GuaranteeDetails »Order By Phone 1-877-898-1086

Mon. 10/6 through Tue. 10/7

TWODAY

Home > Shop By Collection > DH Signature > Lugaford Living Room Collection

Lugaford Living Room Collection by DH Signature

The Lugaford Living Room Collection is an exclusive touch of simplistic brilliance which can be added to any home living room at a great value. The remarkable breadth of relaxation this living room furniture collection can provide will prove to be most rewarding end on the most laborious of days. Choose from a sofa, loveseat, chair, and kick back with the ottoman. This exclusive offering of furniture will not disappoint.

1 to 4 (of 4)

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 m.manufacturers_id = '81' and ((pd.products_name like '%lugaford%' or m.manufacturers_name like '%lugaford%' or cd.categories_name like '%lugaford%') ) order by avail, p.products_ordered desc, pd.products_name

Free Shipping

No Sales Tax

30 Day Price Guarantee

Lugaford Living Room Collection by DH Signature

Shop By Brand

Shop By Collection