SELECT * FROM [dbo].[K8_STOCK] WHERE StockCode IN ('353236PO' , '61020247' , '61020150' , '62065214' )ORDER BY CASE WHEN StockCode = '353236PO' THEN 0 WHEN StockCode = '61020247' THEN 1 WHEN StockCode = '61020150' THEN 2 WHEN StockCode = '62065214' THEN 3 ELSE 4 END
Please log in to see our current stock levels and your pricing.
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.
| Manufacturer Stock Code | 311635/SP |
| EAN Code | 5060218367338 |
| Sub-Category | DocM |
| Colour | Metal Effect |
| Brand | Fresssh |
| Range | Luxury |
| Category | Sanitaryware |
| Room | Bathroom |
| Type | Grab Rails |
| Product | ||
|---|---|---|