WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 377
[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] => 377
[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 4512, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10569711
[post_author] => 0
[post_date] => 2025-06-24 01:50:26
[post_date_gmt] => 2025-06-24 00:50:26
[post_content] => Step into the realm of opulence at this mansion, an avant-garde residence nestled within one of most esteemed Marbella's communities. This magnificent frontline golf mansion, centrally located in the Golf Valley, graces a private parcel with enchanting views overlooking the lush greens of Los Naranjos Golf Course. Boasting a sumptuous open-plan layout, meticulously tailored for unrivaled comfort and showcasing the pinnacle of contemporary design, This residence stands as a testament to architectural brilliance. Crafted by the esteemed Tobal Architects and adorned with the exquisite touch of Pedro Peña, this residence stands as a peerless masterpiece, arguably the most lavish mansion to grace this community. Among its lavish features, a cutting-edge cinema, dedicated yoga and gym sanctuary, a heated pool paired with a soothing Jacuzzi, a playroom for children, the latest in home automation, a self-contained staff quarters, a grand gourmet kitchen, and a chef's culinary haven are but a few of the treasures within. This is a mansion conceived to captivate the most discerning of buyers, promising to steal your breath from the very moment you cross its threshold.
[post_title] => R4436341
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => r4436341
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:50:26
[post_modified_gmt] => 2025-06-24 00:50:26
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/r4436341/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10569741
[post_author] => 0
[post_date] => 2025-06-24 01:50:27
[post_date_gmt] => 2025-06-24 00:50:27
[post_content] => In the esteemed La Zagaleta area, you'll discover this remarkable off-plan villa, set to be move-in ready by spring 2024. Facing south, it spans three levels. Throughout the residence, expect top-notch finishes. The kitchen boasts a full suite of high-quality, integrated Gaggenau appliances, along with Gessi taps and a central island.
A mere 15-minute drive up the hills leads you to La Zagaleta, one of Europe's most exclusive urbanization. Within this community lies a golf course, complete with a clubhouse, pro shop, restaurant, swimming pool, billiard room, bridge room, and tennis courts.
Undoubtedly, this villa in the splendid La Zagaleta is a one-of-a-kind gem.
[post_title] => R4436455
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => r4436455
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:50:27
[post_modified_gmt] => 2025-06-24 00:50:27
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/r4436455/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10569716
[post_author] => 0
[post_date] => 2025-06-24 01:50:26
[post_date_gmt] => 2025-06-24 00:50:26
[post_content] => This mansion represents the pinnacle of blending art, architecture, and engineering within a single magnificent space. This impeccably designed estate offers awe-inspiring, unobstructed panoramic views of the Mediterranean Sea and the majestic Sierra Blanca mountain range. Situated on a generous 8,799m2 plot, with an impressive 2,001m2 of meticulously crafted living space, this authentic Spanish property stands as a testament to bespoke craftsmanship. Conceived by esteemed Spanish interior designer Luis Olazábal, every corner of this estate exudes an eclectic and timeless style.
Upon entry, you're greeted by a stunning grand salon, featuring multiple sunken lounge areas, each meticulously designed to reflect its distinctive character. A striking brass centerpiece chandelier adds to the ambiance. An adjacent dining area boasts dual open steel fireplaces with wooden cladding. Behind velvet curtains lies a fully customized cocktail bar with integrated Bose speakers, personalized lighting, chill-out zones, art-deco flooring, and even a smoke machine. The indoors seamlessly flow to the magnificent backyard through five large steel-case French doors.
The exquisite kitchen offers a separate butler's pantry and chef's island, complete with a vintage Lacanche gas stove, built-in wooden cabinets, wine cooler, and walk-in fridge. The bright dining area overlooks the panoramic garden and sea views, effortlessly connecting to the covered outdoor patio. The property's Andalusian heritage is showcased in its expansive covered and uncovered patios, detailed wooden beam ceilings, a central water feature, lush greenery, meticulously manicured gardens, a spacious pool with ocean views, and a private paddle court.
With a total of nine generously sized bedrooms, each thoughtfully designed, the master suite is a true marvel. Natural wooden accents, custom cabinetry, and unique design elements enhance the room's elegance, with stunning sea views and direct access to a private terrace. The integrated master bathroom features a captivating green copper clawfoot tub under an open glass ceiling, offering abundant natural views and direct access to an outdoor Jacuzzi.
The lower level has been transformed into the ultimate entertainment and wellness center. It includes a multi-elevation movie theatre, a loft-style bar with mirrored ceilings, a custom hammam spa, heated indoor pool, massage room, a gaming area with Formula 1 seats, a state-of-the-art gym, and a bowling alley, along with a poker salon.
The equally impressive guest house comprises seven bedrooms, with a seamless flow of unified details and exquisite finishes throughout. this residence stands as a timeless masterpiece and one of the most grandiose properties to grace the Marbella market in recent years.
[post_title] => R4436359
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => r4436359
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:50:26
[post_modified_gmt] => 2025-06-24 00:50:26
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/r4436359/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 3
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 10569711
[post_author] => 0
[post_date] => 2025-06-24 01:50:26
[post_date_gmt] => 2025-06-24 00:50:26
[post_content] => Step into the realm of opulence at this mansion, an avant-garde residence nestled within one of most esteemed Marbella's communities. This magnificent frontline golf mansion, centrally located in the Golf Valley, graces a private parcel with enchanting views overlooking the lush greens of Los Naranjos Golf Course. Boasting a sumptuous open-plan layout, meticulously tailored for unrivaled comfort and showcasing the pinnacle of contemporary design, This residence stands as a testament to architectural brilliance. Crafted by the esteemed Tobal Architects and adorned with the exquisite touch of Pedro Peña, this residence stands as a peerless masterpiece, arguably the most lavish mansion to grace this community. Among its lavish features, a cutting-edge cinema, dedicated yoga and gym sanctuary, a heated pool paired with a soothing Jacuzzi, a playroom for children, the latest in home automation, a self-contained staff quarters, a grand gourmet kitchen, and a chef's culinary haven are but a few of the treasures within. This is a mansion conceived to captivate the most discerning of buyers, promising to steal your breath from the very moment you cross its threshold.
[post_title] => R4436341
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => r4436341
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:50:26
[post_modified_gmt] => 2025-06-24 00:50:26
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/r4436341/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4515
[max_num_pages] => 377
[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] => 15c41a07c66e91b58669a7672bdd09bf
[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:a0519a131460f970e4a251ee6aff076c:0.35421900 1753262026
)
1
8
6
