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 30,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 (3583, 1408, 6669, 621, 67) ORDER BY an.date DESC ,an.heure DESC LIMIT 42,7
432 Listings
New Project en Israel
-
Top ad
Villa rooms 0 Sqm
Tel Aviv 22/09/2024 New Project
₪
N/A
-
Top ad
Apartment 2 rooms 64 Sqm
Jerusalem 26/09/2024 New Project
₪
2.048.000
-
Top ad
Cottage 6 rooms 380 Sqm
Hod Hasharon 24/09/2024 New Project
₪
8.650.000
-
Top ad
Apartment 4 rooms 105 Sqm
Jerusalem 03/09/2024 New Project
₪
4.237.500
-
Top ad
Apartment 4 rooms 107 Sqm
Netanya 22/08/2024 New Project
₪
2.830.000
-
Apartment 3 rooms 93 Sqm
Tel Aviv 05/10/2024 New Project
₪
5.340.000
-
Apartment 4 rooms 114 Sqm
Tel Aviv 05/10/2024 New Project
₪
6.690.000
-
Mini-Penthouse 2 rooms 93 Sqm
Tel Aviv 05/10/2024 New Project
₪
5.980.000
-
Apartment 4 rooms 113 Sqm
Tel Aviv 05/10/2024 New Project
₪
6.560.000
-
Apartment 3 rooms 63 Sqm
Tel Aviv 05/10/2024 New Project
₪
3.900.000
-
Apartment 4 rooms 104 Sqm
Tel Aviv 05/10/2024 New Project
₪
6.300.000
-
Apartment 4 rooms 114 Sqm
Tel Aviv 05/10/2024 New Project
₪
6.850.000