WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 289
[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] => 289
[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 3456, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10569142
[post_author] => 0
[post_date] => 2025-06-24 01:45:33
[post_date_gmt] => 2025-06-24 00:45:33
[post_content] =>
[post_title] => F1012 - Bright penthouse wthe a sea view!
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f1012-bright-penthouse-wthe-a-sea-view
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:33
[post_modified_gmt] => 2025-06-24 00:45:33
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f1012-bright-penthouse-wthe-a-sea-view/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10567180
[post_author] => 0
[post_date] => 2025-06-24 01:25:10
[post_date_gmt] => 2025-06-24 00:25:10
[post_content] => NEW BUILD RESIDENTIAL COMPLEX IN SANTA POLA
New Build modern gated residential complex consisting of 1, 2 and 3 bedroom apartments and penthouses with 2 complete bathrooms. The complex consists of 4 staircases of flats with spacious landscaped communal areas, including swimming pool, relaxation area and gymnasium.
All properties have been carefully designed to provide you with an exceptional living experience, with high quality finishes and a modern style. Enjoy the spacious terraces, where you can relax, enjoy al fresco dining and watch the most spectacular sunsets.
The location is simply unbeatable: next to the centre of Santa Pola and the palm grove, and only a few minutes from the promenade, you will be close to a wide range of restaurants, bars and supermarkets.
Excellent connection with the national road 332, which connects all the southern Costa Blanca, and with the airport in only 15 minutes.
[post_title] => N8185
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8185
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:10
[post_modified_gmt] => 2025-06-24 00:25:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8185/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10569290
[post_author] => 0
[post_date] => 2025-06-24 01:45:36
[post_date_gmt] => 2025-06-24 00:45:36
[post_content] =>
[post_title] => MPA076
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mpa076
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:36
[post_modified_gmt] => 2025-06-24 00:45:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/mpa076/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10568130
[post_author] => 0
[post_date] => 2025-06-24 01:45:08
[post_date_gmt] => 2025-06-24 00:45:08
[post_content] =>
[post_title] => N6416 - NEW BUILD RESIDENTIAL OF BUNGALOW APARTMENTS IN LOS BALCONES
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n6416-new-build-residential-of-bungalow-apartments-in-los-balcones
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:08
[post_modified_gmt] => 2025-06-24 00:45:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/n6416-new-build-residential-of-bungalow-apartments-in-los-balcones/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10568696
[post_author] => 0
[post_date] => 2025-06-24 01:45:22
[post_date_gmt] => 2025-06-24 00:45:22
[post_content] =>
[post_title] => A4816 - Complex of 34 bungalows in Pilar de la Horadada
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4816-complex-of-34-bungalows-in-pilar-de-la-horadada
[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/a4816-complex-of-34-bungalows-in-pilar-de-la-horadada/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10568729
[post_author] => 0
[post_date] => 2025-06-24 01:45:23
[post_date_gmt] => 2025-06-24 00:45:23
[post_content] =>
[post_title] => B10145 - Spectacular Apartment La Zenia Orihuela Costa 2 bedrooms 2 bathrooms with luxurious common areas
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10145-spectacular-apartment-la-zenia-orihuela-costa-2-bedrooms-2-bathrooms-with-luxurious-common-areas
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:23
[post_modified_gmt] => 2025-06-24 00:45:23
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10145-spectacular-apartment-la-zenia-orihuela-costa-2-bedrooms-2-bathrooms-with-luxurious-common-areas/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10567737
[post_author] => 0
[post_date] => 2025-06-24 01:25:24
[post_date_gmt] => 2025-06-24 00:25:24
[post_content] => NEW BUILD RESIDENTIAL IN TORRE-PACHECO
New build development of 8 townhouses and quads located in Torre-Pacheco
Modern properties with 2 bedrooms and 2 bathrooms, open plan kitchen with living room, fitted wardrobes, terrace, private solarium, garden with the pool and parking space.
These exclusive homes are designed with elegant and functional interiors, fully equipped kitchens, electrical appliances included. The bathrooms have a vanity unit with washbasin and light. The bedrooms include lined wardrobes with drawer units and each property has pre-installation for ducted air conditioning.
The exteriors are no less impressive, including a private swimming pool and a large solarium with summer kitchen so you can enjoy the sun all year round. In addition, the properties have pre-installation for electric car chargers.
Located next to Club de Golf, Torre Pacheco, where you will find all amenities including bars, restaurants, supermarkets and banks and a 15min drive to the lovely beaches of the Mar Menor.
Torre Pacheco is surrounded by award winning golf courses and the whole region is regarded as one of the healthiest places to be in Spain.
This ideal location gives you so much more for your money. Within walking distance to local amenities and many bars and restaurants.
Motorway network nearby to enable you to travel to other areas quickly and easily.
Murcia international airport is 20 minutes away.
[post_title] => N8007
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8007
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:24
[post_modified_gmt] => 2025-06-24 00:25:24
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8007/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10567653
[post_author] => 0
[post_date] => 2025-06-24 01:25:22
[post_date_gmt] => 2025-06-24 00:25:22
[post_content] => NEW BUILD RESIDENTIAL OF BUNGALOW APARTMENTS IN LOS BALCONES
New Build UNIQUE residential complex in Los Balcones.
Residential consist of 136 luxury bungalow apartments built with top quality materials. Each one has magical views of the Laguna Rosa de Torrevieja and the Mediterranean Sea.
The houses have more than 131m2 distributed in a spacious living-dining room with an open-plan kitchen, 2 large bedrooms and 2 full bathrooms.
You can choose between ground floor bungalows with their 2 large private terraces to enjoy the climate of the Costa Blanca.
Or first floor bungalows of 178m2 with its 85m2 solarium with panoramic views of the Laguna Rosa and the Mediterranean Sea
Complex offers idyllic landscaped common areas with 3 swimming pool areas, Jacuzzi areas, fitness area, paddle tennis court, mini golf, children’s area, charging point for electric vehicles… and much more! Its Premium facilities and green areas will allow you to enjoy with your family and friends the 320 days of sunshine that the Costa Blanca offers.
Los Balcones located just outside Torrevieja with all accessible services, just 5 minutes from Playa de los Náufragos, supermarkets, the school and the La Zenia Boulevard Shopping Centre, and a minute from Torrevieja University Hospital.
Complex located 40 minutes from Alicante airport and 1 hour Murcia - Corvera airport.
[post_title] => N6416
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n6416
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:22
[post_modified_gmt] => 2025-06-24 00:25:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n6416/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10567398
[post_author] => 0
[post_date] => 2025-06-24 01:25:15
[post_date_gmt] => 2025-06-24 00:25:15
[post_content] => NEW BUILD BUNGALOWS IN PILAR DE LA HORADADA
New Build developmen located in an unbeatable location, in the centre of Pilar de la Horadada. An area that offers all the necessary services and amenities, such as supermarkets. Additionally, its proximity to the beach makes it an ideal option for your leisure time and Summer getaways.
This residential complex is characterised by its 12 bungalow apartments, which offers 1 bedroom and 1 bathroom properties at a very affordable price, 2 bedroom and 2 bathroom properties and also 3 bedroom and 2 bathroom properties, to cover the needs of each client, offering comfort and style.
The interiors, elegant and functional, have fully equipped kitchens including electrical appliances. The bathrooms have a vanity unit with washbasin and light. Each property has pre-installation for ducted air conditioning, a magnificent solarium for the upper floors and an attractive communal swimming pool area, making it the perfect place to enjoy and relax.
Excellent location, 5 minutes from the sandy beaches and most prestigious 18-hole Lo Romero golf course.
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] => N8366
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8366
[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/n8366/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10567484
[post_author] => 0
[post_date] => 2025-06-24 01:25:18
[post_date_gmt] => 2025-06-24 00:25:18
[post_content] => Exclusive New Development in Pilar de la Horadada, Costa Blanca, Spain
Modern Homes Close to the Sea
Discover this new residential complex in Pilar de la Horadada, a privileged location on the Costa Blanca. Only 2 km from the beach, this project offers a wide variety of 3 bedroom, 2 bathroom properties, with private parking included in the price.
The development has spacious communal areas, including a communal swimming pool, landscaped gardens and a children's play area, ideal for the whole family to enjoy.
Different Typologies to suit your Lifestyle
This development offers various housing options:
Ground floor apartments with private gardens.
Middle floor flats with large terraces.
Penthouses with private solarium.
Ground floor bungalows with private garden.
Top floor bungalows with private garden and solarium.
Townhouses and semi-detached houses with garden and solarium.
All homes have been designed in a modern and functional style, using high quality materials and contemporary finishes.
Equipment and Qualities
The properties are equipped with:
Pre-installation of ducted air conditioning.
Exterior aluminium carpentry with thermal break and double glazing.
Reinforced access door for greater security.
Aerothermal system for efficient hot water production.
Built-in wardrobes with LED lighting.
Bathroom furniture and screens included.
Pilar de la Horadada: A Privileged Place to Live in
Pilar de la Horadada is a coastal town at the southern end of the Costa Blanca, with an exceptional climate and an excellent quality of life. Its lively main street offers a wide variety of shops, supermarkets, restaurants and essential services.
Just a 5 minute drive away, you will find the stunning beaches of Torre de la Horadada and Mil Palmeras, with golden sand a lovely promenade. In addition, the area has cycle paths, hiking trails and multiple sporting activities.
Distances to Key Points
Lo Romero Golf Course - 5 km (10 minutes drive).
Corvera Airport (Murcia) - 40 km (40 minutes by car).
Alicante Airport - 55 km (55 minutes by car).
Zenia Boulevard Shopping Centre - 15 km (15 minutes by car).
Torre de la Horadada Marina - 3 km (5 minutes by car).
Request More Information Today
Don't miss this opportunity to purchase a brand new property in one of the best areas of the Costa Blanca. Contact us now for more details and to arrange a viewing.
[post_title] => N8707
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8707
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:18
[post_modified_gmt] => 2025-06-24 00:25:18
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8707/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10568616
[post_author] => 0
[post_date] => 2025-06-24 01:45:20
[post_date_gmt] => 2025-06-24 00:45:20
[post_content] =>
[post_title] => A9857
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a9857
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:20
[post_modified_gmt] => 2025-06-24 00:45:20
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a9857/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10568799
[post_author] => 0
[post_date] => 2025-06-24 01:45:24
[post_date_gmt] => 2025-06-24 00:45:24
[post_content] =>
[post_title] => A4858 - Complex of 10 townhouses in Pilar de la Horadada
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4858-complex-of-10-townhouses-in-pilar-de-la-horadada
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:24
[post_modified_gmt] => 2025-06-24 00:45:24
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a4858-complex-of-10-townhouses-in-pilar-de-la-horadada/
[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] => 10569142
[post_author] => 0
[post_date] => 2025-06-24 01:45:33
[post_date_gmt] => 2025-06-24 00:45:33
[post_content] =>
[post_title] => F1012 - Bright penthouse wthe a sea view!
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f1012-bright-penthouse-wthe-a-sea-view
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:33
[post_modified_gmt] => 2025-06-24 00:45:33
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f1012-bright-penthouse-wthe-a-sea-view/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4753
[max_num_pages] => 397
[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] => 59a5eb580131a39e98858172159dd5dc
[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:6e57f4c9937dd2f4e4578ceec62343d2:0.37076800 1753642664
)
1
2
2
