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

Cama Elevable

189,00 €

270,00 €

-30%

ENTREGA 24/48H

Envio gratis
3 años de garantia
100 noches de prueba
NULL
array ( 1190642 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 559, 1 => 539, 2 => 1022, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190642-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\',\'539\',\'1022\'', ), 1190666 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 559, 1 => 540, 2 => 1022, ), 'price' => 57.85000000000000142108547152020037174224853515625, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190666-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\',\'540\',\'1022\'', ), 1190660 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 559, 1 => 544, 2 => 1023, ), 'price' => 207.006529000000000451109372079372406005859375, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190660-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\',\'544\',\'1023\'', ), 1190672 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 559, 1 => 540, 2 => 1023, ), 'price' => 233.8665290000000140935298986732959747314453125, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190672-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\',\'540\',\'1023\'', ), 1190654 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 559, 1 => 544, 2 => 1022, ), 'price' => 30.989999999999998436805981327779591083526611328125, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190654-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\',\'544\',\'1022\'', ), 1190648 => array ( 'attributes_values' => array ( 7 => '80 x 180 cm.', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 559, 1 => 539, 2 => 1023, ), 'price' => 176.01652899999999135616235435009002685546875, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190648-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'559\',\'539\',\'1023\'', ), 1190643 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 560, 1 => 539, 2 => 1022, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190643-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\',\'539\',\'1022\'', ), 1190667 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 560, 1 => 540, 2 => 1022, ), 'price' => 57.85000000000000142108547152020037174224853515625, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190667-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\',\'540\',\'1022\'', ), 1190673 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 560, 1 => 540, 2 => 1023, ), 'price' => 233.8665290000000140935298986732959747314453125, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190673-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\',\'540\',\'1023\'', ), 1190661 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 560, 1 => 544, 2 => 1023, ), 'price' => 207.006529000000000451109372079372406005859375, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190661-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\',\'544\',\'1023\'', ), 1190655 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 560, 1 => 544, 2 => 1022, ), 'price' => 30.989999999999998436805981327779591083526611328125, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190655-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\',\'544\',\'1022\'', ), 1190649 => array ( 'attributes_values' => array ( 7 => '80 x 190 cm. ', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 560, 1 => 539, 2 => 1023, ), 'price' => 176.01652899999999135616235435009002685546875, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190649-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'560\',\'539\',\'1023\'', ), 1190644 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 561, 1 => 539, 2 => 1022, ), 'price' => 11.8100000000000004973799150320701301097869873046875, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190644-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\',\'539\',\'1022\'', ), 1190668 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 561, 1 => 540, 2 => 1022, ), 'price' => 69.659999999999996589394868351519107818603515625, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190668-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\',\'540\',\'1022\'', ), 1190674 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 561, 1 => 540, 2 => 1023, ), 'price' => 245.676528999999987945557222701609134674072265625, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190674-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\',\'540\',\'1023\'', ), 1190662 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 561, 1 => 544, 2 => 1023, ), 'price' => 218.81652900000000272484612651169300079345703125, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190662-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\',\'544\',\'1023\'', ), 1190656 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 561, 1 => 544, 2 => 1022, ), 'price' => 42.7999999999999971578290569595992565155029296875, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190656-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\',\'544\',\'1022\'', ), 1190650 => array ( 'attributes_values' => array ( 7 => '80 x 200 cm.', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 561, 1 => 539, 2 => 1023, ), 'price' => 187.82652899999999362989910878241062164306640625, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190650-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'561\',\'539\',\'1023\'', ), 1190645 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 562, 1 => 539, 2 => 1022, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190645-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\',\'539\',\'1022\'', ), 1190669 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 562, 1 => 540, 2 => 1022, ), 'price' => 57.85000000000000142108547152020037174224853515625, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190669-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\',\'540\',\'1022\'', ), 1190675 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 562, 1 => 540, 2 => 1023, ), 'price' => 233.8665290000000140935298986732959747314453125, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190675-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\',\'540\',\'1023\'', ), 1190663 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 562, 1 => 544, 2 => 1023, ), 'price' => 207.006529000000000451109372079372406005859375, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190663-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\',\'544\',\'1023\'', ), 1190657 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 562, 1 => 544, 2 => 1022, ), 'price' => 30.989999999999998436805981327779591083526611328125, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190657-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\',\'544\',\'1022\'', ), 1190651 => array ( 'attributes_values' => array ( 7 => '90 x 180 cm.', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 562, 1 => 539, 2 => 1023, ), 'price' => 176.01652899999999135616235435009002685546875, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190651-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'562\',\'539\',\'1023\'', ), 1190670 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 563, 1 => 540, 2 => 1022, ), 'price' => 57.85000000000000142108547152020037174224853515625, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190670-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\',\'540\',\'1022\'', ), 1190646 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 563, 1 => 539, 2 => 1022, ), 'price' => 0.0, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190646-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\',\'539\',\'1022\'', ), 1190676 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 563, 1 => 540, 2 => 1023, ), 'price' => 233.8665290000000140935298986732959747314453125, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190676-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\',\'540\',\'1023\'', ), 1190664 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 563, 1 => 544, 2 => 1023, ), 'price' => 207.006529000000000451109372079372406005859375, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190664-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\',\'544\',\'1023\'', ), 1190658 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 563, 1 => 544, 2 => 1022, ), 'price' => 30.989999999999998436805981327779591083526611328125, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190658-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\',\'544\',\'1022\'', ), 1190652 => array ( 'attributes_values' => array ( 7 => '90 x 190 cm. ', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 563, 1 => 539, 2 => 1023, ), 'price' => 176.01652899999999135616235435009002685546875, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190652-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'563\',\'539\',\'1023\'', ), 1190647 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 564, 1 => 539, 2 => 1022, ), 'price' => 11.8100000000000004973799150320701301097869873046875, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190647-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\',\'539\',\'1022\'', ), 1190671 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 564, 1 => 540, 2 => 1022, ), 'price' => 69.659999999999996589394868351519107818603515625, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190671-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\',\'540\',\'1022\'', ), 1190677 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', 35 => 'Contratación de Subida y Montaje (+56€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 564, 1 => 540, 2 => 1023, ), 'price' => 245.676528999999987945557222701609134674072265625, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190677-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\',\'540\',\'1023\'', ), 1190665 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 564, 1 => 544, 2 => 1023, ), 'price' => 218.81652900000000272484612651169300079345703125, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190665-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\',\'544\',\'1023\'', ), 1190659 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', 35 => 'Contratación de Subida (+30€). Entrega de 4 a 10 días.', 54 => 'Sin colchón', ), 'attributes' => array ( 0 => 564, 1 => 544, 2 => 1022, ), 'price' => 42.7999999999999971578290569595992565155029296875, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190659-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\',\'544\',\'1022\'', ), 1190653 => array ( 'attributes_values' => array ( 7 => '90 x 200 cm. ', 35 => 'Entrega 24/48 horas. (+0€). GRATIS', 54 => 'Con colchón: medidas 90 x 190 cm', ), 'attributes' => array ( 0 => 564, 1 => 539, 2 => 1023, ), 'price' => 187.82652899999999362989910878241062164306640625, 'specific_price' => array ( 'id_specific_price' => '1589', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '779', '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' => 100, 'reference' => '1190653-CAMAELEV00', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => -1, 'list' => '\'564\',\'539\',\'1023\'', ), )

La Cama Elevable, consiste en un sistema de estructura ligera invisible para los huéspedes, compatible con cualquier estética o decoración. La altura de la cama es de 32 cm, pero puede elevarse con un simple gesto hasta llegar a los 72 cm, de esta manera la cama queda a una altura idónea para hacer la cama sin demasiado esfuerzo, evitando posibles dolores de espalda. Ideales para hoteles.

Características
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.
indeformable

Indeformable.

Indeformable.
Garantía

3 años de garantía.

3 años de garantía.
Altura

Altura 32 cm

Altura 32 cm
Envío Entrega 24/48h
Enrollable