1. Share Product
    Share via E-Mail Share on Facebook Share on Twitter
  2. Previous
    Property 1 of 8
    This Property was added to our catalog on Friday 30 August, 2013.

    Apartments For Sale in Ain Al Rihani
    Agent Reference: [A 2001]
    Location: [Kesrwan]
    Bedrooms: [3]
    Bathrooms: [3]
    Size: [180 m2]

    Our Price:  $300,000

    Located on the main road between Ain Al Rihani and Jeita,this building is under construction and delivery will be on 2013.Each apartment includes 3 bedrooms(1 master),3 bathrooms,maid room in addition to heater,ac installations,2 parking and one basement.Note that two duplex are available with additional 80sqm.
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'salamehe_property.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '399' and opa.orders_id = opb.orders_id and opb.products_id != '399' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 8