WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0eed.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-5ae135-e0eee.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-5ae135-e0ef0.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-5ae135-e0ef1.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-5ae135-e0ef2.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-5ae135-e0ef3.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-5ae135-e0ef5.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0ef6.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0ef7.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0ef8.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0ef9.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0efa.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0efb.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0efc.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0efd.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0efe.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

Charming Apartment For Sale In Guardamar Del Segura, Spain - European.realestate

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0f01.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0f02.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0f03.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

Advanced
Search

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0f04.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

For Sale

Charming Apartment For Sale In Guardamar Del Segura, Spain

  • €199.969

Overview

Property ID: EU-544992
  • Apartment
  • Property Type
  • 130
  • Area Size
  • 4
  • Bedrooms
  • 2
  • Bathrooms

Description


Discover Your Dream Apartment in Guardamar del Segura

If you’re dreaming of a coastal lifestyle with stunning golden sandy beaches right at your doorstep, then we’ve got fantastic news. Introducing a cozy 4-bedroom apartment located on the 3rd floor in the heart of Guardamar del Segura—an inviting coastal town that perfectly balances vibrant community life and serene beach vibes.

Unbeatable Location Just Steps from the Beach

This wonderful 130m2 property is situated merely 750 meters from the sea. Imagine taking a leisurely stroll to the beach within just a few minutes. The beauty of this apartment doesn’t stop there. You’ll find yourself surrounded by all essential services. From supermarkets and shops to delightful restaurants and medical centers, everything you need for a seamless lifestyle is right at your fingertips.

Perfect for Families and Comfort Seekers

Designed with families in mind, this apartment features 4 spacious bedrooms, ensuring comfort and privacy for everyone. Each room is bathed in natural light, creating an uplifting atmosphere for both relaxation and productivity. The 2 full bathrooms are well-equipped and maintained to perfection, boasting quality finishes and natural ventilation to keep things fresh.

Accessibility and Convenience

For those who value accessibility, you’ll appreciate that both bathrooms are adapted for users with reduced mobility. Safety and comfort are paramount, which is why an alarm system has been installed, providing peace of mind for you and your loved ones. The building also features an elevator, making it easy to access your new home from any floor.

Enjoy Year-Round Comfort

Stay cool in the summer and warm in the winter, thanks to the air conditioning installed throughout the apartment. This thoughtful feature ensures that no matter the season, your home remains your sanctuary.

Advertisment

Added Luxuries: Parking and Storage

Another significant advantage of this apartment is the included parking space and storage room. Having your own parking spot is not just a convenience—it’s a luxury in busy coastal towns. Plus, the additional storage ensures that you can keep your living space clutter-free and organized.

Embrace the Sunshine

The apartment’s east-west orientation allows you to soak in the morning sun and unwind with beautiful evening sunsets. This clever layout promotes natural airflow throughout the space, ensuring a breezy and bright atmosphere all day long.

A Comfortable Coastal Lifestyle Awaits

In summary, this apartment is not just a living space; it’s an opportunity to embrace a tranquil lifestyle in one of Spain’s most charming coastal towns. Whether you’re looking for a year-round home or a vacation escape, this is the perfect setting.

Don’t miss out on making this dream home your reality. Head over to our WhiteVillasInSpain site for more details and to schedule a viewing. Your future oasis awaits!

Address

Open on Google Maps
  • Address: Guardamar Del Segura, Alicante, Spain
  • Zip/Postal Code: 03140
  • Country: Spain

Details

Updated on June 28, 2025 at 3:39 am
  • Property ID EU-544992
  • Price €199.969
  • Property Size 130 m²
  • Bedrooms 4
  • Bathrooms 2
  • Property Type Apartment
  • Property Status For Sale
  • Ref. number WM17126

Mortgage Estimation

Schedule a Tour

Tour Type

Similar Listings

For Sale
  • €254.950

Charming Apartment For Sale In Guardamar Del Segura, Spain

Guardamar del Segura, Alicante, Spain
  • 75 m²
  • Beds: 3
  • Apartment
Details
House In Spain Invest
19 hours ago
For Sale
  • €299.950

Charming Apartment For Sale In Orihuela Costa, Spain

Orihuela Costa, Alicante, Spain
  • 97 m²
  • Beds: 3
  • Apartment
Details
House In Spain Invest
19 hours ago
For Sale
  • €147.000

Charming Torrevieja Apartment For Rent: Your Spanish Escape!

Torrevieja, Alicante, Spain
  • 50 m²
  • Beds: 2
  • Apartment
Details
House In Spain Invest
19 hours ago
For Sale
  • €370.000

Charming Apartment For Sale In Torrevieja, Spain

Torrevieja, Alicante, Spain
  • 89 m²
  • Beds: 3
  • Apartment
Details
House In Spain Invest
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-468-5ae135-e0f11.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0f12.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-5ae135-e0f13.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-544992"%' OR pm.meta_value LIKE '%"tax-140-single-property_feature"%' OR pm.meta_value LIKE '%"tax-77-single-property_type"%' OR pm.meta_value LIKE '%"tax-146-single-property_feature"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-147-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-138-single-property_feature"%') ORDER BY p.post_date DESC