Email Us  01483 267676 Contact Us
Latest News  

 Fitness Bikes

Showing: 1–30 of 36 items
Trek                           FX 1

Trek FX 1

£375.00

From £12.97 per month on finance
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
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 £15.57 per month on finance
Trek                           FX 2 Disc

Trek FX 2 Disc

£450.00

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
Trek                           DS 2

Trek DS 2

£500.00

From £17.30 per month on finance
From £17.30 per month on finance
From £19.02 per month on finance
From £19.02 per month on finance
From £19.02 per month on finance
Trek                           FX 3

Trek FX 3

£550.00

From £19.02 per month on finance
Trek                           FX 3

Trek FX 3

£550.00

From £19.02 per month on finance
From £19.02 per month on finance
From £20.75 per month on finance
From £21.62 per month on finance
From £21.62 per month on finance
From £21.62 per month on finance
From £22.14 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