Tranemo 2921 50 Trousers - (Navy)

Tranemo 2921 50 Trousers - (Navy)

Details
Price €45.50
Add to Cart:

Model: JS BTR23PC
Units in Stock4

Tranemo 2921 50 Trousers - Navy

Quality: 65% polyester / 35% cotton, comfort finish, 300 g/m² 
Triple stitched for ultimate strength. Side pockets with extra strong lining. Hip pockets, one with flap. Double ruler pocket. Cargo pocket with mobile phone and pen pocket. Knee pad pockets with height adjustments.

Sizes: 28"-50"R, 30"-40"T, 34"-48"S
Leg Size: 33" - 312 - 28"

Product Code: 
JS BTR23PC Navy

Customers please confirm your sizes during the payment process.

Our price includes..

- Free Shipping
- Direct to your door
- Anywhere on the island of Ireland

Order Online Now!



This product was added to our catalog on Saturday 07 January, 2012.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'justshop_jshop.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1073' and opa.orders_id = opb.orders_id and opb.products_id != '1073' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]