Cheshire - CNCHE-N-SW-OF

The Chesire is a timeless roll-top classic. A deep Victorian double-ended claw-foot bath that adds style and grace to any bathroom.

PRODUCT DETAILS

Capacity:
145 litres

Dimensions :
H: 646 mm | W: 798 mm | L: 1744 mm

Weight:
61 kg

Available Finishes :
QUARRYCAST™ White (Gloss)

Tap Holes :
Tap holes cannot be drilled for this product

Bath Feet :
Available Finishes bath feet

    QUERY: SELECT PID, Ptitle, Ptitleen, Pweight FROM product WHERE ( Pweight = IFNULL((SELECT min(Pweight) FROM product WHERE Pweight > 172),0) OR Pweight = IFNULL((SELECT max(Pweight) FROM product WHERE Pweight < 172),0)) AND Ppage=25 AND =0
    ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '=0' at line 3