Centre Point Egypt

عمرو موسى 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 : Clothing Address Centrepoint, Building 2085 Al Ma’raj City, Maadi - Cairo, Egypt Telephone 0229177300

Offers Coupons Events

Centrepoint is a one stop shopping destination, with Babyshop, Splash, Lifestyle, Shoe Mart and more recently Beautybay under one roof. Centrepoint has become the 1st choice shopping destination for the whole family across the Middle East.

The Centrepoint has been designed to reflect the dynamism and diversity of the brands it represents and leverage their brand equity and appeal. The most visible benefit of this convergence has been the enhanced design and stimulating shopping experience for consumers. Centrepoint will offer the same great value for money in a visually exciting destination for the whole family. It is shaping consumer perceptions, increasing brand worth and fuelling future growth for the group in the mid market retail section.

Centrepoint is located in Maadi city center in cairo and Alex city center in Alexandria.
Babyshop, Splash, Lifestyle, Shoe Mart

Sponsoreship

Find

Title Venue Type

Our Venues

Time	Query
0.20ms	SELECT * FROM `sessions` WHERE `id` = 'dRx5wb22W5VEDDUhdT079l5nVeqW4y1vyLOI1cCY' LIMIT 1
0.23ms	SELECT * FROM `configs`
1.02ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `created_at` DESC LIMIT 5
0.48ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `featured` = '1' ORDER BY `title` ASC LIMIT 10
0.29ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '2' ORDER BY `title` ASC LIMIT 5
0.26ms	SELECT * FROM `news` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `created_at` DESC LIMIT 5
0.47ms	SELECT * FROM `pages` WHERE `published` = '1' AND `deleted` = '0' AND `id` != '1' ORDER BY `created_at` DESC
1.01ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.83ms	SELECT * FROM `types` WHERE `published` = '1' AND `deleted` = '0' ORDER BY `title` DESC
0.37ms	SELECT * FROM `stores` WHERE `published` = '1' AND `deleted` = '0' AND `sponsored` = '1' ORDER BY `title` DESC
0.20ms	SELECT * FROM `stores` WHERE `id` = '51' AND `published` = '1' AND `deleted` = '0' LIMIT 1
0.45ms	SELECT * FROM `images` WHERE `link_id` = '51' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.34ms	SELECT * FROM `images` WHERE `link_id` = '51' AND `link_type` = 'stores'
0.32ms	SELECT * FROM `images` WHERE `link_id` = '51' AND `link_type` = 'stores' ORDER BY `order` ASC
0.32ms	SELECT * FROM `categories` WHERE `id` = '60' LIMIT 1
0.57ms	SELECT * FROM `images` WHERE `link_id` = '87' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.29ms	SELECT * FROM `images` WHERE `link_id` = '83' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.30ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.31ms	SELECT * FROM `images` WHERE `link_id` = '25' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.28ms	SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.32ms	SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.44ms	SELECT * FROM `images` WHERE `link_id` = '44' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.35ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.50ms	SELECT * FROM `images` WHERE `link_id` = '13' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
1.48ms	SELECT * FROM `categories` WHERE `id` = '56' LIMIT 1
0.59ms	SELECT * FROM `images` WHERE `link_id` = '80' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.19ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.28ms	SELECT * FROM `images` WHERE `link_id` = '78' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.16ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.31ms	SELECT * FROM `images` WHERE `link_id` = '76' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.14ms	SELECT * FROM `categories` WHERE `id` = '59' LIMIT 1
0.24ms	SELECT * FROM `images` WHERE `link_id` = '47' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.23ms	SELECT * FROM `images` WHERE `link_id` = '48' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.15ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.22ms	SELECT * FROM `images` WHERE `link_id` = '34' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.13ms	SELECT * FROM `categories` WHERE `id` = '55' LIMIT 1
0.23ms	SELECT * FROM `images` WHERE `link_id` = '30' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.16ms	SELECT * FROM `categories` WHERE `id` = '50' LIMIT 1
0.24ms	SELECT * FROM `images` WHERE `link_id` = '56' AND `link_type` = 'stores' ORDER BY `order` ASC LIMIT 1
0.14ms	SELECT * FROM `categories` WHERE `id` = '49' LIMIT 1
0.20ms	SELECT * FROM `pages` WHERE `id` = '1' AND `published` = '1' LIMIT 1
0.18ms	SELECT * FROM `pages` WHERE `id` = '77' AND `published` = '1' LIMIT 1
0.25ms	INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES ('dRx5wb22W5VEDDUhdT079l5nVeqW4y1vyLOI1cCY', '1679653949', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"4fCILWoRoztqn0BzKridZk5H0iellpD7yqOiKmvl\";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.20ms

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

0.23ms

SELECT * FROM `configs`

1.02ms

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

0.48ms

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

0.29ms

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

0.26ms

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

0.47ms

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

1.01ms

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

0.83ms

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

0.37ms

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

0.20ms

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

0.45ms

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

0.34ms

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

0.32ms

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

0.32ms

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

0.57ms

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

0.29ms

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

0.30ms

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

0.31ms

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

0.28ms

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

0.32ms

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

0.44ms

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

0.35ms

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

0.50ms

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

1.48ms

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

0.59ms

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

0.19ms

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

0.28ms

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

0.16ms

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

0.31ms

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

0.14ms

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

0.24ms

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

0.15ms

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

0.23ms

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

0.15ms

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

0.22ms

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

0.13ms

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

0.23ms

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

0.16ms

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

0.24ms

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

0.14ms

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

0.20ms

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

0.18ms

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

0.25ms

INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES ('dRx5wb22W5VEDDUhdT079l5nVeqW4y1vyLOI1cCY', '1679653949', 'a:5:{s:5:\":new:\";a:0:{}s:5:\":old:\";a:0:{}s:10:\"csrf_token\";s:40:\"4fCILWoRoztqn0BzKridZk5H0iellpD7yqOiKmvl\";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