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

Smart Solar

Smart Solar offer an eco-friendly way to decorate your garden, with solar lighting and solar pond products adding movement and colour to your outdoor space, with no added electricity cost!

Light up your garden with solar pathway lights and glass lanterns. Just 2 of the great range of products from Smart Solar.

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(11891, 13458, 13461, 13464, 13401, 13756, 13431, 13422, 13440, 13446, 13434, 11888))

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