For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Age Group Kids Remove This Item
  2. Size Adjustable? No Remove This Item
Clear All

Category

  1. Skates54item
  2. Brands54item
  3. Bundles52item
  4. Clearance5item
  5. SkateHut Sale31item

Foldable?

  1. No3item

Height Adjustable?

  1. No3item

Kick Stand?

  1. No3item

Light Brake?

  1. No3item

Light Front?

  1. No3item

Light Rear?

  1. No3item

Regenerative Breaking?

  1. No3item

Sales Name

  1. Reduction2item
  2. Clearance1 item
  3. Price Match21item
  4. Red Tier 21 item
  5. B-Stock4item

Variant Size

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

Channel Filters

  1. Allowed41item
  2. Excluded19item
  3. Ebay Only2item

Stock At Supplier

  1. Yes17item
  2. No59item

Cross Sell Type

  1. Colour52item
  2. Size1 item

Reporting Status

  1. Live59item
  2. Discontinued1 item

In Magento

  1. Yes56item
  2. No42item

Use In Google Feed

  1. Yes54item
  2. No59item

B-Stock

  1. Yes4item
  2. No55item

B-Stock Condition

  1. [Box Damage]4item
  2. [Pre-Owned]1 item

Own Brand?

  1. Yes3item
  2. No56item

Channels Ready

  1. Yes40item
  2. No20item

Purchaser

  1. Billy26item
  2. Ricky2item
  3. Tony18item
  4. Own Brand3item

Google Feed Margin Cat

  1. z126item
  2. z227item
  3. z333item
  4. other2item

Order In Active

  1. Yes17item
  2. No43item

Order In Active Shipping Group

  1. Order in - 5 day leadtime18item
  2. Order in - 2-4 day leadtime2item

Order In Product

  1. Yes17item
  2. No59item

Export

  1. No56item

Has Identifier for GMC

  1. Yes58item
  2. No2item

Export Common

  1. No56item

Supplier Name

  1. Centrano1 item
  2. J&R27item
  3. Shiner2item
  4. Skatehut3item
  5. Stateside26item

Is for Gifting?

  1. No59item

Is Configurable Product

  1. Yes55item

Product Label Text

  1. 30% Off7item
  2. 60% Off2item
  3. 15% Off4item
  4. 6% Off3item
  5. 8% Off1 item
  6. 54% Off1 item
  7. 11% Off1 item

Product Type Basic

  1. Roller Skates59item

Is Simple Product

  1. Yes12item
  2. No54item

Department

  1. Roller Derby1 item
  2. Roller Skates58item

Price

  1. £0.00 - £24.991 item
  2. £25.00 - £49.9920item
  3. £50.00 - £74.9919item
  4. £75.00 - £99.994item
  5. £125.00 - £149.991 item
  6. £175.00 - £199.995item
  7. £200.00 - £224.991 item
  8. £425.00 and above8item

Brand Name

  1. Candi Girl2item
  2. LMNADE3item
  3. Moxi16item
  4. Riedell2item
  5. Rio Roller15item
  6. Roces1 item
  7. Roller Derby7item
  8. Rookie2item
  9. SFR11item

Product Type

  1. Roller Derby > Roller Derby Skates1 item
  2. Roller Skates > Completes59item

Main Colour

  1. Black15item
  2. Blue5item
  3. Cream1 item
  4. Green6item
  5. Navy1 item
  6. Orange1 item
  7. Pink8item
  8. Purple6item
  9. Red2item
  10. Teal4item
  11. White7item
  12. Yellow4item

Skate Type

  1. Quad3item

Shoe Size

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

Gender

  1. Female26item
  2. Male16item
  3. Unisex29item

Vegan

  1. Yes15item
  2. No44item

Skate Type Boot

  1. Soft Boot58item

Skate Suitability

  1. Indoor41item
  2. Outdoor47item
  3. Indoor/Outdoor10item

Skate Plate Construction

  1. Plastic48item
  2. Aluminium11item

Skate Closure System

  1. Lacing58item
  2. Velcro21item

Abec Rating

  1. ABEC 525item
  2. ABEC 717item
  3. Skate Rated12item
  4. Unrated4item

Durometer Rating

  1. 78a13item
  2. 82a35item
  3. 83a7item
  4. 85a1 item
  5. 95a1 item
  6. 96a1 item

Adjustable Stopper?

  1. Yes21item
  2. No38item

Light-up Wheels?

  1. No59item

Skate Wheel Size

  1. 53mm7item
  2. 54mm16item
  3. 57mm1 item
  4. 58mm29item
  5. 62mm9item
  6. 65mm8item
  7. 66mm2item

Material Primary

  1. Canvas1 item
  2. Faux Leather15item
  3. Faux Suede13item
  4. Mesh7item
  5. Suede2item
  6. Synthetic1 item
  7. Vinyl18item
  8. PU1 item

Skate Wheel Width

  1. 28mm7item
  2. 30mm11item
  3. 32mm19item
  4. 33mm15item
  5. 35mm8item
  6. 36mm8item
  7. 38mm2item
  8. 43mm1 item
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 (153278, 134407, 153277, 119331, 119340, 119343, 119344, 119345, 119346, 396875, 405847, 119360, 119361, 119362, 119363, 119367, 119368, 153280, 279615, 289610, 119326, 119327, 119335, 381527)) ORDER BY FIELD(e.entity_id,153278,134407,153277,119331,119340,119343,119344,119345,119346,396875,405847,119360,119361,119362,119363,119367,119368,153280,279615,289610,119326,119327,119335,381527)

Showing 24 out of 59

Page