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 an.transaction IN (0) 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 30,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 an.transaction IN (0) AND (1) AND an.idan NOT IN (1587, 1461, 3346, 1395, 238) ORDER BY an.date DESC ,an.heure DESC LIMIT 42,7
885 Listings
For sale en Israel
-
Top ad
Penthouse 6 rooms 173 Sqm
₪
5.400.000
Netanya 10/08/2023 For sale
penthouse - upgrade your life
-
Top ad
Apartment 4 rooms 110 Sqm
₪
1.990.000
Ashdod 26/09/2024 For sale
With terrace, invested, in center, good…
-
Top ad
Apartment 2 rooms 52 Sqm
₪
2.790.000
Tel Aviv 06/10/2024 For sale
With not missing!, pleasant apartment,…
2 rooms apartment in a recent building with…
-
Top ad
Apartment 3 rooms 90 Sqm
₪
1.520.000
Ashkelon 12/03/2023 For sale
EXCLUSIVITY
Roomy, good bargain
Location: ashkelon neve ilan
3 bedroom apartment…
-
Top ad
Villa 6 rooms 300 Sqm
₪
4.500.000
Eilat 02/10/2024 For sale
EXCLUSIVITY
With terrace, calm, invested, balcony on…
Villa grande with large volumes - very high…
-
Penthouse 4 rooms 136 Sqm
₪
5.500.000
Tel Aviv 06/10/2024 For sale
Mini penthouse avec terrasse gordon ben…
-
₪
3.480.000
Tel Aviv 06/10/2024 For sale
EXCLUSIVITY
Investor bauhaus new 2 bedrooms…
New renovayed bauhaus building
2 bedrooms with…
-
Apartment 4 rooms 115 Sqm
₪
4.200.000
Tel Aviv 06/10/2024 For sale
EXCLUSIVITY
Sublime appartement d'architecte
-
Apartment 4 rooms 150 Sqm
₪
6.700.000
Tel Aviv 06/10/2024 For sale
EXCLUSIVITY
Appartement d'exception avec beau…
-
₪
3.190.000
Tel Aviv 06/10/2024 For sale
Beau 3 pieces renove
-
₪
4.290.000
Tel Aviv 06/10/2024 For sale
Stunning 2br lift + parking + balcony…
-
Apartment 5 rooms 131 Sqm
₪
1.950.000
Ashkelon 05/10/2024 For sale
EXCLUSIVITY
near to the sea
In barnea a beautiful spacious 5 room apartment…