WP_Query Object ( [query] => Array ( [posts_per_page] => 12 [suppress_filters] => [post_type] => Array ( [0] => hx_property [1] => newbuilds [2] => mn_property ) [paged] => 40 [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] => 40 [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 468, 12 [posts] => Array ( [0] => WP_Post Object ( [ID] => 10568389 [post_author] => 0 [post_date] => 2025-06-24 01:45:14 [post_date_gmt] => 2025-06-24 00:45:14 [post_content] => [post_title] => 72327 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 72327 [to_ping] => [pinged] => [post_modified] => 2025-06-24 01:45:14 [post_modified_gmt] => 2025-06-24 00:45:14 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.viewspanishproperties.com/property/72327/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 10569448 [post_author] => 0 [post_date] => 2025-06-24 01:45:40 [post_date_gmt] => 2025-06-24 00:45:40 [post_content] => [post_title] => A10561 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => a10561 [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/a10561/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 10569310 [post_author] => 0 [post_date] => 2025-06-24 01:45:37 [post_date_gmt] => 2025-06-24 00:45:37 [post_content] => [post_title] => B10800 - Fully Renovated Apartment with Panoramic Views. TORREVIEJA [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => b10800-fully-renovated-apartment-with-panoramic-views-torrevieja [to_ping] => [pinged] => [post_modified] => 2025-06-24 01:45:37 [post_modified_gmt] => 2025-06-24 00:45:37 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.viewspanishproperties.com/property/b10800-fully-renovated-apartment-with-panoramic-views-torrevieja/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 10569193 [post_author] => 0 [post_date] => 2025-06-24 01:45:34 [post_date_gmt] => 2025-06-24 00:45:34 [post_content] => [post_title] => B10712 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => b10712 [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/b10712/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 10569546 [post_author] => 0 [post_date] => 2025-06-24 01:45:43 [post_date_gmt] => 2025-06-24 00:45:43 [post_content] => [post_title] => 72698 - Commercial premises for sale in the very center of Alicante [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 72698-commercial-premises-for-sale-in-the-very-center-of-alicante [to_ping] => [pinged] => [post_modified] => 2025-06-24 01:45:43 [post_modified_gmt] => 2025-06-24 00:45:43 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.viewspanishproperties.com/property/72698-commercial-premises-for-sale-in-the-very-center-of-alicante/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 10568992 [post_author] => 0 [post_date] => 2025-06-24 01:45:29 [post_date_gmt] => 2025-06-24 00:45:29 [post_content] => [post_title] => B10500 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => b10500 [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/b10500/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 10566965 [post_author] => 0 [post_date] => 2025-06-24 01:25:04 [post_date_gmt] => 2025-06-24 00:25:04 [post_content] => Regenerated Residential Complex in Lomas de Cabo Roig – Renovated Apartments Apartments in a Prime Location Discover this exclusive opportunity to own a renovated apartment in Lomas de Cabo Roig, a sought-after area in Orihuela Costa. This residential complex, originally built in 2008, is undergoing a renovation of some units and will be delivered in June 2025. A show home is available for viewing, allowing you to see the quality finishes firsthand. Property Options to Suit Every Need This development offers 27 refurbished apartments, with a variety of layouts: 1 and 2-bedroom units, ideal for holiday homes or investment. Ground-floor apartments with private gardens, perfect for outdoor living. Middle-floor apartments with spacious terraces, ideal for enjoying the Mediterranean climate. Penthouses with private solariums, offering open views and maximum privacy. Each home is delivered with shower screens in the bathrooms and fully equipped kitchens with appliances, ensuring a turnkey solution for buyers. Exclusive Community Amenities The residential complex is designed for comfort and relaxation, featuring: A communal swimming pool surrounded by beautiful landscaped gardens. An elevator for easy access to all floors. Optional underground parking spaces available at an additional cost. An Unbeatable Location in Orihuela Costa Lomas de Cabo Roig is a prestigious residential area located just 2 km from the coastline of Cabo Roig, home to some of the most beautiful beaches in Orihuela Costa. The area is well-connected by road and offers a wide range of services, including shops, restaurants, supermarkets, and shopping centers. Distances to key points of interest: Beaches of Cabo Roig and Campoamor – 5-minute drive. Zenia Boulevard Shopping Center – 5 km. Villamartín Golf Course – 4 km. Alicante Airport – 30 minutes by car. Murcia-Corvera Airport – 1 hour by car. A Smart Investment in the Costa Blanca With its excellent location, fully renovated apartments, and top-tier amenities, this development is an ideal opportunity for investment, holiday living, or permanent residence. Don’t miss out on this unique chance to own a home in one of the most desirable areas of the Costa Blanca at an unbeatable price. Contact us today for more information or to schedule a visit! [post_title] => N8679 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => n8679 [to_ping] => [pinged] => [post_modified] => 2025-06-24 01:25:04 [post_modified_gmt] => 2025-06-24 00:25:04 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.viewspanishproperties.com/newbuilds/n8679/ [menu_order] => 0 [post_type] => newbuilds [post_mime_type] => [comment_count] => 0 [filter] => raw ) [7] => WP_Post Object ( [ID] => 10569354 [post_author] => 0 [post_date] => 2025-06-24 01:45:38 [post_date_gmt] => 2025-06-24 00:45:38 [post_content] => [post_title] => A10511 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => a10511 [to_ping] => [pinged] => [post_modified] => 2025-06-24 01:45:38 [post_modified_gmt] => 2025-06-24 00:45:38 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.viewspanishproperties.com/property/a10511/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [8] => WP_Post Object ( [ID] => 10569028 [post_author] => 0 [post_date] => 2025-06-24 01:45:30 [post_date_gmt] => 2025-06-24 00:45:30 [post_content] => [post_title] => F0920 - Apartment for Sale near Torres Beach, Villajoyosa ? [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => f0920-apartment-for-sale-near-torres-beach-villajoyosa-%f0%9f%8c%8a [to_ping] => [pinged] => [post_modified] => 2025-06-24 01:45:30 [post_modified_gmt] => 2025-06-24 00:45:30 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.viewspanishproperties.com/property/f0920-apartment-for-sale-near-torres-beach-villajoyosa-%f0%9f%8c%8a/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [9] => WP_Post Object ( [ID] => 10568841 [post_author] => 0 [post_date] => 2025-06-24 01:45:25 [post_date_gmt] => 2025-06-24 00:45:25 [post_content] => [post_title] => A10178 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => a10178 [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/a10178/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [10] => WP_Post Object ( [ID] => 10568663 [post_author] => 0 [post_date] => 2025-06-24 01:45:21 [post_date_gmt] => 2025-06-24 00:45:21 [post_content] => [post_title] => A4803 - Apartment complex in San Pedro del Pinatar (Murcia) 300 meters from the beaches of Mar Minor [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => a4803-apartment-complex-in-san-pedro-del-pinatar-murcia-300-meters-from-the-beaches-of-mar-minor [to_ping] => [pinged] => [post_modified] => 2025-06-24 01:45:21 [post_modified_gmt] => 2025-06-24 00:45:21 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.viewspanishproperties.com/property/a4803-apartment-complex-in-san-pedro-del-pinatar-murcia-300-meters-from-the-beaches-of-mar-minor/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [11] => WP_Post Object ( [ID] => 10568920 [post_author] => 0 [post_date] => 2025-06-24 01:45:27 [post_date_gmt] => 2025-06-24 00:45:27 [post_content] => [post_title] => F0854 - Great Opportunity to Generate Rental Incomes in Benidorm [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => f0854-great-opportunity-to-generate-rental-incomes-in-benidorm [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/f0854-great-opportunity-to-generate-rental-incomes-in-benidorm/ [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] => 10568389 [post_author] => 0 [post_date] => 2025-06-24 01:45:14 [post_date_gmt] => 2025-06-24 00:45:14 [post_content] => [post_title] => 72327 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => 72327 [to_ping] => [pinged] => [post_modified] => 2025-06-24 01:45:14 [post_modified_gmt] => 2025-06-24 00:45:14 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.viewspanishproperties.com/property/72327/ [menu_order] => 0 [post_type] => hx_property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 4567 [max_num_pages] => 381 [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] => 9c5bf87c0eb770e24b4f60b472955bce [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:90a3ee918502674e8c0ce3c9bcd9f0c7:0.22559000 1753317400 )
1
3
1
