Rustica Collection by Powell Furniture

Rustica Full Over Twin Bunk Bed W/ Chair The Rustica furniture collection from Powell Furniture brings you distinctive styling in solid pine, reminiscent of Mexican rustic furniture. Featuring antique wrought iron hardware and solid pine construction, all Rustica furniture pieces give you top quality construction at the best price anywhere.

Rustica Full Over Twin Bunk Bed W/ Chair

Rustica Full Over Twin Bunk Bed W/ Chair  
by Powell Furniture

Rating:

Price: $1,699

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