Uno Ball Topiary Tree - 40cm
Product Code : 5045085 Barcode : 5050642028936
Mega Sale Event, Now On!
Brief Description
Create a stunning frame for your doorways and pathways with the Uno Ball Topiary Tree. Standing 40cm high, this artificial tree looks so realistic, no one would know it wasn't real.
Delivery Options - Available at Checkout
Estimated delivery
£2.952-3 Working Days
£2.952-3 Working Days
Product Description
- Uno Ball Topiary Tree - 40cm
- Create immediate visual impact
- Low maintenance
- Ideal for framing doors and pathways
- Weather and UV resistant
Create a stunning frame for your doorways and pathways with the Uno Ball Topiary Tree. Standing 40cm high, this artificial tree looks so realistic, no one would know it wasn't real.
Just position and leave, without the hassle of watering or shaping. The tree is weather and UV resistant, so will look good all season long, and is sure to garner admiring glances from your friends.
Dimensions:
Plant pot: 11 cm high x 13 cm diameter
Tree stands 40cm high
Questions and answers (1 questions & 1 answers)
SELECT TOP 10 pID,CASE WHEN RTRIM(LTRIM(pLink))<>'' THEN 'product/'+plink WHEN RTRIM(LTRIM(pURL))<>'' THEN pURL ELSE 'product/pl/'+CAST(REPLACE(pid,'/','%2F') AS VARCHAR(MAX)) END,pImage,pName,ISNULL(pListPrice,0),ISNULL(case when pInStock<1 AND ISNULL(mMerchID,'')<>'' THEN pmPrice ELSE pPrice END,0) pPrice,pPackSize,CASE WHEN pInStock<1 AND ISNULL(mMerchID,'')<>'' THEN pmInStock ELSE pInStock END pInStock,pDiscontinued,pAlternativeURL,pPreOrder,CASE WHEN pInStock<1 AND ISNULL(mMerchID,'')<>'' THEN mDeliveryTime ELSE pDeliveryTime END pDeliveryTime,CASE WHEN pInStock<1 AND ISNULL(mMerchID,'')<>'' THEN 1 ELSE 0 END IsMerch,ISNULL(mMerchID,''),ISNULL(mMerchantName,''),pDescription,case when pInStock>0 OR ISNULL(mMerchID,'')<>'' THEN 1 ELSE 0 END InStock, case when pInStock<1 AND ISNULL(mMerchID,'')='FARMANDGARD' AND ISNULL(pmSpecialOffer,'')<>'' THEN pmSpecialOffer ELSE pusp END pUsp,pnew,case when pInStock<1 AND ISNULL(mMerchID,'')<>'' THEN pmShipping WHEN pPrice>50 THEN 0 ELSE pShipping END,pReviewCount,pReviewAvg FROM products OUTER APPLY (SELECT TOP 1 pmPrice,pmInStock,mMerchID,mMerchantName, CASE WHEN LTRIM(RTRIM(pmDeliveryText))<>'' THEN LTRIM(RTRIM(pmDeliveryText)) ELSE msEstimatedTimeScale END AS mDeliveryTime, CASE WHEN pmPrice>msFreeWhenOver THEN 0 WHEN msFlatRate IS NOT NULL THEN msFlatRate WHEN msMinShipping IS NOT NULL AND msMinShipping>pmShipping THEN msMinShipping WHEN msMaxShipping IS NOT NULL AND msMaxShipping<pmShipping THEN msMaxShipping ELSE pmShipping END pmShipping, pmSpecialOffer FROM productmerchant AS [t0] LEFT OUTER JOIN [dbo].[Merchant] AS [t1] ON [t1].[mMerchID] = [t0].[pmMerchID] LEFT OUTER JOIN [dbo].[MerchantService] AS [t2] ON [t2].[msMerchId] = [t1].[mMerchID] WHERE pmApproved=1 AND pmDisplay=1 AND pmInStock>0 AND pmPrice>0 AND msSequence=1 AND pmEAN=EAN ORDER BY pmPrice) MerchStuff,customers_also_purchased WHERE pDisplay=1 AND pID=soldwithpID AND mainpid='5045085' ORDER BY InStock DESC, soldqty desc, pNumRatings*pprice DESC