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 (0) 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 90,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 (0) AND (1) AND an.idan NOT IN (6323, 3654, 6, 1850, 1) ORDER BY an.date DESC ,an.heure DESC LIMIT 126,7
879 Listings
For sale en Israel
-
Top ad
Apartment 4 rooms 121 Sqm
₪
3.480.000
Bat yam 26/09/2024 For sale
With terrace, in a beautiful building,…
-
Top ad
Apartment 2 rooms 40 Sqm
₪
3.450.000
Tel Aviv 17/09/2024 For sale
near to the sea, with not missing!,…
-
Top ad
Apartment 3 rooms 91 Sqm
₪
7.120.000
Tel Aviv 27/03/2024 For sale
EXCLUSIVITY
On frishman st, tel aviv
One real estate exclusively presents to you the…
-
Top ad
Duplex 9 rooms 515 Sqm
₪
19.800.000
Jerusalem 29/09/2024 For sale
Your dream turned to reality in bayt…
Luxurious and unique triplex, 515 square meters…
-
Top ad
Villa 7 rooms 240 Sqm
₪
N/A
Jerusalem 05/10/2024 For sale
With not missing!, with terrace,…
? not to be missed! ?
Discover this superb…
-
Apartment 4 rooms 115 Sqm
₪
3.400.000
Tel Aviv 03/10/2024 For sale
With not missing!, pleasant apartment,…
Superb apartment, magnificent renovation,…
-
₪
4.100.000
Tel Aviv 03/10/2024 For sale
With not missing!, with terrace,…
Anglais
Français
Arabe
Superbe…
-
₪
4.200.000
Tel Aviv 03/10/2024 For sale
Pleasant apartment, with terrace,…
207 / 5?000
Very nice 3-room apartment with a…
-
₪
10.500.000
Tel Aviv 03/10/2024 For sale
With terrace, good site , near to the…
-
Apartment 3 rooms 130 Sqm
₪
7.500.000
Tel Aviv 03/10/2024 For sale
With terrace, in a beautiful building,…
-
₪
3.950.000
Tel Aviv 03/10/2024 For sale
With terrace, calm, invested, high…
-
Penthouse 3 rooms 220 Sqm
₪
16.000.000
Tel Aviv 03/10/2024 For sale
With terrace, calm, large, roomy