Search
tel. 02034415298
Shopping Cart
your cart is empty
CycleScheme.co.uk
Logo
Gazelle Bikes 2012
‹ back
HOME  ›  Bicycles  ›  Gazelle Bikes 2012  › 
ladies | men | special
  • Roller brake(25)
  • Shimano V-rim brake(22)
  • Shimano Deore LX V-rim brake(11)
  • More...
  • Magura HS-11 Hydraulic rim brake(10)
  • V-brake(9)
  • Shimano Ultegra brake unit(7)
  • Shimano XT V-rim brake(6)
  • Shimano Deore V-rim brake(5)
  • Koga(4)
  • Roller Brake(3)
  • Shimano SLX disc brake(2)
  • Coaste Brake(1)
  • Less...
  • Solid(33)
  • Suspension(6)
  • sprung with 50 mm spring travel and adjustable tension(4)
  • More...
  • Solid Cr-Mo(3)
  • Rigid(1)
  • Less...
  • Hub dynamo(54)
  • -(21)
  • Hub Dynamo(19)
  • More...
  • Hub(8)
  • Battery(5)
  • Shimano Nexus(3)
  • Classic(2)
  • No. Battery Light.(1)
  • Less...

connect set charset utf8; SELECT `cms_menu`.* FROM `cms_menu` WHERE (active=1) AND (lang='en') ORDER BY `priority` ASC SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `t`.`id`, `t`.`file`, `t`.`template`, `t`.`parent_id`, `t`.`priority`, `t`.`discount`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`meta_title`, `c`.`meta_description`, `c`.`meta_keywords` FROM `cms_products_categories` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='productscategories' and c.lang='en' WHERE (t.active=1) AND (c.active=1) ORDER BY `t`.`priority` ASC SELECT `t`.`id`, `t`.`file`, `t`.`add_date`, `t`.`recommend`, `t`.`template`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_pages` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='pages' and c.lang='en' WHERE (t.id='21') AND (t.active=1) SELECT `cms_cache`.* FROM `cms_cache` SELECT `t`.`id`, `t`.`file`, `t`.`template`, `t`.`parent_id`, `t`.`priority`, `t`.`discount`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`meta_title`, `c`.`meta_description`, `c`.`meta_keywords` FROM `cms_products_categories` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='productscategories' and c.lang='en' WHERE (t.active=1) AND (c.active=1) ORDER BY `t`.`priority` ASC SELECT `t`.`id`, `t`.`identifier`, `t`.`priority`, `t`.`active`, `c`.`title`, `c`.`description`, `c`.`niceurl`, `c`.`visits`, `c`.`meta_title`, `c`.`meta_keywords`, `c`.`meta_description` FROM `cms_parameters` AS `t` LEFT JOIN `cms_content` AS `c` ON c.controller_item_id=t.id and c.controller='parameters' and c.lang='en' WHERE (t.active=1) SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='24') SELECT `c`.* FROM `cms_products_categories` AS `c` WHERE (c.id='40') SELECT `c`.`id`, `c`.`parent_id` FROM `cms_products_categories` AS `c` WHERE (c.id=24) SELECT `c`.`id`, `c`.`parent_id` FROM `cms_products_categories` AS `c` WHERE (c.id=40) SELECT `p`.`id`, `p`.`file`, `p`.`price`, `p`.`genre`, `p`.`last_price`, `p`.`price_eur`, `p`.`outside_b2b`, `p`.`outside_img`, `ptc`.`products_categories_id`, `pc`.`discount`, `c`.`title`, `c`.`niceurl` FROM `cms_products` AS `p` INNER JOIN `cms_products_to_categories` AS `ptc` LEFT JOIN `cms_products_categories` AS `pc` ON ptc.id=ptc.products_categories_id=pc.id LEFT JOIN `cms_products_desc` AS `c` ON c.products_id=p.id and c.lang='en' WHERE (ptc.products_categories_id='24') AND (p.id=ptc.products_id) AND (p.active=1) ORDER BY `ptc`.`priority` asc, `p`.`price` desc, `p`.`add_date` desc