SELECT DISTINCT fpcm.StockCode, k8s.WebDescription, k8s.WebCategoryToJoin AS PriceGroup, k8s.RetailPrice, k8s.BasePrice, k8s.SalePrice, p.CustomerAccount, k8s.K8LeadTime, fpcm.displayorder, sm1.MessageText AS StockMessage1, sm1.AllowOrder AS AllowOrder1, sm2.MessageText AS StockMessage2, sm2.AllowOrder AS AllowOrder2, sm3.MessageText AS StockMessage3, sm3.AllowOrder AS AllowOrder3, sm4.MessageText AS StockMessage4, sm4.AllowOrder AS AllowOrder4, CASE p.PriceBand WHEN 'R' THEN k8s.RetailPrice*(1-(p.Discount1/100)) WHEN 'B' THEN k8s.BasePrice*(1-(p.Discount1/100)) ELSE k8s.RetailPrice END AS CustomerPrice, CASE WHEN sp.Price > 0 THEN sp.Price WHEN sp.Discount1 > 0 AND sp.PriceBand = 'R' THEN k8s.RetailPrice*(1-(sp.Discount1/100)) WHEN sp.Discount1 > 0 AND sp.PriceBand = 'B' THEN k8s.BasePrice*(1-(sp.Discount1/100)) ELSE k8s.RetailPrice END AS CustomerSpecialPricePerProduct, CASE WHEN sl.Price > 0 THEN sl.Price WHEN sl.Discount1 > 0 AND sl.PriceBand = 'R' THEN k8s.RetailPrice*(1-(sl.Discount1/100)) WHEN sl.Discount1 > 0 AND sl.PriceBand = 'B' THEN k8s.BasePrice*(1-(sl.Discount1/100)) ELSE k8s.RetailPrice END AS CustomerSpecialPricePerPriceGroup, k8s.FreeStockBedford2011, k8s.FreeStockBirmingham2301, k8s.FreeStockWakefield2057, p.Discount1, p.Discount2, sp.Discount1, sp.Discount2, sl.Discount1, sl.Discount2, k8s.SourceK8orEsprit, k8s.StockistBranch, k8s.Photo1, k8s.RecommendedSalesMultiple, k8s.EspritStockRank, k8sa.Value AS Brand, CASE WHEN k8s.websortorder IS NULL THEN 1 ELSE 0 END, k8s.websortorder, COALESCE ( ( SELECT CASE WHEN Count(1) > 0 Then 1 else 0 End As [value] FROM FP_OFFERS FPO JOIN FP_OFFERSPRODUCTS FPOP ON FPO.OfferID = FPOP.OfferID INNER JOIN FP_OFFERGROUPS FPOG ON FPO.GroupID = FPOG.OfferGroupID WHERE FPOP.ProductCode = fpcm.StockCode AND (SYSDATETIME() AT TIME ZONE 'UTC' AT TIME ZONE 'GMT Standard Time' BETWEEN CONVERT(smalldatetime, FPOG.ActiveFromDate + ' ' + FPOG.ActiveFromTime) AND CONVERT(smalldatetime, FPOG.ActiveUntilDate + ' ' + FPOG.ActiveUntilTime)) ) ,0 ) AS OfferFound FROM FP_CATALOGUE_PRODUCT_MAPPING fpcm JOIN K8_STOCK k8s ON k8s.StockCode = fpcm.StockCode LEFT OUTER JOIN K8_CUSTOMERPRICING p ON k8s.WebCategoryToJoin = p.PriceGroup AND p.CustomerAccount = '' LEFT OUTER JOIN K8_SPECIALPRICING sp ON k8s.StockCode = sp.ProductCode AND sp.CustomerAccount = '' LEFT OUTER JOIN K8_SPECIALPRICING sl ON k8s.WebCategoryToJoin = sl.PriceGroup AND sl.CustomerAccount = '' LEFT OUTER JOIN PFP_STOCK_MESSAGES sm1 ON k8s.EspritStockRank = sm1.StockRank AND sm1.MessageTypeID = '1' LEFT OUTER JOIN PFP_STOCK_MESSAGES sm2 ON k8s.EspritStockRank = sm2.StockRank AND sm2.MessageTypeID = '2' LEFT OUTER JOIN PFP_STOCK_MESSAGES sm3 ON k8s.EspritStockRank = sm3.StockRank AND sm3.MessageTypeID = '3' LEFT OUTER JOIN PFP_STOCK_MESSAGES sm4 ON k8s.EspritStockRank = sm4.StockRank AND sm4.MessageTypeID = '4' LEFT JOIN K8_STOCK_ATTRIBUTES k8sa ON k8sa.StockCode = fpcm.StockCode WHERE k8s.Active = 'Y' AND k8s.SourceK8orEsprit = 'Primaflow' AND k8sa.AttributeID = '21' AND k8sa.Active = 'Y' AND fpcm.Active = 'Y' AND k8s.StockCode IN ('50080052' , '11732220' , '11732210' , '11732224' )UNION ALL SELECT DISTINCT fpcm.StockCode, k8s.WebDescription, k8s.WebCategoryToJoin AS PriceGroup, k8s.RetailPrice, k8s.BasePrice, k8s.SalePrice, p.CustomerAccount, k8s.K8LeadTime, fpcm.displayorder, sm1.MessageText AS StockMessage1, sm1.AllowOrder AS AllowOrder1, sm2.MessageText AS StockMessage2, sm2.AllowOrder AS AllowOrder2, sm3.MessageText AS StockMessage3, sm3.AllowOrder AS AllowOrder3, sm4.MessageText AS StockMessage4, sm4.AllowOrder AS AllowOrder4, CASE p.PriceBand WHEN 'R' THEN k8s.RetailPrice*(1-(p.Discount1/100)) WHEN 'B' THEN k8s.BasePrice*(1-(p.Discount1/100)) ELSE k8s.RetailPrice END AS CustomerPrice, CASE WHEN sp.Price > 0 THEN sp.Price WHEN sp.Discount1 > 0 AND sp.PriceBand = 'R' THEN k8s.RetailPrice*(1-(sp.Discount1/100)) WHEN sp.Discount1 > 0 AND sp.PriceBand = 'B' THEN k8s.BasePrice*(1-(sp.Discount1/100)) ELSE k8s.RetailPrice END AS CustomerSpecialPricePerProduct, CASE WHEN sl.Price > 0 THEN sl.Price WHEN sl.Discount1 > 0 AND sl.PriceBand = 'R' THEN k8s.RetailPrice*(1-(sl.Discount1/100)) WHEN sl.Discount1 > 0 AND sl.PriceBand = 'B' THEN k8s.BasePrice*(1-(sl.Discount1/100)) ELSE k8s.RetailPrice END AS CustomerSpecialPricePerPriceGroup, k8s.FreeStockBedford2011, k8s.FreeStockBirmingham2301, k8s.FreeStockWakefield2057, p.Discount1, p.Discount2, sp.Discount1, sp.Discount2, sl.Discount1, sl.Discount2, k8s.SourceK8orEsprit, k8s.StockistBranch, k8s.Photo1, k8s.RecommendedSalesMultiple, k8s.EspritStockRank, k8sa.Value AS Brand, CASE WHEN k8s.websortorder IS NULL THEN 1 ELSE 0 END, k8s.websortorder, COALESCE ( ( SELECT CASE WHEN Count(1) > 0 Then 1 else 0 End As [value] FROM FP_OFFERS FPO JOIN FP_OFFERSPRODUCTS FPOP ON FPO.OfferID = FPOP.OfferID INNER JOIN FP_OFFERGROUPS FPOG ON FPO.GroupID = FPOG.OfferGroupID WHERE FPOP.ProductCode = fpcm.StockCode AND (SYSDATETIME() AT TIME ZONE 'UTC' AT TIME ZONE 'GMT Standard Time' BETWEEN CONVERT(smalldatetime, FPOG.ActiveFromDate + ' ' + FPOG.ActiveFromTime) AND CONVERT(smalldatetime, FPOG.ActiveUntilDate + ' ' + FPOG.ActiveUntilTime)) ) ,0 ) AS OfferFound FROM FP_CATALOGUE_PRODUCT_MAPPING fpcm JOIN K8_STOCK k8s ON k8s.StockCode = fpcm.StockCode LEFT OUTER JOIN K8_CUSTOMERPRICING p ON k8s.WebCategoryToJoin = p.PriceGroup AND p.CustomerAccount = '' LEFT OUTER JOIN K8_SPECIALPRICING sp ON k8s.StockCode = sp.ProductCode AND sp.CustomerAccount = '' LEFT OUTER JOIN K8_SPECIALPRICING sl ON k8s.WebCategoryToJoin = sl.PriceGroup AND sl.CustomerAccount = '' LEFT OUTER JOIN PFP_STOCK_MESSAGES sm1 ON k8s.EspritStockRank = sm1.StockRank AND sm1.MessageTypeID = '1' LEFT OUTER JOIN PFP_STOCK_MESSAGES sm2 ON k8s.EspritStockRank = sm2.StockRank AND sm2.MessageTypeID = '2' LEFT OUTER JOIN PFP_STOCK_MESSAGES sm3 ON k8s.EspritStockRank = sm3.StockRank AND sm3.MessageTypeID = '3' LEFT OUTER JOIN PFP_STOCK_MESSAGES sm4 ON k8s.EspritStockRank = sm4.StockRank AND sm4.MessageTypeID = '4' LEFT JOIN K8_STOCK_ATTRIBUTES k8sa ON k8sa.StockCode = fpcm.StockCode WHERE k8s.Active = 'Y' AND k8s.SourceK8orEsprit = 'FP' AND k8sa.AttributeID = '21' AND k8sa.Active = 'Y' AND fpcm.Active = 'Y' AND k8s.StockCode IN ('50080052' , '11732220' , '11732210' , '11732224' )ORDER BY fpcm.DisplayOrder, CASE WHEN k8s.WebSortOrder IS NULL THEN 1 ELSE 0 END, k8s.WebSortOrder OFFSET (0) ROWS FETCH NEXT (4) ROWS ONLY Primaflow F&P
Boilers
Flues and Accessories
Heating
Radiators
Metal Plumbing
Plastic Plumbing
Packaged Products
Bathroom & Kitchen
Fires
Essentials
Renewables
Clearance
  1. Home
  2. Heating
  3. Pro
  4. Water Treatment
  5. 11732221
Pro 22mm Inline Magnetic Filter
Stock Code: 11732221

Please log in to see our current stock levels and your pricing.

Login to Your Account


If you are an existing customer and need a website login please request one here.

If you are a new customer please apply for an account.

Technical Information

  • Removes Iron Nickel and Cobalt particles from the water
  • Maximum 12,000 gauss surface magnetic field
  • Saves energy by up to 6% per annum
  • No extra operating costs for homeowner
  • Reduces carbon emissions
  • Extends heating system lifetime
  • Easy to service and install
EAN Code5051258067654
Sub-CategoryFilters
BrandPro
CategoryWater Treatment
TypeDomestic Filters
Technical Sheet Click here to download.
Installation Instructions Click here to download.
@@@MANUFACTURERGUARANTEETERMS@@@

Also Available

Product