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 (1) AND an.idag='232' ORDER BY an.date DESC ,an.heure DESC LIMIT 35,7
128
Published listings
87
With pictures
128 Listings
en Israel
-
-
Recommended Property
Apartment 3 rooms 70 Sqm
₪
4.600.000
Tel Aviv 28/09/2024 New Project
With terrace, in a beautiful building,…
-
Apartment 3 rooms 100 Sqm
₪
5.750.000
Tel Aviv 28/09/2024 New Project
With not missing!, with terrace, well…
-
Apartment 3 rooms 121 Sqm
₪
11.800.000
Tel Aviv 28/09/2024 New Project
With not missing!, with terrace, calm,…
Sea !!!!!!!!!!View !!!!!!!!!!!!!!
-
Apartment 3 rooms 134 Sqm
₪
13.400.000
Tel Aviv 27/09/2024 New Project
With not missing!, with terrace, calm,…
Sea !!!!!!!!!!View !!!!!!!!!!!!!!
-
Apartment 4 rooms 125 Sqm
₪
7.500.000
Tel Aviv 27/09/2024 New Project
With not missing!, with terrace, well…
-
Penthouse 4 rooms 177 Sqm
₪
14.200.000
Tel Aviv 27/09/2024 For sale
With terrace, with not missing!,…
-
₪
3.900.000
Tel Aviv 27/09/2024 For sale
With terrace, near to the sea, with not…