WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da6b.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_favethemes_insights`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da6d.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da6e.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da6f.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da70.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da72.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da73.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da74.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da75.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da76.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da77.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da78.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da79.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da7a.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da7b.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da7c.MAI' (Errcode: 28 "No space left on device")]
SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'template/template-compare.php' ) ) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da7d.MAI' (Errcode: 28 "No space left on device")]
SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'template/user_dashboard_favorites.php' ) ) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da7e.MAI' (Errcode: 28 "No space left on device")]
SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'template/template-thankyou.php' ) ) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC

Spacious 290 M² Detached Home In Attica For Sale - European.realestate

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da81.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da82.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da84.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

Advanced
Search

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da85.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

For Sale

Spacious 290 M² Detached Home In Attica For Sale

  • €1.000.000

Overview

Property ID: EU-232000
  • Detached House
  • Property Type
  • 290
  • Area Size
  • 500
  • Land Area
  • 6
  • Bedrooms
  • 5
  • Bathrooms
  • 1994
  • Year Built

Description


Discover Your Dream Home in Attica: A 3-Storey Gem

Have you been searching for that perfect family home in a beautiful location? Look no further! This stunning 3-storey house in Attica boasts a generous 290 square meters of living space. With breathtaking views of the city, mountains, and even the sea, this property has everything you’re looking for and more.

Spacious Layout for Every Family Member

Let’s break down what this spacious home has to offer. The ground floor features two cozy bedrooms, a welcoming living room complete with a kitchen, a bathroom, and an additional WC. This layout is perfect for family living and entertaining guests.

Moving up to the first floor, you’ll find another bedroom and a second living room with an adjoining kitchen, plus its own WC. It’s a great space for older kids or guests to enjoy their privacy while still being part of the household.

The second floor is where the magic happens! Here, you’ll discover three more bedrooms, a bathroom, and yet another WC, providing ample space for everyone to relax and unwind at the end of the day. Who wouldn’t love having that much room to spread out?

Luxury Amenities and Comfort

This home comes packed with fantastic features designed to enhance your living experience. Enjoy the warmth of a fireplace during chilly evenings, or escape the summer heat with air conditioning throughout. The property also boasts a central heating system, ensuring comfort in all seasons.

Advertisment

For those who love to entertain outdoors, the barbecue area is perfect for summer gatherings or family cookouts. Imagine hosting friends and family while enjoying that magnificent view and fresh air. Plus, you’ll have peace of mind with an installed alarm system, providing an extra layer of security for you and your loved ones.

Additional Perks You’ll Love

One of the standout features of this property? It comes with furniture! That’s right, the current owners are leaving behind their stylish furnishings, making it easy for you to move right in and start enjoying your new home right away.

Let’s not forget about the outdoor space. You’ll have your very own garden to cultivate, relax, and enjoy some peace and quiet. Parking will never be an issue, as this property includes a dedicated parking space – a true commodity these days!

Viewing the Property

If you’re excited about this property, let’s make it happen! Keep in mind that to view this stunning home in person, you’ll need to present your ID and tax number, as per the requirements of Law 4072/2012. This is a simple step that helps ensure the process goes smoothly.

Your Future Awaits

This 3-storey house in Attica represents a remarkable opportunity to own a piece of paradise. With its generous space, incredible views, and impressive amenities, it truly checks all the boxes for anyone looking to buy a home. Don’t hesitate to reach out for any additional information or to schedule a viewing. Your dream home is just a call away!

Address

Open on Google Maps
  • Address: Marathonas, Athens - East, Attica, Greece
  • Zip/Postal Code: 19005
  • Country: Greece

Details

Updated on July 1, 2025 at 6:41 am
  • Property ID EU-232000
  • Price €1.000.000
  • Property Size 290 m²
  • Land Area 500 m²
  • Bedrooms 6
  • Rooms 2
  • Bathrooms 5
  • Year Built 1994
  • Property Type Detached House
  • Property Status For Sale
  • Ref. number 28611

Mortgage Estimation

Schedule a Tour

Tour Type

Similar Listings

For Sale
  • €230.000

Spacious 120 M² Detached Home In Pella For Sale

Vegoritida, Pella, Macedonia, Greece
  • 120 m²
  • 550 m²
  • Beds: 3
  • Detached House
Details
Grekodom
2 days ago
For Sale
  • €310.000

Spacious 150 M² Detached Home In Beautiful Chalkidiki

Poligiros, Chalkidiki, Macedonia, Greece
  • 150 m²
  • 778 m²
  • Detached House
Details
Grekodom
4 days ago
For Sale
  • €340.000

Spacious 170 M² Detached Home In Eastern Peloponnese

Evrostini, Corinthia, Peloponnisos, Greece
  • 170 m²
  • 775 m²
  • Beds: 4
  • Detached House
Details
Grekodom
5 days ago
For Sale
  • €380.000
  • €265.000

Spacious 300 M² Detached Home Near Olympic Coast

Katerini, Pieria Prefecture, Macedonia, Greece
  • 300 m²
  • 1133 m²
  • Beds: 6
  • Detached House
Details
Grekodom
5 days ago
Disclaimer: Please note that this property listing is an automatically generated advertisement. The descriptions have been rewritten by our AI agent and should not be considered official property particulars. While European.realestate requires all advertisers to provide accurate information, we do not independently verify the details and cannot accept liability for any inaccuracies. Always contact the listing agent directly for the most accurate and up-to-date information about the property. We strongly recommend obtaining independent legal advice before proceeding with any property purchase.

Notice something incorrect? Help us improve by reporting any issues. You can let us know what you've found by clicking here: Report a problem.

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da89.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da8a.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ac3ab-11da8c.MAI' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-232000"%' OR pm.meta_value LIKE '%"tax-18-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50746-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-75-single-property_feature"%' OR pm.meta_value LIKE '%"tax-96-single-property_country"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-141-single-property_feature"%') ORDER BY p.post_date DESC