+44 1904 698815
My basket €0.000 item(s)

Oase

Oase have been a well respected supplier of pond products for many years, manufacturing high quality, German engineered pond pumps, pond filters, pond vacuums and more.

From the Aquamax range of pumps and filters to the powerful Pondovac 4, the Oase brand is a guarantee of quality.

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`, `cat_index`.`position` AS `cat_index_position` 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.website_id = '2' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' WHERE (`e`.`entity_id` IN(11807, 14909, 14573, 12731, 12722, 11839, 11811, 14919, 14905, 13304, 12730, 12721))

1 - 12 of 146

  2. 1
▪▪▪
  1. 13
Filter By
Help +44 1904 698815, let us help you!

1 - 12 of 146

  2. 1
▪▪▪
  1. 13
Filter By
Help +44 1904 698815, let us help you!
Latest from our Blog View Blog