Half-Day Dubai City Tour with Tickets to Dubai Frame

2026-07-26 4h-5h English

Please select your show time to proceed.

Please select at least one option to proceed.

1 Day Pass, anytime access from 9:00-18:00

There's no availability, please select a different date.

Half-Day Dubai City Tour with Tickets to Dubai Frame

ENGLISH GROUP

Start Date :

Start Time:

Participants:

Price:

€ 0^.00

Total Price :

€ 0^.00

CUSTOMER REVIEWS

21 May 2018

★ ★ ★ ★ ★

Very good

Very very good. Comfortable bus. Tour guide is well experienced. Overall we are happy.

2019-06-24

Is this Review helpful ?

21 May 2018

★ ★ ★ ★ ★

Good tour

Very good tour. Saw the important sites. A long the route our guide helped 4 men stranded when they got on the wrong tour bus. They monopolized the tour because she had to translate what she was saying into their ..Read All

language. ..Read less

2019-09-09

Is this Review helpful ?

21 May 2018

★ ★ ★ ★ ★

Excellent

Thanks to Sam we had a wonderful trip. We would never have seen so many sights if we hadn’t done this trip and it has given us a good idea of where we would like to stay in Dubai in ..Read All

the future when we come back. The group was just the right size for us. I would recommend this trip! ..Read less

2019-09-29

Is this Review helpful ?

21 May 2018

★ ★ ★ ★ ★

Excellent tour for a fair price and great guide!

I went with my family on this tour and it was far above our expectation! We saw much more than expected and received useful information from our guide, Sam. He was super well prepared and made a great mood throughout ..Read All

the tour. He showed us the best photo shooting spots and was very helpful. I can only recommend this tour, as you get a great knowhow and a lot of experience of Dubai. Thank you guys, excellent tour! ..Read less

2019-07-23

Is this Review helpful ?

21 May 2018

★ ★ ★ ★ ★

Excellent tour, knowledgeable and friendly tour guide

2019-02-02

Is this Review helpful ?

Dubai

NEED HELP?

📥 Email us at:

hi@dotravel.com

FAQ

Is my payment secure?

How do I cancel my booking?

What is Your refund policy?

Can I make changes to my booking post-reservation?

How can I apply the promotion I received via email?

Do you store my credit card information in your system?

