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 15,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 (606, 5874, 14, 279, 3714) ORDER BY an.date DESC ,an.heure DESC LIMIT 21,7
433 Listings
New Project en Israel
-
Top ad
Apartment 4 rooms 101 Sqm
Jerusalem 03/09/2024 New Project
₪
3.100.000
-
Top ad
Apartment 5 rooms 111 Sqm
Ashdod 26/09/2024 New Project
₪
3.050.000
-
Top ad
Apartment 4 rooms 97 Sqm
Eilat 02/10/2024 New Project
₪
1.660.000
-
Top ad
Apartment 2 rooms 48 Sqm
Eilat 02/10/2024 New Project
₪
1.500.000
-
Top ad
Ground floor 4 rooms 187 Sqm
Tel Aviv 17/09/2024 New Project
₪
7.800.000
-
Apartment 3 rooms 91 Sqm
Tel Aviv 06/10/2024 New Project
₪
6.710.000
-
Ground floor 6 rooms 136 Sqm
Tel Aviv 06/10/2024 New Project
₪
13.300.000
-
Mini-Penthouse 5 rooms 116 Sqm
Tel Aviv 06/10/2024 New Project
₪
10.000.000
-
Mini-Penthouse 5 rooms 116 Sqm
Tel Aviv 06/10/2024 New Project
₪
10.000.000
-
Apartment 4 rooms 120 Sqm
Tel Aviv 06/10/2024 New Project
₪
8.890.000
-
Apartment 3 rooms 68 Sqm
Tel Aviv 06/10/2024 New Project
₪
6.660.000
-
Apartment 3 rooms 69 Sqm
Tel Aviv 06/10/2024 New Project
₪
5.650.000