Find a Retailer
Become a Reseller
About Us

Browse By:  Kids | Every Room |

navigation: Home » Other » Modern Collections » Modern Walls
Modern Walls

Modern Walls Collection

More Choices
The products featured below include both the products shown in this photo and coordinating products. 

View Only Products in this Photo
Displaying 1 to 15 (of 57 products) Result Pages:  1  2  3  4  [Next >>] 
1054 - Unknown column 'p.products_sort_orderdesc' in 'order clause'

select p.products_image, p.products_model, p.products_type, p.products_sort_order, p.products_id, p.manufacturers_id, p.products_msrp, p.products_dimensions, p.products_personalized, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_msrp) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '964' order by p.products_sort_orderdesc, pd.products_name limit 0, 15