Hozelock Outdoor Tap Connector
Product Code : 2158 Barcode : 5010646005234
92.9% from 17 reviews
Mega Sale Event, Now On!
Brief Description
1" BSP tap connector suitable for use with garden irrigation pumps or taps typically found on farms, in factories or in horticulture.
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
1" BSP tap connector suitable for use with garden irrigation pumps or taps typically found on farms, in factories or in horticulture.
The connector securely attaches to the outdoor tap, and converts it to the Hozelock quick connect system.
Questions and answers
Product Reviews
Hozelock Outdoor Tap Connector
Overall rating92.9% from 17 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='2158' ORDER BY InStock DESC, soldqty desc, pNumRatings*pprice DESC
Customers Also Purchased
- 5 out of 5(40 reviews)£8.78RRP £11.79In Stock Now!
- 4.9 out of 5(37 reviews)£4.49RRP £5.09In Stock Now!
- 4.8 out of 5(10 reviews)£5.49RRP £6.09In Stock Now!
- 4.8 out of 5(16 reviews)£4.99RRP £5.29In Stock Now!
- 4.8 out of 5(41 reviews)£25.99RRP £36.79In 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.4 out of 5(106 reviews)£29.99RRP £38.49In Stock Now!
- 4.7 out of 5(95 reviews)£12.49RRP £14.29In Stock Now!
- 4.7 out of 5(55 reviews)£24.99RRP £36.39In Stock Now!