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, 1, 2, 3) AND an.ville='Netanya' 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 an.transaction IN (0, 1, 2, 3) AND an.ville='Netanya' AND (1) AND an.idan NOT IN (1391, 93, 1270, 1466, 1614) ORDER BY an.date DESC ,an.heure DESC LIMIT 161,7
148 Listings
For sale,For rent,New Project,Holidays to Netanya
-
Top ad
Offices 5 rooms 162 Sqm
Netanya 24/01/2024 For rent
₪
11.713
-
Top ad
Apartment 3 rooms 83 Sqm
Netanya 22/08/2024 New Project
₪
3.350.000
-
Top ad
Apartment 3 rooms 90 Sqm
Netanya 10/08/2023 For sale
₪
3.200.000
-
Top ad
Villa 7 rooms 220 Sqm
Netanya 24/01/2024 For sale
₪
6.800.000
-
Top ad
Apartment 5 rooms 135 Sqm
Netanya 03/08/2023 For sale
₪
5.300.000
Our Features to Netanya
-
3.400.000 ₪
-
3.000.000 ₪
-
3.960.000 ₪
-
14.000.000 ₪
-
2.950.000 ₪
-
1.100.000 ₪
-
335.000 ₪
-
3.100.000 ₪
-
3.350.000 ₪
-
1.940.000 ₪
-
2.500.000 ₪
-
2.230.000 ₪
-
4.500.000 ₪
-
4.580.000 ₪
-
9.500.000 ₪