WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4c5.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-541-29e2c-1b4c6.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-541-29e2c-1b4c8.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-541-29e2c-1b4c9.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-541-29e2c-1b4ca.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-541-29e2c-1b4cb.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-541-29e2c-1b4cd.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4ce.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4cf.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4d0.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4d1.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4d2.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4d3.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4d4.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4d5.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4d6.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4d7.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-541-29e2c-1b4d8.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-541-29e2c-1b4d9.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

Charming Apartment For Sale In Orihuela Costa, Spain - European.realestate

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4dc.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4dd.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4df.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

Advanced
Search

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4e0.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

For Sale

Charming Apartment For Sale In Orihuela Costa, Spain

  • €285.000

Overview

Property ID: EU-1200582
  • Apartment
  • Property Type
  • 93
  • Area Size
  • 2
  • Bedrooms
  • 2
  • Bathrooms

Description


Your Dream Apartment Awaits!

If you’re on the hunt for the perfect apartment, look no further! We’re excited to present this stunning second-floor unit in a modern building equipped with an elevator. Not just any place, this apartment boasts a spacious layout and an abundance of natural light, making it the ideal space for families, couples, or even as a charming second residence.

Spacious and Bright Living

Covering a generous 87 m², this home features two comfortable bedrooms and two full bathrooms. Imagine waking up in a sunlit room, ready to embrace the day. The east-facing orientation ensures you’ll enjoy plenty of natural light throughout the morning, warming up the atmosphere and making your home feel inviting and cheerful.

Outdoor Oasis: Your Private Terrace

Now, let’s talk about one of the most exciting features of this apartment: the spectacular 35 m² terrace. Whether you want to unwind with a good book, host delightful dinners under the stars, or simply soak up some sun, this outdoor space is a real gem. It’s perfect for those lovely days when you want to enjoy the fresh air without leaving the comfort of your home.

Fully Furnished and Ready for You

No need to stress about furniture shopping; this property comes fully furnished! The design is both functional and cozy, offering a warm ambiance right from the start. Plus, with air conditioning installed, you can keep your space comfortable no matter the season.

Advertisment

Convenience at Its Best

Included in the price is a private parking space, a massive plus in today’s busy world. Forget about the hassle of searching for parking. Additionally, the building is nestled within a well-maintained community that features a beautiful communal pool. Picture yourself lounging by the pool on a warm day, enjoying the peaceful surroundings. It’s the perfect spot to spend quality time with friends and family.

Quality of Life and Unbeatable Location

In a nutshell, this apartment is an incredible opportunity for anyone looking to upgrade their living situation. Whether you are aiming for quality of life, comfort, or simply a fabulous location, this place ticks all the boxes. It’s not just a home; it’s a lifestyle.

So why wait? This beautiful apartment won’t last long on the market. Schedule a viewing today, and let’s make your dream home a reality!

Address

Open on Google Maps
  • Address: Orihuela Costa, Alicante (Costa Blanca), Spain
  • Country: Spain

Details

Updated on July 11, 2025 at 4:30 pm
  • Property ID EU-1200582
  • Price €285.000
  • Property Size 93 m²
  • Bedrooms 2
  • Bathrooms 2
  • Property Type Apartment
  • Property Status For Sale
  • Ref. number MR2-89454

Energy Class

  • Energetic class: X
  • A+
  • A
  • B
  • C
  • D
  • E
  • F
  • G
  • H

Mortgage Estimation

Schedule a Tour

Tour Type

Similar Listings

For Sale
  • €159.900

Charming Torrevieja Apartment For Your Perfect Getaway

Torrevieja, Alicante (Costa Blanca), Spain
  • 80 m²
  • Beds: 3
  • Baths: 2
  • Apartment
Details
Red Palm Estate
8 hours ago
For Sale
  • €159.995

Explore A Stunning Apartment In Hacienda Riquelme Golf Resort

Hacienda Riquelme Golf Resort, Murcia, Spain
  • Beds: 2
  • Bath: 1
  • Apartment
Details
Red Palm Estate
8 hours ago
For Sale
  • €219.900

Charming Torrevieja Apartment: Your Spanish Getaway Awaits

Torrevieja, Alicante (Costa Blanca), Spain
  • 120 m²
  • Beds: 2
  • Baths: 2
  • Apartment
Details
Red Palm Estate
8 hours ago
For Sale
  • €229.000

Charming Orihuela Costa Apartment For Sale In Spain

Orihuela Costa, Alicante (Costa Blanca), Spain
  • 87 m²
  • 132 m²
  • Beds: 2
  • Baths: 2
  • Apartment
Details
Red Palm Estate
8 hours 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-29e2c-1b4ee.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4ef.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-29e2c-1b4f1.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-1200582"%' OR pm.meta_value LIKE '%"tax-77-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-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC