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 PREMIUM PLUS

¡Precio rebajado! Colchón Viscoelástico PREMIUM PLUS
  • 80% Firmeza
  • 100% Adaptabilidad
  • 100% Transpirabilidad
  • Tipo: Viscoelástico
  • Desenfundable: Doble funda
  • Alto: 26 cm (± 1 cm)

299,00 €

498,33 €

-40%

ENTREGA 24/48H

  • Envío Express:

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

Envio gratis
10 Años de Garantia
100 noches de prueba
NULL
array ( 1591729 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', ), 'attributes' => array ( 0 => 559, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591729-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\'', ), 1591730 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', ), 'attributes' => array ( 0 => 560, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591730-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\'', ), 1591731 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', ), 'attributes' => array ( 0 => 561, ), 'price' => 27.545455000000000467252903035841882228851318359375, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591731-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\'', ), 1591732 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', ), 'attributes' => array ( 0 => 562, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591732-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\'', ), 1591733 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', ), 'attributes' => array ( 0 => 563, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9998, 'reference' => '1591733-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\'', ), 1591734 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', ), 'attributes' => array ( 0 => 564, ), 'price' => 27.545455000000000467252903035841882228851318359375, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9997, 'reference' => '1591734-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\'', ), 1591735 => array ( 'attributes_values' => array ( 7 => '100 x 180 cm. ', ), 'attributes' => array ( 0 => 565, ), 'price' => 68.8677689999999955716702970676124095916748046875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591735-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'565\'', ), 1591736 => array ( 'attributes_values' => array ( 7 => '100 x 190 cm.', ), 'attributes' => array ( 0 => 566, ), 'price' => 68.8677689999999955716702970676124095916748046875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591736-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'566\'', ), 1591737 => array ( 'attributes_values' => array ( 7 => '100 x 200 cm.', ), 'attributes' => array ( 0 => 567, ), 'price' => 68.8677689999999955716702970676124095916748046875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591737-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'567\'', ), 1591738 => array ( 'attributes_values' => array ( 7 => '105 x 180 cm. ', ), 'attributes' => array ( 0 => 568, ), 'price' => 68.8677689999999955716702970676124095916748046875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591738-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'568\'', ), 1591739 => array ( 'attributes_values' => array ( 7 => '105 x 190 cm.', ), 'attributes' => array ( 0 => 569, ), 'price' => 68.8677689999999955716702970676124095916748046875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9999, 'reference' => '1591739-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'569\'', ), 1591740 => array ( 'attributes_values' => array ( 7 => '105 x 200 cm.', ), 'attributes' => array ( 0 => 570, ), 'price' => 68.8677689999999955716702970676124095916748046875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9996, 'reference' => '1591740-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'570\'', ), 1591741 => array ( 'attributes_values' => array ( 7 => '120 x 180 cm. ', ), 'attributes' => array ( 0 => 571, ), 'price' => 165.289255999999994628524291329085826873779296875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591741-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'571\'', ), 1591742 => array ( 'attributes_values' => array ( 7 => '120 x 190 cm.', ), 'attributes' => array ( 0 => 572, ), 'price' => 165.289255999999994628524291329085826873779296875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591742-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'572\'', ), 1591743 => array ( 'attributes_values' => array ( 7 => '120 x 200 cm. ', ), 'attributes' => array ( 0 => 573, ), 'price' => 192.834710999999998648490873165428638458251953125, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591743-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'573\'', ), 1591744 => array ( 'attributes_values' => array ( 7 => '135 x 180 cm.', ), 'attributes' => array ( 0 => 574, ), 'price' => 165.289255999999994628524291329085826873779296875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9999, 'reference' => '1591744-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'574\'', ), 1591745 => array ( 'attributes_values' => array ( 7 => '135 x 190 cm.', ), 'attributes' => array ( 0 => 575, ), 'price' => 165.289255999999994628524291329085826873779296875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9996, 'reference' => '1591745-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'575\'', ), 1591746 => array ( 'attributes_values' => array ( 7 => '135 x 200 cm.', ), 'attributes' => array ( 0 => 576, ), 'price' => 192.834710999999998648490873165428638458251953125, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591746-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'576\'', ), 1591747 => array ( 'attributes_values' => array ( 7 => '140 x 180 cm.', ), 'attributes' => array ( 0 => 577, ), 'price' => 261.70247899999998253406374715268611907958984375, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591747-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'577\'', ), 1591748 => array ( 'attributes_values' => array ( 7 => '140 x 190 cm.', ), 'attributes' => array ( 0 => 578, ), 'price' => 261.70247899999998253406374715268611907958984375, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9999, 'reference' => '1591748-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'578\'', ), 1591749 => array ( 'attributes_values' => array ( 7 => '140 x 200 cm.', ), 'attributes' => array ( 0 => 579, ), 'price' => 275.47933899999998175189830362796783447265625, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591749-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'579\'', ), 1591750 => array ( 'attributes_values' => array ( 7 => '150 x 180 cm. ', ), 'attributes' => array ( 0 => 580, ), 'price' => 261.70247899999998253406374715268611907958984375, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591750-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'580\'', ), 1591751 => array ( 'attributes_values' => array ( 7 => '150 x 190 cm.', ), 'attributes' => array ( 0 => 581, ), 'price' => 261.70247899999998253406374715268611907958984375, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9991, 'reference' => '1591751-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'581\'', ), 1591752 => array ( 'attributes_values' => array ( 7 => '150 x 200 cm.', ), 'attributes' => array ( 0 => 582, ), 'price' => 275.47933899999998175189830362796783447265625, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9995, 'reference' => '1591752-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'582\'', ), 1591753 => array ( 'attributes_values' => array ( 7 => '160 x 180 cm.', ), 'attributes' => array ( 0 => 583, ), 'price' => 303.02479299999998829662217758595943450927734375, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591753-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'583\'', ), 1591754 => array ( 'attributes_values' => array ( 7 => '160 x 190 cm.', ), 'attributes' => array ( 0 => 584, ), 'price' => 303.02479299999998829662217758595943450927734375, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9999, 'reference' => '1591754-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'584\'', ), 1591755 => array ( 'attributes_values' => array ( 7 => '160 x 200 cm.', ), 'attributes' => array ( 0 => 585, ), 'price' => 330.54545500000000401996658183634281158447265625, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9999, 'reference' => '1591755-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'585\'', ), 1591756 => array ( 'attributes_values' => array ( 7 => '180 x 180 cm.', ), 'attributes' => array ( 0 => 586, ), 'price' => 385.644628000000011525116860866546630859375, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591756-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'586\'', ), 1591757 => array ( 'attributes_values' => array ( 7 => '180 x 190 cm.', ), 'attributes' => array ( 0 => 587, ), 'price' => 385.644628000000011525116860866546630859375, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591757-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'587\'', ), 1591758 => array ( 'attributes_values' => array ( 7 => '180 x 200 cm.', ), 'attributes' => array ( 0 => 588, ), 'price' => 399.44628099999999903957359492778778076171875, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9998, 'reference' => '1591758-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'588\'', ), 1591759 => array ( 'attributes_values' => array ( 7 => '200 x 180 cm. ', ), 'attributes' => array ( 0 => 589, ), 'price' => 440.76859500000000480213202536106109619140625, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591759-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'589\'', ), 1591760 => array ( 'attributes_values' => array ( 7 => '200 x 190 cm.', ), 'attributes' => array ( 0 => 590, ), 'price' => 440.76859500000000480213202536106109619140625, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 9999, 'reference' => '1591760-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'590\'', ), 1591761 => array ( 'attributes_values' => array ( 7 => '200 x 200 cm. ', ), 'attributes' => array ( 0 => 591, ), 'price' => 440.76859500000000480213202536106109619140625, 'specific_price' => array ( 'id_specific_price' => '177', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '250', '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' => 10000, 'reference' => '1591761-COLVPP0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'591\'', ), )

