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='german'
                            AND  `translation`.`table_name_id` = '508'  
                            AND  `translation`.`field_name_id` = '1594' 
                            and saved_doc.saved_id=58757 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='german'
                            AND  `translation`.`table_name_id` = '508'  
                            AND  `translation`.`field_name_id` = '121' 
                            and saved_doc.saved_id=58757 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 = 80221 and al.inactive=0 and og.additional=0) als                

            from sa7 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 = 'french'
            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 = 'french'
            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 = 'french'
            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 FR'
                        AND sa.siteid='71'
                        AND NOT o.hidden 
                        AND IFNULL(sa.old,0)=0
                        AND sa.id>0
                        AND sa.shop_catalogue_id IN (910)
                    GROUP BY sa.id
                    ORDER BY IFNULL(sa.shopspos_cat*1,999)
Genuine Leather, Super King Size, 180 x 200 cm, Exclusive, Designer, Leatherbed, Queensize, Single, Double, Day Bed, Kingsize | Beliani.fr
Prix
Matière
Sort by:
Show:

PU Leather Brown Box Spring Bed Various sizes: 160/180 cm PRESIDENT

1,359.00
FREE shipping, available now

Waterbed Grey with Accessory Various sizes: 160/180 cm NANTES

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

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
(1)
5 stars
(0)
4 stars
(1)
3 stars
(0)
2 stars
(0)
1 star
(0)

Light Brown Wooden Platform Waterbed 180 x 200 cm ZEN

1,539.00
FREE shipping, available now

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

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

Upholstered Grey Bed Various sizes: 160/180 cm SENNEZ

FREE shipping, available from 09-04-2018

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

Metal Black Bed Various Sizes: 160/180 cm LEPUS

FREE shipping, available now

Wooden White Bed Frame Various Sizes: 140/160/180 ROSSELANGE

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,539.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Wooden White Bed Various Sizes: 140/160/180 cm OLIVET

FREE shipping, available now

Metal Black Bed Various Sizes: 160/180 cm LYRA

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,359.00
FREE shipping, available now

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

1,359.00
FREE shipping, available now

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

1,359.00
FREE shipping, available now

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

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

Metal White Bed Various Sizes: 160/180 cm LYRA

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

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

FREE shipping, available now

Wooden Light Brown Bed Various Sizes: 160/180 CARNAC

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

Bed - Super King Size Bed Frame - Wooden - 180x200 cm - Brown - CARNAC

499.00
FREE shipping, available now

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

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)

Wooden White Bed Various Sizes: 160/180 CALAIS

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

Wooden Grey Bed Various Sizes: 160/180 CALAIS

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

Wooden Light Brown Bed Various Sizes: 160/180 CALAIS

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 LA ROCHELLE

FREE shipping, available now
(1)
5 stars
(1)
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 26-03-2018
(2)
5 stars
(2)
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

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

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 Frame - Storage Box - Various Sizes: 160/180 cm - Black - LORIENT

FREE shipping, available now

Faux Leather White Platform Bed Various sizes: 160/180 cm ORELLE

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

Faux Leather Black Platform Bed Various Sizes 160/180 cm ORELLE

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

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

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

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

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

Wooden Bed Japan Style - 180x200 cm - Super King Size - with Side Tables - Light Brown - ZEN

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

Leather White Bed with Frame Various sizes: 160/180 cm AVIGNON

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

Wooden White Bed Various Sizes: 160/180 cm CAEN

FREE shipping, available now

Wooden Light Brown Bed Various Sizes: 160/180 cm CAEN

FREE shipping, available now

Wooden Grey Bed Various Sizes: 160/180 cm CAEN

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

Leather Gold Bed with Frame Various sizes: 160/180 cm AVIGNON

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

Wooden Brown Bed Various Sizes: 160/180 cm CASTRES

FREE shipping, available now

Wooden White Bed Various Sizes: 160/180 cm CASTRES

FREE shipping, available now

White Metal Bed Various Sizes: 160/180 cm ANTLIA

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

Black Metal Bed Various Sizes: 160/180 cm ANTLIA

FREE shipping, available now

Metal Black Bed Various Sizes: 160/180 cm LYNX

FREE shipping, available now

Beds (180x200 cm)

Everyone knows that a comfortable and cosy bed guarantees a goodnight’s sleep. 180x200 cm bed size is perfect for two people. The size refers to the inner bed frame and thus, also the mattress and the slatted bed frame. Instead of choosing one 180 cm mattress, you can use two 90 cm mattresses. Such a solution is advisable if your partner needs a firmer or softer mattress.

Apart from the mattress and a stable slatted bed frame ensuring a comfortable sleep, the outer bed frame and its design are equally important. Bed frames can be tailored to one’s needs. That is why we have classic leather beds, modern boxspring beds and wooden beds. Various models are available in different colours and materials.

In our shop you will find a bed which will perfectly fit your bedroom. You can order it quickly and easily via Internet. If you have any questions please contact us by phone or via Internet.

 

All prices include VAT, excluding shipping costs. Crossed out price is based on competition price.
Ratings

4.96 / 5.00 27

TAKE ADVANTAGE OF OUR EXCLUSIVE

voucher offers

See all pictures