SELECT * FROM ps_product_attribute pa LEFT JOIN ps_product_attribute_image pai ON (pa.id_product_attribute=pai.id_product_attribute) WHERE pa.id_product_attribute= GROUP BY pa.id_product_attribute

Colchón Viscoelástico VISCO 5 Grafeno

¡Precio rebajado! Colchón Viscoelástico VISCO 5 Grafeno
  • 90% Firmeza
  • 85% Adaptabilidad
  • 90% Transpirabilidad
  • Tipo: Viscoelástico
  • Desenfundable: Doble funda
  • Alto: 23,5 cm (± 2 cm)

239,00 €

398,33 €

-40%

ENTREGA 24/48H

  • Envío Express:

    Compra ahora y en 24 - 48 horas laborables lo recibes en tu casa

  • Envío Especializado

    De 2 a 9 dias laborables con subida a domicilio y opcion de montaje

Envio gratis
3 años de garantia
100 noches de prueba
NULL
array ( 1574036 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', ), 'attributes' => array ( 0 => 559, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574036-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\'', ), 1574037 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', ), 'attributes' => array ( 0 => 560, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574037-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\'', ), 1574038 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', ), 'attributes' => array ( 0 => 561, ), 'price' => 27.550000000000000710542735760100185871124267578125, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574038-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\'', ), 1574039 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', ), 'attributes' => array ( 0 => 562, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574039-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\'', ), 1574040 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', ), 'attributes' => array ( 0 => 563, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 998, 'reference' => '1574040-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\'', ), 1574041 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', ), 'attributes' => array ( 0 => 564, ), 'price' => 27.550000000000000710542735760100185871124267578125, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574041-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\'', ), 1574042 => array ( 'attributes_values' => array ( 7 => '100 x 180 cm. ', ), 'attributes' => array ( 0 => 565, ), 'price' => 55.090000000000003410605131648480892181396484375, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574042-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'565\'', ), 1574043 => array ( 'attributes_values' => array ( 7 => '100 x 190 cm.', ), 'attributes' => array ( 0 => 566, ), 'price' => 55.090000000000003410605131648480892181396484375, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574043-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'566\'', ), 1574044 => array ( 'attributes_values' => array ( 7 => '100 x 200 cm.', ), 'attributes' => array ( 0 => 567, ), 'price' => 68.8700000000000045474735088646411895751953125, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574044-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'567\'', ), 1574045 => array ( 'attributes_values' => array ( 7 => '105 x 180 cm. ', ), 'attributes' => array ( 0 => 568, ), 'price' => 68.8700000000000045474735088646411895751953125, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574045-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'568\'', ), 1574046 => array ( 'attributes_values' => array ( 7 => '105 x 190 cm.', ), 'attributes' => array ( 0 => 569, ), 'price' => 68.8700000000000045474735088646411895751953125, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574046-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'569\'', ), 1574047 => array ( 'attributes_values' => array ( 7 => '105 x 200 cm.', ), 'attributes' => array ( 0 => 570, ), 'price' => 82.6400000000000005684341886080801486968994140625, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 998, 'reference' => '1574047-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'570\'', ), 1574048 => array ( 'attributes_values' => array ( 7 => '120 x 180 cm. ', ), 'attributes' => array ( 0 => 571, ), 'price' => 96.409999999999996589394868351519107818603515625, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 999, 'reference' => '1574048-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'571\'', ), 1574049 => array ( 'attributes_values' => array ( 7 => '120 x 190 cm.', ), 'attributes' => array ( 0 => 572, ), 'price' => 96.409999999999996589394868351519107818603515625, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574049-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'572\'', ), 1574050 => array ( 'attributes_values' => array ( 7 => '120 x 200 cm. ', ), 'attributes' => array ( 0 => 573, ), 'price' => 123.969999999999998863131622783839702606201171875, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574050-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'573\'', ), 1574051 => array ( 'attributes_values' => array ( 7 => '135 x 180 cm.', ), 'attributes' => array ( 0 => 574, ), 'price' => 96.409999999999996589394868351519107818603515625, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 999, 'reference' => '1574051-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'574\'', ), 1574052 => array ( 'attributes_values' => array ( 7 => '135 x 190 cm.', ), 'attributes' => array ( 0 => 575, ), 'price' => 96.409999999999996589394868351519107818603515625, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 998, 'reference' => '1574052-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'575\'', ), 1574053 => array ( 'attributes_values' => array ( 7 => '135 x 200 cm.', ), 'attributes' => array ( 0 => 576, ), 'price' => 123.969999999999998863131622783839702606201171875, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574053-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'576\'', ), 1574054 => array ( 'attributes_values' => array ( 7 => '140 x 180 cm.', ), 'attributes' => array ( 0 => 577, ), 'price' => 123.969999999999998863131622783839702606201171875, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574054-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'577\'', ), 1574055 => array ( 'attributes_values' => array ( 7 => '140 x 190 cm.', ), 'attributes' => array ( 0 => 578, ), 'price' => 123.969999999999998863131622783839702606201171875, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 999, 'reference' => '1574055-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'578\'', ), 1574056 => array ( 'attributes_values' => array ( 7 => '140 x 200 cm.', ), 'attributes' => array ( 0 => 579, ), 'price' => 151.509999999999990905052982270717620849609375, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574056-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'579\'', ), 1574057 => array ( 'attributes_values' => array ( 7 => '150 x 180 cm. ', ), 'attributes' => array ( 0 => 580, ), 'price' => 123.969999999999998863131622783839702606201171875, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574057-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'580\'', ), 1574058 => array ( 'attributes_values' => array ( 7 => '150 x 190 cm.', ), 'attributes' => array ( 0 => 581, ), 'price' => 123.969999999999998863131622783839702606201171875, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 994, 'reference' => '1574058-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'581\'', ), 1574059 => array ( 'attributes_values' => array ( 7 => '150 x 200 cm.', ), 'attributes' => array ( 0 => 582, ), 'price' => 151.509999999999990905052982270717620849609375, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 999, 'reference' => '1574059-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'582\'', ), 1574060 => array ( 'attributes_values' => array ( 7 => '160 x 180 cm.', ), 'attributes' => array ( 0 => 583, ), 'price' => 179.06000000000000227373675443232059478759765625, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574060-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'583\'', ), 1574061 => array ( 'attributes_values' => array ( 7 => '160 x 190 cm.', ), 'attributes' => array ( 0 => 584, ), 'price' => 179.06000000000000227373675443232059478759765625, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574061-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'584\'', ), 1574062 => array ( 'attributes_values' => array ( 7 => '160 x 200 cm.', ), 'attributes' => array ( 0 => 585, ), 'price' => 179.06000000000000227373675443232059478759765625, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574062-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'585\'', ), 1574063 => array ( 'attributes_values' => array ( 7 => '180 x 180 cm.', ), 'attributes' => array ( 0 => 586, ), 'price' => 206.6100000000000136424205265939235687255859375, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574063-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'586\'', ), 1574064 => array ( 'attributes_values' => array ( 7 => '180 x 190 cm.', ), 'attributes' => array ( 0 => 587, ), 'price' => 206.6100000000000136424205265939235687255859375, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574064-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'587\'', ), 1574065 => array ( 'attributes_values' => array ( 7 => '180 x 200 cm.', ), 'attributes' => array ( 0 => 588, ), 'price' => 206.6100000000000136424205265939235687255859375, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 998, 'reference' => '1574065-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'588\'', ), 1574066 => array ( 'attributes_values' => array ( 7 => '200 x 180 cm. ', ), 'attributes' => array ( 0 => 589, ), 'price' => 234.157025000000004411049303598701953887939453125, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574066-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'589\'', ), 1574067 => array ( 'attributes_values' => array ( 7 => '200 x 190 cm.', ), 'attributes' => array ( 0 => 590, ), 'price' => 234.157025000000004411049303598701953887939453125, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 1000, 'reference' => '1574067-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'590\'', ), 1574068 => array ( 'attributes_values' => array ( 7 => '200 x 200 cm. ', ), 'attributes' => array ( 0 => 591, ), 'price' => 234.159999999999996589394868351519107818603515625, 'specific_price' => array ( 'id_specific_price' => '78022', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '895', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.400000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 999, 'reference' => '1574068-COLV5GRAF0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'591\'', ), )

