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

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

169,00 €

211,25 €

-20%

ENTREGA 24/48H

  • Envío Express:

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

Envio gratis
3 años de garantia
100 noches de prueba
NULL
array ( 1689199 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', ), 'attributes' => array ( 0 => 559, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\'', ), 1689200 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', ), 'attributes' => array ( 0 => 560, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\'', ), 1689201 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', ), 'attributes' => array ( 0 => 561, ), 'price' => 20.661156999999999328565536416135728359222412109375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\'', ), 1689202 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', ), 'attributes' => array ( 0 => 562, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\'', ), 1689203 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', ), 'attributes' => array ( 0 => 563, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\'', ), 1689204 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', ), 'attributes' => array ( 0 => 564, ), 'price' => 20.661156999999999328565536416135728359222412109375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\'', ), 1689205 => array ( 'attributes_values' => array ( 7 => '100 x 180 cm. ', ), 'attributes' => array ( 0 => 565, ), 'price' => 41.32231399999999865713107283227145671844482421875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'565\'', ), 1689206 => array ( 'attributes_values' => array ( 7 => '100 x 190 cm.', ), 'attributes' => array ( 0 => 566, ), 'price' => 41.32231399999999865713107283227145671844482421875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'566\'', ), 1689207 => array ( 'attributes_values' => array ( 7 => '100 x 200 cm.', ), 'attributes' => array ( 0 => 567, ), 'price' => 51.65289299999999883539203437976539134979248046875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'567\'', ), 1689208 => array ( 'attributes_values' => array ( 7 => '105 x 180 cm. ', ), 'attributes' => array ( 0 => 568, ), 'price' => 30.991735999999999506826497963629662990570068359375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'568\'', ), 1689209 => array ( 'attributes_values' => array ( 7 => '105 x 190 cm.', ), 'attributes' => array ( 0 => 569, ), 'price' => 30.991735999999999506826497963629662990570068359375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'569\'', ), 1689210 => array ( 'attributes_values' => array ( 7 => '105 x 200 cm.', ), 'attributes' => array ( 0 => 570, ), 'price' => 51.65289299999999883539203437976539134979248046875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'570\'', ), 1689211 => array ( 'attributes_values' => array ( 7 => '120 x 180 cm. ', ), 'attributes' => array ( 0 => 571, ), 'price' => 92.9752069999999974925231072120368480682373046875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'571\'', ), 1689212 => array ( 'attributes_values' => array ( 7 => '120 x 190 cm.', ), 'attributes' => array ( 0 => 572, ), 'price' => 92.9752069999999974925231072120368480682373046875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'572\'', ), 1689213 => array ( 'attributes_values' => array ( 7 => '120 x 200 cm. ', ), 'attributes' => array ( 0 => 573, ), 'price' => 113.6363640000000003738023224286735057830810546875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'573\'', ), 1689214 => array ( 'attributes_values' => array ( 7 => '135 x 180 cm.', ), 'attributes' => array ( 0 => 574, ), 'price' => 92.9752069999999974925231072120368480682373046875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'574\'', ), 1689215 => array ( 'attributes_values' => array ( 7 => '135 x 190 cm.', ), 'attributes' => array ( 0 => 575, ), 'price' => 92.9752069999999974925231072120368480682373046875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'575\'', ), 1689216 => array ( 'attributes_values' => array ( 7 => '135 x 200 cm.', ), 'attributes' => array ( 0 => 576, ), 'price' => 113.6363640000000003738023224286735057830810546875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'576\'', ), 1689217 => array ( 'attributes_values' => array ( 7 => '140 x 180 cm.', ), 'attributes' => array ( 0 => 577, ), 'price' => 123.9669420000000030768205760978162288665771484375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'577\'', ), 1689218 => array ( 'attributes_values' => array ( 7 => '140 x 190 cm.', ), 'attributes' => array ( 0 => 578, ), 'price' => 123.9669420000000030768205760978162288665771484375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'578\'', ), 1689219 => array ( 'attributes_values' => array ( 7 => '140 x 200 cm.', ), 'attributes' => array ( 0 => 579, ), 'price' => 144.628098999999991747245076112449169158935546875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'579\'', ), 1689220 => array ( 'attributes_values' => array ( 7 => '150 x 180 cm. ', ), 'attributes' => array ( 0 => 580, ), 'price' => 123.9669420000000030768205760978162288665771484375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'580\'', ), 1689221 => array ( 'attributes_values' => array ( 7 => '150 x 190 cm.', ), 'attributes' => array ( 0 => 581, ), 'price' => 123.9669420000000030768205760978162288665771484375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'581\'', ), 1689222 => array ( 'attributes_values' => array ( 7 => '150 x 200 cm.', ), 'attributes' => array ( 0 => 582, ), 'price' => 144.628098999999991747245076112449169158935546875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'582\'', ), 1689223 => array ( 'attributes_values' => array ( 7 => '160 x 180 cm.', ), 'attributes' => array ( 0 => 583, ), 'price' => 165.289255999999994628524291329085826873779296875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'583\'', ), 1689224 => array ( 'attributes_values' => array ( 7 => '160 x 190 cm.', ), 'attributes' => array ( 0 => 584, ), 'price' => 165.289255999999994628524291329085826873779296875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'584\'', ), 1689225 => array ( 'attributes_values' => array ( 7 => '160 x 200 cm.', ), 'attributes' => array ( 0 => 585, ), 'price' => 196.280991999999997688064468093216419219970703125, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'585\'', ), 1689226 => array ( 'attributes_values' => array ( 7 => '180 x 180 cm.', ), 'attributes' => array ( 0 => 586, ), 'price' => 196.280991999999997688064468093216419219970703125, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'586\'', ), 1689227 => array ( 'attributes_values' => array ( 7 => '180 x 190 cm.', ), 'attributes' => array ( 0 => 587, ), 'price' => 196.280991999999997688064468093216419219970703125, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'587\'', ), 1689228 => array ( 'attributes_values' => array ( 7 => '180 x 200 cm.', ), 'attributes' => array ( 0 => 588, ), 'price' => 227.272727000000003272361936978995800018310546875, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'588\'', ), 1689229 => array ( 'attributes_values' => array ( 7 => '200 x 180 cm. ', ), 'attributes' => array ( 0 => 589, ), 'price' => 278.925619999999980791471898555755615234375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'589\'', ), 1689230 => array ( 'attributes_values' => array ( 7 => '200 x 190 cm.', ), 'attributes' => array ( 0 => 590, ), 'price' => 278.925619999999980791471898555755615234375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'590\'', ), 1689231 => array ( 'attributes_values' => array ( 7 => '200 x 200 cm. ', ), 'attributes' => array ( 0 => 591, ), 'price' => 278.925619999999980791471898555755615234375, 'specific_price' => array ( 'id_specific_price' => '174', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '251', '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.200000', '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' => 'COLV50001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'591\'', ), )

