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

In Pond Lighting

At Bradshaws Direct we stock a large selection of In Pond Lighting as part of our garden and pond lighting range.

With a large selection of pond lighting on offer from Oase, Bermuda, Blagdon, PondKraft and Hozelock, our range of pond lights allows you to choose the ideal lighting solution for your pond. Whether you are looking for solar pond lights or underwater lights, we are sure to have in pond lighting to suit.

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(14817, 16008, 14976, 14973, 14945, 11697, 14975, 14271, 14946, 14944, 11855, 16159))

1 - 12 of 21

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

1 - 12 of 21

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