WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 332
[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] => 332
[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 3972, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10567362
[post_author] => 0
[post_date] => 2025-06-24 01:25:14
[post_date_gmt] => 2025-06-24 00:25:14
[post_content] => NEW BUILD RESIDENTIAL IN LAS COLINAS GOLF
New Build development of luxury apartments on Las Colinas Golf & Country Club.
Beautiful 2 and 3 bedrooms apartments and penthouses.
All ground floor apartments and penthouses have private swimming pools.
3 bedroom apartments have double parking in the basement and a build-in wine room.
All bedrooms and the living room you have direct access to the south facing terrace.
The open kitchen, dining area and living room benefits from the natural light from the big windows to the terraces overlooking the communal area and the green surroundings.
Included in the apartment comes a parking space and private storage room in the basement.
In the heart of the Costa Blanca South we find a leafy valley of 330 hectares between hills, very close to the sea and with a magnificent championship golf course that crosses it. This unique urban development is described as ecological due to the low intensity of housing it has built.
The success of this ecological urban development project lies in a total integration of the buildings in the natural environment. If you are looking for a corner in Spain to disconnect and find that privacy, in Las Colinas Golf & Country Club you will find the ideal place to escape. You will enjoy 200,000 square meters of beautiful Mediterranean landscapes and you will be able to make scenic walks through the lush indigenous, native flora and the extensive fields of orange and lemon groves.
Complex located 40 minutes from Alicante airport and 1 hour Murcia - Corvera airport.
[post_title] => N8327
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8327
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:14
[post_modified_gmt] => 2025-06-24 00:25:14
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8327/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10568275
[post_author] => 0
[post_date] => 2025-06-24 01:45:12
[post_date_gmt] => 2025-06-24 00:45:12
[post_content] =>
[post_title] => F0295 - Modern Ibiza-style villa with private pool
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0295-modern-ibiza-style-villa-with-private-pool
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:12
[post_modified_gmt] => 2025-06-24 00:45:12
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0295-modern-ibiza-style-villa-with-private-pool/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10569637
[post_author] => 0
[post_date] => 2025-06-24 01:45:45
[post_date_gmt] => 2025-06-24 00:45:45
[post_content] =>
[post_title] => 72751
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72751
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:45
[post_modified_gmt] => 2025-06-24 00:45:45
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72751/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10569736
[post_author] => 0
[post_date] => 2025-06-24 01:50:27
[post_date_gmt] => 2025-06-24 00:50:27
[post_content] => Located in the esteemed La Quinta area, this plot faces South East. Spanning 1,329 square meters, its elevated position affords breathtaking views of the sea, mountains, and golf course. It comes with an included villa project boasting nearly 864 square meters. The building permit has already been secured and remains valid. This presents an exceptional investment opportunity.
[post_title] => R4436440
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => r4436440
[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/r4436440/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10568490
[post_author] => 0
[post_date] => 2025-06-24 01:45:17
[post_date_gmt] => 2025-06-24 00:45:17
[post_content] =>
[post_title] => 72195
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72195
[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/72195/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10569965
[post_author] => 0
[post_date] => 2025-06-24 01:55:08
[post_date_gmt] => 2025-06-24 00:55:08
[post_content] => NEW BUILD VILLA IN MIJAS GOLF
New Build modern luxury villa situated in an enviable golf-front location. Spanning a generous plot of 1023 sm², this exceptional property offering a serene ambiance complemented by the lush greenery of the neighbouring golf course.
Dedicated team of expert designers and architects has meticulously curated a bespoke living space that caters to your every aspiration and requirement. This residence exceeds expectations by seamlessly integrating luxurious amenities including rooftop solarium, a private gym, cinema room, games room, and an in-house bar nestled in the basement. The ground floor harmoniously merges the living room, dining area, and kitchen, extending seamlessly to a porch that overlooks a private
swimming pool offering breathtaking views of the prestigious golf course. Additionally, a master bedroom boasting a walk-in closet and a opulent en suite master bathroom, along with two spacious bedrooms sharing a well-appointed bathroom, complement this stunning residence.
Experience the flawless fusion of refined aesthetics and seamless functionality, elevating your lifestyle tounparalleled levels of comfort and opulence.
Discover the allure of Mijas, where enchanting landscapes meet urban vibrancy. Nestled in this picturesque locale, Mijas offers a seamless blend of natural beauty and accessible urbanity. Just a short drive away, find the captivating charm of Fuengirola with its vibrant shopping districts, diverse dining options, and a rich tapestry of cultural experiences. In Mijas, tranquillity harmonises with convenience, offering a sanctuary embracing the tranquillity of its surroundings while effortlessly connected to Fuengirola's bustling scenes.
Amidst the breathtaking vistas, Mijas boasts a backdrop adorned with Mediterranean charm and stunning views, inviting you to indulge in leisurely strolls and cultural exploration.
Experience the best of both worlds - a serene haven near the lively energy of Fuengirola. Mijas promises an idyllic coastal lifestyle merged with the diverse and vibrant experiences of its neighbouring town.
[post_title] => N8371
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8371
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:55:08
[post_modified_gmt] => 2025-06-24 00:55:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8371/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10568174
[post_author] => 0
[post_date] => 2025-06-24 01:45:09
[post_date_gmt] => 2025-06-24 00:45:09
[post_content] =>
[post_title] => F0557 - PENTHOUSE with incredible views IN Vilajoiosa
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0557-penthouse-with-incredible-views-in-vilajoiosa
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:09
[post_modified_gmt] => 2025-06-24 00:45:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0557-penthouse-with-incredible-views-in-vilajoiosa/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10568271
[post_author] => 0
[post_date] => 2025-06-24 01:45:12
[post_date_gmt] => 2025-06-24 00:45:12
[post_content] =>
[post_title] => F0290 - New construction apartments in Poniente beach, Benidorm
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0290-new-construction-apartments-in-poniente-beach-benidorm
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:12
[post_modified_gmt] => 2025-06-24 00:45:12
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0290-new-construction-apartments-in-poniente-beach-benidorm/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10569333
[post_author] => 0
[post_date] => 2025-06-24 01:45:37
[post_date_gmt] => 2025-06-24 00:45:37
[post_content] =>
[post_title] => A10508 - 7 Tourist Apartments with Private Pool: Your Perfect Investment Opportunity
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10508-7-tourist-apartments-with-private-pool-your-perfect-investment-opportunity
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:37
[post_modified_gmt] => 2025-06-24 00:45:37
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10508-7-tourist-apartments-with-private-pool-your-perfect-investment-opportunity/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10569549
[post_author] => 0
[post_date] => 2025-06-24 01:45:43
[post_date_gmt] => 2025-06-24 00:45:43
[post_content] =>
[post_title] => MEM130 - EXCLUSIVE FLAT IN LISTA: TWO BEDROOMS, RENOVATED AND FURNISHE
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mem130-exclusive-flat-in-lista-two-bedrooms-renovated-and-furnishe
[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/mem130-exclusive-flat-in-lista-two-bedrooms-renovated-and-furnishe/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10568859
[post_author] => 0
[post_date] => 2025-06-24 01:45:26
[post_date_gmt] => 2025-06-24 00:45:26
[post_content] =>
[post_title] => B10287
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10287
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:26
[post_modified_gmt] => 2025-06-24 00:45:26
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10287/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10568667
[post_author] => 0
[post_date] => 2025-06-24 01:45:21
[post_date_gmt] => 2025-06-24 00:45:21
[post_content] =>
[post_title] => B10059 - Villa in Dehesa de campoamor
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10059-villa-in-dehesa-de-campoamor
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:21
[post_modified_gmt] => 2025-06-24 00:45:21
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10059-villa-in-dehesa-de-campoamor/
[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] => 10567362
[post_author] => 0
[post_date] => 2025-06-24 01:25:14
[post_date_gmt] => 2025-06-24 00:25:14
[post_content] => NEW BUILD RESIDENTIAL IN LAS COLINAS GOLF
New Build development of luxury apartments on Las Colinas Golf & Country Club.
Beautiful 2 and 3 bedrooms apartments and penthouses.
All ground floor apartments and penthouses have private swimming pools.
3 bedroom apartments have double parking in the basement and a build-in wine room.
All bedrooms and the living room you have direct access to the south facing terrace.
The open kitchen, dining area and living room benefits from the natural light from the big windows to the terraces overlooking the communal area and the green surroundings.
Included in the apartment comes a parking space and private storage room in the basement.
In the heart of the Costa Blanca South we find a leafy valley of 330 hectares between hills, very close to the sea and with a magnificent championship golf course that crosses it. This unique urban development is described as ecological due to the low intensity of housing it has built.
The success of this ecological urban development project lies in a total integration of the buildings in the natural environment. If you are looking for a corner in Spain to disconnect and find that privacy, in Las Colinas Golf & Country Club you will find the ideal place to escape. You will enjoy 200,000 square meters of beautiful Mediterranean landscapes and you will be able to make scenic walks through the lush indigenous, native flora and the extensive fields of orange and lemon groves.
Complex located 40 minutes from Alicante airport and 1 hour Murcia - Corvera airport.
[post_title] => N8327
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8327
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:14
[post_modified_gmt] => 2025-06-24 00:25:14
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8327/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4255
[max_num_pages] => 355
[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] => 57f0e5316e2be5fededa702009650069
[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:6685368464bb7d617cdb644b886cf56f:0.56794800 1752818726
)