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 (3778, 93, 3715, 6610, 126) ORDER BY an.date DESC ,an.heure DESC LIMIT 413,7
433 Listings
New Project en Israel
-
Top ad
Apartment 4 rooms 133 Sqm
Tel Aviv 30/09/2024 New Project
₪
9.955.000
-
Top ad
Apartment 3 rooms 83 Sqm
Netanya 22/08/2024 New Project
₪
3.350.000
-
Top ad
Apartment 3 rooms 79 Sqm
Tel Aviv 22/09/2024 New Project
₪
4.870.000
-
Top ad
Apartment 3 rooms 70 Sqm
Tel Aviv 06/10/2024 New Project
₪
5.350.000
-
Top ad
Apartment 4 rooms 106 Sqm
Netanya 22/08/2024 New Project
₪
3.200.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