WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 16
[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] => newbuilds
[2] => mn_property
)
[paged] => 16
[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] =>
[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 180, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10428327
[post_author] => 0
[post_date] => 2025-05-14 01:45:42
[post_date_gmt] => 2025-05-14 00:45:42
[post_content] =>
[post_title] => Y2103121Siriofis
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => y2103121siriofis
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:42
[post_modified_gmt] => 2025-05-14 00:45:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/y2103121siriofis/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10428078
[post_author] => 0
[post_date] => 2025-05-14 01:45:36
[post_date_gmt] => 2025-05-14 00:45:36
[post_content] =>
[post_title] => CAS034
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => cas034
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:36
[post_modified_gmt] => 2025-05-14 00:45:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/cas034/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10428303
[post_author] => 0
[post_date] => 2025-05-14 01:45:42
[post_date_gmt] => 2025-05-14 00:45:42
[post_content] =>
[post_title] => A10527 - Spacious apartment in the heart of Torrevieja, steps from the beach
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10527-spacious-apartment-in-the-heart-of-torrevieja-steps-from-the-beach
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:42
[post_modified_gmt] => 2025-05-14 00:45:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10527-spacious-apartment-in-the-heart-of-torrevieja-steps-from-the-beach/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10427813
[post_author] => 0
[post_date] => 2025-05-14 01:45:30
[post_date_gmt] => 2025-05-14 00:45:30
[post_content] =>
[post_title] => A1011 - South Bungalow, 2 Bedrooms and Communal Pool in La Florida (Orihuela Costa)
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a1011-south-bungalow-2-bedrooms-and-communal-pool-in-la-florida-orihuela-costa
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:30
[post_modified_gmt] => 2025-05-14 00:45:30
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a1011-south-bungalow-2-bedrooms-and-communal-pool-in-la-florida-orihuela-costa/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10428005
[post_author] => 0
[post_date] => 2025-05-14 01:45:34
[post_date_gmt] => 2025-05-14 00:45:34
[post_content] =>
[post_title] => B10666 - Spacious apartment with 3 bedrooms and side sea views in great location
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10666-spacious-apartment-with-3-bedrooms-and-side-sea-views-in-great-location
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:34
[post_modified_gmt] => 2025-05-14 00:45:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10666-spacious-apartment-with-3-bedrooms-and-side-sea-views-in-great-location/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10425680
[post_author] => 0
[post_date] => 2025-05-14 01:25:04
[post_date_gmt] => 2025-05-14 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] => N8678
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8678
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:25:04
[post_modified_gmt] => 2025-05-14 00:25:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8678/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10428315
[post_author] => 0
[post_date] => 2025-05-14 01:45:42
[post_date_gmt] => 2025-05-14 00:45:42
[post_content] =>
[post_title] => CAS050 - Apartment on the heart of Gijon
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => cas050-apartment-on-the-heart-of-gijon
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:42
[post_modified_gmt] => 2025-05-14 00:45:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/cas050-apartment-on-the-heart-of-gijon/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10428015
[post_author] => 0
[post_date] => 2025-05-14 01:45:35
[post_date_gmt] => 2025-05-14 00:45:35
[post_content] =>
[post_title] => B10673
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10673
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:35
[post_modified_gmt] => 2025-05-14 00:45:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10673/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10427793
[post_author] => 0
[post_date] => 2025-05-14 01:45:29
[post_date_gmt] => 2025-05-14 00:45:29
[post_content] =>
[post_title] => B10461
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10461
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:29
[post_modified_gmt] => 2025-05-14 00:45:29
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10461/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10428339
[post_author] => 0
[post_date] => 2025-05-14 01:45:43
[post_date_gmt] => 2025-05-14 00:45:43
[post_content] =>
[post_title] => A10542
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10542
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:43
[post_modified_gmt] => 2025-05-14 00:45:43
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10542/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10426622
[post_author] => 0
[post_date] => 2025-05-14 01:40:03
[post_date_gmt] => 2025-05-14 00:40:03
[post_content] => Bright South-facing penthouse apartment with two bedrooms, two bathrooms, and an expansive private roof solarium, located in the sought-after Dream Hills II community in Los Altos, Orihuela Costa. Enjoy all-day sunshine thanks to its ideal orientation, with access to a communal pool and parking. Conveniently situated within walking distance of a supermarket and the Via Park III commercial centre, offering a variety of bars, restaurants, and shops.
The apartment features a well-proportioned lounge and dining area, a separate kitchen to the rear, two bedrooms with fitted wardrobes, and two bathrooms. Additional storage cupboards are located in the hallway. French doors from the lounge open onto a covered south-facing balcony, with an external staircase leading to the impressive private roof solarium—an ideal space for barbecues, entertaining, or simply soaking up the sun. Sold furnished and equipped with air conditioning.
Dream Hills II sits on the border between Orihuela Costa and Torrevieja (Los Balcones), providing excellent access to the AP-7 motorway and N-332 coastal road. Alicante Airport is less than a 45-minute drive away.
Early viewing recommended.
[post_title] => VC3732
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3732
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:40:03
[post_modified_gmt] => 2025-05-14 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3732/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10427442
[post_author] => 0
[post_date] => 2025-05-14 01:45:21
[post_date_gmt] => 2025-05-14 00:45:21
[post_content] =>
[post_title] => V259
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => v259
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:21
[post_modified_gmt] => 2025-05-14 00:45:21
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/v259/
[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] => 10428327
[post_author] => 0
[post_date] => 2025-05-14 01:45:42
[post_date_gmt] => 2025-05-14 00:45:42
[post_content] =>
[post_title] => Y2103121Siriofis
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => y2103121siriofis
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:42
[post_modified_gmt] => 2025-05-14 00:45:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/y2103121siriofis/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3575
[max_num_pages] => 298
[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] => 1016e06dd1cea9f0e156b37de423078e
[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
)
)
1
0
1