#	Time	Query
1	1.33 ms	SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1
2	8.67 ms	INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,...
3	0.55 ms	SELECT * FROM `languages` WHERE TRUE AND `short` = 'en'
4	0.67 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
5	0.58 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'products_status_booking' ORDER BY `id` DESC LIMIT 0 , 30
6	0.37 ms	SELECT * FROM `products` p WHERE TRUE AND p.`id` = 3707 AND p.`status` = '23' AND p.`status_booking` = '9' ORDER BY `id` DESC
7	0.71 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3707 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 1000
8	0.56 ms	SELECT * FROM `product_system_meta` WHERE TRUE AND `id_product` = 3707 AND `metaname` = 'bookingextranote' ORDER BY `id` DESC LIMIT 0 , 30
9	0.36 ms	SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'review_status' ORDER BY `id` DESC LIMIT 0 , 30
10	0.21 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 3 ORDER BY `id` DESC LIMIT 0 , 30
11	0.44 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 FROM `reviews` WHERE TRUE AND `id_product` = 3707 AND `status` = '26'
12	0.37 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
13	0.34 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
14	0.41 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 AND `type` = 4 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
15	0.26 ms	SELECT * FROM `languages` WHERE TRUE AND `id` = 1
16	0.34 ms	SELECT * FROM `product_photos` WHERE TRUE AND `id_product` = 3707 ORDER BY `show_order` asc LIMIT 0 , 30
17	0.36 ms	SELECT * FROM `seo` WHERE TRUE AND `id_product` = 3707 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
18	0.6 ms	SELECT sb.*, lg.name as language, t.name as groupType ,t.id as groupTypeId,lg.id as languageId, pp.price as price,pp.id as priceId FROM `sub_product` sb inner join languages lg on sb.id_language = lg.id inner join type t on t.id = sb.type left join product_prices pp on pp.id_subproduct = sb.id...
19	0.37 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 AND `status` = '15' ORDER BY `id_language` DESC LIMIT 0 , 30
20	0.24 ms	SELECT * FROM `type` WHERE TRUE AND `id` = 4 ORDER BY `id` DESC LIMIT 0 , 30
21	0.26 ms	SELECT * FROM `suppliers` s WHERE TRUE AND s.`id` = 36 ORDER BY `id` DESC
22	0.43 ms	SELECT * FROM `supplier_meta` WHERE TRUE AND `id_supplier` = 36 ORDER BY `id` DESC LIMIT 0 , 1000
23	0.3 ms	SELECT * FROM `product_system` WHERE TRUE AND `id_product_dotravel` = 3707 ORDER BY `id` DESC
24	0.48 ms	SELECT SUM(rating_overall) / count(*) as rating_overall FROM `reviews` WHERE TRUE AND `id_product` = 3707 AND `status` = '26'
25	0.55 ms	SELECT COUNT(*) FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') AND `id_product` = 3707
26	0.93 ms	select r.*, c.firstname , c.lastname,(select metavalue from customer_meta where id_customer = c.id and metaname = 'avatar') as avatar from reviews r inner join customers c on c.id = r.id_customer WHERE TRUE AND `id_product` = 3707 AND r.`status` = '26' ORDER BY `rating_overall` DESC LIMIT 0 , 5
27	0.71 ms	SELECT * FROM `review_photos` WHERE TRUE AND `id_review` = 5767 ORDER BY `id` DESC LIMIT 0 , 30
28	0.54 ms	SELECT * FROM `review_confirmation` WHERE TRUE AND `id_review` = 5767 AND `ip` = '216.73.216.90' ORDER BY `id` DESC LIMIT 0 , 30
29	0.27 ms	SELECT * FROM `review_photos` WHERE TRUE AND `id_review` = 5749 ORDER BY `id` DESC LIMIT 0 , 30
30	0.31 ms	SELECT * FROM `review_confirmation` WHERE TRUE AND `id_review` = 5749 AND `ip` = '216.73.216.90' ORDER BY `id` DESC LIMIT 0 , 30
31	0.23 ms	SELECT * FROM `review_photos` WHERE TRUE AND `id_review` = 5766 ORDER BY `id` DESC LIMIT 0 , 30
32	0.27 ms	SELECT * FROM `review_confirmation` WHERE TRUE AND `id_review` = 5766 AND `ip` = '216.73.216.90' ORDER BY `id` DESC LIMIT 0 , 30
33	0.27 ms	SELECT * FROM `review_photos` WHERE TRUE AND `id_review` = 5765 ORDER BY `id` DESC LIMIT 0 , 30
34	0.28 ms	SELECT * FROM `review_confirmation` WHERE TRUE AND `id_review` = 5765 AND `ip` = '216.73.216.90' ORDER BY `id` DESC LIMIT 0 , 30
35	0.26 ms	SELECT * FROM `review_photos` WHERE TRUE AND `id_review` = 5764 ORDER BY `id` DESC LIMIT 0 , 30
36	0.33 ms	SELECT * FROM `review_confirmation` WHERE TRUE AND `id_review` = 5764 AND `ip` = '216.73.216.90' ORDER BY `id` DESC LIMIT 0 , 30
37	0.25 ms	SELECT * FROM `languages` WHERE TRUE AND `name` = 'English'
38	0.32 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 AND `id_language` = 1 ORDER BY `id` DESC LIMIT 0 , 30
39	0.28 ms	SELECT * FROM `product_prices` WHERE TRUE AND `id_subproduct` = 2365 ORDER BY `id` DESC LIMIT 0 , 30
40	0.25 ms	SELECT * FROM `age_group` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30
41	0.27 ms	SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 6689 ORDER BY `id` DESC LIMIT 0 , 30
42	0.33 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 AND `type` = 4 ORDER BY `id_language` ASC LIMIT 0 , 30
43	0.28 ms	SELECT * FROM `product_advantage` WHERE TRUE AND `id_product` = 3707 ORDER BY `id` DESC LIMIT 0 , 30
44	0.41 ms	SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 7 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30
45	0.33 ms	SELECT sb.*, t.name AS type_name FROM `subproduct_blockeddates` AS sb INNER JOIN `type` AS t ON sb.block_type = t.id WHERE t.`group` = 'subproduct_blockeddates_block_type' AND sb.`id_subproduct` = 2365 ORDER BY sb.`id` DESC
46	0.33 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'private' ORDER BY `id` DESC LIMIT 0 , 30
47	0.28 ms	SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30
48	0.43 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 AND `type` = 5 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
49	0.32 ms	SELECT * FROM `sub_product` WHERE TRUE AND `id_product` = 3707 AND `type` = 4 AND `status` = '15' ORDER BY `id` DESC LIMIT 0 , 30
50	0.64 ms	SELECT * FROM `product_meta` WHERE TRUE AND `id_product` = 3707 AND `id_language` = 1 AND `metaname` = 'availability_next_date' ORDER BY `id` DESC LIMIT 0 , 30