COLCHÓN VISCOELÁSTICO VISCO 5 GRAFENO. La espuma ofrece una conductividad térmica muy superior debido a la combinación de tres materiales de elevado índice de conductividad: células abiertas con gran flujo de aire, espuma CoolFlow y el grafeno de conductividad superior.

VISCOGRAFENO: Es un material con propiedades conductivas que permiten evacuar el calor de una manera efectiva y evita la generación de electricidad estática entre muchas más propiedades.

VISCOGRAFENO

La espuma ofrece una conductividad térmica muy superior debido a la combinación de tres materiales de elevado índice de conductividad:

células abiertas con gran flujo de aire, espuma CoolFlow y el grafeno de conductividad superior.

El resultado es la intensificación del 46% del flujo de calor de una célula regular abierta, presentando 7 veces mejor conductividad térmica que la espuma viscoelástica convencional.

La infusión de grafeno mejora significativamente la transferencia del calor de la espuma cuando está comprimida, dirigiendo a un restricto circuito de flujo de aire, inhibiendo así la transferencia del calor convectivo.

Esto se cumple cuando las partículas de grafeno son fuertemente comprimidas, permitiendo a través de sí, la transferencia del calor en dirección a las zonas no comprimidas de la espuma, donde este puede ser liberado por convección.

