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 >= '2022-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
2734 Listings

in Israel

Free Email Alert
  • Sale Mini-Penthouse Netanya
    Featured
    Sale, Published on 08/11/2024

    ₪7.600.000

    Mini-Penthouse 6 rooms, 187

    EXCLUSIVE

    Netanya, City Center

  • New Project Apartment Netanya
    Featured
    New Project, Published on 27/10/2024

    ₪3.100.000

    Apartment 4 rooms, 104

    VIDEO

    Netanya, Kikar

  • Rent Apartment Ashkelon
    Featured
    Rent, Published on 06/08/2023

    ₪4.300

    Apartment 4 rooms, 105

    EXCLUSIVE

    Ashkelon, Barnea

  • Sale Apartment Ashdod
    Featured
    Sale, Published on 06/05/2024

    ₪2.250.000

    Apartment 3 rooms, 100

    EXCLUSIVE

    Ashdod, City

  • Sale Duplex Raanana
    Featured
    Sale, Published on 13/11/2023

    ₪5.850.000

    Duplex 6 rooms, 185

    EXCLUSIVE

    Raanana, Near Center

  • 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

    ₪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

  • Sale, Published on 13/11/2024

    ₪1.220.000

    Apartment 3 rooms, 120

    EXCLUSIVE

    Netivot, Maarav