Time

Query

1.33 ms

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

8.67 ms

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

0.55 ms

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

0.67 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

0.58 ms

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

0.37 ms

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

0.71 ms

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

0.56 ms

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

0.36 ms

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

0.21 ms

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

0.44 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 FROM `reviews` WHERE TRUE AND `id_product` = 3707 AND `status` = '26'

0.37 ms

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

0.34 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

0.41 ms

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

0.26 ms

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

0.34 ms

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

0.36 ms

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

0.6 ms

SELECT sb.*, lg.name as language, t.name as groupType ,t.id as groupTypeId,lg.id as languageId, pp.price as price,pp.id as priceId FROM `sub_product` sb inner join languages lg on sb.id_language = lg.id inner join type t on t.id = sb.type left join product_prices pp on pp.id_subproduct = sb.id...

0.37 ms

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

0.24 ms

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

0.26 ms

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

0.43 ms

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

0.3 ms

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

0.48 ms

SELECT SUM(rating_overall) / count(*) as rating_overall FROM `reviews` WHERE TRUE AND `id_product` = 3707 AND `status` = '26'

0.55 ms

SELECT COUNT(*) FROM `reviews` WHERE status in (select id from status s where s.name = 'active' and s.group = 'review_status') AND `id_product` = 3707

0.93 ms

select r.*, c.firstname , c.lastname,(select metavalue from customer_meta where id_customer = c.id and metaname = 'avatar') as avatar from reviews r inner join customers c on c.id = r.id_customer WHERE TRUE AND `id_product` = 3707 AND r.`status` = '26' ORDER BY `rating_overall` DESC LIMIT 0 , 5

0.71 ms

SELECT * FROM `review_photos` WHERE TRUE AND `id_review` = 5767 ORDER BY `id` DESC LIMIT 0 , 30

0.54 ms

SELECT * FROM `review_confirmation` WHERE TRUE AND `id_review` = 5767 AND `ip` = '216.73.216.90' ORDER BY `id` DESC LIMIT 0 , 30

0.27 ms

SELECT * FROM `review_photos` WHERE TRUE AND `id_review` = 5749 ORDER BY `id` DESC LIMIT 0 , 30

0.31 ms

SELECT * FROM `review_confirmation` WHERE TRUE AND `id_review` = 5749 AND `ip` = '216.73.216.90' ORDER BY `id` DESC LIMIT 0 , 30

0.23 ms

SELECT * FROM `review_photos` WHERE TRUE AND `id_review` = 5766 ORDER BY `id` DESC LIMIT 0 , 30

0.27 ms

SELECT * FROM `review_confirmation` WHERE TRUE AND `id_review` = 5766 AND `ip` = '216.73.216.90' ORDER BY `id` DESC LIMIT 0 , 30

0.27 ms

SELECT * FROM `review_photos` WHERE TRUE AND `id_review` = 5765 ORDER BY `id` DESC LIMIT 0 , 30

0.28 ms

SELECT * FROM `review_confirmation` WHERE TRUE AND `id_review` = 5765 AND `ip` = '216.73.216.90' ORDER BY `id` DESC LIMIT 0 , 30

0.26 ms

SELECT * FROM `review_photos` WHERE TRUE AND `id_review` = 5764 ORDER BY `id` DESC LIMIT 0 , 30

0.33 ms

SELECT * FROM `review_confirmation` WHERE TRUE AND `id_review` = 5764 AND `ip` = '216.73.216.90' ORDER BY `id` DESC LIMIT 0 , 30

0.25 ms

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

0.32 ms

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

0.28 ms

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

0.25 ms

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

0.27 ms

SELECT * FROM `product_bookingfees` WHERE TRUE AND `id_productprice` = 6689 ORDER BY `id` DESC LIMIT 0 , 30

0.33 ms

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

0.28 ms

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

0.41 ms

SELECT a.*, m.id_language, m.name, m.description FROM `advantages` AS a INNER JOIN `advantage_meta` AS m on a.id=m.id_advantage WHERE TRUE AND a.`id` = 7 AND m.`id_language` = 1 ORDER BY `id` desc LIMIT 0 , 30

0.33 ms

SELECT sb.*, t.name AS type_name FROM `subproduct_blockeddates` AS sb INNER JOIN `type` AS t ON sb.block_type = t.id WHERE t.`group` = 'subproduct_blockeddates_block_type' AND sb.`id_subproduct` = 2365 ORDER BY sb.`id` DESC

0.33 ms

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

0.28 ms

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

0.43 ms

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

0.32 ms

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

0.64 ms

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