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 (214) OR pi_CategoryID IN (SELECT pa_CategoryID FROM Categories WHERE pi_ParentID in (214)) )) 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-21' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-21')) 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
Three Stars :: Hotels :: Beirut.com :: Beirut City Guide
 

Adma Blue Screen Furnished Apartments

  • Extended Stay Hotel, Three Star Hotel
  • Adma

Adma Blue Screen is located in the residential area of adma close to the international TV station "LBCI". It has a panoramic view on the bay of Jounieh, is located halfway between Beirut and Tripoli, ...

 

Ahiram Hotel

  • Three Star Hotel
  • Jbeil

A relaxing beach front hotel, that is located on a beach overlooking a beautiful rocky bay, at few steps away from the citadel, the old port and the market of Byblos. At Ahiram Hotel you will be...

 

Anjar Hotel

  • Three Star Hotel
  • Anjar

Ideally situated right next to the Anjar spring and a 10-minute walk from the ruins of Anjar's ancient fortress, Anjar Hotel offers the perfect escape for a low-key weekend or a relaxing vacation.

 

Auberge du Faqra Hotel

  • Three Star Hotel
  • Faraya

L'auberge De Faqra is located on the mountains of Faqra and is 10 km near Ouyoun Siman ski slopes.Guests get to enjoy skiing in the mountains, and the hotel offers ski lessons and the option of...

 

Barouk Palace Hotel

  • Three Star Hotel
  • Barouk

Barouk Palace Hotel is located 1,150 m2 above sea level and is positioned at the Barouk mountain Range with a captivating view which covers the entire mountain range. Barouk Palace targets a variety...

 

Bay Inn Hotel

  • Three Star Hotel
  • Jounieh

Bay inn hotel is in a quaint little calm hotel situated in a quiet neighborhood at the bay of Jounieh / Maameltein.

 

Belmont Hotel

  • Three Star Hotel
  • Ehden

Belmont Hotel, located in a quiet area of Ehden, is the perfect place for a family vacation in the mountains, whether for a ski trip or just a relaxing summer break. Prices starting at: $90 per ...

 

Bliss 3000 Furnished Studios

  • Extended Stay Hotel, Three Star Hotel
  • Hamra

Bliss 3000 has different types of rooms that are suitable and convenient to families, Students, couples and single persons. Short and long term lease accepted.

 

Byblos Comfort Hotel

  • Three Star Hotel
  • Jbeil

Located in the heart of Byblos just a short walk to various centers, restaurants and entertainment areas, Byblos comfort hotel is a newly constructed 3 floor property consisting of 46 elegantly...

 

Byblos Hilltop Hotel

  • Three Star Hotel
  • Jbeil

Just a five minute drive from Byblos City Centre, Byblos Hilltop Hotel is situated in Jbeil. It offers free WiFi in all areas, a restaurant that features a 24-hour room service and a tour desk that...