SELECT p.id, p.name, p.code, p.description, p.product_group, p.image, p.image_gallery, p.size_chart, p.visible, p.insert_date, g.group_title, c.pdf_path FROM product p INNER JOIN product_group g ON g.id = p.product_group LEFT JOIN size_chart c ON p.size_chart = c.id WHERE p.id = 36 Route One Solutions /Track Bottoms / Bespoke Clothing for Sports Clubs, Teams and Corporate Customers

Track Bottoms

Stock Garments...Track Bottoms...Showerproof Pants
Showerproof Pants
C1
105gsm pu coated lightweight polyester dobby textured fabric Soft hand feel jersey lining Elasticated waist with drawcord Concealed hem cord system and zip side pockets 2 colour options Kids and adult sizes
Get a Quote Now
View Size Chart
©2021  | Designed by Shedload Creative