COLCHÓN VISCOELÁSTICO VISCO 5: núcleo compuesto por dos capas, una de 5 cm de Viscoelástica de 55 kg/m³ de densidad unida a otra de 17 cm de Espuma HR BI-FORM de 35 kg/m³ de densidad

VISCOELÁSTICA: Desarrollada por la Nasa para la comodidad del astronauta hoy día la visco se ha convertido en el material más popular para el descanso. Su adaptabilidad y recuperación proporciona confort y relajació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.
Independencia De Pesos

Independencia de pesos.

Independencia de pesos.
indeformable

Indeformable.

Indeformable.
Altura

Altura ± 24 cm

Altura ± 24 cm
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
3 años de garantía

3 Años de garantía

3 Años de garantía
Envío Express Si
Envío Entrega 24/48h
Tipo Viscoelástico
Desenfundable Doble funda
Alto 24 cm (± 2 cm)
Firmeza 75
Adaptabilidad 85
Transpirabilidad 80
  • Almohada Viscoelástica CARBONO ACTIVE , está fabricada con partículas de carbono en su núcleo cuyas propiedades más destacadas son la  disminución de los malos olores  y la humedad, y la  reducción de la electricidad estática corporal,  favoreciendo un sueño mucho más reparador.  DENSIDAD ALTA- PARA PERSONAS QUE LE GUSTA LA FIRMEZA.

    26,00 € 30% 37,14 €
    En stock
  • Cabecero Tapizado   PICASSO   de estilo capitoné, en polipiel de 1ª calidad,  con cuadrantes rectangulares y acolchado con 4  cm   de espuma de densidad 20 kg/m³. Se puede fabricar en cualquier color, con botones tapizados o cristales de Swarovski (efecto diamante). Altura del Cabecero ; 125 cm (modelo desde el suelo).  Grosor :...

    80,10 € 10% 89,00 €
    SOMOS FABRICANTES- PRECIOS CON PORTES E IVA INCLUIDO
  • Canapé Madera Eco gran Capacidad con contorno Polipiel.   Canapé Madera Eco gran Capacidad con contorno Polipiel,  con tapa 3D a juego y contorno en polipiel. Las ventajas de este canapé son: -Máximo almacenaje  (± 26 cm cajón interior). Altura total ± 34 cm. - Modernidad y máxima transpirabilidad. -La tapa cuenta con tejido 3D altamente...

    269,00 € 10% 298,89 €
    SOMOS FABRICANTES- PRECIOS CON PORTES E IVA INCLUIDO
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.

