Email Us  01483 267676 Contact Us
Latest News  

 Adventure Bikes

Showing: 1–3 of 3 items
From £51.89 per month on finance
Trek                           920

Trek 920

£1600.00

From £55.34 per month on finance
Trek                           1120

Trek 1120

£2399.00

From £82.98 per month on finance

SELECT *, ((rrp-sale_price)/rrp)*100 as percentage FROM products WHERE deleted=0 AND active=1 AND category_level_1 = 'Bikes' AND (category_level_2 ='Adventure') AND (stock>=1 OR warehouse_stock>=1) GROUP BY linked_id, colour ORDER BY rrp ASC LIMIT 0, 30