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 (55) OR pi_CategoryID IN (SELECT pa_CategoryID FROM Categories WHERE pi_ParentID in (55)) )) 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-20' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-20')) 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
Mobile Devices :: Appliances :: Shops :: Beirut.com :: Beirut City Guide
 

A.M.T.

  • Mobile Devices
  • Hamra

A.M.T is a mobile phone store in Hamra, where you can get stylish accessories for your phone.

 

Beirut Net

  • Mobile Devices
  • Hamra

Beirut Net is a mobile phones store located in Hamra which has mobile phones' accessories and even game applications.

 

Bilal Cell.Com

  • Mobile Devices
  • Hamra

Bilal Cell.Com is a mobile phones shop located in Hamra which also sells recharger cards and mobile phone accessories.

 

BlackBerry

  • Mobile Devices
  • Downtown

BlackBerry is a line of wireless mobile devices developed by Canadian company Research In Motion (RIM). it is a cell phones store. it has the different brands and accesories.

 

Blue Cell

  • Mobile Devices
  • Hamra

Blue Cell is a mobile phones and accessories store located on Makhoul Street, Hamra. it also sells recharge cards and phone accessories.

 

Blue Square Technology

  • Computers & Devices, Mobile Devices, Gadgets
  • Sin El-Fil, Zalka

A one-stop-shop for multimedia, electronics and accessories, Blue Square Technology imports and distributes first class electronic products.

 

BMT Tech

  • Computers & Devices, Mobile Devices
  • Hamra

BMT Tech is a store located in Hamra which sells desktop computers and laptops. accessories for computers are available there also.

 

BUCell

  • Mobile Devices
  • Hamra

Located near LAU, BUCell is a small shop for all mobile phone accessories and products, as well as credit and unit recharge.

 

Call Net

  • Mobile Devices
  • Hamra

Call Net is the place to find Mobiles, Accessories and Gifts in Hamra. it sells also recharge cards.

 

Cell D'or

  • Mobile Devices
  • Hamra

Cell D'or is a mobile phones shop in Hamra. it sells mobiles and accessorises and recharge cards.