For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Purchaser Tony Remove This Item
  2. Brand Name Root Industries Remove This Item
Clear All

Category

  1. Scooters46item
  2. Accessories1 item
  3. More1 item
  4. Brands46item
  5. Bundles45item
  6. SkateHut Sale25item
  7. Summer Sale3item

Sales Name

  1. Reduction1 item
  2. Clearance3item
  3. Price Match9item
  4. Red Tier 14item
  5. Red Tier 26item

Scooter Compression Type

  1. IHC2item
  2. SCS6item

Channel Filters

  1. Allowed47item

Stock At Supplier

  1. No30item

Cross Sell Type

  1. Colour41item

Reporting Status

  1. Live42item
  2. Discontinued4item
  3. Pending1 item

In Magento

  1. Yes44item
  2. No3item

Use In Google Feed

  1. Yes47item

B-Stock

  1. No47item

Own Brand?

  1. No47item

Channels Ready

  1. Yes40item
  2. No7item

Google Feed Margin Cat

  1. z13item
  2. z28item
  3. z332item
  4. other1 item

Order In Active

  1. No45item

Order In Product

  1. No45item

Export

  1. No45item

Has Identifier for GMC

  1. Yes47item

Export Common

  1. No45item

Supplier Name

  1. Centrano44item
  2. RI Distribution3item

Best Suited to

  1. Hybrid3item

Scooter Type

  1. Stunt Scooter3item

Is for Gifting?

  1. Yes2item
  2. No45item

Is Gift Tier

  1. High2item

Scooter Bar Height

  1. 610mm1 item
  2. 710mm2item

Scooter Height

  1. 825mm3item

Skill Level

  1. Intermediate2item

Product Type Basic

  1. Misc Stickers1 item
  2. Scooter Collar Clamps4item
  3. Scooter Compression Kits4item
  4. Scooter Forks3item
  5. Scooter Grip Tape1 item
  6. Scooter Grips2item
  7. Scooter Bars3item
  8. Scooter Headsets1 item
  9. Scooters - Stunt Scooters3item
  10. Scooter Wheels25item

Is Simple Product

  1. Yes47item

Department

  1. Media1 item
  2. Scooters46item

Price

  1. £0.00 - £24.9914item
  2. £25.00 - £49.9925item
  3. £50.00 - £74.995item
  4. £125.00 and above3item

Product Type

  1. Media > Misc Stickers1 item
  2. Scooters > Collar Clamps4item
  3. Scooters > Compression Kits4item
  4. Scooters > Forks3item
  5. Scooters > Grip Tape1 item
  6. Scooters > Grips2item
  7. Scooters > Handle Bars3item
  8. Scooters > Headsets1 item
  9. Scooters > Wheels25item
  10. Scooters > Stunt Completes3item

Grip Length

  1. 175mm2item

Main Colour

  1. Black18item
  2. Blue4item
  3. Gold3item
  4. Green2item
  5. Multi1 item
  6. Neochrome7item
  7. Orange1 item
  8. Purple1 item
  9. Red2item
  10. Silver5item
  11. White1 item
  12. Yellow1 item

Scooter Bar Compatibility

  1. Fits Oversized Bars Fits Standard Bars7item
  2. Fits Oversized Bars1 item

Scooter Bar Type

  1. Oversized HIC2item
  2. No Slit SCS1 item

Scooter Clamp Type

  1. Collar Clamp + Shim4item
  2. SCS Compression4item

Scooter Fork Type

  1. Fork For 120mm Wheels IHC1 item
  2. Fork For 120mm Wheels SCS2item

Scooter Headset Type

  1. Integrated1 item

Scooter Wheel Size

  1. 110mm19item
  2. 120mm6item

Vegan

  1. No47item

Scooter Height

  1. 68cm - 85cm3item
  2. 80cm - 90cm3item

Bar Height Range

  1. 600mm - 624mm1 item
  2. 700mm and over2item

Bar Width Range

  1. 550mm - 574mm1 item
  2. 600mm - 624mm2item

Deck Length

  1. 19.5"3item

Scooter Wheel Width

  1. 24mm24item

Deck Width

  1. 4.8"3item

Scooter Bar Shape

  1. T - Shape3item
  2. Y - Shape3item

Scooter Rider Height Range

  1. 125cm - 150cm3item
  2. 150cm - 170cm3item

Material Primary

  1. Aluminium3item
  2. Crmo Steel3item

Builder Part

  1. Yes41item
  2. No1 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 (237580, 394685, 101458, 168928, 250922, 237583, 237585, 237586, 237587, 175200, 168924, 237579, 250921, 411073, 168926, 168927, 237582, 237584, 168925, 168929, 101455, 277804, 277805, 102163)) ORDER BY FIELD(e.entity_id,237580,394685,101458,168928,250922,237583,237585,237586,237587,175200,168924,237579,250921,411073,168926,168927,237582,237584,168925,168929,101455,277804,277805,102163)

Showing 24 out of 47

Page