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 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 115,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 (1) AND an.idan NOT IN (367, 446, 384, 3266, 2025) ORDER BY an.date DESC ,an.heure DESC LIMIT 161,7

1506 Listings

en Israel

List Grid

Free email alert

- Recommended Property
- Recommended Property
- Recommended Property
Top ad
Apartment 4 rooms 121 Sqm
₪ 3.860.000

Bat Yam
Bat yam 19/09/2024 New Project
With terrace, calm, in a beautiful… This project consists of a luxurious 35-story…
- Recommended Property
- Recommended Property
- Recommended Property
Top ad
Penthouse 4 rooms 100 Sqm
₪ 3.700.000

Eilat
Eilat 02/10/2024 New Project
EXCLUSIVITY With terrace, calm, in a beautiful… A brand new project new a eilat exceptional…
- Recommended Property
- Recommended Property
Top ad
Apartment 5 rooms 150 Sqm
₪ 3.480.000

Bat Yam
Bat yam 19/09/2024 New Project
EXCLUSIVITY With terrace, calm, in a beautiful… The project is located in bat yam, just a few…
Top ad
Apartment 4 rooms 122 Sqm
₪ 6.700.000

Bavli
Tel Aviv 05/10/2024 For sale
Pleasant apartment, in center, with… Spacious 4 rooms apartment in a fairly recent…
- Recommended Property
- Recommended Property
- Recommended Property
Top ad
Apartment 5 rooms 170 Sqm
₪ 3.550.000

Youd Bet
Ashdod 08/02/2024 For sale
With not missing! Magnificent 5 room apartment for sale in ashdod in…
Apartment 4 rooms 105 Sqm
₪ 6.260.000

City Center
Tel Aviv 05/10/2024 For sale
With terrace, in a beautiful building,… 4 rooms apartment in a new boutique building with…
- Recommended Property
Apartment 4 rooms 112 Sqm
₪ 7.250.000

City Center
Tel Aviv 05/10/2024 For sale
With terrace, in a beautiful building,… 4 rooms apartment in a new small luxury building…
Penthouse 4 rooms 251 Sqm
₪ 18.500.000

Lev Tel-Aviv
Tel Aviv 05/10/2024 For sale
With terrace, in a beautiful building,… Amazing penthouse in a new luxury building with…
Apartment 5 rooms 128 Sqm
₪ 5.650.000

Ramat Aviv
Tel Aviv 05/10/2024 For sale
With not missing!, pleasant apartment,… 5 rooms apartment in a new boutique building in a…
Apartment 5 rooms 130 Sqm
₪ 5.350.000

Yaffo
Tel Aviv 05/10/2024 For sale
EXCLUSIVITY Need renovation, with terrace, in… In north yafo north in a quiet street, close to…
Mini-Penthouse 4 rooms 134 Sqm
₪ 6.400.000

Ramat Aviv
Tel Aviv 05/10/2024 For sale
With not missing!, with terrace,… Mini penthouse 4 rooms close to the beach of ramat…
Apartment 4 rooms 121 Sqm
₪ 4.950.000

Ramat Aviv
Tel Aviv 05/10/2024 For sale
With not missing!, with terrace,… 4.5 rooms apartment close to the beach, ramat aviv…

RealEstate-Israel.com it is also