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 (25) OR pi_CategoryID IN (SELECT pa_CategoryID FROM Categories WHERE pi_ParentID in (25)) )) 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-19' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-19')) 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
Beaches & Pools :: Recreation & Spaces :: Places :: Beirut.com :: Beirut City Guide
 

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...

 

Al Jisr Beach Club

  • Beach & Pool
  • Damour

 

Ammos Beach Resort

  • Beach & Pool
  • Khaldeh

Ammos is a swimming resort, restaurant, nightspot and venue located on the beautiful beach of Khaldeh. Serving as a lounge bar, beach bar, Greek restaurant and a party location, Ammos Beach Resort ...

 

Aqua Marina

  • Beach & Pool
  • Tabarja

The Aqua Marina Beach Resort is a recreation and rest spot located in Tabarja. The resort offers pools and beach access, as well as playgrounds for kids. The resort also rents and sells chalets...

 

ATCL (Automobile et Touring Club du Liban)

  • Outdoor Activities, Beach & Pool
  • Jounieh

The ATCL (Automobile et Touring Club du Liban) is a club and beach resort that organizes automotive events, sports events and many other festivities throughout the year. The club has its own harbor...

 

Atlas Beach

  • Beach & Pool
  • Jiyeh

Atlas Beach is sited in a natural amphitheater along the coast. The beach is situated among more than 17,000 meters of flat land. That means no buildings to block your view, just nature. Atlas...

 

Bain Militaire (Al Hammam Al Aaskary)

  • Beach & Pool
  • El-Manara, Kaslik

Bain Militaire is a sports compound that includes pools, a basketball gym, and access to the beach. It is well suited for families and large groups, lockers are available on demand, and the prices ...

 

Bamboo Bay

  • Beach & Pool
  • Jiyeh

The idea is Gilbert El Khoury’s brainchild, born in 2002. In synch with the concept creator, Bamboo Bay is the place where pleasure is to be shared by couples, families and friends. Bamboo Bay...

 

Bay 183

  • Beach & Pool
  • Jbeil

Previously known as Voile Bleue - Bay 183 is a beach resort on the Byblos sea side. Enjoy swimming and chilling in the pool and the sand beach. The kids also get their share of the fun at the...

 

Beach 37

  • Beach & Pool
  • Rmeileh

Located about 25 minutes away from Beirut, Beach 37 is a sandy beach with a 500-meter waterfront. Entrance fee: $7 per person