WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 97
[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] => 97
[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 1152, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10568644
[post_author] => 0
[post_date] => 2025-06-24 01:45:21
[post_date_gmt] => 2025-06-24 00:45:21
[post_content] =>
[post_title] => B10027 - Residential apartments in Habaneras,
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10027-residential-apartments-in-habaneras
[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/b10027-residential-apartments-in-habaneras/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10567216
[post_author] => 0
[post_date] => 2025-06-24 01:25:10
[post_date_gmt] => 2025-06-24 00:25:10
[post_content] => NEW BUILD RESIDENTIAL IN BENIJOFAR
New Build residential with communal rooftop pool located in the centre of the charming village of Benijofar.
You can choose modern apartments with terraces or penthouses with solarium.
New Build modern properties with an open plan kitchen and living room, 2 and 3 bedrooms, 2 bathrooms, terraces.
An options underground parking space at an extra cost.
Benijofar it is a lovely village with a charming church and an attractive square/plaza located inland on the Southern Costa Blanca, close to the tourist resorts of Guardamar del Segura and Torrevieja.
Benijofar is also a popular place to stay for the summer holidays as it is close enough to the coastal resorts yet quiet enough to be able to get away from it all.
There are several golf courses close by as well as water parks in nearby Rojales and Torrevieja.
The nearest and best beaches to Benijofar are about fifteen minutes away by car and are some of the best beaches on the Southern Costa Blanca, at Guardamar del Segura and Torrevieja. There are also regular bus services from Benijofar to Guardamar del Segura and Torrevieja with easy access to the beaches.
20 minutes drive to Alicante airport with regular flights all over Europe.
[post_title] => N7980
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n7980
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:10
[post_modified_gmt] => 2025-06-24 00:25:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n7980/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10568466
[post_author] => 0
[post_date] => 2025-06-24 01:45:16
[post_date_gmt] => 2025-06-24 00:45:16
[post_content] =>
[post_title] => N7829
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n7829
[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/n7829/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10568780
[post_author] => 0
[post_date] => 2025-06-24 01:45:24
[post_date_gmt] => 2025-06-24 00:45:24
[post_content] =>
[post_title] => B10188 - 2 Bedroom Penthhouse in Las Ramblas, Orihuela Costa
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10188-2-bedroom-penthhouse-in-las-ramblas-orihuela-costa
[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/b10188-2-bedroom-penthhouse-in-las-ramblas-orihuela-costa/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10567000
[post_author] => 0
[post_date] => 2025-06-24 01:25:05
[post_date_gmt] => 2025-06-24 00:25:05
[post_content] => NEW BUILD RESIDENTIAL IN EL RASO, GUARDAMAR DEL SEGURA
New Build private residential complex consisting of 2 bedroom premium apartments and 2 or 3 bedrooms premium penthouses with private community area and luxury amenities.
Modern design apartments in a protected park area with citrus gardens and salt lakes, this beautiful modern development offers the ultimate quality of life that comes with being close to nature and high-tech living.
Modern urbanization, built with comfort in mind. Our elegant design, unmatched building quality, and attention to detail bring your Spanish dreams to life.
Latest tech to keep your home ready from your phone. Smart alarm, cameras, intercom, appliances, air conditioning and etc.
Enjoy endless summer fun with a big salt-water pool in your own community! No need to travel, our sparkling pool offers space for swimming, sunbathing, and relaxation. Dive into paradise , right under your home.
Get ready for a hole-in-one good time! Imagine having a mini golf course right under your home! Endless entertainment for all ages. Whether you’re perfecting your swing or just looking for a fun activity to do with friends and family, our mini golf course has got you covered.
Having a co-working space and coffee corner right under your home offers a great deal of versatility. It allows you to have a dedicated area for work and productivity, separate from the distractions and relaxation of your living space. This can be especially beneficial for those who work from home.
Indulge in the luxury of a spa experience within your community. Relax and rejuvenate in comfort! Enjoy luxurious spa services such as massages, facials, and body treatments without the need to travel. Gather with friends or meet new people in our exclusive community spa.
El Raso is a part of Guardamar del Segura.
Guardamar del Segura is a town located on the Costa Blanca South. With its 11 kilometres of natural beach and its large pine forest.
Guardamar del Segura has a large port with activities throughout the year, it has a large sports centre with paddle tennis, tennis, soccer and a large heated swimming pool that works all year round. It also has a library where there is free wifi and computers.
Guardamar del Segura is only 20km away from the Alicante - Elche (El Altet) airport, where there are many flights every day with connections to the main European cities, due to the demand for tourists on the Costa Blanca.
[post_title] => N7891
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n7891
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:05
[post_modified_gmt] => 2025-06-24 00:25:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n7891/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10568593
[post_author] => 0
[post_date] => 2025-06-24 01:45:19
[post_date_gmt] => 2025-06-24 00:45:19
[post_content] =>
[post_title] => A4792 - Complex of apartments in Pilar de la Horadada
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4792-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/a4792-complex-of-apartments-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] => 10567031
[post_author] => 0
[post_date] => 2025-06-24 01:25:06
[post_date_gmt] => 2025-06-24 00:25:06
[post_content] => New Build Apartments, Bungalows and Villas in Condado de Alhama Golf Resort, Murcia
Modern Homes Next to Golf and Nature
Welcome to a new residential complex of bungalows, apartments, penthouses, and detached villas, located in the prestigious Condado de Alhama Golf Resort, in the region of Murcia. This private resort offers 24-hour security, beautifully landscaped gardens, and direct access to the Jack Nicklaus-designed golf course—making it an ideal destination for golf lovers and families seeking a tranquil Mediterranean lifestyle.
Located just a short walk from the Al Kassar Shopping Center, residents enjoy proximity to shops, restaurants, bars, and essential services within the resort.
Contemporary Design and High-Quality Construction
The development offers bungalows with 2 or 3 bedrooms and 2 bathrooms, available in two types:
Ground floor bungalows with a front garden and rear patio. Some units also include private parking within the garden.
Top floor bungalows with a private porch and a spacious rooftop solarium offering spectacular views of the golf course and surrounding mountains.
All homes are built with high standards of quality and include:
Fitted kitchen with integrated fridge, oven, microwave, extractor hood, and dishwasher
Ducted air conditioning pre-installation in the living room and bedrooms
Modern bathrooms with shower screens, vanity units, mirrors, and ceiling spotlights
Built-in wardrobes with drawers and shelving
Aerothermal water heating system
Electric aluminum shutters in bedrooms
Reinforced security entrance door
Outdoor summer kitchen in top-floor bungalows
Interior and exterior lighting (except decorative lamps)
TV and telephone points in all rooms
Resort Lifestyle with Natural Surroundings
Condado de Alhama is a secure, well-established resort surrounded by nature and mountains, ideal for outdoor living. Residents have access to a comunal swimming pool with solarium area, Mediterranean and tropical gardens, and plenty of walking and cycling routes within the complex.
Excellent Access to Key Locations
Murcia International Airport (Corvera): 40 km
Beaches of Mazarrón: 25 km
Murcia city center: 35 km
Alhama de Murcia town: 15 km
Secure Your New Home in Costa Cálida
Whether you’re looking for a holiday escape, year-round residence, or investment opportunity, this development offers the ideal combination of modern design, comfort, and location.
Contact us today to schedule your visit and find your perfect property in Condado de Alhama Golf Resort.
[post_title] => N8981
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8981
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:06
[post_modified_gmt] => 2025-06-24 00:25:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8981/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10567712
[post_author] => 0
[post_date] => 2025-06-24 01:25:24
[post_date_gmt] => 2025-06-24 00:25:24
[post_content] => New Build Bungalow Residential Complex in Pilar de la Horadada
Exclusive Modern Bungalows in Pilar de la Horadada
This new development offers 16 stylish bungalows in the desirable town of Pilar de la Horadada, located in the southernmost part of Costa Blanca. Choose between 2 or 3-bedroom options, each featuring 2 bathrooms. Ground-floor units come with spacious front and rear terraces, providing direct access to the communal pool and garden, while top-floor units boast a large private rooftop solarium.
Spacious Living with Modern Features
Each bungalow includes a bright and open living/dining area and a fully equipped kitchen with large sliding doors that connect the indoor and outdoor spaces seamlessly. Bedrooms feature built-in wardrobes. Ducted air conditioning is installed, and the complex includes an elevator for easy access to upper floors. Private parking spaces are also included for all units.
Prime Location in Pilar de la Horadada
Pilar de la Horadada is a traditional Spanish town with a lively main street offering supermarkets, shops, restaurants, and bars. The beautiful beaches of Torre de la Horadada and Mil Palmeras are just 5 minutes away. The development is conveniently located 40 km from Corvera Airport (Murcia) and 55 km from Alicante Airport, making it an ideal location for both permanent living and holiday getaways.
[post_title] => N8404
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8404
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:24
[post_modified_gmt] => 2025-06-24 00:25:24
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8404/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10567755
[post_author] => 0
[post_date] => 2025-06-24 01:25:25
[post_date_gmt] => 2025-06-24 00:25:25
[post_content] => NEW BUILD BUNGALOWS IN PILAR DE LA HORADADA
New Build developmen located in an unbeatable location, in the centre of Pilar de la Horadada. An area that offers all the necessary services and amenities, such as supermarkets. Additionally, its proximity to the beach makes it an ideal option for your leisure time and Summer getaways.
This residential complex is characterised by its 12 bungalow apartments, which offers 1 bedroom and 1 bathroom properties at a very affordable price, 2 bedroom and 2 bathroom properties and also 3 bedroom and 2 bathroom properties, to cover the needs of each client, offering comfort and style.
The interiors, elegant and functional, have fully equipped kitchens including electrical appliances. The bathrooms have a vanity unit with washbasin and light. Each property has pre-installation for ducted air conditioning, a magnificent solarium for the upper floors and an attractive communal swimming pool area, making it the perfect place to enjoy and relax.
Excellent location, 5 minutes from the sandy beaches and most prestigious 18-hole Lo Romero golf course.
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.
The airports of Corvera (Murcia) and Alicante are respectively 40 and 55 minutes away.
[post_title] => N8367
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8367
[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/n8367/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10568837
[post_author] => 0
[post_date] => 2025-06-24 01:45:25
[post_date_gmt] => 2025-06-24 00:45:25
[post_content] =>
[post_title] => A4877 - Complex of 6 bungalows in Pilar de la Horadada
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4877-complex-of-6-bungalows-in-pilar-de-la-horadada
[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/a4877-complex-of-6-bungalows-in-pilar-de-la-horadada/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10568678
[post_author] => 0
[post_date] => 2025-06-24 01:45:21
[post_date_gmt] => 2025-06-24 00:45:21
[post_content] =>
[post_title] => B10071
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10071
[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/b10071/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10568605
[post_author] => 0
[post_date] => 2025-06-24 01:45:20
[post_date_gmt] => 2025-06-24 00:45:20
[post_content] =>
[post_title] => A4797 - Apartment complex Los Alcazares Santa Rosalia (Murcia)
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4797-apartment-complex-los-alcazares-santa-rosalia-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/a4797-apartment-complex-los-alcazares-santa-rosalia-murcia/
[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] => 10568644
[post_author] => 0
[post_date] => 2025-06-24 01:45:21
[post_date_gmt] => 2025-06-24 00:45:21
[post_content] =>
[post_title] => B10027 - Residential apartments in Habaneras,
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10027-residential-apartments-in-habaneras
[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/b10027-residential-apartments-in-habaneras/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4281
[max_num_pages] => 357
[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] => 8b71376b756cbb8ad6153f484f1d47fb
[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:3b94e0d0b52f5cb123bbe31a87a95441:0.91677600 1752863443
)