WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 312
[meta_query] => Array
(
[relation] => AND
)
[order] => DESC
[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] => 312
[meta_query] => Array
(
[relation] => AND
)
[order] => DESC
[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 DESC
LIMIT 3732, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10567902
[post_author] => 0
[post_date] => 2025-06-24 01:40:02
[post_date_gmt] => 2025-06-24 00:40:02
[post_content] => Beautiful 2 bedroom, 2 bathroom penthouse apartment (lifts available) with private roof solarium directly overlooking the pool for sale in El Rincon. The apartment has received an updated interior, and comprises of a bright lounge-dining area with patio doors leading onto the sunny balcony with pool and garden views, open plan kitchen with breakfast bar, 2 bedrooms with fitted wardrobes and 2 bathrooms with underfloor heating plus storage/utility room. The master bedroom offers its own en-suite bathroom with walk-in shower, plus access to the front balcony. A unique feature of this particular apartment is that the 2nd bathroom is not en-suite, so can be used as a guest bathroom for visitors without having to go into the twin bedroom. External stairs leads to a large private roof terrace with sea and pool views, and offers plenty of space to sunbathe and entertain on. Also included is ducted air-conditioning in all rooms, secure off-road parking space and the use of 2 communal pools and well maintained garden areas. The entire exterior of the complex has been recently repainted. The current owners have done additional upgrades to the apartment including new flooring throughout, new walk-in shower, lighting, furniture, and appliances (Haier) which are just 4 months old.
Located just a few hundred metres from 3 supermarkets, the Playa Flamenca and Citrus commercial centres, which hosts a vast array of bars, shops and restaurants. The Playa Flamenca beach is only a few minutes drive away including the Zenia Boulevard shopping mall. Due its location and proximity to a wide range of amenities, apartments in El Rincon are a good rental opportunity or make the perfect holiday home with well kept communal areas and the use of 2 beautiful pools.
[post_title] => VC3597
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3597
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:40:02
[post_modified_gmt] => 2025-06-24 00:40:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3597/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10568681
[post_author] => 0
[post_date] => 2025-06-24 01:45:21
[post_date_gmt] => 2025-06-24 00:45:21
[post_content] =>
[post_title] => A4807 - Complex of 56 bungalows in San Pedro del Pinatar (Murcia)
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4807-complex-of-56-bungalows-in-san-pedro-del-pinatar-murcia
[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/a4807-complex-of-56-bungalows-in-san-pedro-del-pinatar-murcia/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10568592
[post_author] => 0
[post_date] => 2025-06-24 01:45:19
[post_date_gmt] => 2025-06-24 00:45:19
[post_content] =>
[post_title] => A4791 - Complex of apartments in Pilar de la Horadada
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4791-complex-of-apartments-in-pilar-de-la-horadada
[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/a4791-complex-of-apartments-in-pilar-de-la-horadada/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10568603
[post_author] => 0
[post_date] => 2025-06-24 01:45:20
[post_date_gmt] => 2025-06-24 00:45:20
[post_content] =>
[post_title] => A4795 - Apartment complex in San Pedro del Pinatar (Murcia)
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4795-apartment-complex-in-san-pedro-del-pinatar-murcia
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:20
[post_modified_gmt] => 2025-06-24 00:45:20
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a4795-apartment-complex-in-san-pedro-del-pinatar-murcia/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10568956
[post_author] => 0
[post_date] => 2025-06-24 01:45:28
[post_date_gmt] => 2025-06-24 00:45:28
[post_content] =>
[post_title] => B10432
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10432
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:28
[post_modified_gmt] => 2025-06-24 00:45:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10432/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10568588
[post_author] => 0
[post_date] => 2025-06-24 01:45:19
[post_date_gmt] => 2025-06-24 00:45:19
[post_content] =>
[post_title] => A4787 - Three-storey residential complex in Pilar de la Horadada
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4787-three-storey-residential-complex-in-pilar-de-la-horadada
[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/a4787-three-storey-residential-complex-in-pilar-de-la-horadada/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10568723
[post_author] => 0
[post_date] => 2025-06-24 01:45:22
[post_date_gmt] => 2025-06-24 00:45:22
[post_content] =>
[post_title] => A4827 - Complex of 11 bungalows in Roldan (Murcia)
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4827-complex-of-11-bungalows-in-roldan-murcia
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:22
[post_modified_gmt] => 2025-06-24 00:45:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a4827-complex-of-11-bungalows-in-roldan-murcia/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10569444
[post_author] => 0
[post_date] => 2025-06-24 01:45:40
[post_date_gmt] => 2025-06-24 00:45:40
[post_content] =>
[post_title] => A10557
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10557
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:40
[post_modified_gmt] => 2025-06-24 00:45:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10557/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10566934
[post_author] => 0
[post_date] => 2025-06-24 01:25:04
[post_date_gmt] => 2025-06-24 00:25:04
[post_content] => NEW BUILD BUNGALOW APARTMENTS IN CONDADO DE ALHAMA GOLF COURSE
New Build exclusive complex of 18 bungalows apartments in Condado de Alhama.
Beautiful bungalows with 2 or 3 bedrooms and 2 bathrooms,been designed with the wellbeing and quality of life of their inhabitants in mind.
Residential offers spacious communal areas, including several communal swimming pools, one of which is heated, where you can enjoy moments of relaxation and fun.
In addition, the complex has landscaped areas for strolling and enjoying the surroundings, as well as parking areas designed for the convenience of residents.
The ground floor bungalows have 3 bedrooms and generous gardens, ideal for spending time outdoors and organising get-together with family and friends.
The top floors, on the other hand, have 2 bedrooms and a spacious solarium that allows you to make the most of the sunlight and views of the natural surroundings.
Condado de Alhama Golf Resort is a fantastic Golf Resort with many facilities and services . A shopping centre, a sports centre, a variety of bars and restaurants, supermarkets and over 25 communal swimming pools and gardens.
Condado de Alhama Golf Resort has its own Jack Nicklaus designed golf course and is only 15 minutes from the beautiful beaches of Bolnuevo and Mazarron.
Mazarron has over 35 km of coastline, much of which is unspoilt coastline. Numerous beaches in the Bay of Mazarron have been awarded the Blue Flag for their quality.
Condado de Alhama Golf Resort is only 20 minutes from the new Corvera International Airport.
[post_title] => N8554
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8554
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:04
[post_modified_gmt] => 2025-06-24 00:25:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8554/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10567648
[post_author] => 0
[post_date] => 2025-06-24 01:25:22
[post_date_gmt] => 2025-06-24 00:25:22
[post_content] => BEAUTIFUL SEA VIEW APARTMENTS IN LA MANGA
This urbanization is located in the largest expansion area of La Manga.
In this new urbanization the homes have been designed to take advantage of every corner of the house, as well as the care in choosing the materials and their design.
Apartments with armored entrance door and doors lacquered in white with stainless steel fittings.
White, monobloc blinds and double glazing with air chamber.
In the master bedroom built-in wardrobe with sliding doors, with a separating shelf in the mezzanine, a bar and a chest of three drawers.
Kitchen with high and low furniture, in white, gola-type handle, single sink with drainer, ceramic hob, electric oven and extractor hood.
Pre-installation of air conditioning (cold and heat) through conduits with provision of zoning of rooms.
La Manga del Mar Menor is a natural strip of land surrounded by two seas, the Mar Menor and the Mediterranean Sea. To this rarity you can add the multiple leisure and free time options, restaurants, supermarkets, medical centers, pharmacies, nautical sports centers, golf courses.
La Manga is located on the north coast of the Costa Calida and is a popular holiday destination for tourists. The narrow land strip separating the warm lagoon and the colder sea has a unique microclimate. It’s one of the most exotic areas in Spain.
Corvera airport is about 1 hour drive away and Alicante airport about 2 hours away.
[post_title] => N6158
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n6158
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:22
[post_modified_gmt] => 2025-06-24 00:25:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n6158/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10568069
[post_author] => 0
[post_date] => 2025-06-24 01:45:07
[post_date_gmt] => 2025-06-24 00:45:07
[post_content] =>
[post_title] => N6158 - BEAUTIFUL SEAVIEW APARTMENTS IN LA MANGA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n6158-beautiful-seaview-apartments-in-la-manga
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:07
[post_modified_gmt] => 2025-06-24 00:45:07
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/n6158-beautiful-seaview-apartments-in-la-manga/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10567754
[post_author] => 0
[post_date] => 2025-06-24 01:25:25
[post_date_gmt] => 2025-06-24 00:25:25
[post_content] => NEW BUILD RESIDENTIAL COMPLEX IN LA MANGA
New Build residential complex is located in a unique and special place, between two seas, in a privileged location and with all the services you may need at your fingertips in the Region of Murcia, beautiful coastline with the beaches of transparent and shallow waters.
At this residential complex apartments have been designed to make the most of every last corner of the property, as well as the
the choice of materials and the design of the homes.
Live a world of sensations and pleasurable moments with all the
services and activities that you desire at your fingertips.
Installations - Air conditioning:
Air conditioning system by ducts, for hot and cold, throughout the house (except in distributors and bathrooms) and operated by central console.
Electrical appliances:
Stainless steel oven.
Black ceramic hob with three burners.
Stainless steel refrigerator.
Extractor hood integrated in furniture.
Integrated dishwasher.
Common areas:
Access to the building via white PVC door and double glazing with air chamber.
Entrance halls and stair treads specially decorated with national marble.
White thermo-lacquered aluminium handrail on interior staircases.
Lighting by presence detection in basement and interior common areas.
White motorised sectional garage access door.
Stainless steel urbanisation railings.
Video door entry system.
Satellite dish with European channels.
Swimming pool with landscaped solarium.
La Manga del Mar Menor is a natural strip of land surrounded by two seas, the Mar Menor and the Mediterranean Sea. To this rarity you can add the multiple leisure and free time options, restaurants, supermarkets, medical censers, pharmacies, nautical sports censers, golf courses.
La Manga is located on the north coast of the Costa Calida and is a popular holiday destination for tourists. The narrow land strip separating the warm lagoon and the colder sea has a unique microclimate. It's one of the most exotic areas in Spain.
Corvera airport is about 1 hour drive away and Alicante airport about 2 hours away.
[post_title] => N8368
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8368
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:25
[post_modified_gmt] => 2025-06-24 00:25:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8368/
[menu_order] => 0
[post_type] => newbuilds
[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] => 10567902
[post_author] => 0
[post_date] => 2025-06-24 01:40:02
[post_date_gmt] => 2025-06-24 00:40:02
[post_content] => Beautiful 2 bedroom, 2 bathroom penthouse apartment (lifts available) with private roof solarium directly overlooking the pool for sale in El Rincon. The apartment has received an updated interior, and comprises of a bright lounge-dining area with patio doors leading onto the sunny balcony with pool and garden views, open plan kitchen with breakfast bar, 2 bedrooms with fitted wardrobes and 2 bathrooms with underfloor heating plus storage/utility room. The master bedroom offers its own en-suite bathroom with walk-in shower, plus access to the front balcony. A unique feature of this particular apartment is that the 2nd bathroom is not en-suite, so can be used as a guest bathroom for visitors without having to go into the twin bedroom. External stairs leads to a large private roof terrace with sea and pool views, and offers plenty of space to sunbathe and entertain on. Also included is ducted air-conditioning in all rooms, secure off-road parking space and the use of 2 communal pools and well maintained garden areas. The entire exterior of the complex has been recently repainted. The current owners have done additional upgrades to the apartment including new flooring throughout, new walk-in shower, lighting, furniture, and appliances (Haier) which are just 4 months old.
Located just a few hundred metres from 3 supermarkets, the Playa Flamenca and Citrus commercial centres, which hosts a vast array of bars, shops and restaurants. The Playa Flamenca beach is only a few minutes drive away including the Zenia Boulevard shopping mall. Due its location and proximity to a wide range of amenities, apartments in El Rincon are a good rental opportunity or make the perfect holiday home with well kept communal areas and the use of 2 beautiful pools.
[post_title] => VC3597
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3597
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:40:02
[post_modified_gmt] => 2025-06-24 00:40:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3597/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4463
[max_num_pages] => 372
[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] => 5356fd9c26487fc649a480ef5db7979c
[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:1a1e5613fa86fb2ecb2ee436f2574488:0.77228200 1753174189
)
1
2
2
