Email Us  01483 267676 Contact Us
Latest News  

 Fitness Bikes

Showing: 1–30 of 61 items
From £12.80 per month on finance
From £12.97 per month on finance
Trek                           FX 1

Trek FX 1

£375.00

From £12.97 per month on finance
From £13.84 per month on finance
From £13.84 per month on finance
From £13.84 per month on finance
Trek                           FX 2

Trek FX 2

£400.00

From £13.84 per month on finance
From £13.84 per month on finance
From £13.84 per month on finance
Trek                           FX 2

Trek FX 2

£400.00

From £13.84 per month on finance
From £13.84 per month on finance
From £13.84 per month on finance
From £14.35 per month on finance
From £14.70 per month on finance
From £14.70 per month on finance
From £14.70 per month on finance
From £15.57 per month on finance
From £15.57 per month on finance
Trek                           FX 2 Disc

Trek FX 2 Disc

£450.00

From £15.57 per month on finance
From £15.57 per month on finance
From £16.43 per month on finance
From £16.43 per month on finance
From £16.43 per month on finance
From £16.43 per month on finance
From £16.43 per month on finance
Trek                           DS 2

Trek DS 2

£500.00

From £17.30 per month on finance
From £17.30 per month on finance
From £18.16 per month on finance
From £18.16 per month on finance
From £19.02 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 ='Fitness') AND (stock>=1 OR warehouse_stock>=1) GROUP BY linked_id, colour ORDER BY rrp ASC LIMIT 0, 30