WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 157
[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] => 157
[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 1872, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10568549
[post_author] => 0
[post_date] => 2025-06-24 01:45:18
[post_date_gmt] => 2025-06-24 00:45:18
[post_content] =>
[post_title] => B9548 - The luxury flat on the seafront in La Mata
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b9548-the-luxury-flat-on-the-seafront-in-la-mata
[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/b9548-the-luxury-flat-on-the-seafront-in-la-mata/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10568829
[post_author] => 0
[post_date] => 2025-06-24 01:45:25
[post_date_gmt] => 2025-06-24 00:45:25
[post_content] =>
[post_title] => A4873 - Complex of 16 apartments and 10 bungalows in Torre de la Horadada 50 meters from the beach
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4873-complex-of-16-apartments-and-10-bungalows-in-torre-de-la-horadada-50-meters-from-the-beach
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:25
[post_modified_gmt] => 2025-06-24 00:45:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a4873-complex-of-16-apartments-and-10-bungalows-in-torre-de-la-horadada-50-meters-from-the-beach/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10567156
[post_author] => 0
[post_date] => 2025-06-24 01:25:09
[post_date_gmt] => 2025-06-24 00:25:09
[post_content] => Modern New Build Villas for Sale in San Pedro del Pinatar – Close to Beach and Town Centre
Exclusive Residential Project in Costa Cálida
This new boutique development consists of just four contemporary independent villas, ideally located in a quiet residential area near the centre of San Pedro del Pinatar, Murcia. Just 1.4 km from the beaches of Lo Pagán, these homes offer the perfect combination of comfort, privacy, and proximity to essential services and coastal attractions.
San Pedro del Pinatar is one of the most sought-after destinations on the Costa Cálida, known for its natural salt lagoons, therapeutic mud baths, and a wide variety of leisure, dining, and wellness options. With both the Mediterranean Sea and Mar Menor within easy reach, this location is ideal for enjoying year-round sunshine and a relaxed lifestyle.
Contemporary Design and Smart Layout
Each villa features:
3 bedrooms and 3 bathrooms, including two en-suite bathrooms
Open-plan kitchen and living area, with direct access to a spacious terrace
Ground floor bedroom and bathroom, ideal for guests or multi-generational living
Private swimming pool with LED lighting and outdoor solar shower
Large rooftop solarium for sunbathing, entertaining or relaxing
Plot with private parking space
The homes have been designed with modern living in mind, offering high-quality finishes and smart installations:
Security entrance door
Motorised aluminium shutters
Pre-installation of ducted air conditioning
Underfloor heating in bathrooms
Fitted bathrooms with illuminated mirrors and furniture
A show villa is available for viewing, allowing you to experience the high standards and layout in person.
Prime Location with Excellent Connectivity
These villas are perfectly located to enjoy both tranquillity and convenience. All daily services including shops, restaurants, supermarkets, and health centres are within walking distance. In addition, the area is well connected by road and public transport.
Distances to main points of interest:
Lo Pagán Beach: 1.4 km
Mar Menor beaches: 2 km
Dos Mares Shopping Centre: 3.5 km
Lo Romero Golf Course: 10 km
Roda Golf Resort: 9 km
Murcia International Airport: 35 km (25 minutes by car)
Alicante Airport: 75 km (45 minutes by car)
Reserve Your New Villa in San Pedro Today
This is a rare opportunity to own a newly built villa in one of the most desirable coastal areas of Murcia. With limited units available, contact us now to receive more information, schedule a visit, or secure your dream home by the sea.
[post_title] => N8925
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8925
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:09
[post_modified_gmt] => 2025-06-24 00:25:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8925/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10567786
[post_author] => 0
[post_date] => 2025-06-24 01:25:26
[post_date_gmt] => 2025-06-24 00:25:26
[post_content] => NEW BUILD VILLAS IN PILAR DE LA HORADADA
New Build villas in Pilar de la Horadada.
The interior of the villas consist of 3 bedrooms, 3 bathrooms en suite, large open plan living room with kitchen all located on two floors.
The exteriors have a large landscaped garden with private swimming pool and parking space.
New Build Villas where you will find the best Mediterranean style adapted to modern design.
Residential consists of 17 villas located in Pilar de la Horadada, surrounded by all the services you need and just a few minutes from the beach.
Pilar de la Horadada is a typical Spanish village in the most southern part of the Costa Blanca.
The large main street has supermarkets, lots of shops, restaurants and bars and some lovely squares.
The beautiful beaches of Torre de la Horadada and Mil Palmeras with fine sand promenade is just 5 minutes away.
In Pilar de la Horadada there is also a well-developed cycling and walking path network, and there is also a large offer of various sports activities.
Lo Romero 18 hole golf course is just a short drive from town.
The airports of Corvera (Murcia) and Alicante are respectively 40 and 55 minutes away.
[post_title] => N7207
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n7207
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:26
[post_modified_gmt] => 2025-06-24 00:25:26
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n7207/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10568789
[post_author] => 0
[post_date] => 2025-06-24 01:45:24
[post_date_gmt] => 2025-06-24 00:45:24
[post_content] =>
[post_title] => B10199
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10199
[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/b10199/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10569120
[post_author] => 0
[post_date] => 2025-06-24 01:45:32
[post_date_gmt] => 2025-06-24 00:45:32
[post_content] =>
[post_title] => 72443 - Spacious recently renovated villa with 3,600 m2 of plot and private pool
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72443-spacious-recently-renovated-villa-with-3600-m2-of-plot-and-private-pool
[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/72443-spacious-recently-renovated-villa-with-3600-m2-of-plot-and-private-pool/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10567958
[post_author] => 0
[post_date] => 2025-06-24 01:45:04
[post_date_gmt] => 2025-06-24 00:45:04
[post_content] =>
[post_title] => 5691 - Stunning Villas in Los Montesinos
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5691-stunning-villas-in-los-montesinos
[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/5691-stunning-villas-in-los-montesinos/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10569526
[post_author] => 0
[post_date] => 2025-06-24 01:45:42
[post_date_gmt] => 2025-06-24 00:45:42
[post_content] =>
[post_title] => 72729
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72729
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:42
[post_modified_gmt] => 2025-06-24 00:45:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72729/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10569474
[post_author] => 0
[post_date] => 2025-06-24 01:45:41
[post_date_gmt] => 2025-06-24 00:45:41
[post_content] =>
[post_title] => F1067 - Spacious 2-Bedroom Apartment in the Eagle Tower Complex
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f1067-spacious-2-bedroom-apartment-in-the-eagle-tower-complex
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:41
[post_modified_gmt] => 2025-06-24 00:45:41
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f1067-spacious-2-bedroom-apartment-in-the-eagle-tower-complex/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10567140
[post_author] => 0
[post_date] => 2025-06-24 01:25:09
[post_date_gmt] => 2025-06-24 00:25:09
[post_content] => Newly built villas located in the municipality of Aspe.
Newly built villas with several models to choose from, with 2, 3 or 4 bedrooms, on one or two floors and built with slabs or with a structure: depending on the model and the plot chosen, the exact price will be calculated.
All the villas are built on rustic plots of over 10,000 m2, of which around 2,500 m2 will be fenced off.
The villas have an open-plan kitchen with living room, built-in wardrobes, private swimming pool, porch, storage room and outdoor parking space.
There are several plots to choose from. The price is based on a plot priced at £77,500 (if another plot is chosen, the difference will be paid or credited according to the price of the plot).
Self-build project, delivery in approximately 12 months from the granting of the licence.
If you are looking for a quiet environment, close to typical Spanish villages away from tourist crowds, surrounded by mountains, with a very large plot and about 30 minutes from the sea, this is your home.
Aspe is a typical Spanish village with all the amenities for everyday life, surrounded by mountains and with several natural areas nearby where you can go hiking or mountain biking.
Located 25 km from the beach, 9 km from Elche and about 20 km from Alicante airport.
[post_title] => N8936
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8936
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:09
[post_modified_gmt] => 2025-06-24 00:25:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8936/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10568453
[post_author] => 0
[post_date] => 2025-06-24 01:45:16
[post_date_gmt] => 2025-06-24 00:45:16
[post_content] =>
[post_title] => N7749 - NEW BUILD VILLA IN PILAR DE LA HORADADA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n7749-new-build-villa-in-pilar-de-la-horadada
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:16
[post_modified_gmt] => 2025-06-24 00:45:16
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/n7749-new-build-villa-in-pilar-de-la-horadada/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10569232
[post_author] => 0
[post_date] => 2025-06-24 01:45:35
[post_date_gmt] => 2025-06-24 00:45:35
[post_content] =>
[post_title] => MON081
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mon081
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:35
[post_modified_gmt] => 2025-06-24 00:45:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/mon081/
[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] => 10568549
[post_author] => 0
[post_date] => 2025-06-24 01:45:18
[post_date_gmt] => 2025-06-24 00:45:18
[post_content] =>
[post_title] => B9548 - The luxury flat on the seafront in La Mata
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b9548-the-luxury-flat-on-the-seafront-in-la-mata
[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/b9548-the-luxury-flat-on-the-seafront-in-la-mata/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4807
[max_num_pages] => 401
[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] => 463de19b977ae8f74c94d756a30e94ed
[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:3d2a0536eb20f6b8a94b8d13d7864019:0.46221400 1753710416
)
3
3
1