Características
Topdormitorios

Fabricación propia Topdormitorios.

Fabricación propia Topdormitorios.
Salud

Okö tex estándar 100: Certificado que indica que nuestras materias primas, y por tanto, nuestros productos, contienen sustancias inócuas para la salud.

Okö tex estándar 100: Certificado que indica que nuestras materias primas, y por tanto, nuestros productos, contienen sustancias inócuas para la salud.
Olores

Sanitized: Certificado que garantiza la absorción de olores del ambientes, tales como el sudor, el tabaco, etc.  Los olores innecesarios son encerrados en unas moléculas con formato de caja. Esta función se va regenerando en el propio tejido. También, gracias a esta funcionalidad, la célula bloquea el proceso nutricional de las bacterias, interrumpiendo así su habilidad para funcionar, crecer y reproducirse.

Sanitized: Certificado que garantiza la absorción de olores del ambientes, tales como el sudor, el tabaco, etc.  Los olores innecesarios son encerrados en unas moléculas con formato de caja. Esta función se va regenerando en el propio tejido. También, gracias a esta funcionalidad, la célula bloquea el proceso nutricional de las bacterias, interrumpiendo así su habilidad para funcionar, crecer y reproducirse.
Medio Ambiente

Certipur: Garantiza la seguridad, salubridad y respeto al medio ambiente de las espumas utilizadas para la fabricación de nuestros colchones.

Certipur: Garantiza la seguridad, salubridad y respeto al medio ambiente de las espumas utilizadas para la fabricación de nuestros colchones.
Transpiración

Certificado que garantiza que la viscoelástica es de estructura celular abierta, que permite una mejor transpiración, siendo la utilizada por TOPDORMITORIOS en sus colchones viscoelásticos.

Certificado que garantiza que la viscoelástica es de estructura celular abierta, que permite una mejor transpiración, siendo la utilizada por TOPDORMITORIOS en sus colchones viscoelásticos.
Atérmico

