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 date >= '2022-10-06'
AND an.transaction IN (2) AND (1) AND an.idag IN (210, 144, 233, 226, 316, 342, 601, 511, 525, 232, 83, 288, 175, 60, 357, 440, 379, 513, 522, 527, 529, 577, 630) ORDER BY rand() LIMIT 295,5SELECT 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 date >= '2022-10-06'
AND an.transaction IN (2) AND (1) AND an.idan NOT IN (649, 3297, 6209, 598, 602) ORDER BY an.date DESC ,an.heure DESC LIMIT 413,7
433 Listings
New Project en Israel
-
Top ad
Apartment 3 rooms 79 Sqm
Jerusalem 03/09/2024 New Project
₪
3.420.000
-
Top ad
Apartment 5 rooms 172 Sqm
Tel Aviv 05/10/2024 New Project
₪
11.540.000
-
Top ad
Apartment 3 rooms 70 Sqm
Tel Aviv 26/09/2024 New Project
₪
4.250.000
-
Top ad
Apartment 3 rooms 80 Sqm
Tel Aviv 03/09/2024 New Project
₪
5.875.000
-
Top ad
Apartment 2 rooms 49 Sqm
Jerusalem 03/10/2024 New Project
₪
1.920.000
-
Apartment 4 rooms 115 Sqm
Netanya 24/01/2024 New Project
₪
3.100.000
-
Apartment 4 rooms 110 Sqm
Netanya 24/01/2024 New Project
₪
3.500.000
-
Apartment 5 rooms 126 Sqm
Netanya 24/01/2024 New Project
₪
2.780.000
-
Apartment 3 rooms 90 Sqm
Netanya 24/01/2024 New Project
₪
3.300.000
-
Apartment 5 rooms 150 Sqm
Netanya 24/01/2024 New Project
₪
6.100.000
-
Apartment 3 rooms 93 Sqm
Netivot 27/12/2023 New Project
₪
1.425.000
-
Apartment 4 rooms 113 Sqm
Netivot 27/12/2023 New Project
₪
1.525.000