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 Muelles CLASSIC

¡Precio rebajado! Colchón Muelles CLASSIC
  • 60% Firmeza
  • 50% Adaptabilidad
  • 90% Transpirabilidad
  • Tipo: Muelles
  • Alto: 25 cm

155,85 €

173,16 €

-10%

ENTREGA 24/48H

  • Envío Estándar:

    Compra ahora y en 2 a 5 días laborables recibirás el pedido en tu domicilio.

  • Envío Especializado

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

Envio gratis
2 Años de Garantia
100 noches de prueba
NULL
array ( 1545724 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', ), 'attributes' => array ( 0 => 559, ), 'price' => 4.589999999999999857891452847979962825775146484375, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545724-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\'', ), 1545725 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', ), 'attributes' => array ( 0 => 560, ), 'price' => 4.589999999999999857891452847979962825775146484375, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545725-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\'', ), 1545726 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', ), 'attributes' => array ( 0 => 561, ), 'price' => 19.260000000000001563194018672220408916473388671875, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545726-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\'', ), 1545727 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', ), 'attributes' => array ( 0 => 562, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545727-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\'', ), 1545728 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', ), 'attributes' => array ( 0 => 563, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545728-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\'', ), 1545729 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', ), 'attributes' => array ( 0 => 564, ), 'price' => 14.6776859999999995665120877674780786037445068359375, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545729-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\'', ), 1545730 => array ( 'attributes_values' => array ( 7 => '105 x 180 cm. ', ), 'attributes' => array ( 0 => 568, ), 'price' => 12.842974999999999141664375201798975467681884765625, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545730-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'568\'', ), 1545731 => array ( 'attributes_values' => array ( 7 => '105 x 190 cm.', ), 'attributes' => array ( 0 => 569, ), 'price' => 12.842974999999999141664375201798975467681884765625, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545731-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'569\'', ), 1545732 => array ( 'attributes_values' => array ( 7 => '105 x 200 cm.', ), 'attributes' => array ( 0 => 570, ), 'price' => 28.438016999999998546400092891417443752288818359375, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545732-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'570\'', ), 1545733 => array ( 'attributes_values' => array ( 7 => '135 x 180 cm.', ), 'attributes' => array ( 0 => 574, ), 'price' => 38.5289259999999984529495122842490673065185546875, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545733-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'574\'', ), 1545734 => array ( 'attributes_values' => array ( 7 => '135 x 190 cm.', ), 'attributes' => array ( 0 => 575, ), 'price' => 38.5289259999999984529495122842490673065185546875, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545734-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'575\'', ), 1545735 => array ( 'attributes_values' => array ( 7 => '135 x 200 cm.', ), 'attributes' => array ( 0 => 576, ), 'price' => 60.54545499999999691453922423534095287322998046875, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545735-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'576\'', ), 1545736 => array ( 'attributes_values' => array ( 7 => '150 x 180 cm. ', ), 'attributes' => array ( 0 => 580, ), 'price' => 55.95867799999999903093339526094496250152587890625, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545736-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'580\'', ), 1545737 => array ( 'attributes_values' => array ( 7 => '150 x 190 cm.', ), 'attributes' => array ( 0 => 581, ), 'price' => 55.95867799999999903093339526094496250152587890625, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545737-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'581\'', ), 1545738 => array ( 'attributes_values' => array ( 7 => '150 x 200 cm.', ), 'attributes' => array ( 0 => 582, ), 'price' => 79.8099169999999986657712724991142749786376953125, 'specific_price' => array ( 'id_specific_price' => '74028', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '932', '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.100000', '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' => '1545738-COLMC0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'582\'', ), )

Colchón Muelles CLASSIC está compuesto por un núcleo de muelles Biconical Plus que proporcionan una gran firmeza y durabilidad. Refuerzo perimetral y cuñas laterales. 

MUELLES BICÓNICOS O BONNELL: son muelles en forma de reloj de arena que ofrecen una gran transpirabilidad y son atérmicos.

Colchón recomendado para personas de poco peso, niños y adolescentes.

Características
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.
Garantía 2 Años

Garantía 2 años.

Garantía 2 años.
Refuerzos

Refuerzos perimetrales para evitar las
Deformaciones laterales y centrales con
Hr de alta densidad y firmeza.

Refuerzos perimetrales para evitar las
Deformaciones laterales y centrales con
Hr de alta densidad y firmeza.
Firmeza

Firmeza: media

Firmeza: media
Altura 20 cm

Altura total ± 20 cm.

Altura total ± 20 cm.
Transpirable

Transpirable

Transpirable
TEJIDO DAMASCO

Tejido damasco alta calidad.

Tejido damasco alta calidad.
Carcasa de muelles Bicónicos

Carcasa muelles bicónicos sistemas bonell extrafirme de 2,3 mm.

Carcasa muelles bicónicos sistemas bonell extrafirme de 2,3 mm.
Envío Estándar Si
Envío Entrega 3 a 9 días
Envío Especializado Si
Tipo Muelles
Alto 25 cm
Firmeza 60
Adaptabilidad 50
Transpirabilidad 90
Garantía 2
  • 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Á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...

    159,00 € 20% 198,75 €
    En stock
  • Colchón Muelles Ensacados  VISCO TRIUMPH:  Compuesto por 3 cm de Viscolástica de Alta Densidad 50 Kg/m³,  2 cm de Viscogel +   Carcasa de Muelles Ensacados  Independientes (System Embox) , que ofrece una gran firmeza, tiene Refuerzos Perimetrales para evitar las deformaciones laterales y centrales con Espuma de HR de alta densidad . Contiene...

    418,00 € 20% 522,50 €
    ENTREGA 24-48 HORAS