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 (1830)
                    GROUP BY sa.id
                    ORDER BY IFNULL(sa.shopspos_cat*1,999)
Modern short pile rugs | Beliani.co.uk
Sort by:
Show:

Area Rug Grey Various Sizes KATERINI

FREE shipping, available now

Area Rug Black Various Sizes KATERINI

FREE shipping, available now

Area Rug Blue Various Sizes KATERINI

FREE shipping, available now

Area Rug Beige Various Sizes KATERINI

FREE shipping, available now

Patchwork Rug from Leather 160 x 230 cm - ENNE

509.00
FREE shipping, available from 2018-03-12

Carpet brown - 160x230 cm - rug - leather - USAK

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

Carpet - Rug - Colourful - Chevron - Cotton - 160x230 cm - BISMIL

649.00
FREE shipping, available now

Area Rug Leather Black and Beige Various Sizes DEVELI

FREE shipping, available now

Rug - Carpet – Short Pile - Cotton - Various Sizes - Multi-coloured - ARAKLI

FREE shipping, available from 2018-04-23

Rug - Carpet - Patchwork - Leather - ø140 cm - Black and White - BERGAMA

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

Area Rug Leather Grey Various Sizes AGACLI

FREE shipping, available now

Carpet - Rug - Short Pile - Green and Beige - 80x150 cm - MALKARA

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

Area Rug Pink and Green Various Sizes EDESA

Out of stock

Rug - Carpet - Hand Tufted - Wool - Various Sizes - Blue and Grey - PATNOS

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

Area Rug Grey Various Sizes XANTI

FREE shipping, available now

Area Rug Beige Various Sizes XANTI

FREE shipping, available now

Rug - Carpet - Cotton - Wool - Handmade - Various Sizes - Grey Beige Black - POLATLI

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

Area Rug Red and Beige Various Sizes ALIMOS

FREE shipping, available now

Rug - Carpet - Handtufted - Wool - Various Sizes - Yellow and Beige - TIRE

FREE shipping, available now

Rug - Carpet - Hand Tufted - Wool - Various Sizes - Light Blue - DALI

FREE shipping, available now

Vintage Rug Beige Various Sizes PATRAS

FREE shipping, available now

Rug - Carpet - Hand Tufted - Cotton - 80x150 cm - Grey - YALOVA

119.00
FREE shipping, available now

Area Rug Black and Beige Various Sizes LAMIA

FREE shipping, available now

Area Rug Pink and Beige Various Sizes LAMIA

FREE shipping, available now

Rug - Carpet - Hand Tufted - Cotton - Various Sizes - Grey - YALOVA

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

Vintage Rug Grey Various Sizes ARGOS

FREE shipping, available now

Rug - Carpet - Hand Tufted - Cotton - Various Sizes - Light Blue - YALOVA

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

Rug - Carpet - Hand Tufted - Wool - Various Sizes - Grey - ZILE

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

Area Rug Black and White Various Sizes DAFNI

FREE shipping, available now

Rug- Carpet - Handtufted - Wool - Various Sizes - Dark Blue - ZILE

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

Area Rug Beige Various Sizes SERRES

FREE shipping, available now

Area Rug Blue Various Sizes SERRES

FREE shipping, available now

Rug - Carpet - Hand Tufted - Wool and Cotton - Various Sizes - Beige - ERBAA

FREE shipping, available now

Rug - Carpet - Cotton - Jute - Handmade - 80x150 cm - Brown Beige - SILOPI

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

Rug - Carpet - Viscose - Various Sizes - Beige - GESI

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

Rug - Carpet - Viscose - Various Sizes - Dark Grey - GESI

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

Rug - Carpet - Viscose - Various Sizes - Light Grey - GESI

FREE shipping, available now

Rug - Carpet - Viscose - Various Sizes - Dark Grey - GESI

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

Rug - Carpet - Viscose - Various Sizes - Dark Blue - GESI

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

Rug - Carpet - Cotton - Jute - Handmade - Various Sizes - Blue Beige - SILOPI

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

Hand-Tufted Yellow Cotton Rug Various Sizes - SILVAN

FREE shipping, available from 2018-04-23

Hand-Tufted Blue Rug Various Sizes SILVAN

FREE shipping, available now

Hand-Tufted Grey Cotton Rug Various Sizes - SILVAN

FREE shipping, available from 2018-04-23

