select /*getOffers*/ distinct sa.mi_id, sa.id, o.offer_id, sa.id as saved_id, sa.id orig_id
                , IFNULL(master_sa.id, sa.id) master_sa
                , IFNULL(master_sa.saved_group_id, sa.saved_group_id) saved_group_id
                , IFNULL(master_sa.saved_group_ordering, sa.saved_group_ordering) saved_group_ordering
                , 0 as visits
                , shop_rating_cache.avg*100 rated
                , IFNULL(master_sa.id,sa.id) ifnullmastersa
                , IFNULL(sa.master_ShopSAAlias,1) master_ShopSAAlias
                , IFNULL(sa.master_ShopDesription,1) master_ShopDesription
                , IFNULL(sa.master_descriptionShop,1) master_descriptionShop
                , IFNULL(sa.master_descriptionTextShop,1) master_descriptionTextShop
                , IFNULL(sa.master_pics,1) master_pics
                , IFNULL(sa.master_banner,1) master_banner
                , IFNULL(sa.master_sims,1) master_sims
                , IFNULL(sa.master_others,1) master_others
                , IFNULL(sa.master_ShopSAKeywords,1) master_ShopSAKeywords
                , IFNULL(sa.master_ShopShortTitle,1) master_ShopShortTitle
                , IFNULL(sa.master_icons,1) master_icons
                , IFNULL(sa.master_amazon,1) master_amazon
                , max(sa.shop_catalogue_id) cat_id
                , alias.name ShopDescription
                , sa.ShopHPrice  as ShopHPrice
                , sa.ShopMinusPercent
                , sa.ShopShortDescription
                , sa.ShopPrice  as ShopPrice
                , (0 ) as fake_free_shipping
                , alias.name alias
                , o.name offer_name
                , IFNULL(tShopSAAlias.value, tShopSAAlias_default.value) ShopSAAlias
                , IFNULL(tShopShortTitle.value, tShopShortTitle_default.value) ShopShortTitle
                , orig_o.offer_id orig_offer_id
                , orig_o.available
                , orig_o.available_weeks
                , orig_o.available_date
                , IF(orig_o.available
                    , 'In stock'
                    ,IF(orig_o.available_weeks
                        , CONCAT('Available from:', ' ', DATE(date_add(NOW(), INTERVAL orig_o.available_weeks week)))
                        , IF(orig_o.available_date='0000-00-00'
                            , 'Out of stock'
                            , CONCAT('Available from:',' ', orig_o.available_date)
                        )
                    )
                ) available_text
                #, sa.details
                , sa.ShopShippingCharge
                , o.sshipping_plan_free
                , sa.siteid
                , IF(IF(0, 1, IFNULL(tsshipping_plan_free_tr.value,0)), 0, spc.shipping_cost) as shipping_cost

                , (select translation.value from translation
                    join saved_doc on saved_doc.doc_id=translation.id
                            where translation.language='english'
                            AND  `translation`.`table_name_id` = '508'  
                            AND  `translation`.`field_name_id` = '1594' 
                            and saved_doc.saved_id=IFNULL(master_sa.id, sa.id) order by saved_doc.primary desc limit 1) alt
                , (select translation.value from translation
                    join saved_doc on saved_doc.doc_id=translation.id
                            where translation.language='english'
                            AND  `translation`.`table_name_id` = '508'  
                            AND  `translation`.`field_name_id` = '121' 
                            and saved_doc.saved_id=IFNULL(master_sa.id, sa.id) order by saved_doc.primary desc limit 1) title
                , (SELECT group_concat(concat(al.article_id,':',al.default_quantity,':',a.weight_per_single_unit))
                    FROM article_list al
                    JOIN offer_group og ON al.group_id = og.offer_group_id and base_group_id=0
                    join article a on a.article_id=al.article_id and a.admin_id=0
                    WHERE og.offer_id = o.offer_id and al.inactive=0 and og.additional=0) als                 

            from sa2 sa
            left join sa_all master_sa on sa.master_sa=master_sa.id
            join offer o on o.offer_id=IFNULL(master_sa.offer_id, sa.offer_id)
            left join offer orig_o on orig_o.offer_id=sa.offer_id
            join translation t1 on 
                t1.id=47 
                AND  `t1`.`table_name_id` = '887'  
                AND  `t1`.`field_name_id` = '5575' 
                and t1.language='english'
            left join translation t2 on 
                t2.id=(57-orig_o.available)
                AND  `t2`.`table_name_id` = '887'  
                AND  `t2`.`field_name_id` = '5575' 
                and t2.language='english'
            left join translation tShopDesription on tShopDesription.id=IF(IFNULL(sa.master_ShopDesription,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopDesription`.`table_name_id` = '411'  
                AND  `tShopDesription`.`field_name_id` = '1678' 
                and tShopDesription.language = 'english'
            left join translation tShopDesription_default on tShopDesription_default.id=IF(IFNULL(sa.master_ShopDesription,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopDesription_default`.`table_name_id` = '411'  
                AND  `tShopDesription_default`.`field_name_id` = '1678' 
                and tShopDesription_default.language = 'english'
            join offer_name alias on IFNULL(tShopDesription.value, tShopDesription_default.value)=alias.id
            left join translation tShopSAAlias on tShopSAAlias.id=IF(IFNULL(sa.master_ShopSAAlias,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopSAAlias`.`table_name_id` = '411'  
                AND  `tShopSAAlias`.`field_name_id` = '5550' 
                and tShopSAAlias.language = 'english'
            left join translation tShopSAAlias_default on tShopSAAlias_default.id=IF(IFNULL(sa.master_ShopSAAlias,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopSAAlias_default`.`table_name_id` = '411'  
                AND  `tShopSAAlias_default`.`field_name_id` = '5550' 
                and tShopSAAlias_default.language = 'english'
            left join translation tShopShortTitle on tShopShortTitle.id=IF(IFNULL(sa.master_ShopShortTitle,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopShortTitle`.`table_name_id` = '411'  
                AND  `tShopShortTitle`.`field_name_id` = '5553' 
                and tShopShortTitle.language = 'english'
            left join translation tShopShortTitle_default on tShopShortTitle_default.id=IF(IFNULL(sa.master_ShopShortTitle,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopShortTitle_default`.`table_name_id` = '411'  
                AND  `tShopShortTitle_default`.`field_name_id` = '5553' 
                and tShopShortTitle_default.language = 'english'
            left join translation tsshipping_plan_free_tr
                on tsshipping_plan_free_tr.language=sa.siteid
                and tsshipping_plan_free_tr.id=orig_o.offer_id
                AND  `tsshipping_plan_free_tr`.`table_name_id` = '285'  
                AND  `tsshipping_plan_free_tr`.`field_name_id` = '5557' 
            join translation tsshipping_plan_id
                on tsshipping_plan_id.language=sa.siteid
                and tsshipping_plan_id.id=orig_o.offer_id
                AND  `tsshipping_plan_id`.`table_name_id` = '285'  
                AND  `tsshipping_plan_id`.`field_name_id` = '5558' 
            join shipping_plan_country spc on spc.shipping_plan_id=tsshipping_plan_id.value
            join config_api_values cav on cav.par_id=5 and cav.value=sa.siteid
            join country c on c.code=spc.country_code and c.name=REPLACE(cav.description,'United Kingdom','UK')
            left join shop_rating_cache on shop_rating_cache.shop_id=1 and shop_rating_cache.saved_id=sa.id
                    WHERE tShopSAAlias.value != ''
                        AND sa.username='Beliani UK'
                        AND sa.siteid='3'
                        AND NOT o.hidden 
                        AND IFNULL(sa.old,0)=0
                        AND sa.id>0
                        AND sa.shop_catalogue_id IN (1719)
                    GROUP BY sa.id
                    ORDER BY IFNULL(sa.shopspos_cat*1,999)
Upholstered Beds | Beliani.co.uk
Price
Colour
Lying surface
Sort by:
Show:

Light Grey Upholstered Bed Various Sizes: 160/180 cm VALBONNE

FREE shipping, available now

Dark Grey Upholstered Bed 160/180 cm VALBONNE

FREE shipping, available now

Bed - King Size Bed Frame - Upholstered - 160x200 cm - Beige - REIMS

579.00
FREE shipping, available now

Upholstered Grey and Beige Bed Various sizes: 160/180 cm VALENCE

FREE shipping, available now

Upholstered Grey Bed Various sizes: 160/180 cm SENNEZ

FREE shipping, available from 2018-04-09

Upholstered Blue Bed Various sizes: 160/180 cm SENNEZ

FREE shipping, available now

Upholstered Grey and Dark Beige Bed Various sizes: 160/180 cm VALENCE

FREE shipping, available now

Upholstered bed - Various Sizes: 160/180 cm - Light Grey - LORIENT

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered bed - Fabric - 140x200 cm - Double - Grey - RENNES

469.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered bed - Fabric - 160x200 cm - Kingsize - Grey - RENNES

589.00
FREE shipping, available from 2018-04-02
(2)
5 stars
(2)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered bed - Fabric - 160x200 cm - Kingsize - Dark blue - RENNES

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Beige Bed Various sizes: 90/140/160/180 cm RENNES

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered bed - Fabric - 180x200 cm - Super king size - Grey - RENNES

529.00
FREE shipping, available from 2018-04-02
(2)
5 stars
(2)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Dark Blue Bed Various sizes: 90/140/180 cm RENNES

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Bed Frame - Storage Box - Various Sizes: 160/180 cm - Black - LORIENT

FREE shipping, available now

Upholstered bed - Various Sizes: 160/180 cm - Dark Grey - LORIENT

FREE shipping, available from 2018-03-26

Upholstered Grey Platform Bed Various sizes: 160/180 cm ORELLE

FREE shipping, available from 2018-04-02

Upholstered Grey Bed with Frame Various sizes: 160/180 cm VIENNE

FREE shipping, available now

Upholstered Black Box Spring Bed Various sizes: 160/180 cm PRESIDENT

1,159.00
FREE shipping, available now
(2)
5 stars
(2)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Beige Box Spring Bed Various sizes: 160/180 cm PRESIDENT

1,259.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Grey Box Spring Bed Various sizes: 160/180 cm PRESIDENT

1,159.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Light Grey Box Spring Bed Various sizes: 160/180 cm PRESIDENT

1,159.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Super King Size Bed - Box Spring - 180x200 cm - Grey and Green - PRESIDENT

1,259.00
FREE shipping, available now

Upholstered Light Blue Bed with Frame Various sizes: 160/180 cm VIENNE

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Beige Box Spring Bed with Pocket Sprung Mattress Various sizes: 160/180 cm ADMIRAL

1,239.00
FREE shipping, available now

Black Box Spring Bed with Pocket Sprung Mattress Various sizes: 160/180 cm ADMIRAL

1,239.00
FREE shipping, available now

Grey Box Spring Bed with Pocket Sprung Mattress Various sizes: 160/180 cm ADMIRAL

1,139.00
FREE shipping, available now

Light Grey Box Spring Bed with Pocket Sprung Mattress Various sizes: 160/180 cm ADMIRAL

1,339.00
FREE shipping, available now

Upholstered Dark Blue Bed with Frame Various sizes: 160/180 cm VIENNE

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Bed - King Size Bed Frame - Upholstered - 160x200 cm - Dark Grey - LA ROCHELLE

489.00
FREE shipping, available from 2018-03-26
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Beige Bed Various sizes: 160/180 cm LA ROCHELLE

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Bed - Single Bed Frame - With Storage - 90x200 cm - Grey - METZ

599.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Bed - Double Size Bed Frame - With Storage - 140x200 cm - Grey - METZ

659.00
FREE shipping, available now

Upholstered Bed Grey Various sizes: 90/140/160/180 cm METZ

FREE shipping, available now
(2)
5 stars
(2)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Black Bed Various sizes: 160/180 cm LA ROCHELLE

FREE shipping, available from 2018-03-26
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Bed - Super King Size Bed Frame - Upholstered - 180x200 cm - Dark Grey - LA ROCHELLE

539.00
FREE shipping, available from 2018-03-26
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Bed - King Size Bed Frame - Upholstered - 160x200 cm - Grey - REIMS

579.00
FREE shipping, available now

Bed - Bed Frame - Platform Bed - Upholstered - 140x200 cm - Double - Grey - AMBASSADOR

589.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Bed - Bed Frame - Platform Bed - Upholstered - 160x200 cm - Kingsize - Beige - AMBASSADOR

599.00
FREE shipping, available now
(2)
5 stars
(2)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Beige Platform Bed Various sizes: 140/180 cm AMBASSADOR

FREE shipping, available now
(5)
5 stars
(4)
4 stars
(0)
3 stars
(1)
2 stars
(0)
1 star
(0)

Bed - Bed Frame - Platform Bed - Upholstered - 180x200 cm - Super Kingsize - Grey - AMBASSADOR

619.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Violet Platform Bed Various sizes: 140/180 cm AMBASSADOR

FREE shipping, available now

Upholstered Light Grey Bed with Frame Various sizes: 160/180 cm SAVERNE

FREE shipping, available now
(4)
5 stars
(3)
4 stars
(1)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Grey Bed with Stable Slatted Frame Various sizes: 160/180 cm NANTES

FREE shipping, available now
(14)
5 stars
(13)
4 stars
(0)
3 stars
(1)
2 stars
(0)
1 star
(0)

Upholstered Grey Bed with Stable Slatted Frame Various sizes: 160/180 cm PARIS

FREE shipping, available now
(11)
5 stars
(10)
4 stars
(1)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered bed - 160x200 cm - MONTPELLIER beige

559.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Beige Bed Various sizes: 160/180 cm MONTPELLIER

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered bed - Various Sizes: 160/180 cm - MONTPELLIER grey

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered bed - 180x200cm - Super king size - MONTPELLIER light blue

679.00
FREE shipping, available from 2018-03-26
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Grey Bed with Stable Slatted Frame Various sizes: 160/180 cm LILLE

FREE shipping, available now
(18)
5 stars
(18)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Bed - Fabric - Super King Size - incl. stable slatted frame - Grey - 180 x 200 cm - VICHY

909.00
FREE shipping, available now
(2)
5 stars
(2)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Bed - Fabric - King Size - 180x200 cm - incl. stable slatted frame - Black - VICHY

839.00
FREE shipping, available now
(2)
5 stars
(2)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Beige Bed with Frame Various sizes: 160/180 cm MARSEILLE

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Light Blue Bed with Frame Various sizes: 160/180 cm MARSEILLE

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered Dark Blue Bed with Frame Various sizes: 160/180 cm MARSEILLE

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Upholstered beds

Material beds are the best solution, especially for the colour lovers. They consist of stable frame and durable polyester. Soft headrest is safe and comfortable. Plus, the elegant legs complete the whole appearance. It doesn’t matter if you choose colourful, grey or wine AMBASSADOR model – you will be happy of the design and pleasant sleep.

If you want to have a more classical model, please check our modern leather beds. We also offer wooden and continental beds. If you are interested in any particular model, just place the order on the internet and we will deliver it to your house.

If you have any questions, please contact our customer service department.

* All prices incl. VAT and incl. shipping cost
Ratings

4.92 / 5.00 124

TAKE ADVANTAGE OF OUR EXCLUSIVE

voucher offers

See all pictures