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 (104) 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. BAR

FILTERS [+]

FILTERS BY

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)

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.