Our top categories
Other areas to consider
WITH sHeieracy AS (SELECT sectionID [Id] FROM sections WHERE sectionID = 51 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
- £499RRP £509Quick, there's only 3 left!
- £789RRP £819Quick, there's only 4 left!
- £454.99RRP £497.99Quick, there's only 1 left!
- £84.99RRP £89.99Quick, there's only 2 left!
- £118.79RRP £131.99Quick, there's only 2 left!
- £319.99RRP £349.99Quick, there's only 4 left!
- £189RRP £199Quick, there's only 3 left!
- £174.99RRP £188.99Quick, there's only 3 left!
- £119.99Quick, there's only 1 left!
- £18.52RRP £19.98In Stock Now!
Delivery Options
Almost all of our garden power tools come with free delivery and we aim to get your purchases with you within three working days. If you require a next-day delivery, call us to ask if it is available for that particular product. Due to certain items being sent from other merchants and not directly from our own warehouse, this is not always possible. Our items are packaged to a high standard to minimise the risk of damages, but in the event that an item is damaged in transit, we will provide a replacement as soon as possible.
Refunds & Returns
In the event that you are unhappy with your purchase, we offer a 14 day cooling-off period to send the item(s) back to us for a full refund or exchange.If you think that your purchase could be faulty, you can call us within 30 days to arrange an exchange or refund, in accordance with your statutory consumer rights.
For full terms and conditions about our Returns Policy, click here.