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 285,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 (578, 632, 470, 3255, 278) ORDER BY an.date DESC ,an.heure DESC LIMIT 399,7
432 Listings
New Project en Israel
-
Top ad
Apartment 4 rooms 110 Sqm
₪
4.100.000
Jerusalem 03/09/2024 New Project
Holyland bait vagan
-
-
Recommended Property
Top ad
Duplex 6 rooms 257 Sqm
₪
14.500.000
Jerusalem 03/09/2024 New Project
Jerusalem mamilla david's village
New luxury project located in one of the most…
-
Top ad
Apartment 3 rooms 61 Sqm
$
1.850.000
Eilat 02/10/2024 New Project
EXCLUSIVITY
With not missing!, pleasant apartment,…
-
Top ad
Apartment 4 rooms 113 Sqm
₪
6.460.000
Tel Aviv 03/10/2024 New Project
With terrace, in a beautiful building,…
4 rooms apartment in new project with lift parking…
-
Top ad
Apartment 2 rooms 48 Sqm
₪
1.500.000
Eilat 02/10/2024 New Project
EXCLUSIVITY
With terrace, in a beautiful building,…
-
Apartment 5 rooms 140 Sqm
₪
N/A
Ashdod 06/05/2024 New Project
With terrace, in a beautiful building,…
-
Apartment 4 rooms 126 Sqm
$
N/A
Ashdod 06/05/2024 New Project
In a beautiful building, near to the…
-
$
N/A
Ashdod 06/05/2024 New Project
In a beautiful building, near to the…
-
Apartment 5 rooms 146 Sqm
$
N/A
Ashdod 06/05/2024 New Project
In a beautiful building, near to the…
-
₪
2.156.000
Jerusalem 18/03/2024 New Project
In the city center of jerusalem mekor…
New real estate project in the mekor haim…
-
₪
3.430.000
Jerusalem 18/03/2024 New Project
In the city center of jerusalem mekor…
New real estate project in the mekor haim…
-
Apartment 4 rooms 108 Sqm
₪
4.135.000
Jerusalem 15/02/2024 New Project
City center