No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by rt.ordering' at line 1 SQL=SELECT rt.* FROM abx_properties_rates as rt WHERE rt.published = 1 AND rt.productid = order by rt.ordering
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by i.ordering' at line 1 SQL=SELECT i.* FROM abx_properties_images as i WHERE i.published = 1 AND i.parent = order by i.ordering
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by p.ordering' at line 1 SQL=SELECT p.*,c.name as name_category,t.name as name_type,cy.name as name_country,s.name as name_state,l.name as name_locality,pf.name as name_profile,pf.logo_image as logo_image_profile, CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as Pslug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as Cslug, CASE WHEN CHAR_LENGTH(cy.alias) THEN CONCAT_WS(":", cy.id, cy.alias) ELSE cy.id END as CYslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END as Sslug, CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(":", l.id, l.alias) ELSE l.id END as Lslug, CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":", t.id, t.alias) ELSE t.id END as Tslug FROM abx_properties_products as p LEFT JOIN abx_properties_country AS cy ON cy.id = p.cyid LEFT JOIN abx_properties_state AS s ON s.id = p.sid LEFT JOIN abx_properties_locality AS l ON l.id = p.lid LEFT JOIN abx_properties_category AS c ON c.id = p.cid LEFT JOIN abx_properties_type AS t ON t.id = p.type LEFT JOIN abx_properties_profiles AS pf ON pf.mid = p.agent_id WHERE p.published = 1 AND p.parent = order by p.ordering
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by i.ordering' at line 1 SQL=SELECT i.* FROM abx_properties_images as i WHERE i.published = 1 AND i.parent = order by i.ordering
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by p.ordering' at line 1 SQL=SELECT p.*,c.name as name_category,t.name as name_type,cy.name as name_country,s.name as name_state,l.name as name_locality,pf.name as name_profile,pf.logo_image as logo_image_profile, CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as Pslug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as Cslug, CASE WHEN CHAR_LENGTH(cy.alias) THEN CONCAT_WS(":", cy.id, cy.alias) ELSE cy.id END as CYslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END as Sslug, CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(":", l.id, l.alias) ELSE l.id END as Lslug, CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":", t.id, t.alias) ELSE t.id END as Tslug FROM abx_properties_products as p LEFT JOIN abx_properties_country AS cy ON cy.id = p.cyid LEFT JOIN abx_properties_state AS s ON s.id = p.sid LEFT JOIN abx_properties_locality AS l ON l.id = p.lid LEFT JOIN abx_properties_category AS c ON c.id = p.cid LEFT JOIN abx_properties_type AS t ON t.id = p.type LEFT JOIN abx_properties_profiles AS pf ON pf.mid = p.agent_id WHERE p.published = 1 AND p.parent = order by p.ordering
-
AB101: Αγροτεμάχιο στο Πολύγυρο ΧΑΛΚΙΔΙΚΗΣ -ΕΞΑΙΡΕΤΙΚΟ -" 4.288,00 ΤΜ ΠΕΡΙΟΧΗ ΓΕΡΑΚΟΥ ΑΛΩΝΙ - ΧΟΛΟΜΩΝΤΑΣ " ΑΠΕΡΑΝΤΗ ΘΕΑ ΘΑΛΑΣΣΑ
€ 48,000
-
ΑΒ102: Αγροτεμάχιο στο Παλαιόκαστρο - 6.250,00 ΤΜ - ΑΜΦΙΘΕΑΤΡΙΚΟ - ΔΙΠΛΑ ΣΕ ΜΕΖΟΝΕΤΕΣ - ΕΚΤΟΣ ΣΧΕΔΙΟΥ - ΚΑΤΑΛΛΗΛΟ ΓΙΑ ΟΡΕΙΝΗ ΚΑΤΟΙΚΙΑ
€ 25,000
-
OB002: Οικόπεδο 1.070,00 ΤΜ στον Πολύγυρο - ΝΕΑ ΤΙΜΗ - ΠΕΡΙΟΧΗ ΛΟΥΚΙ - Σ.Δ. 0,6 - ΝΕΟΚΤΙΣΤΗ ΠΕΡΙΟΧΗ ΚΑΤΑΛΛΗΛΟ ΓΙΑ ΕΠΕΝΔΥΣΗ
€ 180,000
-
OΘ003: Οικόπεδο στη ΠΑΡΑΛΙΑ ΓΕΡΑΚΙΝΗΣ -ΓΕΡΑΚΙΝΗ ΧΑΛΚΙΔΙΚΗΣ - ΕΝΤΟΣ ΣΧΕΔΙΟΥ - Σ.Δ. 0,5
TIMH 495.000,00 - ΜΟΝΑΔΙΚΟ
€ 495,000
-
AB103: Αγροτεμάχιο στο Πολύγυρο - ΔΙΠΛΑ ΣΕ ΣΠΙΤΙΑ - ΕΚΤΟΣ ΣΧΕΔΙΟΥ - ΘΕΑ ΕΞΑΙΡΕΤΙΚΗ - ΑΝΑΒΑΘΜΙΣΜΕΝΗ ΠΕΡΙΟΧΗ
€ 55,000
-
ΑΒ105 : Αγροτεμάχιο στο Παλαιόκαστρο ΚΟΝΤΑ ΣΤΟ ΠΑΛΙΟ ΧΩΡΙΟ - -ΕΚΤΟΣ ΣΧΕΔΙΟΥ -ΙΔΑΝΙΚΟ ΓΙΑ ΕΞΟΧΙΚΗ ΚΑΤΟΙΚΙΑ ΣΤΗ ΦΥΣΗ
NEA TIMH 30.000,00
€ 30,000
-
AB107: Αγροτεμάχιο στο Παλαιόκαστρο - ΕΝΤΟΣ ΖΩΝΗΣ - ΜΕ ΟΙΚΟΔΟΜΙΚΗ ΑΔΕΙΑ ΣΕ ΙΣΧΥ - 100 μ ΑΠΟ ΤΗΝ ΑΣΦΑΛΤΟ - ΠΕΡΙΟΧΗ ΑΓΙΟΣ ΧΡΙΣΤΟΦΟΡΟΣ ΠΑΛΑΙΟΚΑΣΤΡΟΥ ΧΑΛΚΙΔΙΚΗΣ
€ 22,000
-
AB108: Αγροτεμάχιο στο Πολύγυρο -ΠΡΟΠΟΔΕΣ ΠΟΛΥΓΥΡΟΥ ΧΑΛΚΙΔΙΚΗΣ - ΒΟΥΝΟ - ΕΞΑΙΡΕΤΙΚΟ - ΑΠΕΡΑΝΤΟ ΓΑΛΑΖΙΟ - ΕΚΤΟΣ ΣΧΕΔΙΟΥ -ΤΣΟΥΚΑΛΑΣ - ΠΑΝΟΡΑΜΙΚΟ - ΘΕΑ ΣΕ ΟΛΗ ΤΗΝ ΧΑΛΚΙΔΙΚΗ
€ 59,000
-
AB109: Αγροτεμάχιο στο Πολύγυρο -ΣΤΗΝ ΕΙΣΟΔΟ ΤΟΥ ΠΟΛΥΓΥΡΟΥ ΧΑΛΚΙΔΙΚΗΣ - ΚΑΤΑΛΛΗΛΟ ΓΙΑ SUPER MARKET - ΕΚΤΟΣ ΣΧΕΔΙΟΥ - ΕΦΑΠΤΕΤΑΙ ΣΤΟ ΔΡΟΜΟ ΠΟΛΥΓΥΡΟΥ - ΘΕΣ/ΝΙΚΗΣ
€ 160,000