SELECT pa_ContactID,t_ContactName FROM Profiles as P inner join Categories_ContactsCategories as CC on (CC.pi_contactID=pa_ContactID and pi_CategoryID in (32)) where P.b_Deleted=0 and P.b_Completed=1 and b_featured=0 and ( (t_picsFolder='place' and b_Status=1) OR (t_picsFolder!='place') ) and ( (t_picsFolder='event' and pa_ContactID in (select pi_ContactID FROM Profiles_Events WHERE pi_ContactID=pa_ContactID and ((d_EndDate='0000-00-00') Or (d_EndDate ='2014-04-16' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-16')) and NotImportant=0)) OR (t_picsFolder!='event') ) and ( (t_picsFolder='movie' and 1 in (select b_PlayingNow FROM Profiles_Movies WHERE pi_MovieID=pa_ContactID))OR (t_picsFolder!='movie') ) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
Stores and Malls to Shop for Clothes in Lebanon :: Beirut.com :: Beirut City Guide
 

2 Zareh

  • Clothing
  • Hamra

2 Zareh is a boutique in Hamra, where you can find the latest designs in fashion.

 

2Pieces

  • Clothing
  • Achrafieh

2Pieces is a small shop located in Achrafieh. Consisting mostly of bikinis of European and South American styles, these suits are specially decorated with exotic and brilliant colors. They also...

 

7 Camicie

  • Clothing
  • Sea Side, Verdun

The world of 7camicie cannot be limited to its Italian origin. Made by old traditions and modern designs, this brand is known for its glamor, quality and style. The complementary features of...

 

7 For All Mankind

  • Clothing
  • Downtown

7 For All Mankind, the Californian brand that leads the premium denim sector and came to fame as the favorite jeans of Hollywood celebrities, breathes into all its collections details of luxury and...

 

Aïzone

  • Clothing, Luxury & High End, Accessories
  • Achrafieh, Downtown, Hazmieh, Sea Side, Verdun

Aïzone, the more casual side of Aïshti, exists as a separate entity and carries some of the hippest international brands including Camper, True Religion, 7 for All Mankind, Armani Jeans, and various...

 

Abaco

  • Clothing, Shoes & Footwear
  • Achrafieh

Knapsacks, bags and all other Abaco accessories encourage travel, irreplaceable accomplices in a way of life. They are seductive with irresistible designs, anti-conformist and inspired by a sense of...

 

Absorba Underwear

  • Clothing
  • Achrafieh, Dbayeh

Absorba remains the label known all around the world for its high quality baby underwear and sleepwear combining comfort and security. The collections are colourful, chic and comfortable.

 

Adidas

  • Clothing, Shoes & Footwear, Sporting Goods
  • Downtown, Hamra, Hazmieh, Jnah, Mar Elias, Verdun

Their motto: Impossible is Nothing, drives all brand communication initiatives and helps strengthen the brand's bond with consumers. Besides sports footwear, the company also produces other...

 

Adolfo Dominguez

  • Clothing, Luxury & High End, Shoes & Footwear
  • Achrafieh, Downtown

Adolfo Dominguez was born May 14, 1950. He studied design and cinematography in Paris, with further studies in London. He took over his father's fashion boutique in Ourense in the early 1970s and...

 

Adora Boutique

  • Clothing, Accessories
  • Monot

Visit Adora Boutique for an exquisite collection of artisan clothing, accessories and the traditional Abaya!