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 56,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 2 rooms 49 Sqm
₪ 3.100.000

Lev Tel-Aviv
Tel Aviv 26/09/2024 New Project
With not missing!, in center, new Reference : tl 2415
Apartment 2 rooms 44 Sqm
₪ 3.750.000

Lev Tel-Aviv
Tel Aviv 26/09/2024 New Project
With not missing!, in center, high… Reference : tl 2417
Apartment 2 rooms 59 Sqm
₪ 2.086.000

Bat Yam
Bat yam 26/09/2024 New Project
With not missing!, in center, with… Reference : by 202
Apartment 3 rooms 77 Sqm
₪ 7.650.000

Quarter Of The Sea
Tel Aviv 26/09/2024 New Project
In center, with terrace, in a new… Reference : tl 2421
Apartment 3 rooms 81 Sqm
₪ 1.685.000

Ashkelon
Ashkelon 26/09/2024 New Project
With terrace, well arranged, good site ,…
Apartment 3 rooms 77 Sqm
₪ 4.390.000

Dizengof
Tel Aviv 26/09/2024 For sale
EXCLUSIVITY With terrace, in center, good site ,…
Apartment 3 rooms 70 Sqm
₪ 3.740.000

Florentine
Tel Aviv 26/09/2024 For sale
With terrace, in center, good site ,…

1
2
6
7
8
9
10
11
12
13
14
15

RealEstate-Israel.com it is also