Youth & Kids Bikes

Youth & Kids Bikes

28 Items

per page
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE ((e.entity_id IN (495435, 495432, 495417, 495414, 495408, 495411, 495429, 495402, 495405, 504517, 495426, 504652, 504661, 495399, 495396, 495390, 495393, 469531, 504631, 495387, 495384, 467353, 474180, 504505, 504619, 504613, 504502, 504616))) AND (e.created_in '1627772401') ORDER BY FIELD(e.entity_id,495435,495432,495417,495414,495408,495411,495429,495402,495405,504517,495426,504652,504661,495399,495396,495390,495393,469531,504631,495387,495384,467353,474180,504505,504619,504613,504502,504616)
  1. Dimension 26

    Ridgeback Dimension 26

    £529.99
     
  2. Dimension 24

    Ridgeback Dimension 24

    £489.99
     
  3. Mx26

    Ridgeback Mx26

    £469.99
     
  4. Serenity

    Ridgeback Serenity

    £469.99
    Out of stock
  5. Destiny

    Ridgeback Destiny

    £449.99
     
  6. Mx24

    Ridgeback Mx24

    £449.99
    Out of stock
  7. Dimension 20

    Ridgeback Dimension 20

    £449.99
    Out of stock
  8. Best Seller
    Harmony

    Ridgeback Harmony

    £379.99
     
  9. Mx20

    Ridgeback Mx20

    £379.99
    Out of stock
  10. Dimension 16

    Ridgeback Dimension 16

    £369.99
     
  11. Best Seller
    Mx16

    Ridgeback Mx16

    £259.99
     
  12. Melody

    Ridgeback Melody

    £259.99
     
  13. Honey

    Ridgeback Honey

    £229.99
     
  14. Best Seller
    Mx14

    Ridgeback Mx14

    £229.99
    Out of stock
  15. Best Seller
    2020 Mx14

    Ridgeback 2020 Mx14

    From £219.99
     
  16. Best Seller
    Scoot XL

    Ridgeback Scoot XL

    £159.99
     
  17. New
    Scoot

    Ridgeback Scoot

    £149.99
     
  18. Scoot XL

    Ridgeback Scoot XL

    £139.99
     
  19. Best Seller
    Scoot

    Ridgeback Scoot

    From £129.99