Rug - Carpet - Polyester - Cotton - Handmade - Various Sizes - Brown - TOSYA

FREE shipping, available now

Rug - Carpet - Cotton - Wool - Handmade - Various Sizes - Brown - SARAY

119.00
FREE shipping, available now

Rug - Carpet - Cotton - Wool - Handmade - 80x150 cm - Grey - SARAY

119.00
FREE shipping, available now

Rug - Carpet - Wool - Handmade - 160x230 cm - Dark Grey - SARAY

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

Rug - Carpet - Wool - Handmade - Various Sizes - Brown - SARAY II

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

Rug - Carpet - Cotton - Wool - Handmade - Various Sizes - Brown - POLATLI

119.00
FREE shipping, available now

Rug - Cotton - Denim - Handmade - Various Sizes - Blue - ADIYAMAN

FREE shipping, available now

Rug - Carpet - Cotton - Wool - Handmade - Various Sizes - Grey - PAYAS

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

Rug - Carpet - Cotton - Jute - Polyester - Handmade - Various Sizes - Beige - TUNCELI

FREE shipping, available now

Rug - Carpet - Wool - Handmade - Various Sizes - Dark Grey - PAYAS

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

Rug - Carpet - Cotton - Wool - Handmade - Various Sizes - Beige and Grey - PATNOS

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

Carpet - Rug - Multicolour - Cotton - Various Sizes - MALATYA

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

Rug - Carpet - Handmade - Cotton - Various Sizes - Brown - NIZIP

119.00
FREE shipping, available now

Rug - Carpet - Hand Tufted - Wool - Various Sizes - Grey and Beige - NIZIP

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

Rug - Carpet - Short Pile - Cotton - Various Sizes - Multi-colour - MERSIN

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

Rug - Carpet - Short Pile - Cotton - Various Sizes - Blue - MERSIN

FREE shipping, available now

Rug - Carpet - Handmade - Cotton - Various Sizes - Multi and White - BARTIN

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

Rug - Carpet - Handmade - Cotton - Various Sizes - Multi and Black - BARTIN

FREE shipping, available now

Rug - Carpet - Cowhide - Patchwork - Various Sizes - Brown and Blue - ALIAGA

FREE shipping, available from 2018-04-23

Rug - Carpet - Cotton Rug - Handmade - Various Sizes - Grey - ORTACA

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

Rug - Carpet -Living Room Rug - Cotton - Various Sizes - Blue - ALANYA

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

Rug - Carpet - Short Pile - Cotton - Various Sizes - Multicolour - DANCA

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

Rug - Carpet - Cowhide - Patchwork - Various Sizes - Brown and Blue and Beige - AMASYA

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

Rug - Carpet - Short Pile - Cotton - Various Sizes - Light Multicolour - DANCA

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

Rug - Carpet - Living Room Rug - Cotton - Various Sizes - Beige - DERINCE

FREE shipping, available now

Rug - Carpet - Living Room Rug - Cotton - Various Sizes - Orange - DERINCE

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

Rug - Carpet - Living Room Rug - Cotton - 80x150 cm - Light Blue - DERINCE

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

Rug - Carpet - Living Room Rug - Cotton - Various Sizes - Red - DERINCE

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

Rug - Carpet - Short Pile - Cotton - Various Sizes - Dark Multicolour - DANCA

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

Rug - Carpet – Cowhide Rug - Patchwork - Various Sizes - Brown and Gold - ARTVIN

FREE shipping, available now

Rug - Carpet - Handmade - Cotton - Various Sizes - Braun - NIKSAR

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

Rug - Carpet - Handmade - Cotton - Various Sizes - Orange - NIKSAR

FREE shipping, available now

Rug - Carpet - Cowhide Rug - Patchwork - Various Sizes - Brown and Gold - BANDIRMA

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

Rug - Carpet - Cotton - Various Sizes - Grey - BESNI

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

Rug - Carpet - Cotton - Various Sizes - Blue - BESNI

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

Rug - Carpet - Cotton - Various Sizes - Dark Blue - TALAS

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

Rug - Carpet - Cotton - Various Sizes - Red - BESNI

FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)
* All prices incl. VAT and incl. shipping cost
Ratings

4.99 / 5.00 116

TAKE ADVANTAGE OF OUR EXCLUSIVE

voucher offers

See all pictures