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 290,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 (1632, 3305, 94, 378, 3777) ORDER BY an.date DESC ,an.heure DESC LIMIT 406,7
433 Listings
New Project en Israel
-
Top ad
Penthouse 5 rooms 150 Sqm
₪
4.950.000
Netanya 24/01/2024 New Project
Nord de la ville - netanya - proche…
-
Top ad
Apartment 4 rooms 126 Sqm
₪
8.550.000
Tel Aviv 05/10/2024 New Project
With not missing!, in center, with…
New project in a quiet street close to the…
-
Top ad
Apartment 4 rooms 97 Sqm
₪
4.000.000
Netanya 22/08/2024 New Project
VIDEO
With terrace, in center, balcony on the…
-
Top ad
Apartment 5 rooms 145 Sqm
₪
N/A
Bat yam 19/09/2024 New Project
With terrace, calm, in a beautiful…
Designed by a famous architect, this project…
-
Top ad
Apartment 3 rooms 102 Sqm
₪
7.100.000
Tel Aviv 28/09/2024 New Project
With not missing!, with terrace, clear,…
-
₪
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
-
Penthouse 5 rooms 295 Sqm
₪
7.500.000
Ashdod 14/02/2024 New Project
VIDEO
Quality project
-
₪
2.350.000
Bat yam 12/02/2024 New Project
New project near the sea and the tramway…
Very beautiful new project in the heart of bat…
-
₪
2.450.000
Bat yam 12/02/2024 New Project
New project near the sea and the tramway…
Very beautiful new project in the heart of bat…
-
₪
2.300.000
Netanya 24/01/2024 New Project
Projet au pied du kikar
-
Ground floor 5 rooms 130 Sqm
₪
4.850.000
Netanya 24/01/2024 New Project
Nord de la ville - netanya - proche…