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'
AND (1) AND an.idag IN (210, 144, 233, 226, 316, 342, 601, 511, 525, 232, 288, 175, 60, 357, 440, 379, 513, 522, 527, 529, 577, 630) ORDER BY rand() 	LIMIT 0,5
2017 Listings

in Israel

Free Email Alert
  • Sale Apartment Jerusalem
    Featured
    Sale, Published on 02/11/2024

    ₪2.850.000

    Apartment 3 rooms, 69

    EXCLUSIVE

    Jerusalem, Rasko

  • Sale Villa Hadera
    Featured
    Sale, Published on 29/10/2024

    ₪8.950.000

    Villa 8 rooms, 300

    EXCLUSIVE

    Hadera, City Center

  • Sale Cottage Gan Yavne
    Featured
    Sale, Published on 05/11/2024

    ₪3.790.000

    Cottage 6 rooms, 260

    EXCLUSIVE

    Gan Yavne, Gan Yavne

  • Sale Building Eilat
    Featured
    Sale, Published on 11/11/2024

    ₪5.400.000

    Building 10 rooms, 400

    EXCLUSIVE

    Eilat, Shachamon 4

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

    ₪17.000.000

    Penthouse 6 rooms, 272

    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