Newsflash

We have published new farashe 2011 product pictures to our products page.

  • Finnish (Suomi)
  • English (United Kingdom)
Home Products Tuotteet
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9;10 AND ((`rca_vm_product`.`product_id`=`rca_vm_product_price`.`product_id` AN' at line 3 SQL=SELECT COUNT(DISTINCT `rca_vm_product`.`product_sku`) as num_rows FROM (`rca_vm_product`, `rca_vm_category`, `rca_vm_product_category_xref`,`rca_vm_shopper_group`) LEFT JOIN `rca_vm_product_price` ON `rca_vm_product`.`product_id` = `rca_vm_product_price`.`product_id` WHERE `rca_vm_product_category_xref`.`product_id`=`rca_vm_product`.`product_id` AND `rca_vm_product_category_xref`.`category_id`=`rca_vm_category`.`category_id` AND `rca_vm_product_category_xref`.`category_id`=6;9;10 AND ((`rca_vm_product`.`product_id`=`rca_vm_product_price`.`product_id` AND `rca_vm_shopper_group`.`shopper_group_id`=`rca_vm_product_price`.`shopper_group_id`) OR `rca_vm_product_price`.`product_id` IS NULL) AND `rca_vm_shopper_group`.`default` = 1 AND `product_parent_id`=0 AND `product_publish`='Y' AND `category_publish`='Y'
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9;10 AND ((`rca_vm_product`.`product_id`=`rca_vm_product_price`.`product_id` AN' at line 5 SQL=SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`rca_vm_category`.`category_id`, `rca_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`, `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`rca_vm_product`.`mdate`, `rca_vm_product`.`cdate` FROM (`rca_vm_product`, `rca_vm_category`, `rca_vm_product_category_xref`,`rca_vm_shopper_group`) LEFT JOIN `rca_vm_product_price` ON `rca_vm_product`.`product_id` = `rca_vm_product_price`.`product_id` WHERE `rca_vm_product_category_xref`.`product_id`=`rca_vm_product`.`product_id` AND `rca_vm_product_category_xref`.`category_id`=`rca_vm_category`.`category_id` AND `rca_vm_product_category_xref`.`category_id`=6;9;10 AND ((`rca_vm_product`.`product_id`=`rca_vm_product_price`.`product_id` AND `rca_vm_shopper_group`.`shopper_group_id`=`rca_vm_product_price`.`shopper_group_id`) OR `rca_vm_product_price`.`product_id` IS NULL) AND `rca_vm_shopper_group`.`default` = 1 AND `product_parent_id`=0 AND `product_publish`='Y' AND `category_publish`='Y' GROUP BY `rca_vm_product`.`product_sku` ORDER BY `rca_vm_product`.`product_name` ASC LIMIT 0, 20

Tuotteet

Alla olevat matot ovat aitoa suomalaista käsityötä, jotka ovat saavuttaneet myös kansainvälistä suosiota. Ne ovat helppohoitoisia, laadukkaita ja allergisoimattomia. Materiaali on vesipesun kestävää 100 % puuvillaa (poislukien hirvennahkamatto Taiga). Saatavana useita eri kokoja ja värejä, myös pyöreänä. Kaikki matot sopivat sekä koti- että julkitilojen sisustamiseen.