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-18' and (d_EndTime >= '08:00:00' OR d_EndTime ='00:00:00')) OR (d_EndDate >'2014-04-18')) 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 (295)) or (pi_ParentID in (select pa_CategoryID from Categories where pi_ParentID in (295)))) 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 Real Estate Listings and Property Developments in Lebanon :: Beirut.com :: Beirut City Guide
 

Victoria Residence

  • Property Developments
  • Aramoun
  • Real Estate Developer: Burjan LLC
 

Corniche Tower

  • Property Developments
  • Corniche El Mazraa
  • Real Estate Developer: F Group
 

bedrooms Apartment for Rent in Beirut / Ain al-Mraiseh for $10,000 / Year

Amazing Value !A beautifully presented two rooms office offering opulent working space located in a prime location in Beirut, Ain El Mraiseh. With multiple access points, the office is located on a...

 

bedrooms Apartment for Rent in Beirut / Ain al-Mraiseh for $21,000 / Year

Amazing Value !An Attractive, generously proportioned office space for rent, ideally located on a main road in Ain El Mraiseh, Beirut. The office comprises entrance hall, five generous rooms,...

 

bedrooms Apartment for Rent in Beirut / Ain al-Mraiseh for $21,000 / Year

Amazing Value !Enviably located moments from both Beirut Down Town and Verdun neighborhoods, this desirable four rooms office combines beautiful contemporary interiors and open area view. This well...

 

bedrooms Apartment for Rent in Beirut / Ain al-Mraiseh for $24,000 / Year

In a Class by ItselfSuited on the fifth floor of a totally renovated building in the commercial hub of Ain Al-Mraiseh, Beirut, this unit offers over 113 SQM of ideal working space with capacious...

 

bedrooms Apartment for Rent in Beirut / Ain al-Mraiseh for $40,000 / Year

  • Residential, Commercial
  • Real Estate Agent: Brokers XP

Impressive and UniqueAn Attractive, generously proportioned five rooms 3rd floor office, offering over 150 SQM of exceptionally working space, ideally located in Ain Al-Mraiseh. The office comprises ...

 

bedrooms Apartment for Rent in Beirut / Ain al-Tineh for $20,000 / Year

  • Residential, Commercial
  • Real Estate Agent: Brokers XP

Excellent ValueSituated on the first floor of a building in Ain al Tineh with multiple access points, this elegant four rooms office combines bright interiors and contemporary furniture. The office ...

 

bedrooms Apartment for Rent in Beirut / Airport Area for $100,000 / Year

  • Residential, Commercial
  • Real Estate Agent: Brokers XP

Open to OffersA beautifully presented open space showroom offering opulent working space with beautiful high ceilings in a prime location in Airport area, Beirut. The property is set within a...

 

bedrooms Apartment for Rent in Beirut / Airport Area for $55,000 / Year

  • Residential, Commercial
  • Real Estate Agent: Brokers XP

Excellent Value !This beautifully presented showroom offering opulent working space with high ceilings is available for rent in Airport Area. The showroom comprises a wide reception hall, a...