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 (936)
                    GROUP BY sa.id
                    ORDER BY IFNULL(sa.shopspos_cat*1,999)
Patio Furniture | Beliani.co.uk
Material
Variant
Sort by:
Show:

4 Piece Conversation Set White with Blue Cushions BALTIC

1,199.00
FREE shipping, available now

Double Hammock with Stand - Beige TERAMO

539.00
FREE shipping, available now

Set of 2 Accent Chairs White ACAPULCO

139.00
FREE shipping, available now

Set of 2 Accent Chairs Light Grey ACAPULCO

139.00
FREE shipping, available now

Set of 2 Accent Chairs Black ACAPULCO

139.00
FREE shipping, available now

Set of 2 Accent Chairs Brown ACAPULCO

139.00
FREE shipping, available now

Set of 2 Accent Chairs Green ACAPULCO

139.00
FREE shipping, available now

Set of 2 Accent Chairs Orange ACAPULCO

139.00
FREE shipping, available now

Set of 2 Accent Chairs Blue ACAPULCO

139.00
FREE shipping, available now

2 Seater Bistro Set White ACAPULCO

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

2 Seater Bistro Set Black ACAPULCO

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

2 Seater Bistro Set Light Grey ACAPULCO

259.00
FREE shipping, available now

2 Seater Bistro Set Brown ACAPULCO

259.00
FREE shipping, available now

2 Seater Bistro Set Green ACAPULCO

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

2 Seater Bistro Set Orange ACAPULCO

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

2 Seater Bistro Set Blue ACAPULCO

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

Resin Wicker Conversation Set - Outdoor Sofa Patio Furniture - MILANO

1,049.00
FREE shipping, available now
(99+)
5 stars
(107)
4 stars
(2)
3 stars
(1)
2 stars
(0)
1 star
(0)

Garden Bench - 2 Seater - Outdoor Bench - Accacia Wood - TOSCANA

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

Wicker Dining Set with Bench and Chairs - BARLETTA

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

Outdoor Lounge Chair - Adjustable Wicker Sun Lounger - PERUGIA

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

Rattan Garden Sun Lounger - Outdoor - Rattan - Wicker - FIRENZE

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

Rattan Outdoor Set - Patio Furniture - Chairs - Table - CAPRI

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

Garden Bistro Set for 2 Lime Green FIORI

159.00
FREE shipping, available now

Garden Bistro Set for 2 Grey FIORI

159.00
FREE shipping, available now

Garden Bistro Set for 2 White FIORI

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

Garden Bistro Set for 2 Blue FIORI

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

Garden Bistro Set for 2 Taupe FIORI

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

Electric patio heater - Umbrella mounted - Infrared - STROMBOLI

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

Outdoor Conversation Set - Steel and Acacia - Modern Furniture - BERMUDA

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

Garden bench - Outdoor bench - 3- Seater - Brown - HILO

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

Outdoor Bistro Set - Folding Table and 2 Chairs - FIJI White

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

Garden Bisto Set in Light Brown FIJI

209.00
FREE shipping, available now

White Wooden Garden Bistro Set with Zigzag Cushions FIJI

239.00
FREE shipping, available now

Garden Bistro Set with Blue-white Cushions FIJI

199.00
FREE shipping, available now

White Wooden Garden Bistro Set with Grey-Beige Cushions FIJI

239.00
FREE shipping, available now

Garden Bistro Set with Grey-beige Cushions FIJI

199.00
FREE shipping, available now

White Wooden Garden Bistro Set with Yellow Cushions FIJI

239.00
FREE shipping, available now

Garden Bistro Set with Yellow Cushions FIJI

199.00
FREE shipping, available now

Dining Chair - Garden Chair - Kitchen Chair - Black - MERTON

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

Garden Furniture - 4 Seater Sofa Set with Cushions - Table and Chairs - Brown - PACIFIC

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

Sun Lounger - Rattan - Garden Lounger - Reclining - Grey - TURIN

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

Garden Sofa Set - Patio Set - Rattan - 4 Seater Sofa Set - MARSALA

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

Aluminium Dining Set with 6 Folding Chairs White - CATANIA

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

Coffee table - Side table - Plastic table - Outdoor Table - Transparent Green - NEWHAM

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

Coffee table - Side table - Plastic table - Outdoor Table - Transparent Blue - NEWHAM

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