Colchón Viscoelático PREMIUM PLUS; destaca por la Eficiencia de su núcleo, compuesto por tres capas, 7 cm de Viscoelástica de 65 kg/m³ de densidad perforado, unidos a 1,5 cm de Dry-Feel (que genera canales de aireación), complementados con 17 cm de Espuma HR BI-FORM de 40 kg/m³ de densidad. Desenfundable funda interior y funda exterior.

DRY-FEEL: Es un material innovador que ubicado entre la viscoelástica y el núcleo HR, con el fin de otorgar al colchón de mayor aireación previniendo el calor.

Características
Topdormitorios

Fabricación propia Topdormitorios.

Fabricación propia Topdormitorios.
Adaptación

Máxima adaptación al cuerpo, eliminando puntos de presión en zona lumbar.

Máxima adaptación al cuerpo, eliminando puntos de presión en zona lumbar.
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.
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.
Firmeza

Firmeza: alta

Firmeza: alta
Independencia De Pesos

Independencia de pesos.

Independencia de pesos.
Platabanda Acolchada

Platabanda acolchada con tejido velour con válvulas de aireación y asas tejidas manualmente.

Platabanda acolchada con tejido velour con válvulas de aireación y asas tejidas manualmente.
indeformable

Indeformable.

Indeformable.
Núcleo Hr Bi-Form

16 cm HR Bi-Form de 40 kg/m³

16 cm HR Bi-Form de 40 kg/m³
Viscoelástica Colchones

