Our top categories
Pond Kits
Kits & All in One solutions for your pond
Pond Pumps
Get water from A to B, the simple way
Pond Filters
Keep your water nice & clean
Pond UVC's
UV Light To Clear Algea
- Read About:
- Hozelock Cyprio Brand
Other areas to consider
Other departments
- Oase Fountain Pumps
- Oase Pond Filters
- Oase Pond Pumps
- Oase UVC
- Hozelock Pond Fountain Pumps
- Hozelock Pond Filters
- Hozelock Pond UVC lights
- Hozelock Aquaforce
- Hozelock Cascade Pond Pumps
- Hozelock Easyclear Pump and Filter
- Hozelock Bioforce Pond Filters
- Laguna Pond Filters
- Laguna Pond Pumps
- Hozelock Pond
- Lotus Pond Filters
- Lotus Pond Pumps
- Pontec Pond Filters
- Pontec Pond Pumps
- Blagdon Pond Pumps
- Pond Fish Food Flakes
- Pond Fish Food Sticks
- Pond Fish Food Pellets
- Pond Fish Food Wheatgerm
- Hozelock Eco Filters
WITH sHeieracy AS (SELECT sectionID [Id] FROM sections WHERE sectionID = 40 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.5 out of 5(2 reviews)£179.99RRP £205.99Quick, there's only 1 left!
- 4.2 out of 5(24 reviews)£64.98RRP £171.99Quick, there's only 3 left!
- £24.99RRP £27.99Quick, there's only 2 left!
- 4.8 out of 5(5 reviews)£96.02RRP £166.99Quick, there's only 2 left!
- 5 out of 5(2 reviews)£10.44RRP £16.29Quick, there's only 4 left!
- 5 out of 5(1 reviews)£19.98RRP £24.99Quick, there's only 9 left!
- 4.9 out of 5(26 reviews)£38.79RRP £89.99Quick, there's only 6 left!
- 3.3 out of 5(3 reviews)£21.99RRP £33.49Quick, there's only 2 left!
- 3.5 out of 5(2 reviews)£21.99RRP £33.99Quick, there's only 1 left!
- £4.38In Stock Now!
Hozelock Cyprio Pond Equipment
Hozelock Cyprio is a world renowned brand in aquatics that produced a vast range of quality products for your garden pond. Hozelock Cyprio has both extended and improved upon their existing vast quality range of aquatic products. They are a leader in innovation and have engineered a number of quality award winning products to help keep your pond and fish healthy. Including their award winning Easyclear pond pumps.
For every pond pump, filter and general pond product we aim to provide all the essential information needed to help you select the correct products for the needs of your pond.