WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 314
[meta_query] => Array
(
[relation] => AND
)
[order] => DESC
[meta_key] => _price
[orderby] => meta_value_num
)
[query_vars] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => mn_property
[2] => newbuilds
)
[paged] => 314
[meta_query] => Array
(
[relation] => AND
)
[order] => DESC
[meta_key] => _price
[orderby] => meta_value_num
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] => all
[menu_order] =>
[embed] =>
[category__in] => Array
(
)
[category__not_in] => Array
(
)
[category__and] => Array
(
)
[post__in] => Array
(
)
[post__not_in] => Array
(
)
[post_name__in] => Array
(
)
[tag__in] => Array
(
)
[tag__not_in] => Array
(
)
[tag__and] => Array
(
)
[tag_slug__in] => Array
(
)
[tag_slug__and] => Array
(
)
[post_parent__in] => Array
(
)
[post_parent__not_in] => Array
(
)
[author__in] => Array
(
)
[author__not_in] => Array
(
)
[search_columns] => Array
(
)
[ignore_sticky_posts] =>
[cache_results] => 1
[update_post_term_cache] => 1
[update_menu_item_cache] =>
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] =>
[comments_per_page] => 50
[no_found_rows] =>
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
)
[relation] => AND
[table_aliases:protected] => Array
(
)
[queried_terms] => Array
(
)
[primary_table] => wp_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[key] => _price
)
[relation] => OR
)
[relation] => AND
[meta_table] => wp_postmeta
[meta_id_column] => post_id
[primary_table] => wp_posts
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => wp_postmeta
)
[clauses:protected] => Array
(
[wp_postmeta] => Array
(
[key] => _price
[compare] => =
[compare_key] => =
[alias] => wp_postmeta
[cast] => CHAR
)
)
[has_or_relation:protected] =>
)
[date_query] =>
[request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
wp_postmeta.meta_key = '_price'
) AND ((wp_posts.post_type = 'hx_property' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'mn_property' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'newbuilds' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 DESC
LIMIT 3756, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10569059
[post_author] => 0
[post_date] => 2025-06-24 01:45:31
[post_date_gmt] => 2025-06-24 00:45:31
[post_content] =>
[post_title] => B10550
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10550
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:31
[post_modified_gmt] => 2025-06-24 00:45:31
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10550/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10569178
[post_author] => 0
[post_date] => 2025-06-24 01:45:34
[post_date_gmt] => 2025-06-24 00:45:34
[post_content] =>
[post_title] => B10699 - ? EXCLUSIVE APARTMENT WITH SEA VIEW OF TWO HAB. IN RESIDENTIAL LA CALMA - ORIHUELA COSTA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10699-%f0%9f%8c%85-exclusive-apartment-with-sea-view-of-two-hab-in-residential-la-calma-orihuela-costa
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:34
[post_modified_gmt] => 2025-06-24 00:45:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10699-%f0%9f%8c%85-exclusive-apartment-with-sea-view-of-two-hab-in-residential-la-calma-orihuela-costa/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10567904
[post_author] => 0
[post_date] => 2025-06-24 01:40:02
[post_date_gmt] => 2025-06-24 00:40:02
[post_content] => South facing 2 bedroom, 2 bathroom townhouse for sale in Res. Playa Flamenca IX. The property is located in the heart of Playa Flamenca, with all manner of amenities and services within walking distance, including the Zenia Boulevard shopping mall and the sandy blue flag beaches of Playa Flamenca. A fantastic property for permanent living or as a holiday home due to its prime location!
The property offers a great front tiled garden with retractable awnings, a bright lounge-dining area with feature fireplace, fully equipped kitchen to the rear, plus a downstairs bathroom with walk-in shower. There is also a storage cupboard located underneath the stairs. Upstairs there are 2 bedrooms with fitted wardrobes, and a family bathroom with walk-in shower. The twin bedroom has access to a small utility area, where you will find the washing machine and electric boiler. From the master bedroom you can access the South facing balcony. Sold with furniture, white goods, air-conditioning and underfloor heating.
Located just a 10 minutes walk to the Zenia Boulevard shopping mall, the biggest in the Alicante province with over 155 shops. Playa Flamenca beach is also a 15-20 minute walk away.
Viewings advised for this centrally positioned property!
[post_title] => VC3656
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3656
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:40:02
[post_modified_gmt] => 2025-06-24 00:40:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3656/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10569682
[post_author] => 0
[post_date] => 2025-06-24 01:45:46
[post_date_gmt] => 2025-06-24 00:45:46
[post_content] =>
[post_title] => B10938 - Ideal Home Steps from the Beach with Tourist License
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10938-ideal-home-steps-from-the-beach-with-tourist-license
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:46
[post_modified_gmt] => 2025-06-24 00:45:46
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10938-ideal-home-steps-from-the-beach-with-tourist-license/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10569245
[post_author] => 0
[post_date] => 2025-06-24 01:45:35
[post_date_gmt] => 2025-06-24 00:45:35
[post_content] =>
[post_title] => A10477
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10477
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:35
[post_modified_gmt] => 2025-06-24 00:45:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10477/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10569184
[post_author] => 0
[post_date] => 2025-06-24 01:45:34
[post_date_gmt] => 2025-06-24 00:45:34
[post_content] =>
[post_title] => A10450
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10450
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:34
[post_modified_gmt] => 2025-06-24 00:45:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10450/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10568908
[post_author] => 0
[post_date] => 2025-06-24 01:45:27
[post_date_gmt] => 2025-06-24 00:45:27
[post_content] =>
[post_title] => F0843
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0843
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:27
[post_modified_gmt] => 2025-06-24 00:45:27
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0843/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10569598
[post_author] => 0
[post_date] => 2025-06-24 01:45:44
[post_date_gmt] => 2025-06-24 00:45:44
[post_content] =>
[post_title] => B10913
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10913
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:44
[post_modified_gmt] => 2025-06-24 00:45:44
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10913/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10568929
[post_author] => 0
[post_date] => 2025-06-24 01:45:28
[post_date_gmt] => 2025-06-24 00:45:28
[post_content] =>
[post_title] => F0860 - Apartment for Sale in Cala de Vila Joiosa! ?️
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0860-apartment-for-sale-in-cala-de-vila-joiosa-%f0%9f%8f%96%ef%b8%8f
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:28
[post_modified_gmt] => 2025-06-24 00:45:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0860-apartment-for-sale-in-cala-de-vila-joiosa-%f0%9f%8f%96%ef%b8%8f/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10567368
[post_author] => 0
[post_date] => 2025-06-24 01:25:15
[post_date_gmt] => 2025-06-24 00:25:15
[post_content] => Modern New Build Apartments in Pilar de la Horadada – Comfort, Style, and Prime Location
Boutique Residential Project with Only 7 Homes
Discover an exclusive new build development in the heart of Pilar de la Horadada, offering just 7 stylish apartments with 2 or 3 bedrooms. Located only 3 km from the beach, this modern building is ideal for those seeking a tranquil coastal lifestyle with all essential services within walking distance.
Key Ready!!
The development features three floors with elevator access and secure entry control systems, ensuring safety and convenience. Whether you’re looking for a permanent residence, a vacation home, or a smart investment on the Costa Blanca, this limited-edition residential building provides an ideal opportunity.
Contemporary Design and High-Quality Finishes
Each apartment is thoughtfully designed with modern finishes, ensuring a blend of elegance and functionality. Features include:
Furnished kitchens with modern appliances included
Built-in wardrobes in all bedrooms with interior lining
Pre-installed ducted air conditioning
Fully equipped bathrooms with vanity units, mirrors, and shower screens
Motorized shutters in the living room for added comfort and light control
These homes are designed to offer maximum comfort all year round, with layouts that make the most of natural light and open living spaces.
Life in Pilar de la Horadada – Year-Round Coastal Living
Pilar de la Horadada, located in the southernmost part of Alicante, offers a perfect combination of relaxed coastal charm and modern amenities. With beautiful sandy beaches, scenic cycling routes, and excellent sports facilities, the area attracts both locals and international residents.
From your new home, you’ll enjoy easy access to shops, restaurants, parks, and medical centers—all just steps away. This peaceful town also offers proximity to natural parks and hiking trails, perfect for outdoor enthusiasts.
Key Distances to Points of Interest
Torre de la Horadada Beach – 3 km
Lo Romero Golf Course – 5 km
La Zenia Boulevard Shopping Center – 15 km
Corvera Airport (Murcia) – 40 km
Alicante Airport – 55 km
Secure Your New Home on the Costa Blanca
Don’t miss the chance to own a beautifully designed new-build apartment in a privileged location. Contact us today for more information or to arrange a viewing. Your new life in the sun awaits in Pilar de la Horadada.
[post_title] => N8803
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8803
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:15
[post_modified_gmt] => 2025-06-24 00:25:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8803/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10568915
[post_author] => 0
[post_date] => 2025-06-24 01:45:27
[post_date_gmt] => 2025-06-24 00:45:27
[post_content] =>
[post_title] => A10226
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10226
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:27
[post_modified_gmt] => 2025-06-24 00:45:27
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10226/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10568724
[post_author] => 0
[post_date] => 2025-06-24 01:45:22
[post_date_gmt] => 2025-06-24 00:45:22
[post_content] =>
[post_title] => A4828 - Complex of 11 bungalows in Roldan (Murcia)
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4828-complex-of-11-bungalows-in-roldan-murcia
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:22
[post_modified_gmt] => 2025-06-24 00:45:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a4828-complex-of-11-bungalows-in-roldan-murcia/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 12
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 10569059
[post_author] => 0
[post_date] => 2025-06-24 01:45:31
[post_date_gmt] => 2025-06-24 00:45:31
[post_content] =>
[post_title] => B10550
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10550
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:31
[post_modified_gmt] => 2025-06-24 00:45:31
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10550/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4463
[max_num_pages] => 372
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] =>
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] =>
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] => 1
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] => 1
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => ffa179399b6b63a6e0915dd5d8ffdb55
[query_vars_changed:WP_Query:private] =>
[thumbnails_cached] =>
[allow_query_attachment_by_filename:protected] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)
[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)
[query_cache_key:WP_Query:private] => wp_query:a46f665088b86d40f00d9fb49b97687b:0.31720500 1753174019
)