WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 80
[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] => 80
[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 948, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10569621
[post_author] => 0
[post_date] => 2025-06-24 01:45:44
[post_date_gmt] => 2025-06-24 00:45:44
[post_content] =>
[post_title] => B10925
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10925
[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/b10925/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10567360
[post_author] => 0
[post_date] => 2025-06-24 01:25:14
[post_date_gmt] => 2025-06-24 00:25:14
[post_content] => NEW BUILD RESIDENTIAL COMPLEX IN PILAR DE LA HORADADA
New Build residential of apartments and penthouses in Pilar de la Horadada.
Ground floor and middle floor apartments with large terraces and top floor penthouses with private solariums.
Modern properties with 2 and 3bedrooms, 2 bathrooms, open plan kitchen with spacious living room, fitted wardrobes. Each property has parking space and storage room.
Everything at your fingertips so that you can enjoy an excellent location.
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] => N8009
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8009
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:14
[post_modified_gmt] => 2025-06-24 00:25:14
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8009/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10569430
[post_author] => 0
[post_date] => 2025-06-24 01:45:40
[post_date_gmt] => 2025-06-24 00:45:40
[post_content] =>
[post_title] => A10552
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10552
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:40
[post_modified_gmt] => 2025-06-24 00:45:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10552/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10568897
[post_author] => 0
[post_date] => 2025-06-24 01:45:27
[post_date_gmt] => 2025-06-24 00:45:27
[post_content] =>
[post_title] => A10232
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10232
[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/a10232/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10568153
[post_author] => 0
[post_date] => 2025-06-24 01:45:09
[post_date_gmt] => 2025-06-24 00:45:09
[post_content] =>
[post_title] => 70823 - Floor divided into studios. Investor opportunity.
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 70823-floor-divided-into-studios-investor-opportunity
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:09
[post_modified_gmt] => 2025-06-24 00:45:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/70823-floor-divided-into-studios-investor-opportunity/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10568964
[post_author] => 0
[post_date] => 2025-06-24 01:45:28
[post_date_gmt] => 2025-06-24 00:45:28
[post_content] =>
[post_title] => B10447 - Ground-Floor Apartment for Sale Near La Mata Beach
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10447-ground-floor-apartment-for-sale-near-la-mata-beach
[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/b10447-ground-floor-apartment-for-sale-near-la-mata-beach/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10567098
[post_author] => 0
[post_date] => 2025-06-24 01:25:08
[post_date_gmt] => 2025-06-24 00:25:08
[post_content] => New Build Townhouses for Sale in Cox – 44 Modern Homes with Great Amenities
Discover a new residential development of 44 modern townhouses in Cox, Alicante. These homes are available in 2- and 3-bedroom layouts, each featuring a private solarium, terraces, patios, and private parking. The community offers access to shared areas, including a communal swimming pool, creating an ideal environment for relaxation.
Prime Location with Excellent Connectivity
This development is located just 40 km from Alicante International Airport, making travel easy and convenient. Cox is well-connected to major cities: Orihuela is only 8 km away, Elche 20 km, Alicante 48 km, and Murcia 25 km. Golf enthusiasts will appreciate the nearby courses such as La Finca (12 km) and Vistabella (14 km).
Easy Access to Major Roads
Cox provides easy access to the AP-7 motorway and the Autovía del Mediterráneo (A-7), as well as local routes to surrounding areas such as Granja de Rocamora and Callosa de Segura. The town and surrounding areas boasts a population of over 35,000, offering a peaceful yet vibrant lifestyle.
Local Amenities and Attractions
Residents will enjoy a wide range of local amenities, including shops, schools, sports facilities, medical centers, and quick access to the beaches of the Costa Blanca, such as Guardamar del Segura and Torrevieja.
Included Features
Each home comes with a landscaped garden, LED lighting, electric shutters, solar panel pre-installation, fitted wardrobes, a security door, a fully equipped kitchen with Silestone countertops, and much more.
[post_title] => N8414
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8414
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:08
[post_modified_gmt] => 2025-06-24 00:25:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8414/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10568582
[post_author] => 0
[post_date] => 2025-06-24 01:45:19
[post_date_gmt] => 2025-06-24 00:45:19
[post_content] =>
[post_title] => F0728 - "Spectacular Apartment on the 18th Floor with Panoramic Sea Views in Benidorm"
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0728-spectacular-apartment-on-the-18th-floor-with-panoramic-sea-views-in-benidorm
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:19
[post_modified_gmt] => 2025-06-24 00:45:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0728-spectacular-apartment-on-the-18th-floor-with-panoramic-sea-views-in-benidorm/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10568589
[post_author] => 0
[post_date] => 2025-06-24 01:45:19
[post_date_gmt] => 2025-06-24 00:45:19
[post_content] =>
[post_title] => A4788 - Three-storey residential complex in Pilar de la Horadada
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4788-three-storey-residential-complex-in-pilar-de-la-horadada
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:19
[post_modified_gmt] => 2025-06-24 00:45:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a4788-three-storey-residential-complex-in-pilar-de-la-horadada/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10568978
[post_author] => 0
[post_date] => 2025-06-24 01:45:29
[post_date_gmt] => 2025-06-24 00:45:29
[post_content] =>
[post_title] => f0889
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0889
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:29
[post_modified_gmt] => 2025-06-24 00:45:29
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0889/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10568423
[post_author] => 0
[post_date] => 2025-06-24 01:45:15
[post_date_gmt] => 2025-06-24 00:45:15
[post_content] =>
[post_title] => MON016 - GREAT NEW CONSTRUCTION HOMES IN BUENAVISTA, MADRID
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mon016-great-new-construction-homes-in-buenavista-madrid
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:15
[post_modified_gmt] => 2025-06-24 00:45:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/mon016-great-new-construction-homes-in-buenavista-madrid/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10568552
[post_author] => 0
[post_date] => 2025-06-24 01:45:18
[post_date_gmt] => 2025-06-24 00:45:18
[post_content] =>
[post_title] => A9543 - Penthouse in the center, right next to Plaza de Oriente. With parking
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a9543-penthouse-in-the-center-right-next-to-plaza-de-oriente-with-parking
[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/a9543-penthouse-in-the-center-right-next-to-plaza-de-oriente-with-parking/
[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] => 10569621
[post_author] => 0
[post_date] => 2025-06-24 01:45:44
[post_date_gmt] => 2025-06-24 00:45:44
[post_content] =>
[post_title] => B10925
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10925
[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/b10925/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4489
[max_num_pages] => 375
[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] => 2228f6805848164eb916e02d84c42939
[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:27a542475a76d30475cbbfa0f3fc86db:0.53791300 1753209452
)