WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e636.MAD' (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-541-798fd-4e637.MAD' (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-541-798fd-4e639.MAD' (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-541-798fd-4e63a.MAD' (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-541-798fd-4e63b.MAD' (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-541-798fd-4e63d.MAD' (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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e63e.MAD' (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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e63f.MAD' (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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e640.MAD' (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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e641.MAD' (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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e642.MAD' (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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e643.MAD' (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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e644.MAD' (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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e645.MAD' (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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e646.MAD' (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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e647.MAD' (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-541-798fd-4e648.MAD' (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-541-798fd-4e649.MAD' (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

Stunning 900 M² Villa In Kefalonia's Island Paradise - European.realestate

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e64c.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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e64d.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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e64f.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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

Advanced
Search

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e653.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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

For Sale

Stunning 900 M² Villa In Kefalonia’s Island Paradise

  • €1.100.000

Overview

Property ID: EU-185971
  • Villa
  • Property Type
  • 900
  • Area Size

Description


Your Dream Villa Awaits in Kefalonia

Are you on the hunt for a perfect getaway or a luxurious new home? Look no further! We have an extraordinary opportunity for you: a stunning under-construction villa boasting a massive 900 square meters of space, nestled in the picturesque landscapes of Kefalonia, one of Greece’s most beautiful islands.

What’s Included?

This villa isn’t just a shell; it’s a canvas waiting for you to make it your own. One of the best parts? The owners have decided to leave the furniture with the sale! This means you can move right in and start enjoying your new paradise without lifting a finger. Imagine walking into a professionally decorated space that already feels like home!

Why Choose Kefalonia?

Kefalonia is more than just a stunning backdrop; it’s a lifestyle. With its breathtaking beaches, charming villages, and vibrant culture, it offers the perfect blend of serenity and excitement. Enjoy a day soaking up the sun on Myrtos Beach, or explore the lush landscapes of the island. Whether you’re looking for adventure or relaxation, Kefalonia has it all.

A Quick Note on Viewing

Now, let’s talk about the important stuff. If you’re seriously considering viewing this phenomenal property, keep in mind that, according to Law 4072/2012, you will need to provide your ID and tax number when you register for the property demonstration. We want to make the process as smooth as possible for you, so just a heads up!

Advertisment

Location, Location, Location

While we can’t pinpoint the exact location of the villa on the map, rest assured, it is in a fantastic area that offers all the charm of island living. You’ll have easy access to all the local amenities, from delicious tavernas serving up traditional Greek cuisine to vibrant markets brimming with local produce.

Contact Us for More Information

If you have any questions or need more details, don’t hesitate to reach out. We are here to assist you every step of the way. Whether it’s about construction specifics, local attractions, or a tour of the property, we’re just a call or click away.

Your Kefalonia Escape Awaits

This is an incredible opportunity that you don’t want to miss. Imagine sipping your morning coffee on the terrace or hosting friends and family in a space crafted for luxury and comfort. The villa in Kefalonia could be yours! Reach out today, and let’s make your dream a reality!

Address

Open on Google Maps
  • Address: Sipiada, Magnesia, Thessalia, Greece
  • Zip/Postal Code: 28083
  • Country: Greece

Details

Updated on July 14, 2025 at 1:05 am
  • Property ID EU-185971
  • Price €1.100.000
  • Property Size 900 m²
  • Property Type Villa
  • Property Status For Sale
  • Ref. number 41789

Mortgage Estimation

Schedule a Tour

Tour Type

Similar Listings

For Sale
  • €3.200.000

Stunning 510 M² Villa For Sale In Crete

Ierapetra, Lasithi Prefecture, Crete, Greece
  • 510 m²
  • 2000 m²
  • Villa
Details
Grekodom
1 day ago
For Sale
  • €1.300.000

Stunning 300 M² Villa In Scenic Sithonia

Sithonia, Chalkidiki, Macedonia, Greece
  • 300 m²
  • 4350 m²
  • Beds: 5
  • Baths: 8
  • Villa
Details
Grekodom
1 day ago
For Sale
  • €1.067.000

Spacious 170 M² Villa For Sale In Stunning Crete

Ierapetra, Lasithi Prefecture, Crete, Greece
  • 170 m²
  • Villa
Details
Grekodom
2 days ago
For Sale
  • €640.000

Charming 111 M² Villa In The Heart Of The Cyclades

Naxos, Cyclades, Aegean Islands, Greece
  • 111 m²
  • 1724 m²
  • Beds: 3
  • Baths: 4
  • Villa
Details
Grekodom
2 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-541-798fd-4e661.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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e662.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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-798fd-4e663.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-185971"%' 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-141-single-property_feature"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC