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 (76)) 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
Guide to Gyms, Exercise Studios and Sports Facilities in Lebanon :: Beirut.com :: Beirut City Guide
 

Abakua Dance School

  • Gyms & Studios
  • Gemmayzeh

If you hitting the dance floor usually provokes an insane wave of hilarious laughter, it’s time to change the established equilibrium. Abakua Dance School helps setting salseras and salseros...

 

Advanced Sports Center

  • Gyms & Studios
  • Jal el-Dib

Advanced Sports Center (ASC) is the first health center in Lebanon and the Middle East to provide a wide range of health services in one place with a multidisciplinary approach personalized for each...

 

Art & Movement Dance Studio

  • Gyms & Studios
  • Jal el-Dib

The Art & Movement Dance Studio is a studio located in Jal El Dib that gives lessons in all kinds of dancing. They teach Classical Ballet, Contemporary dancing, Jazz dancing, Hip Hop, and Oriental...

 

Arthur Murray Dance Studio

  • Gyms & Studios
  • Zalka

Before signing the Franchisee Agreement with Arthur Murray International Inc., Daniel and Rania Haddad established their own dance school in 1999, dubbing it the Freestyle Dance Studio. Both Daniel...

 

Atlantis Club

  • Gyms & Studios
  • Hamra

Atlantis are a health club facility that promotes wellness and beauty through: Professional expertise, state of the art gym equipment, group exercise studio, beauty salon, healthy bar and a swimming...

 

Atlantis Gym

  • Gyms & Studios
  • Sarba

Whether you'd like to engage in bodybuiliding, billiards, oriental dance, aerobics, taebo, Jiu-Jitsu, Taekwondo or Aikido, all are welcome at Atlantis Gym.

 

Avalon Fitness Club

  • Gyms & Studios
  • Quraitem

Avalon Fitness Club has a huge space and an astonishingly wide range of facilities and services, while still retaining the personality, friendliness and warmth of a much smaller club.

 

Bailando

  • Gyms & Studios
  • Ain El Mreisseh

Since 2003, “Bailando” is a leading in the organization of Musical & Dance Latin Events in Lebanon. Many Local Dancers, International Dance Stars & Artists have participated in Bailando’s...

 

Beirut Olympic Gym

  • Gyms & Studios
  • Gemmayzeh

The Beirut Olympic Gym was started by Coach Khalil Abboud 63 years ago as a place to train the young Lebanese generation. Since then, Beirut Olympic has become more and more of an institution and is...

 

Beirut Yoga Sivananda Center

  • Gyms & Studios
  • Gemmayzeh

The Beirut Yoga Sivananda Center first opened its doors on the 16th of October 2000. The idea of a center in Beirut was put forth by senior disciples of Swami Vishnu-devananda in 1997. It first seemed...