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 265,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, 3309, 451, 371, 638) ORDER BY an.date DESC ,an.heure DESC LIMIT 371,7
432 Listings
New Project en Israel
-
Top ad
Apartment 4 rooms 133 Sqm
₪
9.955.000
Tel Aviv 30/09/2024 New Project
With not missing!, with terrace, clear,…
-
Top ad
Apartment 4 rooms 104 Sqm
₪
6.300.000
Tel Aviv 05/10/2024 New Project
With not missing!, in center, with…
New apartment with lift and balcony
Ready end…
-
Top ad
Apartment 3 rooms 86 Sqm
₪
1.850.000
Eilat 02/10/2024 New Project
EXCLUSIVITY
Apartment with terrace, calm apartment,…
The luxury home project is located in the most…
-
Top ad
Penthouse 5 rooms 165 Sqm
₪
4.150.000
Eilat 02/10/2024 New Project
EXCLUSIVITY
With terrace, calm, in a beautiful…
A brand new project new a eilat exceptional…
-
Top ad
Apartment 2 rooms 54 Sqm
₪
3.450.000
Jerusalem 03/09/2024 New Project
In the city center of jerusalem
A new luxury residential project in jerusalem near…
-
Apartment 4 rooms 111 Sqm
₪
3.300.000
Netanya 22/08/2024 New Project
VIDEO
Balcony on the sea, good site , high…
-
Apartment 4 rooms 106 Sqm
₪
3.200.000
Netanya 22/08/2024 New Project
VIDEO
Balcony on the sea, good site , high…
-
Apartment 5 rooms 132 Sqm
₪
4.000.000
Netanya 22/08/2024 New Project
VIDEO
Balcony on the sea, good site , high…
-
Apartment 4 rooms 104 Sqm
₪
3.100.000
Netanya 22/08/2024 New Project
VIDEO
Balcony on the sea, good site , high…
-
₪
13.000
Netanya 22/08/2024 New Project
VIDEO
Invested, good site , high standing
-
₪
4.000.000
Netanya 22/08/2024 New Project
VIDEO
With terrace, in center, balcony on the…
-
₪
3.350.000
Netanya 22/08/2024 New Project
VIDEO
With terrace, in center, balcony on the…