WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 26
[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] => 26
[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 300, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10569063
[post_author] => 0
[post_date] => 2025-06-24 01:45:31
[post_date_gmt] => 2025-06-24 00:45:31
[post_content] =>
[post_title] => 72426
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72426
[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/72426/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10569170
[post_author] => 0
[post_date] => 2025-06-24 01:45:33
[post_date_gmt] => 2025-06-24 00:45:33
[post_content] =>
[post_title] => B10681
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10681
[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/b10681/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10568712
[post_author] => 0
[post_date] => 2025-06-24 01:45:22
[post_date_gmt] => 2025-06-24 00:45:22
[post_content] =>
[post_title] => A15673 - Apartment in San Miguel de Salinas with unobstructed views in the center
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a15673-apartment-in-san-miguel-de-salinas-with-unobstructed-views-in-the-center
[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/a15673-apartment-in-san-miguel-de-salinas-with-unobstructed-views-in-the-center/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10569182
[post_author] => 0
[post_date] => 2025-06-24 01:45:34
[post_date_gmt] => 2025-06-24 00:45:34
[post_content] =>
[post_title] => 72652 - APARTMENT IN CAROLINAS ALTAS - BOULEVARD DEL PLA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72652-apartment-in-carolinas-altas-boulevard-del-pla
[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/72652-apartment-in-carolinas-altas-boulevard-del-pla/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10568404
[post_author] => 0
[post_date] => 2025-06-24 01:45:15
[post_date_gmt] => 2025-06-24 00:45:15
[post_content] =>
[post_title] => 72103 - 3 Bedroom Apartment - Third Floor - Ready to Move In
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72103-3-bedroom-apartment-third-floor-ready-to-move-in
[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/72103-3-bedroom-apartment-third-floor-ready-to-move-in/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10568533
[post_author] => 0
[post_date] => 2025-06-24 01:45:18
[post_date_gmt] => 2025-06-24 00:45:18
[post_content] =>
[post_title] => A9514 - Beautiful apartment with large terrace, 2 bedrooms, 2 bathrooms at 500m from Archena spa and mountain views
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a9514-beautiful-apartment-with-large-terrace-2-bedrooms-2-bathrooms-at-500m-from-archena-spa-and-mountain-views
[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/a9514-beautiful-apartment-with-large-terrace-2-bedrooms-2-bathrooms-at-500m-from-archena-spa-and-mountain-views/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10568919
[post_author] => 0
[post_date] => 2025-06-24 01:45:27
[post_date_gmt] => 2025-06-24 00:45:27
[post_content] =>
[post_title] => B10379
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10379
[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/b10379/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10567912
[post_author] => 0
[post_date] => 2025-06-24 01:40:03
[post_date_gmt] => 2025-06-24 00:40:03
[post_content] => This spacious and well-presented two-bedroom corner apartment is ideally located just moments from the renowned Villamartin Plaza and golf course, offering a wide range of amenities right on your doorstep.
Situated on the first floor with lift access, the apartment enjoys a bright and airy interior with a modern design and generous living space. It is sold fully furnished and includes air conditioning, a private storage room, and allocated parking.
The open-plan lounge and dining area is filled with natural light and flows seamlessly into an American-style kitchen. From here, you can access a private balcony—an ideal spot for morning coffee. The lounge also benefits from a Juliet balcony, enhancing the sense of light and space. Both double bedrooms feature fitted wardrobes, while the stylish family bathroom includes a walk-in shower.
The apartment is part of a well-maintained community with a unique advantage—homeowners currently pay no community fees, as rental income from an on-site ATM covers the usual 200€ annual charge.
Perfectly positioned just a short stroll from Villamartin Plaza, residents have easy access to a bank, hairdressers, restaurants, bars, a taxi rank, and a bus stop. The beautiful blue-flag beaches of the Orihuela Costa and the popular Zenia Boulevard shopping centre are just a five-minute drive away.
[post_title] => VC3713
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3713
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:40:03
[post_modified_gmt] => 2025-06-24 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3713/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10567924
[post_author] => 0
[post_date] => 2025-06-24 01:40:03
[post_date_gmt] => 2025-06-24 00:40:03
[post_content] => Situated in the popular Torregolf IV development in Pau 8, this top floor apartment offers comfortable living with access to a communal pool and off-road parking.
The apartment features a bright lounge and dining area, with a fitted kitchen conveniently located to one side. There are two double bedrooms, each with built-in wardrobes, and a family bathroom. From the lounge, patio doors open onto a private balcony, with a spiral staircase leading up to a generously sized roof solarium—an ideal space for outdoor dining or simply enjoying the sun. The solarium offers open views, including a glimpse of the sea.
The apartment faces South-East, providing plenty of natural light. Torregolf IV is a well-established and well-maintained community, just a short walk from Villamartin Plaza and the golf course. Local beaches and the popular Zenia Boulevard shopping centre are also just a few minutes’ drive away.
Early viewing is recommended.
[post_title] => VC3775
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3775
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:40:03
[post_modified_gmt] => 2025-06-24 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3775/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10570423
[post_author] => 0
[post_date] => 2025-07-05 23:30:04
[post_date_gmt] => 2025-07-05 22:30:04
[post_content] => This superb apartment is presented for sale on good condition and has been well maintained.
The property offers a spacious 3 bedroom, 1 bathroom accommodation set right in the heart of Guardamar old town, just a few hundred meters from the beach and all the surrounding amenities on offer.
Three good size bedrooms and a family bathroom with a large separate Kitchen and utility area.
Ideal holiday apartment with everything on the doorstep.
There is an allocated under ground car parking space available.
[post_title] => VA5272
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5272-14
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-05 23:30:04
[post_modified_gmt] => 2025-07-05 22:30:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5272-14/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10570776
[post_author] => 0
[post_date] => 2025-07-11 23:30:18
[post_date_gmt] => 2025-07-11 22:30:18
[post_content] => This superb apartment is presented for sale on good condition and has been well maintained.
The property offers a spacious 3 bedroom, 1 bathroom accommodation set right in the heart of Guardamar old town, just a few hundred meters from the beach and all the surrounding amenities on offer.
Three good size bedrooms and a family bathroom with a large separate Kitchen and utility area.
Ideal holiday apartment with everything on the doorstep.
There is an allocated under ground car parking space available.
[post_title] => VA5272
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5272-26
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-11 23:30:18
[post_modified_gmt] => 2025-07-11 22:30:18
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5272-26/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10571210
[post_author] => 0
[post_date] => 2025-07-19 23:30:09
[post_date_gmt] => 2025-07-19 22:30:09
[post_content] => This superb apartment is presented for sale on good condition and has been well maintained.
The property offers a spacious 3 bedroom, 1 bathroom accommodation set right in the heart of Guardamar old town, just a few hundred meters from the beach and all the surrounding amenities on offer.
Three good size bedrooms and a family bathroom with a large separate Kitchen and utility area.
Ideal holiday apartment with everything on the doorstep.
There is an allocated under ground car parking space available.
[post_title] => VA5272
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5272-42
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-19 23:30:09
[post_modified_gmt] => 2025-07-19 22:30:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5272-42/
[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] => 10569063
[post_author] => 0
[post_date] => 2025-06-24 01:45:31
[post_date_gmt] => 2025-06-24 00:45:31
[post_content] =>
[post_title] => 72426
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72426
[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/72426/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4411
[max_num_pages] => 368
[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] => deed5618118b7c787183244590084b71
[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:d17a88484f4ce80b4aa5f94bf8ddeb5c:0.50439900 1753089236
)
1
3
1
