WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 420
[meta_query] => Array
(
[relation] => AND
)
[order] => ASC
[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] => 420
[meta_query] => Array
(
[relation] => AND
)
[order] => ASC
[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 ASC
LIMIT 5028, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10568453
[post_author] => 0
[post_date] => 2025-06-24 01:45:16
[post_date_gmt] => 2025-06-24 00:45:16
[post_content] =>
[post_title] => N7749 - NEW BUILD VILLA IN PILAR DE LA HORADADA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n7749-new-build-villa-in-pilar-de-la-horadada
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:16
[post_modified_gmt] => 2025-06-24 00:45:16
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/n7749-new-build-villa-in-pilar-de-la-horadada/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10569232
[post_author] => 0
[post_date] => 2025-06-24 01:45:35
[post_date_gmt] => 2025-06-24 00:45:35
[post_content] =>
[post_title] => MON081
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mon081
[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/mon081/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10567571
[post_author] => 0
[post_date] => 2025-06-24 01:25:20
[post_date_gmt] => 2025-06-24 00:25:20
[post_content] => NEW BUILD VILLA IN PILAR DE LA HORADADA
New Build villa in Pilar de la Horadada.
Modern villa build over 2 floors, has 3 bedrooms, 2 bathrooms, open plan kitchen with the living room, terrace, garden with private pool and parking space.
Pilar de la Horadada is a typical Spanish village in the most southern part of the Costa Blanca.
The large main street has supermarkets, lots of shops, restaurants and bars and some lovely squares.
The beautiful beaches of Torre de la Horadada and Mil Palmeras with fine sand promenade is just 5 minutes away.
The airports of Corvera (Murcia) and Alicante are respectively 40 and 55 minutes away.
[post_title] => N7749
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n7749
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:20
[post_modified_gmt] => 2025-06-24 00:25:20
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n7749/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10567071
[post_author] => 0
[post_date] => 2025-06-24 01:25:07
[post_date_gmt] => 2025-06-24 00:25:07
[post_content] => NEW BUILD RESIDENTIAL IN LOS ALCAZARES
New Build residential is composed of 32 apartments and penthouses with 2 and 3 bedrooms and 9 exclusive villas combining modern design, quality and functionality.
The unbeatable location offers amazing views to golf and the Mar Menor sea.
Modern properties with open plan kitchen and the lounge area, fitted wardrobes, terraces, parking space and storage rooms.
Penthouses has private solarium.
Residential located in a frontline of the prestigious golf course “La Serena Golf”. This golf course is well renowned for its lakes and vegetation that interweave with the golf course. The water and lakes are present in 16 of the 18 holes, but all the course is designed to offer the golfer different strategies in each hole. Another aspect that makes this golf course unique is that it’s connected by walking to the city centre, something impossible to find in other golf locations that allow us to enjoy the calm and the beauty of the area without refusing the access to the services that Los Alcázares offers.
Residential located in Los Alcázares an exceptional area on the Costa Cálida at only
25 minutes from Murcia airport and 55 min from Alicante airport. The area is connected through highway with the cities of Cartagena, Murcia and Alicante and the rest of the beaches of the Costa Cálida and the Costa Blanca.
[post_title] => N7932
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n7932
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:07
[post_modified_gmt] => 2025-06-24 00:25:07
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n7932/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10567082
[post_author] => 0
[post_date] => 2025-06-24 01:25:07
[post_date_gmt] => 2025-06-24 00:25:07
[post_content] => Boutique Development of New Build Homes with Private Pools in Pilar de la Horadada
Exclusive Residential in a Prime Costa Blanca Location
Discover this boutique new-build development of just 10 exclusive homes in Pilar de la Horadada, a charming coastal town in the south of the Costa Blanca. Located on the outskirts of town, this modern project offers open views towards green park areas while being only 2 km from the Mediterranean beaches of Torre de la Horadada. Enjoy the convenience of having all essential services within walking distance, including supermarkets, restaurants, banks, schools and health services.
Choice of Layouts with Private Outdoor Spaces
This new development offers a variety of 2- and 3-bedroom layouts to suit different needs and lifestyles:
Ground floor houses feature a private garden, pool with beach-style area and fully landscaped exteriors with automatic irrigation.
Top floor houses boast a private solarium with summer kitchen, pergola, outdoor toilet and private pool with built-in jacuzzi, plus a dedicated bicycle storage room at ground floor.
Semi-detached villas offer generous indoor and outdoor space with a private garden and pool, ideal for family living or long stays.
All homes include a private parking space.
Premium Features and High-Quality Finishes
Designed with comfort, efficiency and style in mind, all homes come equipped with:
Ducted air conditioning fully installed
Electric shutters and reinforced front doors
LED lighting package for indoor and outdoor areas
Fitted kitchens with BOSCH or SIEMENS appliances
Stylish bathrooms with underfloor heating, mirrors, vanity units and shower screens
Modern design that maximizes natural light and functionality
These thoughtfully designed homes deliver a seamless blend of indoor comfort and outdoor living, perfect for enjoying the warm Mediterranean climate all year round.
Key distances:
Beaches: 2 km
Lo Romero Golf Course: 6 km
Dos Mares Shopping Centre (San Javier): 10 km
Zenia Boulevard Shopping Centre (Orihuela Costa): 12 km
Murcia International Airport: 40 km
Alicante Airport: 70 km
Ideal for Living or Investment
With limited availability and a privileged location, this new development in Pilar de la Horadada represents a fantastic opportunity for both permanent living and investment. Whether you’re seeking a holiday home, a retirement retreat or a rental property, these modern homes offer everything you need.
Contact us today to secure your new home on the Costa Blanca.
[post_title] => N8954
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8954
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:07
[post_modified_gmt] => 2025-06-24 00:25:07
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8954/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10567140
[post_author] => 0
[post_date] => 2025-06-24 01:25:09
[post_date_gmt] => 2025-06-24 00:25:09
[post_content] => Newly built villas located in the municipality of Aspe.
Newly built villas with several models to choose from, with 2, 3 or 4 bedrooms, on one or two floors and built with slabs or with a structure: depending on the model and the plot chosen, the exact price will be calculated.
All the villas are built on rustic plots of over 10,000 m2, of which around 2,500 m2 will be fenced off.
The villas have an open-plan kitchen with living room, built-in wardrobes, private swimming pool, porch, storage room and outdoor parking space.
There are several plots to choose from. The price is based on a plot priced at £77,500 (if another plot is chosen, the difference will be paid or credited according to the price of the plot).
Self-build project, delivery in approximately 12 months from the granting of the licence.
If you are looking for a quiet environment, close to typical Spanish villages away from tourist crowds, surrounded by mountains, with a very large plot and about 30 minutes from the sea, this is your home.
Aspe is a typical Spanish village with all the amenities for everyday life, surrounded by mountains and with several natural areas nearby where you can go hiking or mountain biking.
Located 25 km from the beach, 9 km from Elche and about 20 km from Alicante airport.
[post_title] => N8936
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8936
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:09
[post_modified_gmt] => 2025-06-24 00:25:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8936/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10569120
[post_author] => 0
[post_date] => 2025-06-24 01:45:32
[post_date_gmt] => 2025-06-24 00:45:32
[post_content] =>
[post_title] => 72443 - Spacious recently renovated villa with 3,600 m2 of plot and private pool
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72443-spacious-recently-renovated-villa-with-3600-m2-of-plot-and-private-pool
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:32
[post_modified_gmt] => 2025-06-24 00:45:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72443-spacious-recently-renovated-villa-with-3600-m2-of-plot-and-private-pool/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10569526
[post_author] => 0
[post_date] => 2025-06-24 01:45:42
[post_date_gmt] => 2025-06-24 00:45:42
[post_content] =>
[post_title] => 72729
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72729
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:42
[post_modified_gmt] => 2025-06-24 00:45:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72729/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10567958
[post_author] => 0
[post_date] => 2025-06-24 01:45:04
[post_date_gmt] => 2025-06-24 00:45:04
[post_content] =>
[post_title] => 5691 - Stunning Villas in Los Montesinos
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5691-stunning-villas-in-los-montesinos
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:04
[post_modified_gmt] => 2025-06-24 00:45:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/5691-stunning-villas-in-los-montesinos/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10569474
[post_author] => 0
[post_date] => 2025-06-24 01:45:41
[post_date_gmt] => 2025-06-24 00:45:41
[post_content] =>
[post_title] => F1067 - Spacious 2-Bedroom Apartment in the Eagle Tower Complex
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f1067-spacious-2-bedroom-apartment-in-the-eagle-tower-complex
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:41
[post_modified_gmt] => 2025-06-24 00:45:41
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f1067-spacious-2-bedroom-apartment-in-the-eagle-tower-complex/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10568549
[post_author] => 0
[post_date] => 2025-06-24 01:45:18
[post_date_gmt] => 2025-06-24 00:45:18
[post_content] =>
[post_title] => B9548 - The luxury flat on the seafront in La Mata
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b9548-the-luxury-flat-on-the-seafront-in-la-mata
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:18
[post_modified_gmt] => 2025-06-24 00:45:18
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b9548-the-luxury-flat-on-the-seafront-in-la-mata/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10568829
[post_author] => 0
[post_date] => 2025-06-24 01:45:25
[post_date_gmt] => 2025-06-24 00:45:25
[post_content] =>
[post_title] => A4873 - Complex of 16 apartments and 10 bungalows in Torre de la Horadada 50 meters from the beach
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4873-complex-of-16-apartments-and-10-bungalows-in-torre-de-la-horadada-50-meters-from-the-beach
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:25
[post_modified_gmt] => 2025-06-24 00:45:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a4873-complex-of-16-apartments-and-10-bungalows-in-torre-de-la-horadada-50-meters-from-the-beach/
[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] => 10568453
[post_author] => 0
[post_date] => 2025-06-24 01:45:16
[post_date_gmt] => 2025-06-24 00:45:16
[post_content] =>
[post_title] => N7749 - NEW BUILD VILLA IN PILAR DE LA HORADADA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n7749-new-build-villa-in-pilar-de-la-horadada
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:16
[post_modified_gmt] => 2025-06-24 00:45:16
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/n7749-new-build-villa-in-pilar-de-la-horadada/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 7679
[max_num_pages] => 640
[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] => c5a59dc751ca163dff8f9f913c93642f
[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:be63066902488f034d8b2a03461d464b:0.34658300 1757634994
)
1
2
3