La principal característica de los colchones de la viscoelástica es su adaptabilidad a las formas del cuello, eliminando presiones y problemas cervicales. Tejido transpirable y elástico que facilita los movimientos en el descanso.

La principal característica de los colchones de la viscoelástica es su adaptabilidad a las formas del cuello, eliminando presiones y problemas cervicales. Tejido transpirable y elástico que facilita los movimientos en el descanso.
Altura

Altura ± 26 cm

Altura ± 26 cm
7 cm De Viscoelástica

7 cm de viscoelástica de alta densidad 65 kg/m³

7 cm de viscoelástica de alta densidad 65 kg/m³
7 cm De Viscoelástica

7 cm de viscoelástica de alta densidad 65 kg/m3

7 cm de viscoelástica de alta densidad 65 kg/m3
Dry-feel

1,5 Cm DRY-FEEL, genera canales de aireación para máxima transpiración.

1,5 Cm DRY-FEEL, genera canales de aireación para máxima transpiración.
Garantía 10 Años

Garantía 10 Años.

Garantía 10 Años.
Envío Express Si
Envío Entrega 24/48h
Tipo Viscoelástico
Desenfundable Doble funda
Alto 26 cm (± 1 cm)
Firmeza 80
Adaptabilidad 100
Transpirabilidad 100
Garantía 10
  • Almohada Viscoelástica , con  núcleo de viscoelástica de 65 kg/m³  de alta calidad,  funda exterior en  tejido Strech. Máxima adaptabilidad y confort. Almohada Viscoelástica de tacto suave y mullido, sensación de ingravidez. Medidas; 14 cm (alto) x 37 cm (ancho ) LA ALMOHADA TOP-VENTAS, POR SU RELACIÓN CALIDAD-PRECIO

    24,00 € 20% 30,00 €
    En stock
  • Colchón Viscoelático PREMIUM 6: Núcleo compuesto por una capa de  6 cm de Viscoelástica de 65 kg/m³ de densidad +  17 cm de HR BI-FORM de 35 kg/m³ de densidad . Desenfundable funda interior y funda exterior. 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...

    199,00 € 30% 284,29 €
    En stock
  • Canapé  Gran Capacidad (Top Ventas) opción contorno polipiel a juego. Máximo almacenaje (± 29 cm cajón interior). En TopDormitorios puede personalizar en  POLIPIEL, TELA O TERCIOPELO  con  44 colores a elegir . Altura total ± 36 cm. Estructura súper-reforzada en cajón y tapa. Va depositado al suelo directamente con goma perimetral para...

    247,00 € 30% 352,86 €
    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.9 /5

Basado en 31 opiniones del cliente

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

ISAIAS M. publicado el 04/10/2019 tras la compra hecha el 14/09/2019

5/5

quizá uno de los mejores de la tienda. Estupendo. Cuesta adaptarse (sensación inicial de rigidez) cuando los años de experiencia anteriores han sido sobre muelles y colchón blando.

¿Esta opinion le ha parecido util? 0 No 0

ANGEL D. publicado el 18/09/2019 tras la compra hecha el 28/08/2019

5/5

El mejor colchon que he dormido

¿Esta opinion le ha parecido util? 0 No 0

MANUEL F. publicado el 06/09/2019 tras la compra hecha el 21/08/2019

5/5

colchón recomendable de muy alta calidad

¿Esta opinion le ha parecido util? 0 No 0

Montserrat F. publicado el 23/08/2019 tras la compra hecha el 11/08/2019

5/5

Perfecto. 10 de 10.

¿Esta opinion le ha parecido util? 0 No 0

Francisco V. publicado el 09/08/2019 tras la compra hecha el 29/07/2019

5/5

Parece bastante aceptable.

¿Esta opinion le ha parecido util? 0 No 1

FRANCISCO D. publicado el 05/08/2019 tras la compra hecha el 26/07/2019

5/5

Muy muy cómodo, es un colchón genial!!

¿Esta opinion le ha parecido util? 2 No 0

RAMON JOSE F. publicado el 23/03/2019 tras la compra hecha el 05/03/2019

5/5

De momento el colchón cumple muy bien y su firmeza es muy buena.

¿Esta opinion le ha parecido util? 2 No 0

PILAR M. publicado el 19/03/2019 tras la compra hecha el 26/02/2019

5/5

estoy encantado con mi colchon

¿Esta opinion le ha parecido util? 2 No 0

Araceli G. publicado el 23/02/2019 tras la compra hecha el 06/02/2019

5/5

Muy buen colchón y a buen precio.

¿Esta opinion le ha parecido util? 0 No 2

Sergio O. publicado el 20/11/2018 tras la compra hecha el 26/10/2018

5/5

Producto perfecto

¿Esta opinion le ha parecido util? 0 No 0

×