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 6

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

199,00 €

284,29 €

-30%

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 ( 228771 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', ), 'attributes' => array ( 0 => 559, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 996, 'reference' => '228771-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\'', ), 228772 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', ), 'attributes' => array ( 0 => 560, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 991, 'reference' => '228772-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\'', ), 228773 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', ), 'attributes' => array ( 0 => 561, ), 'price' => 11.8016529999999999489546098629944026470184326171875, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228773-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\'', ), 228774 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', ), 'attributes' => array ( 0 => 562, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 995, 'reference' => '228774-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\'', ), 228775 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', ), 'attributes' => array ( 0 => 563, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 947, 'reference' => '228775-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\'', ), 228776 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', ), 'attributes' => array ( 0 => 564, ), 'price' => 11.8016529999999999489546098629944026470184326171875, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 988, 'reference' => '228776-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\'', ), 228777 => array ( 'attributes_values' => array ( 7 => '100 x 180 cm. ', ), 'attributes' => array ( 0 => 565, ), 'price' => 59.0247930000000025074768927879631519317626953125, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228777-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'565\'', ), 228778 => array ( 'attributes_values' => array ( 7 => '100 x 190 cm.', ), 'attributes' => array ( 0 => 566, ), 'price' => 59.0247930000000025074768927879631519317626953125, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228778-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'566\'', ), 228779 => array ( 'attributes_values' => array ( 7 => '100 x 200 cm.', ), 'attributes' => array ( 0 => 567, ), 'price' => 82.6446279999999973142621456645429134368896484375, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228779-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'567\'', ), 228780 => array ( 'attributes_values' => array ( 7 => '105 x 180 cm. ', ), 'attributes' => array ( 0 => 568, ), 'price' => 59.0247930000000025074768927879631519317626953125, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 995, 'reference' => '228780-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'568\'', ), 228781 => array ( 'attributes_values' => array ( 7 => '105 x 190 cm.', ), 'attributes' => array ( 0 => 569, ), 'price' => 59.0247930000000025074768927879631519317626953125, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 977, 'reference' => '228781-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'569\'', ), 228782 => array ( 'attributes_values' => array ( 7 => '105 x 200 cm.', ), 'attributes' => array ( 0 => 570, ), 'price' => 82.6446279999999973142621456645429134368896484375, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 992, 'reference' => '228782-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'570\'', ), 228783 => array ( 'attributes_values' => array ( 7 => '120 x 180 cm. ', ), 'attributes' => array ( 0 => 571, ), 'price' => 118.057850999999999430656316690146923065185546875, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228783-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'571\'', ), 228784 => array ( 'attributes_values' => array ( 7 => '120 x 190 cm.', ), 'attributes' => array ( 0 => 572, ), 'price' => 118.057850999999999430656316690146923065185546875, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 992, 'reference' => '228784-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'572\'', ), 228785 => array ( 'attributes_values' => array ( 7 => '120 x 200 cm. ', ), 'attributes' => array ( 0 => 573, ), 'price' => 141.66942099999999982173903845250606536865234375, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 997, 'reference' => '228785-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'573\'', ), 228786 => array ( 'attributes_values' => array ( 7 => '135 x 180 cm.', ), 'attributes' => array ( 0 => 574, ), 'price' => 118.057850999999999430656316690146923065185546875, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 992, 'reference' => '228786-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'574\'', ), 228787 => array ( 'attributes_values' => array ( 7 => '135 x 190 cm.', ), 'attributes' => array ( 0 => 575, ), 'price' => 118.057850999999999430656316690146923065185546875, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 961, 'reference' => '228787-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'575\'', ), 228788 => array ( 'attributes_values' => array ( 7 => '135 x 200 cm.', ), 'attributes' => array ( 0 => 576, ), 'price' => 141.66942099999999982173903845250606536865234375, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 995, 'reference' => '228788-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'576\'', ), 228789 => array ( 'attributes_values' => array ( 7 => '140 x 180 cm.', ), 'attributes' => array ( 0 => 577, ), 'price' => 153.479339000000010173607734031975269317626953125, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228789-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'577\'', ), 228790 => array ( 'attributes_values' => array ( 7 => '140 x 190 cm.', ), 'attributes' => array ( 0 => 578, ), 'price' => 153.479339000000010173607734031975269317626953125, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 997, 'reference' => '228790-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'578\'', ), 228791 => array ( 'attributes_values' => array ( 7 => '140 x 200 cm.', ), 'attributes' => array ( 0 => 579, ), 'price' => 165.289255999999994628524291329085826873779296875, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228791-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'579\'', ), 228792 => array ( 'attributes_values' => array ( 7 => '150 x 180 cm. ', ), 'attributes' => array ( 0 => 580, ), 'price' => 153.479339000000010173607734031975269317626953125, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228792-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'580\'', ), 228793 => array ( 'attributes_values' => array ( 7 => '150 x 190 cm.', ), 'attributes' => array ( 0 => 581, ), 'price' => 153.479339000000010173607734031975269317626953125, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 952, 'reference' => '228793-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'581\'', ), 228794 => array ( 'attributes_values' => array ( 7 => '150 x 200 cm.', ), 'attributes' => array ( 0 => 582, ), 'price' => 165.289255999999994628524291329085826873779296875, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 985, 'reference' => '228794-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'582\'', ), 228795 => array ( 'attributes_values' => array ( 7 => '160 x 180 cm.', ), 'attributes' => array ( 0 => 583, ), 'price' => 200.702479000000010955773177556693553924560546875, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228795-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'583\'', ), 228796 => array ( 'attributes_values' => array ( 7 => '160 x 190 cm.', ), 'attributes' => array ( 0 => 584, ), 'price' => 200.702479000000010955773177556693553924560546875, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228796-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'584\'', ), 228797 => array ( 'attributes_values' => array ( 7 => '160 x 200 cm.', ), 'attributes' => array ( 0 => 585, ), 'price' => 224.31405000000000882209860719740390777587890625, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228797-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'585\'', ), 228798 => array ( 'attributes_values' => array ( 7 => '180 x 180 cm.', ), 'attributes' => array ( 0 => 586, ), 'price' => 283.34710699999999405918060801923274993896484375, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228798-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'586\'', ), 228799 => array ( 'attributes_values' => array ( 7 => '180 x 190 cm.', ), 'attributes' => array ( 0 => 587, ), 'price' => 283.34710699999999405918060801923274993896484375, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 997, 'reference' => '228799-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'587\'', ), 228800 => array ( 'attributes_values' => array ( 7 => '180 x 200 cm.', ), 'attributes' => array ( 0 => 588, ), 'price' => 306.9669420000000172876752912998199462890625, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => 995, 'reference' => '228800-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'588\'', ), 228801 => array ( 'attributes_values' => array ( 7 => '200 x 180 cm. ', ), 'attributes' => array ( 0 => 589, ), 'price' => 342.38016499999997677150531671941280364990234375, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228801-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'589\'', ), 228802 => array ( 'attributes_values' => array ( 7 => '200 x 190 cm.', ), 'attributes' => array ( 0 => 590, ), 'price' => 342.38016499999997677150531671941280364990234375, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228802-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'590\'', ), 228803 => array ( 'attributes_values' => array ( 7 => '200 x 200 cm. ', ), 'attributes' => array ( 0 => 591, ), 'price' => 342.38016499999997677150531671941280364990234375, 'specific_price' => array ( 'id_specific_price' => '176', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '249', '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.300000', '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' => '228803-COLVP60032', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'591\'', ), )

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 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.
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.
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 Hr Bi-Form

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

