Zamalek FISH GARDEN (Genent El 2asmak)

عمرو موسى 2012: موقع حملة عمرو موسى...More
Motaz Tours: Motaz Tours Egypt provide a very special diving program in Hurghada, Sharm El-Sheikh, Nuwbaa, Soma B......More
Mall of Arabia Cairo: Mall of Arabia is planned to hold:- 900 brands.- A free parking space to hold up to 9,000 cars.- 13 ......More
Al Riwaq Art Space - Bahrain: Situated in the neighbourhood of Adliya in Bahrain, Al Riwaq Art Space is dedicated to promoting loc......More
Albareh Art Gallery - Manama -...: Since opening its doors in 1998, an early pioneer in Bahrain and the Arabian Gulf, Albareh Art Galle......More

Category : Shopping & Retail Address Zamalek, Cairo, Egypt Telephone 0227351606

Aquarium Grotto Garden 1867
145 years later Khedawy Ismail had decided to establish this aquarium.
It had been place for kings and Princes only.
1902 had been opened for public for first time under supervision of central administration of zoos.

حديقة الأسماك او حديقة الجبلاية, توجد في الزمالك في شارع الجبلاية بالقاهرة ، أنشأها الخديوي إسماعيل في سنة 1867, و تعتبر من أفضل الحدائق التي أنشئت في عصر الخديوى في القاهرة.الحديقة تديرها اداره حديقة الحيوان بالجيزة من سنة 1902 وقد قامت بإصلاح 24 حوض لعرض 33 نوع من الأسماك النيلية فيها قبل إفتتاح الحديقة للجمهور رسميا في 21 نوفمبر 1902.

أغلقت الحديقة في سنة 1965 لفترة طويلة, وذلك للتصليح و تم تجديدها و اشرف على التصليح جهات علميه و هندسيه تابعه لوزارة الزراعة المصرية, وأفتتحت مرة اخرى في سنة 1983.

تبلغ مساحتها مضافاً إليها مجموعة الحدائق النباتية المجاورة لها نحو تسعة أفدنة ونصف الفدا

Sponsoreship

Find

Title Venue Type

Our Venues

