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

Garden Lights & Garden Lighting

Light up your garden or pond at night with our wide range of outdoor, garden and pond lighting.

At Bradshaws Direct we stock several garden lighting solutions including underwater lighting, solar lighting and illuminated fountains, everything you’d expect from a professional range of garden lights.

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(14715, 14817, 14944, 13422, 14384, 13431, 14321, 13434, 11902, 16242, 16254, 15949))

1 - 12 of 14

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

1 - 12 of 14

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