WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 525
[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] => 525
[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 6288, 12
[posts] => Array
(
[0] => 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
)
[1] => 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
)
[2] => 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
)
[3] => 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
)
[4] => 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
)
[5] => WP_Post Object
(
[ID] => 10568801
[post_author] => 0
[post_date] => 2025-06-24 01:45:24
[post_date_gmt] => 2025-06-24 00:45:24
[post_content] =>
[post_title] => B10214
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10214
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:24
[post_modified_gmt] => 2025-06-24 00:45:24
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10214/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10567201
[post_author] => 0
[post_date] => 2025-06-24 01:25:10
[post_date_gmt] => 2025-06-24 00:25:10
[post_content] => Luxury New Build Villa for Sale in La Zenia, Orihuela Costa
Exclusive Living Near the Beach on the Costa Blanca
Located just 1 km from the sandy beaches of La Zenia, this stunning luxury villa in Orihuela Costa offers the perfect balance of comfort, design and Mediterranean lifestyle. With 4 spacious bedrooms, each with its own en-suite bathroom, plus a guest toilet, this home is ideal for families or those seeking a spacious holiday retreat near the sea.
Premium Design and Outdoor Features
Set on a generous 580m2 private plot, the villa is designed with high-quality finishes and attention to detail. It features:
South-southeast orientation for optimal natural light
Large private pool with integrated jacuzzi
Chill-out area with automatic bioclimatic pergola, outdoor kitchen and exterior toilet.
Private underground garage with space for multiple vehicles
Beautiful landscaped garden ideal for outdoor living
This property allows you to enjoy the sunny climate of the Costa Blanca year-round.
Advanced Technology and Comfort
Built for modern living, the villa includes state-of-the-art features:
Armoured security entrance door
Electric underfloor heating with room-by-room temperature control
Zoned air conditioning system (hot and cold) via ducts
Pre-installation for home automation to manage blinds, climate and technical security
Double-glazed aluminium windows with injected polyurethane for superior insulation
Designer bathrooms with LED lighting, suspended vanities, and sliding safety glass shower screens
The hot water system is powered by aerothermal heat pump technology, enhancing energy efficiency.
Prime Location in La Zenia
La Zenia is a sought-after residential area in Orihuela Costa, renowned for its vibrant community, year-round amenities, and proximity to the beach. Residents enjoy access to:
La Zenia Boulevard Shopping Centre – 2.5 km
Villamartín Golf Course – 4.5 km
Torrevieja city centre – 9 km
Alicante Airport – 40 km
Murcia-Corvera Airport – 60 km
Surrounded by restaurants, bars, international schools, and supermarkets, La Zenia is one of the most dynamic areas of the southern Costa Blanca.
Secure Your Dream Villa in La Zenia
Whether you are looking for a luxury family residence or a premium investment on the Mediterranean coast, this villa is an exceptional opportunity. Contact us today for more information, to schedule a visit, and to make this dream home yours before it’s gone.
[post_title] => N8897
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8897
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:10
[post_modified_gmt] => 2025-06-24 00:25:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8897/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10568515
[post_author] => 0
[post_date] => 2025-06-24 01:45:18
[post_date_gmt] => 2025-06-24 00:45:18
[post_content] =>
[post_title] => F0662 - Exclusive Luxury Villa with Stunning Panoramic Sea and Benidorm Views
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0662-exclusive-luxury-villa-with-stunning-panoramic-sea-and-benidorm-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/f0662-exclusive-luxury-villa-with-stunning-panoramic-sea-and-benidorm-views/
[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] => 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
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 6476
[max_num_pages] => 540
[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] => 63321ec1fd537aab1b90e7fc2f5ced0e
[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:6f6695595c3e556c97dad1b6f7ca87c2:0.76112500 1756128820
)