Curvaceous, contemporary design characterises the Lund range
More product images: Click to see
Description
Delivery
Reviews
Your flowing, contemporary statement suite
The curvaceous designs of the Lund range, constructed with glazed vitreous china, provide the ultimate statement pieces. The organic Lund basin is finished in gloss white, and comes with a single tap hole to make installation a breeze. We are so confident with the quality and durability of our suites that a leading 10 year warranty is offered as standard.
"I know having a great product is only matched by outstanding service. My team ensures you receive the very best experience before, during and after your purchase."
No Reviews for this product but we have a review for other products from this manufacturer
SELECT reviews.customers_name, reviews.reviews_rating, reviews.date_added, reviews.reviews_id, reviews_description.reviews_text, products.products_id, products.products_name, products.products_image, reviews.thumbs_down, reviews.thumbs_up FROM products_to_categories INNER JOIN reviews ON products_to_categories.products_id = reviews.products_id LEFT JOIN reviews_description ON reviews_description.reviews_id = reviews.reviews_id LEFT JOIN products ON products.products_id = reviews.products_id LEFT JOIN categories ON categories.categories_id = products_to_categories.categories_id INNER JOIN products_to_sites ON products_to_sites.products_id = reviews.products_id WHERE (products_to_categories.categories_id IN ('270961','65202') OR categories.parent_id = '65202') AND reviews.moderated = '1' AND products_to_sites.site_id = 'BathEmpire' GROUP BY reviews.reviews_id ORDER BY IF(products_to_categories.categories_id = '270961',1,0) DESC, IF( reviews.thumbs_up>0, IF( reviews.thumbs_down>0, SUM((1+reviews.thumbs_up)/(1+reviews.thumbs_down)), 1+reviews.thumbs_up ), 1-reviews.thumbs_down ) DESC, reviews.date_added DESC LIMIT 3
BIGINT UNSIGNED value is out of range in '(1 - `potncom_carshop`.`reviews`.`thumbs_down`)'
SELECT reviews.customers_name, reviews.reviews_rating, reviews.date_added, reviews.reviews_id, reviews_description.reviews_text, products.products_id, products.products_name, products.products_image, reviews.thumbs_down, reviews.thumbs_up FROM products INNER JOIN reviews ON products.products_id = reviews.products_id INNER JOIN products_to_sites ON products_to_sites.products_id = reviews.products_id AND products_to_sites.site_id = 'BathEmpire' LEFT JOIN reviews_description ON reviews_description.reviews_id = reviews.reviews_id WHERE products.manufacturers_id = '397' AND reviews.moderated = '1' GROUP BY products.products_id,reviews.reviews_id ORDER BY IF( reviews.thumbs_up>0, IF( reviews.thumbs_down>0, SUM((1+reviews.thumbs_up)/(1+reviews.thumbs_down)), 1+reviews.thumbs_up ), 1-reviews.thumbs_down ) DESC, reviews.date_added DESC LIMIT 3
BIGINT UNSIGNED value is out of range in '(1 - `potncom_carshop`.`reviews`.`thumbs_down`)'