Time	Query
0.57ms	SELECT * FROM `sessions` WHERE `id` = 'GIjcEr02IC4CFzVdbmBxy4WNmQRH6xetVhV9FoEC' LIMIT 1
0.36ms	SELECT * FROM `configs`
0.87ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `created_at` DESC LIMIT 5
0.87ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `title` ASC LIMIT 10
0.46ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '2' ORDER BY `title` ASC LIMIT 5
0.37ms	SELECT * FROM `news` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `created_at` DESC LIMIT 5
0.52ms	SELECT * FROM `pages` WHERE `published` = '1' AND `deleted` = '0' AND `id` != '1' ORDER BY `created_at` DESC
2.10ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.50ms	SELECT * FROM `types` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
1.13ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '1' ORDER BY `title` DESC
0.51ms	SELECT * FROM `stores` WHERE `id` = '68' AND `published` = '1' AND `deleted` = '0' LIMIT 1
0.78ms	SELECT * FROM `images` WHERE `link_id` = '68' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.56ms	SELECT * FROM `images` WHERE `link_id` = '68' AND `link_type` = 'stores'
0.42ms	SELECT * FROM `images` WHERE `link_id` = '68' AND `link_type` = 'stores' ORDER BY `order` ASC
0.35ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.85ms	SELECT * FROM `images` WHERE `link_id` = '87' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.55ms	SELECT * FROM `images` WHERE `link_id` = '83' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.49ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.46ms	SELECT * FROM `images` WHERE `link_id` = '25' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.36ms	SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.34ms	SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.61ms	SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.27ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.58ms	SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.28ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.45ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.25ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.50ms	SELECT * FROM `images` WHERE `link_id` = '78' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.28ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.55ms	SELECT * FROM `images` WHERE `link_id` = '76' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.26ms	SELECT * FROM `categories` WHERE `id` = '59' LIMIT 1
0.56ms	SELECT * FROM `images` WHERE `link_id` = '47' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.28ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.99ms	SELECT * FROM `images` WHERE `link_id` = '48' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.46ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.79ms	SELECT * FROM `images` WHERE `link_id` = '34' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.32ms	SELECT * FROM `categories` WHERE `id` = '55' LIMIT 1
0.58ms	SELECT * FROM `images` WHERE `link_id` = '30' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.31ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.47ms	SELECT * FROM `images` WHERE `link_id` = '56' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.39ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.76ms	SELECT * FROM `pages` WHERE `id` = '1' AND `published` = '1' LIMIT 1
0.44ms	SELECT * FROM `pages` WHERE `id` = '77' AND `published` = '1' LIMIT 1
0.48ms	INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES ('GIjcEr02IC4CFzVdbmBxy4WNmQRH6xetVhV9FoEC', '1728896509', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"cHUWpjApNTAfIIYFoyZMEZuoNws16dBBlLSkMlgq\";s:7:\"configs\";a:11:{s:9:\"site_name\";s:42:\"7awalaya - Hawalaya - حـواليــّه\";s:13:\"meta_keywords\";s:106:\"Events, Exhibitions, Offers, Coupons, 7awalaya, Android, Application, Mobile, Tablet, shopping, navigation\";s:16:\"meta_description\";s:237:\"RIGHT PLACE, RIGHT DEAL, RIGHT TIME\r\n7AWALAYA is a free mobile phone application that gives you deals and information from your favorite brands when you’re around the shopping point. No need to search for offers, they’ll come to you.\";s:8:\"facebook\";s:32:\"http://www.facebook.com/7awalaya\";s:7:\"twitter\";s:31:\"http://www.twitter.com/7awalaya\";s:10:\"googleplus\";s:27:\"http://google.com/+7awalaya\";s:13:\"contact_email\";s:17:\"info@7awalaya.com\";s:12:\"header_title\";s:8:\"7awalaya\";s:12:\"package_text\";s:29:\"Choose Package that suits you\";s:10:\"login_text\";s:35:\"Login with your E-mail and Password\";s:13:\"register_text\";s:33:\"Register with E-mail and Password\";}s:8:\"language\";s:2:\"en\";}')

Time

Query

0.57ms

SELECT * FROM `sessions` WHERE `id` = 'GIjcEr02IC4CFzVdbmBxy4WNmQRH6xetVhV9FoEC' LIMIT 1

0.36ms

SELECT * FROM `configs`

0.87ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `created_at` DESC LIMIT 5

0.87ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `title` ASC LIMIT 10

0.46ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '2' ORDER BY `title` ASC LIMIT 5

0.37ms

SELECT * FROM `news` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `created_at` DESC LIMIT 5

0.52ms

SELECT * FROM `pages` WHERE `published` = '1' AND `deleted` = '0' AND `id` != '1' ORDER BY `created_at` DESC

2.10ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC

0.50ms

SELECT * FROM `types` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC

1.13ms

SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '1' ORDER BY `title` DESC

0.51ms

SELECT * FROM `stores` WHERE `id` = '68' AND `published` = '1' AND `deleted` = '0' LIMIT 1

0.78ms

SELECT * FROM `images` WHERE `link_id` = '68' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.56ms

SELECT * FROM `images` WHERE `link_id` = '68' AND `link_type` = 'stores'

0.42ms

SELECT * FROM `images` WHERE `link_id` = '68' AND `link_type` = 'stores' ORDER BY `order` ASC

0.35ms

SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1

0.85ms

SELECT * FROM `images` WHERE `link_id` = '87' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.55ms

SELECT * FROM `images` WHERE `link_id` = '83' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.49ms

SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.46ms

SELECT * FROM `images` WHERE `link_id` = '25' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.36ms

SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.34ms

SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.61ms

SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.27ms

SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1

0.58ms

SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.28ms

SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1

0.45ms

SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.25ms

SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1

0.50ms

SELECT * FROM `images` WHERE `link_id` = '78' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.28ms

SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1

0.55ms

SELECT * FROM `images` WHERE `link_id` = '76' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.26ms

SELECT * FROM `categories` WHERE `id` = '59' LIMIT 1

0.56ms

SELECT * FROM `images` WHERE `link_id` = '47' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.28ms

SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1

0.99ms

SELECT * FROM `images` WHERE `link_id` = '48' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.46ms

SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1

0.79ms

SELECT * FROM `images` WHERE `link_id` = '34' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.32ms

SELECT * FROM `categories` WHERE `id` = '55' LIMIT 1

0.58ms

SELECT * FROM `images` WHERE `link_id` = '30' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.31ms

SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1

0.47ms

SELECT * FROM `images` WHERE `link_id` = '56' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1

0.39ms

SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1

0.76ms

SELECT * FROM `pages` WHERE `id` = '1' AND `published` = '1' LIMIT 1

0.44ms

SELECT * FROM `pages` WHERE `id` = '77' AND `published` = '1' LIMIT 1

0.48ms

INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES ('GIjcEr02IC4CFzVdbmBxy4WNmQRH6xetVhV9FoEC', '1728896509', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"cHUWpjApNTAfIIYFoyZMEZuoNws16dBBlLSkMlgq\";s:7:\"configs\";a:11:{s:9:\"site_name\";s:42:\"7awalaya - Hawalaya - حـواليــّه\";s:13:\"meta_keywords\";s:106:\"Events, Exhibitions, Offers, Coupons, 7awalaya, Android, Application, Mobile, Tablet, shopping, navigation\";s:16:\"meta_description\";s:237:\"RIGHT PLACE, RIGHT DEAL, RIGHT TIME\r\n7AWALAYA is a free mobile phone application that gives you deals and information from your favorite brands when you’re around the shopping point. No need to search for offers, they’ll come to you.\";s:8:\"facebook\";s:32:\"http://www.facebook.com/7awalaya\";s:7:\"twitter\";s:31:\"http://www.twitter.com/7awalaya\";s:10:\"googleplus\";s:27:\"http://google.com/+7awalaya\";s:13:\"contact_email\";s:17:\"info@7awalaya.com\";s:12:\"header_title\";s:8:\"7awalaya\";s:12:\"package_text\";s:29:\"Choose Package that suits you\";s:10:\"login_text\";s:35:\"Login with your E-mail and Password\";s:13:\"register_text\";s:33:\"Register with E-mail and Password\";}s:8:\"language\";s:2:\"en\";}')

7awalaya Shopping never being easier