Advanced search

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 56,7

Engel nehassim
Contact: Engel Patrick

Phone

Phone 2

Cell phone

Website

128 Published listings

87 With pictures

128 Listings

en Israel

List Grid

Free email alert

Ground floor 3 rooms 165 Sqm
₪ 8.300.000

Quarter Of The Sea
Tel Aviv 26/09/2024 For sale
With terrace, calm, with not missing!,…
Duplex 3 rooms 89 Sqm
₪ 4.890.000

Quarter Of The Sea
Tel Aviv 25/09/2024 For sale
Need renovation, with terrace, calm,…
Apartment 4 rooms 126 Sqm
₪ 9.260.000

Quarter Of The Sea
Tel Aviv 25/09/2024 For sale
With terrace, calm, near to the sea,…
Penthouse 5 rooms 260 Sqm
₪ N/A

Quarter Of The Sea
Tel Aviv 25/09/2024 For sale
With terrace, calm, balcony on the sea,…
Penthouse 5 rooms 280 Sqm
₪ 18.500.000

Quarter Of The Sea
Tel Aviv 25/09/2024 For sale
With terrace, calm, near to the sea,…
Apartment 2 rooms 60 Sqm
₪ 3.700.000

Quarter Of The Sea
Tel Aviv 25/09/2024 For sale
Calm, near to the sea, with not…
Penthouse 4 rooms 210 Sqm
₪ 13.500.000

Quarter Of The Sea
Tel Aviv 25/09/2024 For sale
With terrace, calm, in a beautiful…

1
2
4
5
6
7
8
9
10
11
12
13
14
18
19

RealEstate-Israel.com it is also