Hozelock Jet Spray Plus Gun With Waterstop Connector - 2682
Product Code : 02682 Barcode : 5010646037594
97.8% from 9 reviews
Mega Sale Event, Now On!
Brief Description
Combines all the features of the premium hose gun range with a choice of jet, cone and fast-fill spray patterns.
Also comes with a waterstop connector for easy changing of accesories without getting wet.
View all 205 Hozelock products or visit our Hozelock brand page
Delivery Options - Available at Checkout
Estimated delivery
£2.952-3 Working Days
£2.952-3 Working Days
Product Description
Combines all the features of the premium hose gun range with a choice of jet, cone and fast-fill spray patterns.
Also comes with a waterstop connector for easy changing of accesories without getting wet.
Questions and answers
Product Reviews
Hozelock Jet Spray Plus Gun With Waterstop Connector - 2682
Overall rating97.8% from 9 reviews
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='02682' ORDER BY InStock DESC, soldqty desc, pNumRatings*pprice DESC
Customers Also Purchased
- 4.8 out of 5(41 reviews)£25.99RRP £36.79In Stock Now!
- 5 out of 5(40 reviews)£8.78RRP £11.79In Stock Now!
- 4.4 out of 5(106 reviews)£29.99RRP £38.49In Stock Now!
- 4.8 out of 5(16 reviews)£6.59RRP £8.59In Stock Now!
- 4.3 out of 5(11 reviews)£5.49RRP £7.49In Stock Now!
- 4.7 out of 5(101 reviews)£59.99RRP £75.48In Stock Now!
- 4.1 out of 5(13 reviews)£7.69RRP £11.69Quick, there's only 9 left!
- 4.3 out of 5(11 reviews)£32.49RRP £57.49Quick, there's only 9 left!
- 4.9 out of 5(37 reviews)£4.49RRP £5.09In Stock Now!
- 4.7 out of 5(53 reviews)£67.48RRP £134.99In Stock Now!