1
2
3
4
5+
Numbers only !
More criteria
SELECT * from usersannonces WHERE DATEDIFF(NOW(),datefin) > 2 ORDER BY idannonce DESC
SELECT SQL_CALC_FOUND_ROWS 
    an.*,
    ag.telephone,
    ag.telephone2,
    ag.mobile,
    ag.url,
    qu.nom AS quartier_nom, 
    (SELECT COUNT(*) FROM `agences_annonces_recommande` AS anr WHERE anr.ida = an.idag AND anr.idan = an.idan) AS anrecommande,
    (SELECT COUNT(*) FROM `agences_page_dediee` AS agd2 WHERE agd2.ida = an.idag) AS agpagedediee2,
    (SELECT COUNT(*) FROM `agence` AS agd 
        LEFT JOIN `forfait` ON agd.`forfait` = `forfait`.`nom` 
        WHERE agd.id = an.idag AND `forfait`.`page_dediee` = 1) AS agpagedediee
FROM `annonce` AS an
    INNER JOIN `agence` AS ag ON an.idag = ag.id
    INNER JOIN `quartier` AS qu ON an.quartier = qu.idqu
WHERE 1
    AND an.vendu = 'N'
    /* AND an.ActivImmo != 'N' */
    AND ag.bloque = 'N'
    AND ag.id != 7
	AND ag.forfait != 'LITE'
    AND date >= '2023-11-13'
ORDER BY rand() 	LIMIT 0,5
2024 Listings

in Israel

Free Email Alert
  • Sale Apartment Ashkelon
    Featured
    Sale, Published on 25/10/2024

    ₪1.950.000

    Apartment 5 rooms, 131

    EXCLUSIVE

    Ashkelon, Barnea

  • Sale Cottage Netanya
    Featured
    Sale, Published on 23/07/2024

    ₪3.200.000

    Cottage 8 rooms, 190

    EXCLUSIVE

    Netanya, Netanya

  • Sale Apartment Tel Aviv
    Featured
    Sale, Published on 28/10/2024

    ₪4.300.000

    Apartment 3 rooms, 79

    EXCLUSIVE

    Tel Aviv, City Center

  • Sale Apartment Tel Aviv
    Featured
    Sale, Published on 03/11/2024

    ₪3.700.000

    Apartment 2 rooms, 60

    Tel Aviv, Quarter Of The Sea

  • New Project Apartment Tel Aviv
    Featured
    New Project, Published on 25/10/2024

    ₪5.340.000

    Apartment 3 rooms, 93

    Tel Aviv, Quarter Of The Sea

  • Rent, Published on 13/11/2024

    ₪5.000

    Apartment 2 rooms, 45

    EXCLUSIVE

    Jerusalem, City Center

  • Sale, Published on 13/11/2024

    ₪5.450.000

    Villa 3 rooms, 71

    Tel Aviv, Bazel

  • Sale, Published on 13/11/2024

    ₪2.450.000

    Apartment 3 rooms, 87

    VIDEO

    Bat yam, Bat Yam

  • Sale, Published on 13/11/2024

    ₪10.000.000

    Duplex-Penthouse 7 rooms, 260

    Netanya, Netanya

  • Sale, Published on 13/11/2024

    ₪2.950.000

    Apartment 5 rooms, 125

    Netanya, City Center

  • Sale, Published on 13/11/2024

    ₪1.250.000

    Apartment 2 rooms, 58

    EXCLUSIVE

    Ashkelon, Marina

  • Sale, Published on 13/11/2024

    ₪4.700.000

    Ground floor 5 rooms, 125

    Netanya, City Center