For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Reporting Status Live Remove This Item
  2. Abec Rating Unrated Remove This Item
Clear All

Category

  1. Scooters1 item
  2. Skates8item
  3. Brands9item
  4. Bundles3item
  5. Clearance2item
  6. New Arrivals2item
  7. SkateHut Sale3item

Foldable?

  1. No1 item

Height Adjustable?

  1. No1 item

Kick Stand?

  1. No1 item

Light Brake?

  1. No1 item

Light Front?

  1. No1 item

Light Rear?

  1. No1 item

Material Secondary

  1. Aluminium1 item

Regenerative Breaking?

  1. No1 item

Sales Name

  1. Price Match2item
  2. B-Stock2item

Variant Size

  1. Size - Junior UK 11 (EU 29)2item
  2. Size - Junior UK 12 (EU 30)3item
  3. Size - Junior UK 13 (EU 31.5)2item
  4. Size - UK 1 (EU 33)2item
  5. Size - UK 2 (EU 34)2item
  6. Size - UK 3 (EU 35)2item

Channel Filters

  1. Allowed4item
  2. Excluded7item

Stock At Supplier

  1. Yes5item
  2. No11item

Cross Sell Type

  1. Colour6item

In Magento

  1. Yes8item
  2. No10item

Use In Google Feed

  1. Yes9item
  2. No10item

B-Stock

  1. Yes2item
  2. No9item

B-Stock Condition

  1. [Box Damage]2item

Own Brand?

  1. No11item

Channels Ready

  1. Yes9item
  2. No2item

Purchaser

  1. Tony3item

Google Feed Margin Cat

  1. z11 item
  2. z25item
  3. other5item

Order In Active

  1. No10item

Order In Active Shipping Group

  1. Order in - 5 day leadtime6item

Order In Product

  1. Yes5item
  2. No11item

Export

  1. No10item

Has Identifier for GMC

  1. Yes3item
  2. No8item

Export Common

  1. No10item

Supplier Name

  1. Centrano1 item
  2. J&R10item

Is for Gifting?

  1. No11item

Is Configurable Product

  1. Yes2item

Product Label Text

  1. 15% Off2item

Product Type Basic

  1. Inline Skates - Rollerblades7item
  2. Roller Skates3item
  3. Scooter Bearings1 item

Is Simple Product

  1. Yes3item
  2. No8item

Department

  1. Inline Skates7item
  2. Roller Skates3item
  3. Scooters1 item

Price

  1. £0.00 - £24.991 item
  2. £25.00 - £49.993item
  3. £150.00 - £174.992item
  4. £275.00 and above5item

Brand Name

  1. North Scooters1 item
  2. Roller Derby3item
  3. SEBA1 item
  4. FR Skates6item

Product Type

  1. Inline Skates > Roller Blades7item
  2. Roller Skates > Completes3item
  3. Scooters > Bearings1 item

Main Colour

  1. Black5item
  2. Blue2item
  3. Red1 item
  4. Teal2item
  5. White1 item

Skate Type

  1. Quad1 item

Shoe Size

  1. Size - Junior UK 11 (EU 29)2item
  2. Size - Junior UK 12 (EU 30)3item
  3. Size - Junior UK 13 (EU 31.5)2item
  4. Size - UK 1 (EU 33)2item
  5. Size - UK 2 (EU 34)2item
  6. Size - UK 3 (EU 35)2item
  7. Size - UK 4 (EU 37)2item
  8. Size - UK 5 (EU 38)3item
  9. Size - UK 6 (EU 39)6item
  10. Size - UK 6.5 (EU 39.5)5item
  11. Size - UK 7 (EU 41)6item
  12. Size - UK 8 (EU 42)6item
  13. Size - UK 9 (EU 43)5item
  14. Size - UK 9.5 (EU 43.5)5item
  15. Size - UK 10 (EU 44)4item
  16. Size - UK 11 (EU 46)4item
  17. Size - UK 12 (EU 47)4item

Gender

  1. Unisex10item

Vegan

  1. No11item

Skate Type Boot

  1. Hard Boot7item
  2. Soft Boot3item

Skate Suitability

  1. Indoor3item
  2. Outdoor10item

Age Group

  1. Adult7item
  2. Kids3item

Skate Plate Construction

  1. Plastic3item

Skate Closure System

  1. Lacing10item
  2. Velcro6item
  3. Buckle7item

Size Adjustable?

  1. No10item

Durometer Rating

  1. 83a3item
  2. 84a5item
  3. 85a2item

Adjustable Stopper?

  1. No4item

Light-up Wheels?

  1. No4item

Skate Wheel Size

  1. 54mm3item
  2. 80mm7item

Material Primary

  1. Mesh3item
  2. Plastic7item

Skate Wheel Width

  1. 28mm3item
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 (407056, 380375, 408187, 379736, 379769, 379802, 379835, 379610, 119343, 119344, 310145)) ORDER BY FIELD(e.entity_id,407056,380375,408187,379736,379769,379802,379835,379610,119343,119344,310145)

11 Items