Name: The Ice Bar Experience at Icebarcelona
Brand: Dotravel
Availability: InStock

Experience the first ice bar on the beach in the world! Enter an experimental and avant-garde environment 5 degrees below zero. At least twice a year, the theme of the room, the lighting, and the sculptures are updated.

Gloves

Warm Jacket

Drink

Entry

Before You Go

Room themes and lighting are updated at least twice a year.

Please carry documents proving children's age on the day of your visit.

The venue is kept at 5°C; warm jacket and gloves are included, dress warmly.

Prices: adults €19, children €8.50 (ages 5–11).

Bring proof of age for children to avoid any surcharge.

No reviews yet

Experience a bold seaside ice installation that blends art, curiosity, and sensory thrill. This avant-garde venue transports you to a sub-zero world where room designs, lighting, and sculptures are reinvented regularly for a fresh encounter each visit.

Unmatched beachfront setting with a chilly, immersive vibe
Seasonal themes updated twice a year for new photography moments
All-in-one experience includes entry, a drink, and warm gear to stay comfortable
Ideal for groups, couples, and unique celebrations seeking standout memories

Time

Query

3.63 ms

SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1

13.25 ms

INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...

0.62 ms

SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'

407.78 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_language` = 1 AND `metaname` = 'redirect_from_id' AND `metavalue` = '4731' ORDER BY `id` DESC LIMIT 0 , 30

1.08 ms

SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4731 ORDER BY `id` DESC

0.91 ms

SELECT * FROM `type` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.93 ms

SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'ticket' ORDER BY `id` DESC LIMIT 0 , 30

1.57 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4731 ORDER BY `id_language` DESC LIMIT 0 , 30

0.79 ms

SELECT * FROM `languages` WHERE TRUE AND `id` = 1

0.58 ms

SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30

0.92 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30

1.15 ms

SELECT * FROM `products` p WHERE TRUE AND p.`id` = 4731 AND p.`status` = '23' ORDER BY `id` DESC

1.86 ms

SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC

0.4 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '10' ORDER BY `id` DESC LIMIT 0 , 30

0.56 ms

SELECT SUM(rating_valueformoney) as rating_valueformoney, SUM(rating_convenience) as rating_convenience, SUM(rating_accessibility) as rating_accessibility, SUM(rating_overall) as rating_overall, AVG(rating_overall) as rating_overall_avg, COUNT(*) as review_count FROM `reviews` WHERE status IN...

1.34 ms

SELECT * FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') and title not like '' AND `id_product` = 4731 ORDER BY `rating_overall` desc LIMIT 20 , 30

1.92 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '9' ORDER BY `id` DESC LIMIT 0 , 30

1.08 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4731 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000

0.93 ms

SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 4731 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30

1.25 ms

SELECT pr.price as min FROM `product_prices` as pr INNER JOIN `sub_product` AS s ON s.id = pr.id_subproduct INNER JOIN `age_group` AS a ON a.id = pr.id_agegroup -- WHERE a.show_order = 1 AND s.`id_product` = 4731 ORDER BY s.`id_language` ASC

1.82 ms

SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 4731 ORDER BY `id` DESC

1.33 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'sub_product_status' ORDER BY `id` DESC LIMIT 0 , 30

1.3 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4731 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30

0.85 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4731 ORDER BY `show_order` asc LIMIT 0 , 30

2.38 ms

SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4731 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30

1.99 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4731 ORDER BY `id` DESC LIMIT 0 , 30

0.51 ms

SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 3757 ORDER BY `id` DESC LIMIT 0 , 30

0.51 ms

SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30

0.57 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4731 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30

1.34 ms

SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 4731 ORDER BY `id` DESC LIMIT 0 , 30

1.15 ms

SELECT short_description, image_name,image_path, id_language, name FROM `label_products` LEFT JOIN labels lb on lb.id = id_label LEFT JOIN labels_meta lm on lm.id_label = label_products.id_label where id_product ='4731'

2.11 ms

SELECT * FROM `favorites` WHERE TRUE AND `id_product` = 4731 ORDER BY `id` DESC LIMIT 0 , 30

1.27 ms

SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'disabled' AND `group` = 'favorites_status' ORDER BY `id` DESC LIMIT 0 , 30

0.68 ms

SELECT pc.id_category as id, cm.name as name, cm.seo_url as seo_url ,(SELECT img_name FROM categories where id = pc.id_category) as img FROM `product_category` AS pc INNER JOIN `category_meta` AS cm ON pc.id_category = cm.id_category WHERE TRUE AND pc.`id_product` = 4731 AND cm.`id_language` = 1...

1.44 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4731 ORDER BY `show_order` ASC LIMIT 0 , 30

0.5 ms

SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'

1.34 ms

SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 7 ORDER BY `id` DESC LIMIT 0 , 30

0.95 ms

SELECT destinations.id, destination_meta.name,seo_url FROM `destinations` join destination_meta on destination_meta.id_destination = destinations.id join destination_parent on destination_parent.id_parent = destinations.id where true AND destinations.status = 24 AND destination_meta.id_language =...

1.6 ms

SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 3 ORDER BY `id` DESC LIMIT 0 , 30

1.07 ms

0.77 ms

SELECT * FROM `destination_parent` WHERE TRUE AND `id_child` = 1 ORDER BY `id` DESC LIMIT 0 , 30

2.53 ms

SELECT p.* FROM `related_product` rp inner join products p on rp.id_related = p.id inner join suppliers s on p.id_supplier = s.id WHERE TRUE AND `id_product` = 4731 AND p.`status` = 23 AND s.`status` = 10 ORDER BY `id` DESC LIMIT 0 , 3

42.53 ms

SELECT p.* FROM `products` p JOIN `suppliers` s ON p.id_supplier = s.id JOIN `status` st ON s.status = st.id WHERE p.`status` = 23 AND p.id not in ( 4731 ) AND st.name = 'active' AND st.group = 'suppliers_status' AND p.id IN ( SELECT id_product FROM `product_destination` WHERE id_destination IN...

3.28 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4607 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30

1.52 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4607 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30

1.32 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4607 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30

1.12 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4607 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30

1.39 ms

SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4607 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.64 ms

SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30

0.79 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4607 ORDER BY `id` DESC LIMIT 0 , 30

3.12 ms

4.29 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4607 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30

0.56 ms

3 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4576 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30

4.77 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4576 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30

0.57 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4576 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30

4.1 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4576 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30

2.8 ms

SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4576 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.42 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4576 ORDER BY `id` DESC LIMIT 0 , 30

4.4 ms

4.38 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4576 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30

9.23 ms

0.61 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 AND `metaname` = 'title' ORDER BY `id` DESC LIMIT 0 , 30

1.45 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 AND `metaname` = 'summary' ORDER BY `id` DESC LIMIT 0 , 30

4.87 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 AND `metaname` = 'typeHour' ORDER BY `id` DESC LIMIT 0 , 30

1.12 ms

SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 AND `metaname` = 'currency' ORDER BY `id` DESC LIMIT 0 , 30

1.7 ms

SELECT * FROM `seo` WHERE TRUE AND `id_product` = 4608 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30

0.51 ms

SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 4608 ORDER BY `id` DESC LIMIT 0 , 30

0.66 ms

0.69 ms

SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 4608 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30

0.9 ms

1.14 ms

SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (?,?,?) AND metaname = ? AND id_language = ?

0.54 ms

SELECT * FROM `type` WHERE TRUE AND `group` = 'subproduct_blockeddates_block_type' ORDER BY `id` DESC LIMIT 0 , 30

0.43 ms

SELECT * FROM `subproduct_blockeddates` WHERE TRUE AND `id_subproduct` = 3757 ORDER BY `date` ASC LIMIT 0 , 30

2485.98 ms

SELECT * FROM `customer_productlog` WHERE TRUE

6.1 ms

INSERT INTO `customer_productlog` ( `id` , `content` ) VALUES( NULL , '{\"id_product\":\"4731\",\"id_user\":\"NULL\",\"dateVisited\":1785173416}' )

0.39 ms

SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC

0.84 ms

SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000

The Ice Bar Experience at Icebarcelona

Ice Bar on the Beach

About This ticket

Meeting Point

You might also like

2 Hours PRIVATE SUNSET Sailing Experience Barcelona up to 11 Guests

Car Transportation, Vineyard Tour & Wine Tasting and Sailing Experience to Barcelona

3 Hours PRIVATE Sailing Experience Barcelona up to 11 Guests