WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 379
[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] => 379
[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 4536, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 8101330
[post_author] => 15
[post_date] => 2023-05-24 10:38:35
[post_date_gmt] => 2023-05-24 09:38:35
[post_content] => Villa HG. The Hidden Gem of the Golf Valley
A state-of-the-art property designed by a renowned local architect using the finest materials and attention to detail.
Set on an elevated plot walking distance to La Quinta golf and a few minutes' drive from Puerto Banus, easy access to the motorway giving you a quick conection to Malaga airport and Malaga itself. Due to its elevated position, the property has open sea and golf views and also utmost privacy. It's south facing so you can enjoy sun all day on its beautifully landscaped garden and its 20 metre long pool.
Villa HG Marbella has had no effort spared in bringing together the finest materials, state-of-the-art technology and craftsmanship to create it. Bright and open, the main level has a grand double height entrance hall with large skylight which makes a dramatic statement with the sea view across the room, a double staircase and a lift that provides easy access to the three levels of the property. The spacious living room is flanked on either side by open fireplaces that separate the tv room on one side and the dining room on the other. The modern chef's kitchen with a separate butler's kitchen, opens to the dining area and a second lounge where you can have the family close by or pre-dinner drinks when you are entertaining. An office and a guest bedroom suite with independent access are also on this level.
Upstairs, the impressive main bedroom suite enjoys a privileged position with a private open terrace and panoramic views. Four additional bedrooms suites, all of them with private terraces provide generous accommodation.
Perfect leisure time is guaranteed by all the amenities on the lower level of this villa, with an amazing spa area incorporating a heated indoor pool, cold pool, sauna, hammam, massage room and a fully equipped gym. For additional entertainment, the wine cellar, cinema room and the games room with snooker and poker tables provide something to suit almost every taste, also for car-lovers who will be able to watch their toys parked in the 3-car garage.
Outdoors, a flat manicured garden is set around the 20 metre infinity styled pool with a large gazebo with sitting and dining areas, bar and kitchen. This is the perfect home for either a family to create great memories or to entertain friends and enjoy the ideal lifestyle that this property and Marbella provide.
[post_title] => VSP006 - Villa HG
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vsp006-villa-hg
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-03 15:15:31
[post_modified_gmt] => 2025-07-03 14:15:31
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/?post_type=mn_property&p=8101330
[menu_order] => 0
[post_type] => mn_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10569718
[post_author] => 0
[post_date] => 2025-06-24 01:50:26
[post_date_gmt] => 2025-06-24 00:50:26
[post_content] => Discover the captivating duplex penthouse gracing the coveted frontline of Puente Romano's beach. Nestled within the gated community of Orquidea, this extraordinary residence boasts unrivaled sea views and has been curated with impeccable interior design by Ambience, exuding an irresistible charm. The main floor welcomes you with a generous living room adorned with floor-to-ceiling glass sliding doors, inviting an abundance of natural light. Every corner is meticulously adorned with tasteful furnishings and finishes, harmonizing neutral tones with bursts of vibrant colors, creating a soothing and welcoming ambiance. A double-sided fireplace adds a touch of elegance, separating the living area from the exquisite open-plan kitchen and dining spaces. Step onto the terrace for a covered dining experience and a chic chill-out area, all while relishing uninterrupted sea vistas. Each bedroom is a sumptuous en-suite sanctuary, thoughtfully designed to elevate both comfort and opulence. The elegant master bedroom boasts generous space and a stunning bathroom, while its private terrace, complete with a pool and inviting chill-out zone, offers an exclusive retreat overlooking the sea. With its southern orientation, this residence epitomizes a coastal paradise, perfectly situated along Marbella's prestigious Golden Mile.
[post_title] => R4436365
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => r4436365
[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/r4436365/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => 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
)
[3] => 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
)
[4] => 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] => 5
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 8101330
[post_author] => 15
[post_date] => 2023-05-24 10:38:35
[post_date_gmt] => 2023-05-24 09:38:35
[post_content] => Villa HG. The Hidden Gem of the Golf Valley
A state-of-the-art property designed by a renowned local architect using the finest materials and attention to detail.
Set on an elevated plot walking distance to La Quinta golf and a few minutes' drive from Puerto Banus, easy access to the motorway giving you a quick conection to Malaga airport and Malaga itself. Due to its elevated position, the property has open sea and golf views and also utmost privacy. It's south facing so you can enjoy sun all day on its beautifully landscaped garden and its 20 metre long pool.
Villa HG Marbella has had no effort spared in bringing together the finest materials, state-of-the-art technology and craftsmanship to create it. Bright and open, the main level has a grand double height entrance hall with large skylight which makes a dramatic statement with the sea view across the room, a double staircase and a lift that provides easy access to the three levels of the property. The spacious living room is flanked on either side by open fireplaces that separate the tv room on one side and the dining room on the other. The modern chef's kitchen with a separate butler's kitchen, opens to the dining area and a second lounge where you can have the family close by or pre-dinner drinks when you are entertaining. An office and a guest bedroom suite with independent access are also on this level.
Upstairs, the impressive main bedroom suite enjoys a privileged position with a private open terrace and panoramic views. Four additional bedrooms suites, all of them with private terraces provide generous accommodation.
Perfect leisure time is guaranteed by all the amenities on the lower level of this villa, with an amazing spa area incorporating a heated indoor pool, cold pool, sauna, hammam, massage room and a fully equipped gym. For additional entertainment, the wine cellar, cinema room and the games room with snooker and poker tables provide something to suit almost every taste, also for car-lovers who will be able to watch their toys parked in the 3-car garage.
Outdoors, a flat manicured garden is set around the 20 metre infinity styled pool with a large gazebo with sitting and dining areas, bar and kitchen. This is the perfect home for either a family to create great memories or to entertain friends and enjoy the ideal lifestyle that this property and Marbella provide.
[post_title] => VSP006 - Villa HG
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vsp006-villa-hg
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-03 15:15:31
[post_modified_gmt] => 2025-07-03 14:15:31
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/?post_type=mn_property&p=8101330
[menu_order] => 0
[post_type] => mn_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4541
[max_num_pages] => 379
[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] => 749287c142b506fe4be2e69f669b5c53
[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:fc268c3e041ffaebd4b22c4f091733b9:0.61649200 1753304622
)
1
4
4