Coffee table - Side table - Plastic table - Outdoor Table - Transparent Red - NEWHAM

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

Dining Chair - Garden Chair - Kitchen Chair - White - MERTON

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

Dining Chair - Garden Chair - Kitchen Chair - Red - MERTON

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

Dining Chair - Garden Chair - Kitchen Chair - Ghost Chair - Transparent - Red - MERTON

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

Dining Chair - Garden Chair - Kitchen Chair - Grey - MERTON

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

Wicker Outdoor Dining Chair - Garden and Patio Chairs - Model ITALY

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

Wicker Outdoor Dining Set for 6 - Patio Table 160 cm with Chairs - ITALY

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

Outdoor Dining Set - Resin Wicker Table with 8 Chairs - ITALY 220

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

Garden chair - Outdoor Chair - Garden Furniture - MAUI

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

Outdoor Sofa 3 Seater - Stainless Steel and Wicker - CREMA White

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

Solid Wooden Garden Chair - Adjustable Backrest -TOSCANA

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

Outdoor Sofa 3 Seater - Stainless Steel and Wicker - CREMA Brown

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

Modern Outdoor Conversation Set - Wicker Patio Furniture - CREMA

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

Garden Bench - Wooden bench, 180 cm - JAVA

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

Garden bench of white balau, 180 cm - JAVA Marlboro

679.00
FREE shipping, available now

Modern Outdoor Conversation Set - Wicker Patio Furniture - CREMA Brown

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

Modern Outdoor Conversation Set - Wicker Patio Furniture - CREMA White

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

Solid Wooden Lounger - Wheels - Outdoor - Garden Furniture- TOSCANA

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

Exclusive Wooden Garden Sun Lounger - with cushion, beige - TOSCANA

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

Electric patio heater - Free standing - Infrared - VEZUVIO

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

Adjustable Wicker Lounge Chair Grey - VASTO

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

Adjustable Wicker Lounge Chair Brown - VASTO

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

Electric patio heater - Free standing - Infrared - Built-in ashtray - VEZUVIO

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

Electric patio heater - Free standing - Infrared - Table top - ETNA

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

Electric patio heater - Free standing - Infrared - ETNA

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

Electric patio heater - Hanging - Infrared - KABA

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

Teak Style Outdoor Dining Chair with Adjustable Backrest - RIVIERA

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

3 Seater Garden Bench - Seat - Acacia Wood - TOSCANA Marlboro

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

Patio set - Garden set - Acacia wood - Table and two chairs - TOSCANA

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

Patio set - Garden set - Acacia wood - Table and two chairs - Terracotta cushions - TOSCANA

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

Patio set - Garden set - Acacia wood - Table and two chairs - Light terracotta cushions - TOSCANA

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

Sectional Outdoor Sofa Set - Modern White Wicker Furniture - SANO

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

Foldable Garden Chair - Wooden - Patio Outdoor - JAVA

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

Patio Furniture

If you are a fortunate owner of a big garden search no longer and furnish it with our vast range of garden furniture. We offer a variety of quality outdoor products in various colours, shapes and materials. Match different styles and create your own, unique garden retreat. Granite furniture looks great in an open surrounding while wooden sets can be used outdoor as well as indoor.

Furnish your balcony or terrace with our lounge furniture and save some space thanks to folding or stacking chairs. Although smaller than classic rattan furniture, they add a fresh touch and ensure comfortable sitting. For higher comfort use one of our top-notch quality cushions available in various colours.

If you prefer wooden furniture to polyrattan check our adjustable loungers. Depending on wood type they come in light brown (crafted from teak wood) or dark, red- brown tone (crafted from Yellow Balau/bankirai. With time wood gains a silvery layer, which is called "patina". To avoid it treat the wood with a specialist care products. Apart from wooden loungers, we offer excellent quality wooden benches as well as reclining chair.

In order to protect your garden furniture, you might consider the purchase of balcony/garden accessories such as a rain cover (to protect furniture from variable weather conditions) or a patio heater (to enjoy chilly summer evenings). Lounge on extremely comfortable XL or XXL bean bags.

Find these and many other products in our online shop. Thanks to our excellent customer service you will enjoy your new designer furniture in no time.

 

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

4.97 / 5.00 446

TAKE ADVANTAGE OF OUR EXCLUSIVE

voucher offers

See all pictures