For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "squbi three wheel scooter" has 26 results

Filter By

Current Filters

  1. Sales Name Red Tier 1 Remove This Item
  2. Supplier Name Shiner Remove This Item
Clear All

Category

  1. Skateboards14item
  2. Scooters9item
  3. Skates3item
  4. Longboards1 item
  5. Shoes2item
  6. Bundles23item
  7. SkateHut Sale11item
  8. Footwear2item
  9. Summer Sale1 item

Scooter Compression Type

  1. HIC2item
  2. SCS3item

Variant Width

  1. 129mm1 item
  2. 139mm1 item
  3. 149mm1 item
  4. 159mm2item
  5. 5"2item
  6. 5.5"1 item
  7. 8"1 item
  8. 8.25"2item

Channel Filters

  1. Allowed22item
  2. Excluded4item

Stock At Supplier

  1. No26item

Cross Sell Type

  1. Colour11item
  2. Width12item

Reporting Status

  1. Live24item
  2. Discontinued2item

In Magento

  1. Yes26item
  2. No2item

Use In Google Feed

  1. Yes26item
  2. No2item

B-Stock

  1. No26item

Own Brand?

  1. No26item

Channels Ready

  1. Yes26item

Purchaser

  1. Ricky25item

Google Feed Margin Cat

  1. z11 item
  2. z28item
  3. z318item

Order In Active

  1. No18item

Order In Product

  1. No25item

Export

  1. No21item

Has Identifier for GMC

  1. Yes26item

Export Common

  1. No21item

Best Suited to

  1. Hybrid2item

Skateboard Deck Randomiser

  1. No9item

Is for Gifting?

  1. No26item

Is Configurable Product

  1. Yes2item

Product Label Text

  1. 30% Off4item
  2. 35% Off2item
  3. 40% Off1 item
  4. 50% Off4item

Product Type Basic

  1. Heelys2item
  2. Skate Bearings1 item
  3. Skate Wheels1 item
  4. Scooter Collar Clamps1 item
  5. Scooter Compression Kits2item
  6. Scooter Decks2item
  7. Scooter Forks3item
  8. Skateboard Bearings1 item
  9. Skateboard Trucks13item

Heelys Collection

  1. Classic1 item
  2. Snazzy1 item

Is Simple Product

  1. Yes24item
  2. No2item

Department

  1. Footwear2item
  2. Roller Skates2item
  3. Scooters8item
  4. Skateboards14item

Price

  1. £0.00 - £24.998item
  2. £25.00 - £49.9911item
  3. £50.00 - £74.994item
  4. £75.00 and above3item

Brand Name

  1. Addict Scootering5item
  2. Blazer Pro3item
  3. Bones Bearings2item
  4. Bullet2item
  5. Grind King2item
  6. Heelys2item
  7. Independent5item
  8. Krux3item
  9. Sims1 item
  10. Sushi1 item

Number Of Wheels

  1. 22item

Product Type

  1. Footwear > Heelys2item
  2. Roller Skates > Bearings1 item
  3. Roller Skates > Wheels1 item
  4. Scooters > Collar Clamps1 item
  5. Scooters > Compression Kits2item
  6. Scooters > Decks2item
  7. Scooters > Forks3item
  8. Skateboards > Bearings1 item
  9. Skateboards > Trucks13item

Main Colour

  1. Black8item
  2. Multi3item
  3. Neochrome1 item
  4. Raw2item
  5. Red3item
  6. Silver8item
  7. White1 item

Deck Type

  1. Integrated1 item

Scooter Bar Compatibility

  1. Fits Oversized Bars Fits Standard Bars3item

Scooter Clamp Type

  1. Collar Clamp + Shim1 item
  2. SCS Compression2item

Scooter Fork Type

  1. Fork For Small Wheels HIC1 item
  2. Fork For 120mm Wheels HIC1 item
  3. Fork For 120mm Wheels SCS1 item

Truck Width

  1. 110mm1 item
  2. 129mm1 item
  3. 139mm1 item
  4. 149mm1 item
  5. 159mm2item
  6. 185mm1 item
  7. 5"1 item
  8. 5.5"1 item
  9. 8.25"1 item

Shoe Size

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

Skateboard Truck Height

  1. Low - Wheels < 53mm5item
  2. Mid - Wheels 53-56mm8item

Scooter Deck Type

  1. Integrated 120mm2item

Skateboard Deck Width Suitability

  1. 6.65"1 item
  2. 6.75"1 item
  3. 7"1 item
  4. 7.12"1 item
  5. 7.15"1 item
  6. 7.4"1 item
  7. 7.5"3item
  8. 7.6"3item
  9. 7.75"4item
  10. 7.8"5item
  11. 7.85"3item
  12. 7.88"3item
  13. 7.9"3item
  14. 8"6item
  15. 8.1"5item
  16. 8.12"5item
  17. 8.2"5item
  18. 8.25"4item
  19. 8.38"1 item
  20. 8.4"1 item
  21. 8.5"1 item
  22. 8.6"3item
  23. 8.62"2item
  24. 8.68"2item
  25. 8.7"2item
  26. 8.75"2item
  27. 8.82"2item
  28. 8.85"2item
  29. 8.9"2item
  30. 9"2item
  31. 9.5"1 item
  32. 9.62"1 item
  33. 9.75"1 item
  34. 10"1 item
  35. 10.5"1 item
  36. 7.875"2item
  37. 8.125"3item
  38. 8.375"1 item

Skateboard Truck Hanger Width

  1. 110mm1 item
  2. 129mm1 item
  3. 139mm1 item
  4. 149mm1 item
  5. 159mm2item
  6. 185mm1 item
  7. 5.0"2item
  8. 5.5"1 item
  9. 8.0"1 item
  10. 8.25"2item

Gender

  1. Unisex2item

Vegan

  1. No26item

Deck Length

  1. 21"1 item
  2. 22"1 item

Deck Width

  1. 5.1"2item

Age Group

  1. Kids2item

Abec Rating

  1. Skate Rated2item

Skate Wheel Size

  1. 62mm1 item

Material Primary

  1. Aluminium3item
  2. Canvas1 item
  3. Synthetic1 item

Builder Part

  1. Yes20item
  2. No3item
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 (126678, 279110, 102044, 276222, 276219, 132331, 132394, 132393, 101742, 163463, 111474, 150785, 154087, 269833, 269835, 111768, 111786, 111790, 137604, 112519, 112612, 111737, 111767, 111784)) ORDER BY FIELD(e.entity_id,126678,279110,102044,276222,276219,132331,132394,132393,101742,163463,111474,150785,154087,269833,269835,111768,111786,111790,137604,112519,112612,111737,111767,111784)

Showing 24 out of 26

Page