SELECT pa_ContactID,t_ContactName FROM Profiles as P inner join Categories_ContactsCategories as CC on (CC.pi_contactID=pa_ContactID) inner join Categories on (pa_CategoryID=pi_CategoryID) 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-17' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-17')) 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 ((pi_ParentID in (22)) or (pi_ParentID in (select pa_CategoryID from Categories where pi_ParentID in (22)))) and b_closed=0 and pa_ContactID not in (15756,15755,15754) group by pa_ContactID order by `b_featured` DESC,t_ContactName asc
Recreation :: Spaces :: Places :: Beirut.com :: Beirut City Guide
 

The Corniche

  • Public Space
  • El-Manara
 

7D Cinema

  • Amusement Center
  • Hadeth

Located in Karout Mall, 7D Cinema is an entertaining experience where you can relax in comfort and watch high-quality movies that run between 7 and 10 minutes in length.

 

Abou Philippe Beach & Resort

  • Beach & Pool
  • Jbeil

A good resort gives you a break from your worries. However, this Beach Resort soars beyond such widely accepted standards. Located on Jbeil's magical shore, Abou Philippe strives to make you...

 

Adyar

  • Vineyard
  • Ghazir

ADYAR, simply means ''Monasteries'' in arabic. Unlike others, Adyar is not simply a Lebanese Wine, Adyar is a great ‘’Vin de terroir’’. Its vineyards and wineries are located in different...

 

Ain Zhalta

  • Public Space
  • Barouk

Ain Zhalta is a traditional mountain village located in the Chouf district, rich with history and natural wonders. The village is a full service touristic destination, with a beautiful view of the...

 

Aitou

  • Public Space
  • Zgharta

Aitou is a village located in the Zgharta district of North Lebanon.

 

Akoura

  • Public Space
  • Akoura

Akoura is a village located in the Jbeil district. The village's beautiful natural environment makes it a prime location for tourists.

 

Al Assi River

  • Public Space
  • Bekka

Al Assi River is a natural stream of water, that is prized for its harsh currents and rocky path, which makes it the dream destination for rafting aficionados. Unlike other rivers, Al Assi offers...

 

Al Jabal Club

  • Public Space
  • Qattin

Al Jabal Club, located in Hiyata, Mount Lebanon, is a club that hosts cultural, sports, and social events.

 

Al Jisr Beach Club

  • Beach & Pool
  • Damour