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='342' ORDER BY an.date DESC ,an.heure DESC LIMIT 49,7

Comacom Tel Aviv
Contact: Guedj Eric

Phone

Phone 2

Cell phone

Website

Vous cherchez un bien immobilier en israël pour investir ou pour y séjourner ?

l’agence immobilière comacom est là pour vous orienter, vous diriger à choisir le bien qui vous convient

contactez nous nous ferons de votre rêve une réalité !

105 Published listings

88 With pictures

105 Listings

en Israel

List Grid

Free email alert

Apartment 4 rooms 103 Sqm
₪ 4.050.000

City Center
Herzliya 26/09/2024 New Project
With terrace, in center, good site ,…
Apartment 2 rooms 52 Sqm
₪ 3.950.000

Florentine
Tel Aviv 26/09/2024 New Project
With terrace, in center, good site ,…
Apartment 3 rooms 80 Sqm
₪ 2.313.000

Sea
Netanya 26/09/2024 New Project
With terrace, invested, in center, good…
Apartment 4 rooms 108 Sqm
₪ 3.090.000

Bat Yam
Bat yam 26/09/2024 New Project
With terrace, in a beautiful building,…
Apartment 4 rooms 105 Sqm
₪ 2.650.000

City Center
Netanya 26/09/2024 New Project
With not missing!, good site , quality…
Apartment 3 rooms 84 Sqm
₪ 3.020.000

Sea
Netanya 26/09/2024 New Project
With not missing!, in a new building,… Reference : nt 216
Apartment 3 rooms 84 Sqm
₪ 3.020.000

Sea
Netanya 26/09/2024 New Project
With not missing!, in a new building,… Reference : nt 216

1
2
3
4
5
6
7
8
9
10
14
15

RealEstate-Israel.com it is also