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 ('299198PB' , '299201CS' , '299201WS' , '299201HG' )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 ('299198PB' , '299201CS' , '299201WS' , '299201HG' )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. Bathroom & Kitchen
  3. Grohe
  4. Showers
  5. 299201ss
Euphoria SmartControl Shower System - 310mm Head Supersteel
Stock Code: 299201SS
Manufacturers Stock Code: 26507DC0

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

  • GROHE SmartControl: intuitive operation at the push of a button
  • Set water temperature instantly and reliably with GROHE TurboStat
  • For a super-safe surface that’s cool to the touch
  • GROHE SafeStop (Plus) – scalding protection at 38°C and (optional) 43°C
  • GROHE Water Saving technology for reduced consumption
  • Easy to clean and scratch-resistant thanks to the GROHE StarLight coating
  • Fit your cool new shower fast without damaging the tiles
  • Integrated EasyReach tray keeps shower products to hand
  • GROHE DreamSpray delivers showering luxury for every spray pattern
  • GROHE PureRain spray: super soft, like warm summer rain
Manufacturer Stock Code26507DC0
EAN Code4005176526374
Sub-CategoryMixer Showers
ColourSupersteel
BrandGrohe
RangeEuphoria
CategoryShowers
RoomBathroom
TypeExposed
@@@MANUFACTURERGUARANTEETERMS@@@

Also Available

Product