For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Skate Suitability Outdoor Remove This Item
  2. Age Group Adult Remove This Item
Clear All

Category

  1. Skates16item
  2. Brands16item
  3. Bundles8item
  4. Clearance1 item
  5. New Arrivals2item
  6. SkateHut Sale6item

Material Secondary

  1. Aluminium1 item

Sales Name

  1. Clearance1 item
  2. Price Match2item
  3. B-Stock1 item

Shoe Size Adjustable

  1. Junior UK 11 - UK 11 item
  2. UK 1 - UK 41 item

Shoe Size Multi

  1. Size - Junior UK 11 (EU 29)1 item
  2. Size - Junior UK 11.5 (EU 29.5)1 item
  3. Size - Junior UK 12 (EU 30)1 item
  4. Size - Junior UK 12.5 (EU 31)1 item
  5. Size - Junior UK 13 (EU 31.5)1 item
  6. Size - Junior UK 13.5 (EU 32)1 item
  7. Size - UK 1 (EU 33)2item
  8. Size - UK 1.5 (EU 33.5)1 item
  9. Size - UK 2 (EU 34)1 item
  10. Size - UK 2.5 (EU 34.5)1 item
  11. Size - UK 3 (EU 35)1 item
  12. Size - UK 3.5 (EU 36)1 item
  13. Size - UK 4 (EU 37)1 item

Variant Size

  1. Size - Junior UK 11 (EU 29)1 item
  2. Size - Junior UK 13 (EU 31.5)3item
  3. Size - UK 1 (EU 33)4item
  4. Size - UK 2 (EU 34)3item
  5. Size - UK 3 (EU 35)3item
  6. Size - UK 4 (EU 37)3item
  7. Size - UK 5 (EU 38)2item
  8. Size - UK 6 (EU 39)3item
  9. Size - UK 7 (EU 41)3item
  10. Size - UK 8 (EU 42)2item

Channel Filters

  1. Allowed9item
  2. Excluded8item

Stock At Supplier

  1. Yes7item
  2. No17item

Cross Sell Type

  1. Colour11item

Reporting Status

  1. Live17item

In Magento

  1. Yes12item
  2. No15item

Use In Google Feed

  1. Yes16item
  2. No17item

B-Stock

  1. Yes1 item
  2. No16item

B-Stock Condition

  1. [Box Damage]1 item

Own Brand?

  1. No17item

Channels Ready

  1. Yes16item
  2. No1 item

Purchaser

  1. Billy5item

Google Feed Margin Cat

  1. z11 item
  2. z26item
  3. z32item
  4. other7item

Order In Active

  1. No13item

Order In Active Shipping Group

  1. Order in - 5 day leadtime8item

Order In Product

  1. Yes7item
  2. No14item

Export

  1. No13item

Has Identifier for GMC

  1. Yes5item
  2. No12item

Export Common

  1. No13item

Supplier Name

  1. Centrano1 item
  2. J&R9item
  3. Stateside5item
  4. Kaltik2item

Is for Gifting?

  1. No17item

Is Configurable Product

  1. Yes5item

Product Label Text

  1. 30% Off1 item
  2. 35% Off1 item
  3. 8% Off1 item

Product Type Basic

  1. Inline Skates - Adjustable2item
  2. Inline Skates - Aggressive3item
  3. Inline Skates - Rollerblades9item
  4. Roller Skates3item

Is Simple Product

  1. Yes2item
  2. No16item

Department

  1. Inline Skates14item
  2. Roller Skates3item

Price

  1. £25.00 - £49.992item
  2. £50.00 - £74.993item
  3. £150.00 - £174.992item
  4. £175.00 - £199.991 item
  5. £225.00 - £249.993item
  6. £250.00 - £274.991 item
  7. £275.00 and above5item

Brand Name

  1. Kaltik2item
  2. Rio Roller3item
  3. Roces1 item
  4. SEBA3item
  5. SFR2item
  6. FR Skates6item

Product Type

  1. Inline Skates > Adjustable Roller Blades2item
  2. Inline Skates > Aggressive Skates3item
  3. Inline Skates > Roller Blades9item
  4. Roller Skates > Completes3item

Main Colour

  1. Black8item
  2. Blue3item
  3. Green2item
  4. Navy1 item
  5. Red1 item
  6. White2item

Shoe Size

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

Gender

  1. Male5item
  2. Unisex12item

Vegan

  1. Yes3item
  2. No14item

Skate Type Boot

  1. Hard Boot10item
  2. Soft Boot7item

Skate Plate Construction

  1. Plastic3item

Skate Closure System

  1. Lacing15item
  2. Velcro5item
  3. Buckle14item

Abec Rating

  1. ABEC 53item
  2. ABEC 75item
  3. ABEC 92item
  4. Unrated7item

Size Adjustable?

  1. Yes2item
  2. No15item

Durometer Rating

  1. 82a6item
  2. 84a5item
  3. 85a4item
  4. 88a2item

Adjustable Stopper?

  1. No4item

Light-up Wheels?

  1. No4item

Skate Wheel Size

  1. 58mm3item
  2. 60mm2item
  3. 62mm3item
  4. 64mm1 item
  5. 70mm1 item
  6. 76mm1 item
  7. 80mm9item

Material Primary

  1. Faux Suede3item
  2. Leather2item
  3. Plastic11item
  4. PU1 item

Skate Wheel Width

  1. 33mm3item
  2. 36mm3item
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 (173841, 173840, 379211, 379649, 380375, 408187, 394325, 379736, 379769, 379802, 379835, 409499, 409754, 379610, 119335, 119326, 119327)) ORDER BY FIELD(e.entity_id,173841,173840,379211,379649,380375,408187,394325,379736,379769,379802,379835,409499,409754,379610,119335,119326,119327)

17 Items