WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-2a2c0-1b7e7.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-2a2c0-1b7e8.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-2a2c0-1b7ea.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-2a2c0-1b7eb.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-2a2c0-1b7ec.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-2a2c0-1b7ed.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-2a2c0-1b7ef.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7f0.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7f1.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7f2.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7f3.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7f4.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7f5.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7f6.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7f7.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7f8.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7f9.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-2a2c0-1b7fa.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-2a2c0-1b7fb.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

Stunning Polop Villa: Your Dream Home In Spain - European.realestate

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-541-2a2c0-1b7fe.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b7ff.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b801.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b802.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC

For Sale

Stunning Polop Villa: Your Dream Home In Spain

  • €475.000

Overview

Property ID: EU-1199771
  • Villa
  • Property Type
  • 108
  • Area Size
  • 432
  • Land Area
  • 3
  • Bedrooms
  • 2
  • Bathrooms
  • Newly build
  • Condition

Description


Modern Luxury Villas for Sale in Polop de la Marina, Costa Blanca

If you’re dreaming of a home that perfectly balances luxury and nature, look no further than Polop de la Marina. This stunning area, nestled in the heart of the northern Costa Blanca, boasts a limited collection of five newly built luxury villas that redefine contemporary living. Whether you’re planning to settle down, retire, or invest, these villas offer a unique opportunity to embrace a sophisticated lifestyle surrounded by breathtaking views of the sea and mountains.

Contemporary Living Surrounded by Nature

These elegant homes are designed with both comfort and functionality in mind. Imagine enjoying your morning coffee with the stunning backdrop of nature. Each villa is set in a tranquil residential area, making it the perfect oasis for families and individuals alike. The charm of Polop de la Marina combined with modern architecture creates an unbeatable living experience that you won’t want to miss.

Stylish Design and High-End Features

Each villa is situated on a generous 432 m² private plot, providing ample space for relaxation and entertainment. You can choose between single-level or two-level layouts for your new castle, and if you need even more room, there’s an option to add a basement. Imagine entertaining friends in an open-plan living and dining area or whipping up gourmet meals in a fully furnished kitchen. Here’s what you can expect:

  • 3 to 5 spacious bedrooms, all with built-in wardrobes
  • 2-3 modern bathrooms featuring cozy underfloor heating
  • An airy open-plan living and dining space
  • A fully equipped kitchen designed to inspire

But that’s just the beginning. You can customize your villa with optional extras that elevate your living experience:

Advertisment
  • A private swimming pool to make those hot summer days enjoyable
  • Automatic driveway gates for added privacy and security
  • An energy-efficient air conditioning system to keep you cool
  • A stylish LED lighting package to set the mood
  • A solarium and landscaped garden for outdoor tranquility
  • A pool bar and outdoor chill-out area for entertaining under the stars

A Prime Location Between Sea and Mountains

The location of these villas is another highlight. Polop de la Marina uniquely sits between the iconic Sleeping Lion Peak and the beautiful Bay of Altea. You get the best of both worlds: serenity and accessibility. Here are some nearby attractions:

  • Beaches of Benidorm and Albir – 10 km away
  • La Nucía sports complex – just 4 km
  • Altea old town and marina – 11 to 12 km
  • Melia Villaitana Golf Course – approximately 13 km
  • Exciting theme parks like Terra Mitica and Aqualandia – 13 to 15 km
  • Calpe and its stunning beaches – 23 km
  • Alicante city center – 38 km
  • Alicante International Airport – about 55 km (only a 40 min drive)

Mediterranean Lifestyle and Investment Potential

These villas are more than just beautiful homes. They represent an incredible investment opportunity, thanks to their prime location, stunning design, and rental potential. Imagine exploring nature trails, cycling along picturesque routes, and indulging in local culinary delights year-round. Whether for permanent residence or a vacation retreat, these properties are a gateway to the Mediterranean lifestyle you’ve always wanted.

Ready to turn your dream of luxury living in Polop de la Marina into reality? Contact us today to book a visit or request more information. Don’t miss out on this opportunity!

Address

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

Features

Details

Updated on July 11, 2025 at 4:28 pm
  • Property ID EU-1199771
  • Price €475.000
  • Property Size 108 m²
  • Land Area 432 m²
  • Bedrooms 3
  • Bathrooms 2
  • Property Type Villa
  • Property Status For Sale
  • Condition Newly build
  • Ref. number RSG-24029

Energy Class

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

Mortgage Estimation

Schedule a Tour

Tour Type

Similar Listings

For Sale
  • €250.000

Stunning Villa For Sale In Torrevieja, Spain

Torrevieja, Alicante (Costa Blanca), Spain
  • 69 m²
  • 305 m²
  • Beds: 2
  • Bath: 1
  • Villa
Details
Red Palm Estate
9 hours ago
For Sale
  • €670.000

Charming Villa For Sale In Ciudad Quesada, Spain

Ciudad Quesada, Alicante (Costa Blanca), Spain
  • 360 m²
  • 850 m²
  • Beds: 5
  • Baths: 4
  • Villa
Details
Red Palm Estate
9 hours ago
For Sale
  • €630.000

Charming Villa For Sale In Sunny Torrevieja, Spain

Torrevieja, Alicante (Costa Blanca), Spain
  • 256 m²
  • Beds: 3
  • Baths: 3
  • Villa
Details
Red Palm Estate
9 hours ago
For Sale
  • €3.500

Discover Estepona: Homes For Sale In Málaga, Spain

Estepona, Málaga, Greece
  • 152 m²
  • Villa
Details
Marbella Luxury Homes
10 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-2a2c0-1b80f.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b810.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' 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-2a2c0-1b812.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-1199771"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-50743-single-property_type"%') ORDER BY p.post_date DESC