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

    Villa For Sale in Raachine
    Agent Reference: [M 3020]
    Location: [Kesrwan]
    Bedrooms: [3]
    Bathrooms: [5]
    Size: [400 m2]

    Our Price:  $500,000

    -Ss floor (2 parking, technical room , water tank 10000m3 water ,cave , wc, kitchenette ) -ground floor (salon, chimney salon , dining room , main kitchen , guest wc ) -First floor ( master bedroom , master wc, 2 bedrooms , 1 wc , living ) -Roof top (kitchenette , wc , open Jacuzzi , pergola ) General specifications : -400 sqm every block -exterior gladding , natural stone and wood -central heater (chauffage) wood chimney -interior doors are made of oak wood -gypsum board ceiling -kitchens cabinets are made of natural oak -flooring for salon: ceramic 90*90 (pleine masse) -flooring for bedrooms: parquet (wood) -exterior glass: double glass securite Location : Attitude :1000 m Area: Raachine Keserwan limit of Aachkout View : panoramic sea and mountain view
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 = '380' and opa.orders_id = opb.orders_id and opb.products_id != '380' 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