Upright Vacuums
-
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'
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 (423, 424, 807, 1140, 1225, 1707, 1745, 2757, 2769, 2976, 2977, 3100)) ORDER BY FIELD(e.entity_id,423,424,807,1140,1225,1707,1745,2757,2769,2976,2977,3100)
-
PRIORITY: | QTY: 4 | RECOMMENDED: | PRICE: 349.99
Sebo Uk Ltd 91503GB Bagged Upright Vacuum Cleaner
Dimensions: H 117 x W 30 x D 31 cm
£349.99 -
PRIORITY: | QTY: 5 | RECOMMENDED: | PRICE: 449
Sebo Uk Ltd 91533GB Automatic X7 Pro ePower Upright Cleaner Bagged 890 Watts Weight: 7.6kg Computer
Dimensions: H 117 x W 30 x D 31 cm
£449.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 149
Bosch BCHF216GB Ready Serie 2 ProClean Cordless Vacuum Cleaner - 40 Minute Run Time
Dimensions: H 116 x W 26.5 x D 16.5 cm
£149.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 429.99
Shark ICZ300UKT Anti Hair Wrap Cordless Upright Vacuum Cleaner with PowerFins
Dimensions: H 108 x W 25 x D 26 cm
£429.99 -
PRIORITY: | QTY: 3 | RECOMMENDED: | PRICE: 399.99
Shark ICZ300UK Anti Hair Wrap Cordless Upright Vacuum Cleaner with PowerFins & Powered Lift-Away
Dimensions: H 108 x W 25 x D 26 cm
£399.99 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 229.99
Shark NV602UKT Vacuum Cleaner-Red
Dimensions: H 118 x W 28.5 x D 26 cm
£229.99 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 429.99
Shark IZ400UKT Stratos Cordless Stick Vacuum Cleaner - Pet Pro Model - 60 Minutes Run Time - Copper
Dimensions: H 114 x W 27 x D 17 cm
£429.99 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 349.99
Shark AZ3000UKT Shark Stratos XL Anti Hair Wrap Plus Anti-Odour Upright Vacuum - Navy Blue
Dimensions: H 117 x W 27 x D 30 cm
£349.99 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 99.99
Vax U85-AS-BE Upright Corded Bagless Vacuum - Orange/Grey
Dimensions: H 110 x W 31 x D 30.5 cm
£99.99 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 249.99
Shark EX150UK CarpetXpert Deep Carpet Cleaner - Navy
Dimensions: H 1111 x W 304 x D 348 cm
£249.99 -
£299.99
-
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 199.99
Vax CWGRV011 Rapid Power Revive Carpet Cleaner
Dimensions: H 59 x W 30.5 x D 37 cm
£199.99
postcode: local: no
session postcode: session local: no