4.7 /5

Basado en 108 opiniones del cliente

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

MARIA M. publicado el 21/10/2019 tras la compra hecha el 30/09/2019

5/5

bueno!

¿Esta opinion le ha parecido util? 0 No 0

ANGEL MIGUEL S. publicado el 21/10/2019 tras la compra hecha el 30/09/2019

5/5

Me ha encantado, la profesionalidad que tienen los comerciales, y los productos son de mucha calidad.

¿Esta opinion le ha parecido util? 0 No 0

ELENA G. publicado el 19/10/2019 tras la compra hecha el 17/09/2019

4/5

Un poco duro

¿Esta opinion le ha parecido util? 0 No 0

Raquel G. publicado el 16/10/2019 tras la compra hecha el 14/09/2019

5/5

2 meses y perfecto! Un pelín duro pero es cuestión de gustos..

¿Esta opinion le ha parecido util? 0 No 0

PEDRO M. publicado el 14/10/2019 tras la compra hecha el 24/09/2019

5/5

Muy buena compra y muy buen servicio. Para repetir.

¿Esta opinion le ha parecido util? 0 No 0

RAMONA MARIA G. publicado el 05/10/2019 tras la compra hecha el 14/09/2019

5/5

lo recomiendo, se adapta muy bien

¿Esta opinion le ha parecido util? 0 No 0

Porfirio S. publicado el 02/10/2019 tras la compra hecha el 23/08/2019

3/5

muy duro

¿Esta opinion le ha parecido util? 0 No 0

WALBERTO V. publicado el 30/09/2019 tras la compra hecha el 09/09/2019

5/5

muy bueno

¿Esta opinion le ha parecido util? 0 No 0

MARIA EVA G. publicado el 27/09/2019 tras la compra hecha el 07/09/2019

5/5

MUY COMODO. DESCANSO COMO UN BEBE. LOS PROBLEMAS DE ESPALDA ME HAN MEJORADO DE MOMENTO.

¿Esta opinion le ha parecido util? 0 No 0

JORGE M. publicado el 23/09/2019 tras la compra hecha el 30/08/2019

5/5

Justo lo que buscaba

¿Esta opinion le ha parecido util? 0 No 0

×