Atérmico.

Atérmico.
Tratamiento higiene

Ultimate Freshness. Tratamiento integral anti-bacterias, anti-moho y antiácaros, aloe vera, propiedades naturales del ALOE VERA, muy rica en nutrientes para nuestro organismo.

Ultimate Freshness. Tratamiento integral anti-bacterias, anti-moho y antiácaros, aloe vera, propiedades naturales del ALOE VERA, muy rica en nutrientes para nuestro organismo.
Calidad

Certificado de calidad de TOPDORMITORIOS.Garantizamos la calidad en todos nuestros productos. Nuestras materias primas son de muy buena calidad y de carácter nacional. En todos nuestros productos damos  100 días de prueba, para que pueda ver la calidad de primera mano. A mismo tiempo, llamando a nuestros clientes unos días después de recibir el producto para que le ha parecido y ver que ha llegado en buen estado.

Certificado de calidad de TOPDORMITORIOS.Garantizamos la calidad en todos nuestros productos. Nuestras materias primas son de muy buena calidad y de carácter nacional. En todos nuestros productos damos  100 días de prueba, para  que pueda ver la calidad  de primera mano. A mismo tiempo, llamando a nuestros clientes unos días después de recibir el producto para que le ha parecido y ver que ha llegado en buen estado.
Desenfundable

Desenfundable. Al contrario de un colchón empotrado donde no se puede apreciar lo que tiene dentro, nuestros colchones de gama alta son desenfudables para que pueda apreciar la calidad y para un fácil la lavado.

Desenfundable. Al contrario de un colchón empotrado donde no se puede apreciar lo que tiene dentro, nuestros colchones de gama alta son desenfudables para que pueda apreciar la calidad y para un fácil la lavado.
Garantía 4 Años

Garantía 4 años.

Garantía 4 años.
Independencia De Pesos

Independencia de pesos.

Independencia de pesos.
indeformable

Indeformable.

Indeformable.
Núcleo

17 cm HR Bi-Form de 35 kg/m³

17 cm HR Bi-Form de 35 kg/m³
Firmeza: media / alta

Firmeza media / alta. Confort Supreme

Firmeza media / alta. Confort Supreme
5 cm de Visco

5 cm de viscoelástica

5 cm de viscoelástica
5 cm de viscoelástica Aloe Vera

5 cm de viscoelástica perfilada Aloe Vera

5 cm de viscoelástica perfilada Aloe Vera
Envío Express Si
Envío Entrega 24/48h
Envío Especializado Si
Tipo Viscoelástico
Desenfundable Doble funda
Alto 23,5 cm (± 2 cm)
Firmeza 90
Adaptabilidad 85
Transpirabilidad 90
Ver el certificado de confianza
  • Para mas informacion sobre las caracteristicas del control de opiniones, y la posibilidad de contactar el autor de la opinion, por favor consulte nuestras CGU.
  • Ningun descuento ni puntos de fidelidad han sido ofrecidos a cambio de estas opiniones
  • Las opiniones son publicadas y conservadas durante un periodo de cinco año
  • Las opiniones no pueden ser modificadas: si un cliente desea modificar su opinion entonces debe contactar con Opiniones Verficadas para pedir la supresion de la opinion y publicar una nueva
  • Los motivos de la supresion de las opiniones estan disponibles aqui.

5 /5

Basado en 2 opiniones del cliente

  • 1
    0
  • 2
    0
  • 3
    0
  • 4
    0
  • 5
    2
Ordenar opiniones por :

Norma P. publicado el 19/09/2019 tras la compra hecha el 19/08/2019

5/5

buena calidad

¿Esta opinion le ha parecido util? 0 No 0

José Francisco J. publicado el 01/09/2019 tras la compra hecha el 22/08/2019

5/5

Un 10. Muestras espaldas lo ha agregdecido.

¿Esta opinion le ha parecido util? 0 No 0

×