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

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe5e.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-5acef7-14fe60.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-5acef7-14fe61.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-5acef7-14fe62.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-5acef7-14fe63.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-5acef7-14fe65.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe66.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe67.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe68.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe69.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe6a.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe6b.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe6c.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe6d.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe6e.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

Spacious 220 M² Maisonette In Attica For Sale - European.realestate

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe71.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe72.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe73.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

Advanced
Search

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe74.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

For Sale

Spacious 220 M² Maisonette In Attica For Sale

  • €420.000

Overview

Property ID: EU-210027
  • Maisonette
  • Property Type
  • 220
  • Area Size
  • 620
  • Land Area
  • 2
  • Bedrooms
  • 3
  • Bathrooms
  • yes
  • Garages
  • 1995
  • Year Built

Description


Discover Your Dream Maisonette in Attica

Are you on the hunt for a perfect home in Attica? Look no further! This stunning maisonette offers an impressive 220 square meters of living space, spread across three levels. Whether you’re a growing family or someone looking to enjoy some extra room, this property caters to all your needs.

Spacious Living Areas

Let’s dive into the layout. The semi-basement is a cozy retreat featuring a living room and kitchen, perfect for entertaining guests or spending quality time with family. You’ll also find a bathroom, adding extra convenience.

Moving up to the ground floor, you’ll find another inviting bedroom and, yes, another living room with a kitchen! This makes it perfect for a guest area or perhaps your own personal oasis. Just think of the possibilities!

The first floor features yet another bedroom and living space, flushing the home with natural light and comfort. Each level is well-thought-out to enhance your living experience, making it ideal for both relaxation and gatherings.

Stylish Features Await You

This maisonette isn’t just about size; it also boasts some fantastic features. You’ll love cozying up by the fireplace on chilly evenings or having control over your home’s temperature with an effective heating system. Imagine sipping hot cocoa while basking in warmth!

And here’s a bonus: the furniture you see will stay with the home, making your move-in process a breeze. Who doesn’t love the idea of moving into a fully furnished place? Just pack your bags and start living!

Advertisment

Safety and Security

Worried about security? This property comes equipped with an alarm system, ensuring that you feel safe and secure in your new home.

Outdoor Space and Parking

But wait, there’s more! You’ll also get a lovely garden space—perfect for those who enjoy a bit of greenery or outdoor barbecues with friends. Plus, there’s a garage for your car, making parking a non-issue.

Important Notes

All the information provided here has been sourced directly from the property owner, so it’s best to stay flexible. Be mindful of typographical errors and the potential for price changes.

In accordance with Law 4072/2012, you’ll need to provide your ID and tax number to view the property. This step ensures a smooth demonstration agreement process. It’s a small step toward stepping into your dream home.

Find Your Place Today!

Remember, the map indication is just a general area—nothing too specific—so feel free to reach out for more details. We’re here to help you every step of the way!

In summary, this maisonette in Attica offers a unique blend of space, style, and security, making it a one-of-a-kind opportunity. Don’t miss out on making this beautiful home your own!

Address

Open on Google Maps
  • Address: Artemida (Loutsa), Athens - East, Attica, Greece
  • Zip/Postal Code: 19016
  • Country: Greece

Details

Updated on July 1, 2025 at 9:56 am
  • Property ID EU-210027
  • Price €420.000
  • Property Size 220 m²
  • Land Area 620 m²
  • Bedrooms 2
  • Rooms 3
  • Bathrooms 3
  • Garages yes
  • Year Built 1995
  • Property Type Maisonette
  • Property Status For Sale
  • Ref. number 30107

Mortgage Estimation

Schedule a Tour

Tour Type

Similar Listings

For Sale
  • €160.000
  • €150.000

Explore This Expansive 93 M² Maisonette In Crete

Makris Gialos, Lasithi Prefecture, Crete, Greece
  • 93 m²
  • Beds: 3
  • Maisonette
Details
Grekodom
4 days ago
For Sale
  • €1.150.000

Spacious 221 M² Maisonette For Sale In Athens

Agia Paraskevi, Athens - North, Attica, Greece
  • 221 m²
  • Beds: 4
  • Maisonette
Details
Grekodom
4 days ago
For Sale
  • €950.000

Spacious 184 M² Maisonette In Athens Awaits You

Agia Paraskevi, Athens - North, Attica, Greece
  • 184 m²
  • Beds: 4
  • Maisonette
Details
Grekodom
4 days ago
For Sale
  • €535.000

Spacious 131 M² Maisonette In The Heart Of Athens

Kallipoli - Freattida, Piraeus, Attica, Greece
  • 131 m²
  • Beds: 3
  • Maisonette
Details
Grekodom
4 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-5acef7-14fe78.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe79.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5acef7-14fe7a.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-210027"%' OR pm.meta_value LIKE '%"tax-50744-single-property_feature"%' 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-50765-single-property_type"%') ORDER BY p.post_date DESC