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
                    , ' JA'
                    ,IF(orig_o.available_weeks
                        , CONCAT('Lieferbar ab:', ' ', DATE(date_add(NOW(), INTERVAL orig_o.available_weeks week)))
                        , IF(orig_o.available_date='0000-00-00'
                            , 'Lieferbar ab: noch nicht bekannt'
                            , CONCAT('Lieferbar ab:',' ', 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 sa8 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='german'
            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='german'
            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 = 'german'
            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 = 'german'
            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 = 'german'
            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 = 'german'
            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 = 'german'
            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 = 'german'
            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 AT'
                        AND sa.siteid='16'
                        AND NOT o.hidden 
                        AND IFNULL(sa.old,0)=0
                        AND sa.id>0
                        AND sa.shop_catalogue_id IN (449)
                    GROUP BY sa.id
                    ORDER BY IFNULL(sa.shopspos_cat*1,999)
Rattanlounge | Beliani.at
Preis
Anzahl der Sitzplätze
Produktvarianten
Sortieren nach:
Ansehen:

Lounge Set Rattan braun 8-Sitzer Auflagen beige XXL

1,899.00
Sofort kostenlos lieferbar
(99+)
5 Sterne
(167)
4 Sterne
(7)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan grau 8-Sitzer Auflagen grau XXL

1,899.00
Sofort kostenlos lieferbar

Lounge Set Rattan weiss 8-Sitzer Auflagen grau XXL

1,899.00
Sofort kostenlos lieferbar
(33)
5 Sterne
(29)
4 Sterne
(2)
3 Sterne
(2)
2 Sterne
(0)
1 Stern
(0)

Gartensofa Rattan dunkelbraun 3-Sitzer Auflagen beige ROMA

699.00
Sofort kostenlos lieferbar

Lounge Set weiss 4-Sitzer Auflagen grau SAN MARINO

1,599.00
Sofort kostenlos lieferbar
(1)
5 Sterne
(1)
4 Sterne
(0)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan hellbraun 9-Sitzer rund Auflagen weiss SEVERO

1,999.00
Sofort kostenlos lieferbar

Lounge Set Rattan grau 5-Sitzer Auflagen grau LAZZARO

1,369.00
Sofort kostenlos lieferbar

Lounge Set Rattan dunkelbraun 4-Sitzer Auflagen beige MILANO

1,399.00
Sofort kostenlos lieferbar
(37)
5 Sterne
(36)
4 Sterne
(1)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Gartensofa Rattan weiss 3-Sitzer Auflagen grau CREMA

799.00
Sofort kostenlos lieferbar
(10)
5 Sterne
(9)
4 Sterne
(1)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan weiss 5-Sitzer Auflagen grau CREMA

1,699.00
Sofort kostenlos lieferbar
(7)
5 Sterne
(7)
4 Sterne
(0)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan braun 5-Sitzer Auflagen weiss CREMA

1,699.00
Sofort kostenlos lieferbar
(2)
5 Sterne
(2)
4 Sterne
(0)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan weiss 5-Sitzer Auflagen türkis CREMA

1,699.00
Sofort kostenlos lieferbar
(4)
5 Sterne
(3)
4 Sterne
(1)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan dunkelbraun 4-Sitzer Auflagen weiss RIMINI

999.00
Sofort kostenlos lieferbar
(11)
5 Sterne
(11)
4 Sterne
(0)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Gartenmöbel Set Rattan braun 2-Sitzer Auflagen weiss CAPRI

649.00
Sofort kostenlos lieferbar
(12)
5 Sterne
(12)
4 Sterne
(0)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Verbindungsklammern für Rattan Lounge Sets (2 Stück)

49.90
Sofort kostenlos lieferbar
(11)
5 Sterne
(10)
4 Sterne
(1)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan braun 4-Sitzer Auflagen beige LUCA

799.00
Sofort kostenlos lieferbar
(2)
5 Sterne
(2)
4 Sterne
(0)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan braun 4-Sitzer Auflagen beige MARSALA

569.00
Sofort kostenlos lieferbar
(1)
5 Sterne
(1)
4 Sterne
(0)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Gartenmöbel Set Rattan grau 8-Sitzer Auflagen beige MAESTRO

2,249.00
Sofort kostenlos lieferbar
(18)
5 Sterne
(17)
4 Sterne
(0)
3 Sterne
(1)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan schwarz 8-Sitzer Auflagen beige MAESTRO

2,249.00
Sofort kostenlos lieferbar
(7)
5 Sterne
(7)
4 Sterne
(0)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan braun 6-Sitzer Auflagen beige ROMA

1,429.00
Sofort kostenlos lieferbar
(85)
5 Sterne
(78)
4 Sterne
(5)
3 Sterne
(1)
2 Sterne
(1)
1 Stern
(0)

Lounge Set Rattan schwarz 4-Sitzer SANO

1,199.00
Sofort kostenlos lieferbar
(22)
5 Sterne
(22)
4 Sterne
(0)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan braun 7-Sitzer Auflagen beige GRANDE

1,799.00
Sofort kostenlos lieferbar
(99+)
5 Sterne
(108)
4 Sterne
(5)
3 Sterne
(1)
2 Sterne
(0)
1 Stern
(0)

Lounge Set Rattan weiss 4-Sitzer Auflagen karamell SANO

1,199.00
Sofort kostenlos lieferbar
(9)
5 Sterne
(9)
4 Sterne
(0)
3 Sterne
(0)
2 Sterne
(0)
1 Stern
(0)

Rattan Lounge

Obwohl diese noch nicht allzu lange auf dem Markt sind, gehören Rattan Gartenmöbel zu den beliebtesten Einrichtungsstücken für den Garten. Das absolut wetterfeste Material eignet sich hervorragend für die Verwendung im Freien und kann durch ein paar wenige Pflegetipps lange ein Highlight Ihres Gartens bleiben. Das Gartenset selber kann auch im Winter draussen gelassen werden. Die Kissen sollten jedoch vor der Witterung geschützt werden, sei es durch die Lagerung in einer Rattan Kissenbox oder durch Abdeckung mit einem Regenschutz. Je nach Bedürfnis haben wir die Lounge Möbel auch als Balkonmöbel in der passenden Grösse im Angebot.

* Alle Preise inkl. MwSt und inkl. Versandkosten
Bewertungen

4.94 / 5.00 551

PROFITIEREN SIE VON UNSEREN EXKLUSIVEN

Gutscheinangeboten

Alle Bilder sehen