Our top categories
Water Features
Garden water features
Garden Ornaments
Faux decor, sculptures, ornaments and more
Planters & Tubs
Garden planters and tubs
Garden Lighting
Garden lights by Ellumiere
Solar Garden Lights
Solar powered decorative lights
Hanging Baskets
Hanging baskets and brackets
Garden Clocks
Garden wall clocks
Product Care & Spares
Water feature care and spare parts
WITH sHeieracy AS (SELECT sectionID [Id] FROM sections WHERE sectionID = 673 UNION ALL SELECT s.sectionID FROM sections s JOIN sHeieracy n ON s.topSection=n.Id) 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, sHeieracy WHERE pDisplay=1 AND pSection = [sHeieracy].[Id] ORDER BY InStock DESC, pNumRatings*pprice DESC
Popular Products
- 4.8 out of 5(19 reviews)£489.99RRP £517Quick, there's only 4 left!
- 4.8 out of 5(25 reviews)£134.99RRP £138Quick, there's only 8 left!
- 4.9 out of 5(12 reviews)£39.99RRP £41.99Quick, there's only 8 left!
- 4.7 out of 5(26 reviews)£389.99Quick, there's only 10 left!
- 4.6 out of 5(26 reviews)£219.99RRP £245Quick, there's only 7 left!
- 5 out of 5(5 reviews)£284.99RRP £345Quick, there's only 2 left!
- £289.99In Stock Now!
- 4.8 out of 5(4 reviews)£249RRP £287Quick, there's only 3 left!
- £299.99Quick, there's only 3 left!
- 4.9 out of 5(24 reviews)£41.99RRP £43.99In Stock Now!