16 cm HR Bi-Form de 40 kg/m³
6 Cm De Viscoelástica

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

6 cm de viscoelástica de alta densidad 65 kg/m³
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 (± 1 cm)
Firmeza 80
Adaptabilidad 90
Transpirabilidad 75
Garantía 3
  • Cabecero tapizado MANET 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 : 8 cm....

    106,00 € 20% 132,50 €
    SOMOS FABRICANTES- PRECIOS CON PORTES E IVA INCLUIDO
  • 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
  • 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....

    299,00 € 40% 498,33 €
    PORTES E IVA INCLUIDOS
  • Pack compuesto por: - Canapé polipiel gran capacidad  en polipiel de alta calidad, con tapa 3D a juego. Posibilidad de poner la tapa en contorno polipiel. Va depositado al suelo directamente con  goma perimetral.    Altura total  ± 36 cm .    Altura cajón interior   ± 29 cm. -  Colchón Viscoelástico Premium 6:   núcleo...

    429,00 € 20% 536,25 €
    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.8 /5

Basado en 48 opiniones del cliente

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

ANTONIO M. publicado el 24/10/2019 tras la compra hecha el 04/10/2019

5/5

MUY COMODO. DUERMO COMO UN BEBE.

¿Esta opinion le ha parecido util? 0 No 0

EUGENIO M. publicado el 01/10/2019 tras la compra hecha el 10/09/2019

5/5

buen producto

¿Esta opinion le ha parecido util? 0 No 0

Felix P. publicado el 18/09/2019 tras la compra hecha el 28/08/2019

5/5

Estupendo, cómodo, nivel de firmeza y adaptabilidad como quería.

¿Esta opinion le ha parecido util? 0 No 0

MARIA JESUS A. publicado el 03/09/2019 tras la compra hecha el 24/08/2019

5/5

Relación calidad-precio inmejorable. Os recomendare.

¿Esta opinion le ha parecido util? 0 No 0

JAVIER FRANCISCO I. publicado el 24/08/2019 tras la compra hecha el 13/08/2019

5/5

La atención al cliente la calidad del artículo y muy muy importante la rapidez y control en el servicio de reparto. Cuando sea necesario volveré a Vds.

¿Esta opinion le ha parecido util? 0 No 0

Rachel B. publicado el 13/08/2019 tras la compra hecha el 31/07/2019

5/5

Es complicado comprar un colchón por internet pero este es excelente . Me he basado en los anteriores comentarios y os dejo aquí mi pequeña aportación .

¿Esta opinion le ha parecido util? 0 No 0

Ingrid Z. publicado el 12/08/2019 tras la compra hecha el 31/07/2019

4/5

Comodisimo

¿Esta opinion le ha parecido util? 0 No 0

JOAQUINA M. publicado el 31/07/2019 tras la compra hecha el 19/07/2019

5/5

Este colchon es comodisimo, lo probé en Ciudad Real y me animé a pedirlo hasta el norte de España. Estoy muy contenta

¿Esta opinion le ha parecido util? 0 No 0

ELVIRA JULIA A. publicado el 22/10/2018 tras la compra hecha el 09/10/2018

5/5

Bueno

¿Esta opinion le ha parecido util? 0 No 0

MANUEL JUAN A. publicado el 05/10/2018 tras la compra hecha el 27/09/2018

5/5

Colchón de buena calidad cumple mis expectativas de firmeza me levanto por la mañana muy descansado Totalmente recomendable

¿Esta opinion le ha parecido util? 3 No 0

×