icms_db Object ( [conn] => Resource id #7 [res] => [row] => [connected] => 1 [sql] => SELECT SQL_CALC_FOUND_ROWS a.ArticleID,a.ArticleTitle,a.ArticleSum,a.ArticleFull,a.startdt,a.enddt,a.Flags,a.ORD,a.Status,a.Created,a.CreatedBy,a.LastUpdated,a.LastUpdatedBY,a.Hash,a.oldid,a.price,a.priceb2b,a.discount,a.discountb2b,a.final_price,a.final_priceb2b,a.seo_title,a.seo_keywords,a.seo_description FROM icms_articles as a inner join icms_art_cat b on b.ArticleID=a.ArticleID WHERE a.ArticleID > 0 AND b.CategoryID IN (132) AND a.Status IN (4) AND a.Flags='3' AND a.LanguageID='1' group by ArticleID ORDER BY b.ord DESC LIMIT 0,12 )

1. HOME
2. Products
3. Living
4. WALL SYSTEMS
5. SINGLE MODULAR ELEMENTS

WALL SYSTEMS

FILTERS [+]

FILTERS BY

CATEGORY: WALL SYSTEMS

• COMPLETE COMPOSITIONS (100)
• SINGLE MODULAR ELEMENTS (100)

COMPOSITION WIDTH

• From 50cm - 100cm
• From 100cm - 200cm
• From 200cm - 300cm
• From 200cm- 450cm
• More than 450cm

SOFA DEPTH

• From 90 to 94 cm
• From 100cm - 200cm
• From 200cm - 300cm
• From 200cm - 45cm
• More Than 450cm

NUMBER OF SEATER PER SOFA

• 1-Seater Armchair (36)
• 2-Seater Armchair (36)
• 3-Seater Armchair (36)
• 3-Seater Maximum Sofa (134)
• 4-Seater Sofa and more (121)

MATERIAL

• Metal (6)
• Fabric (134)
• Wood
• Leather (50)
• Lacquer (12)
• Plastic Materials (2)
• Eco- Friendly (50)
• Stain-resistant
• Water-resistant

RATE

COLOR

• Black (36)
• Brown (36)
• Beige (36)
• Blue (134)
• Grey (121)
• White (36)
• Red (36)
• Green (36)
• Yellow (134)
• Orange (121)

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

0 ITEMS

SORT BY:

PLEASE SELECT

• PRICE ASCEDING
• PRICE DESCEDING
• NAME ASCEDING
• NAME DESCEDING

PAGE: 0 OF 0

Unfortunately there are no products matching your request.