For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "jd bug junior street scooter" has 24 results

Filter By

Current Filters

  1. Foldable? No Remove This Item
  2. Number Of Wheels 2 Remove This Item
Clear All

Category

  1. Bundles15item
  2. SkateHut Sale14item
  3. Black Friday Deals2item

Height Adjustable?

  1. No24item

Sales Name

  1. Reduction6item
  2. Price Match5item
  3. Red Tier 21 item

Channel Filters

  1. Allowed24item

Stock At Supplier

  1. No24item

Cross Sell Type

  1. Colour21item

Reporting Status

  1. Live24item

In Magento

  1. Yes24item

Use In Google Feed

  1. Yes24item

B-Stock

  1. No24item

Own Brand?

  1. No24item

Channels Ready

  1. Yes23item
  2. No1 item

Purchaser

  1. Billy2item
  2. Tony18item

Country Of Origin

  1. China2item

Google Feed Margin Cat

  1. z11 item
  2. z23item
  3. z320item

Order In Active

  1. No24item

Order In Product

  1. No24item

Export

  1. No24item

Has Identifier for GMC

  1. Yes24item

Export Common

  1. No24item

Supplier Name

  1. Core2item
  2. J&R18item
  3. Onecall2item
  4. Stateside1 item
  5. Yvolve1 item

Scooter Type

  1. Adult/Commuter Scooter1 item
  2. Dirt Scooter2item
  3. Kids Scooter21item
  4. Light Up Wheel2item
  5. Stunt Scooter1 item

Is for Gifting?

  1. No24item

Scooter Bar Height

  1. Adjustable20item
  2. 650mm2item
  3. 845mm2item

Scooter Height

  1. 845mm7item
  2. 870mm6item
  3. 880mm2item
  4. 910mm1 item
  5. 915mm2item
  6. 950mm5item
  7. 1160mm1 item

Skill Level

  1. Beginner1 item

Product Type Basic

  1. Scooters - Commuter2item
  2. Scooters - Dirt Scooters2item
  3. Scooters - Folding20item

Is Simple Product

  1. Yes24item

Department

  1. Scooters24item

Price

  1. £25.00 - £49.9920item
  2. £50.00 - £74.991 item
  3. £100.00 and above1 item

Brand Name

  1. Blunt Envy2item
  2. Core2item
  3. Frenzy1 item
  4. JD Bug18item
  5. Neon1 item

Product Type

  1. Scooters > Commuter Completes2item
  2. Scooters > Dirt Completes2item
  3. Scooters > Folding Completes20item

Main Colour

  1. Black9item
  2. Blue6item
  3. Multi1 item
  4. Pink3item
  5. Purple2item
  6. Red2item
  7. White1 item

Scooter Wheel Size

  1. 100mm7item
  2. 120mm13item
  3. 200mm1 item
  4. 230mm1 item
  5. 200mm1 item
  6. 150mm1 item

Gender

  1. Unisex18item

Vegan

  1. No24item

Age

  1. 4 to 61 item
  2. 6 to 88item
  3. 8 to 1216item
  4. 10 +23item
  5. 5 +1 item

Scooter Height

  1. 50cm - 75cm6item
  2. 68cm - 85cm14item
  3. 80cm - 90cm22item
  4. 90cm and over8item

Age Group

  1. Kids20item

Scooter Rider Height Range

  1. 90cm - 125cm6item
  2. 125cm - 150cm14item
  3. 150cm - 170cm22item
  4. 170cm and over8item
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.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 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')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (98845, 98846, 98847, 98848, 98849, 98850, 127036, 98839, 98840, 98841, 98842, 98843, 98851, 98852, 98853, 98854, 99167, 99168, 356092, 356094, 98898, 98831, 329916, 329917)) ORDER BY FIELD(e.entity_id,98845,98846,98847,98848,98849,98850,127036,98839,98840,98841,98842,98843,98851,98852,98853,98854,99167,99168,356092,356094,98898,98831,329916,329917)

24 Items