WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 578
[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] => 578
[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 6924, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10567969
[post_author] => 0
[post_date] => 2025-06-24 01:45:04
[post_date_gmt] => 2025-06-24 00:45:04
[post_content] =>
[post_title] => 5949
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5949
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:04
[post_modified_gmt] => 2025-06-24 00:45:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/5949/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10568122
[post_author] => 0
[post_date] => 2025-06-24 01:45:08
[post_date_gmt] => 2025-06-24 00:45:08
[post_content] =>
[post_title] => F1081 - Villa project in Calpe with sea views – Keys in 2026.
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f1081-villa-project-in-calpe-with-sea-views-keys-in-2026
[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/f1081-villa-project-in-calpe-with-sea-views-keys-in-2026/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10567867
[post_author] => 0
[post_date] => 2025-06-24 01:25:28
[post_date_gmt] => 2025-06-24 00:25:28
[post_content] => EXCLUSIVE VILLA WITH SPECTACULAR VIEWS
New construction villa in Calpe with excellent views of the Sea, Peñón, and the bay of Calpe.
High tech villa with excellent high standing construction materials.
The House is built on 3 levels, connected by an interior elevator.
The house has home automation, BBQ area, Chillout area, underfloor heating, Design garden, infinity pool.
Located in the Maryvilla de Calpe urbanization, a short distance from the beach and all the necessary services.
[post_title] => N5667
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n5667
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:28
[post_modified_gmt] => 2025-06-24 00:25:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n5667/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10569563
[post_author] => 0
[post_date] => 2025-06-24 01:45:43
[post_date_gmt] => 2025-06-24 00:45:43
[post_content] =>
[post_title] => MEM135 - EXCLUSIVE OPPORTUNITY: FURNISHED & TURNKEY APARTMENT IN GOYA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mem135-exclusive-opportunity-furnished-turnkey-apartment-in-goya
[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/mem135-exclusive-opportunity-furnished-turnkey-apartment-in-goya/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10569089
[post_author] => 0
[post_date] => 2025-06-24 01:45:32
[post_date_gmt] => 2025-06-24 00:45:32
[post_content] =>
[post_title] => F0954 - Premium Apartment at Sunset Cliffs - 29th Floor
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0954-premium-apartment-at-sunset-cliffs-29th-floor
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:32
[post_modified_gmt] => 2025-06-24 00:45:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0954-premium-apartment-at-sunset-cliffs-29th-floor/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10568388
[post_author] => 0
[post_date] => 2025-06-24 01:45:14
[post_date_gmt] => 2025-06-24 00:45:14
[post_content] =>
[post_title] => MON003 - NEW CONSTRUCTION LUXURY INDEPENDENT VILLA IN TORRELODONES
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mon003-new-construction-luxury-independent-villa-in-torrelodones
[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/mon003-new-construction-luxury-independent-villa-in-torrelodones/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10569070
[post_author] => 0
[post_date] => 2025-06-24 01:45:31
[post_date_gmt] => 2025-06-24 00:45:31
[post_content] =>
[post_title] => MEM103 - EXCLUSIVE BRAND NEW RENOVATED APARTMENT IN THE CENTER OF MADRID
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mem103-exclusive-brand-new-renovated-apartment-in-the-center-of-madrid
[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/mem103-exclusive-brand-new-renovated-apartment-in-the-center-of-madrid/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10568502
[post_author] => 0
[post_date] => 2025-06-24 01:45:17
[post_date_gmt] => 2025-06-24 00:45:17
[post_content] =>
[post_title] => F0640 - Exclusive Villa in Benidorm: Unique Space in a Privileged Residential Area
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0640-exclusive-villa-in-benidorm-unique-space-in-a-privileged-residential-area
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:17
[post_modified_gmt] => 2025-06-24 00:45:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0640-exclusive-villa-in-benidorm-unique-space-in-a-privileged-residential-area/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10567966
[post_author] => 0
[post_date] => 2025-06-24 01:45:04
[post_date_gmt] => 2025-06-24 00:45:04
[post_content] =>
[post_title] => 15042 - FAMOUS RIDING CENTER WITH INDEPENDENT RURAL HOUSE
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 15042-famous-riding-center-with-independent-rural-house
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:04
[post_modified_gmt] => 2025-06-24 00:45:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/15042-famous-riding-center-with-independent-rural-house/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10569609
[post_author] => 0
[post_date] => 2025-06-24 01:45:44
[post_date_gmt] => 2025-06-24 00:45:44
[post_content] =>
[post_title] => F1084 - Exclusive Villa Surrounded by Nature in Alicante
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f1084-exclusive-villa-surrounded-by-nature-in-alicante
[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/f1084-exclusive-villa-surrounded-by-nature-in-alicante/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10566985
[post_author] => 0
[post_date] => 2025-06-24 01:25:05
[post_date_gmt] => 2025-06-24 00:25:05
[post_content] => Frontline Lake Villas in Santa Rosalía Lake Resort, Murcia
New-Build Luxury Villas in a Unique Mediterranean Resort
Discover an exclusive collection of newly built villas in Santa Rosalía Lake and Life Resort, a premier private gated development located in the Region of Murcia. These luxurious homes are set on the front line of the resort’s stunning artificial lake, just 4 km from the beaches of the Mar Menor and close to the vibrant coastal town of Los Alcázares.
Contemporary Design and Premium Comfort
Each villa is designed on a single level plus a spacious basement and a rooftop solarium. With 4 bedrooms, 5 bathrooms, and 1 guest toilet, these homes offer an ideal layout for family living or entertaining. The open-plan kitchen and living-dining area lead to generous outdoor spaces, including a private garden with a pool, two English patios for cross ventilation at basement, and an expansive solarium with spectacular lake views.
Notable features include:
Fully equipped kitchen with modern appliances
Finished garden with artificial grass, palm tree, shrubs, and drip irrigation system
Air conditioning via ducted system
6 solar panels included for energy efficiency
Bathrooms furnished with cabinets, mirrors, and shower screens
Basement with utility room, bathroom, and technical room
Private parking space for two vehicles
Exclusive Amenities in Santa Rosalía Lake and Life Resort
This exceptional resort spans 126,000 m² of landscaped green areas with walking and cycling paths, paddle and tennis courts, mini-golf, dog parks, sports facilities, leisure zones, and a clubhouse. The central attraction is a crystal-clear artificial lake of nearly 17,000 m², complete with white-sand beaches, palm trees, and two islands—one featuring a lakeside bar. Several beach bars are also spread around the lake, offering a true Mediterranean-Caribbean fusion experience.
Prime Location with Excellent Connectivity
Santa Rosalía Lake Resort enjoys a strategic position on the Costa Cálida, offering quick access to the region’s best attractions:
Beaches of Mar Menor: 4 km
Los Alcázares (town center and marina): 4 km
Roda Golf and La Serena Golf: 3–5 km
Cartagena city center: 15 km
Murcia International Airport (RMU): 22 km
Zenia Boulevard Shopping Center: 25 km
Your Dream Villa Awaits in the Heart of Costa Cálida
Live the ultimate lifestyle in one of the most innovative resorts in Spain. Contact us today to learn more about these frontline lake villas and schedule your visit.
[post_title] => N8997
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8997
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:05
[post_modified_gmt] => 2025-06-24 00:25:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8997/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10568564
[post_author] => 0
[post_date] => 2025-06-24 01:45:19
[post_date_gmt] => 2025-06-24 00:45:19
[post_content] =>
[post_title] => C0015 - Homes with modern design and high technology on the front line
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => c0015-homes-with-modern-design-and-high-technology-on-the-front-line
[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/c0015-homes-with-modern-design-and-high-technology-on-the-front-line/
[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] => 10567969
[post_author] => 0
[post_date] => 2025-06-24 01:45:04
[post_date_gmt] => 2025-06-24 00:45:04
[post_content] =>
[post_title] => 5949
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5949
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:04
[post_modified_gmt] => 2025-06-24 00:45:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/5949/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 7115
[max_num_pages] => 593
[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] => 1e750d622eb5fb1850d7f7baf6a90de2
[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:2454231cb9b56e541186cda5ce9a7491:0.75618700 1756913713
)
1
3
4
