Hover over image to zoom and click to enlarge
*All products come flat pack unless otherwise stated
1064 - 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 'Metal%' OR pd.products_name LIKE 'Bunk%' OR pd.products_name LIKE 'Bed%' OR p...' at line 1
Ventura 3' Metal Bunk Bed in Black
Product Code : 200-205-016.SEC
OUR PRICE TODAY £299.95(Price Includes VAT)
The Ventura 3' Single Twin Sleeper Metal Bunk Beds are finished in Black and feature two 3' single bunks with attractive curved head and foot end and metal slatted bases. This bunk bed can also be used as two separate 3' single beds and feature wooden caps, ladder slats and metal slatted bases for extra strength and stability.
Metal Bunk Bed
Ladder with Stylish wooden steps
Metal slatted bases
Length: 201 cm Width: 97 cm Height: 55 cm
select count(*) as total from products p, products_description pd, products_to_categories pc where (pd.products_name LIKE 'Ventura%' OR pd.products_name LIKE '3'%' OR pd.products_name LIKE 'Metal%' OR pd.products_name LIKE 'Bunk%' OR pd.products_name LIKE 'Bed%' OR pd.products_name LIKE 'in%' OR pd.products_name LIKE 'Black%') and p.products_status = '1' and p.products_id = pc.products_id and p.products_id = pd.products_id and p.products_id != '13317' and pd.language_id = '1'