Yamazee Living Room Collection by DH Signature

Yamazee SofaThe Yamazee Living Room Furniture Collection will continue to perform with comfort and luxury beyond a reasonable doubt, and is exclusively made available here. High grade stitching and top quality leather and cushioning ensure the ultimate in living room furniture experiences. Astoundingly smooth lines, combined with the finest of furniture materials not found anywhere else, this living room furniture set is sure to satisfy. Manufactured in the USA

Yamazee Chair

Yamazee Chair 
by DH Signature

Price: $999

FREE SHIPPING

Compare

SALE! 5% Off orders over $500

Yamazee Loveseat

Yamazee Loveseat 
by DH Signature

Price: $1,299

FREE SHIPPING

Compare

SALE! 5% Off orders over $500

Yamazee Ottoman

Yamazee Ottoman 
by DH Signature

Price: $699

FREE SHIPPING

Compare

SALE! 5% Off orders over $500

Yamazee Sofa

Yamazee Sofa 
by DH Signature

Price: $1,299

FREE SHIPPING

Compare

SALE! 5% Off orders over $500

  

Price Match Guarantee


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 '%yamazee%' or m.manufacturers_name like '%yamazee%' or cd.categories_name like '%yamazee%') ) order by avail, p.products_ordered desc, pd.products_name