WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 34
[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] => 34
[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 396, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10568721
[post_author] => 0
[post_date] => 2025-06-24 01:45:22
[post_date_gmt] => 2025-06-24 00:45:22
[post_content] =>
[post_title] => B10139
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10139
[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/b10139/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10568938
[post_author] => 0
[post_date] => 2025-06-24 01:45:28
[post_date_gmt] => 2025-06-24 00:45:28
[post_content] =>
[post_title] => B10402 - Lomas del Golf, Villamartin 114 m2 semi-detached
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10402-lomas-del-golf-villamartin-114-m2-semi-detached
[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/b10402-lomas-del-golf-villamartin-114-m2-semi-detached/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10567905
[post_author] => 0
[post_date] => 2025-06-24 01:40:03
[post_date_gmt] => 2025-06-24 00:40:03
[post_content] => This beautifully renovated 1-bedroom apartment is situated in the highly sought-after Villamartin Plaza, within a secure gated community with lift access. The property offers use of a stunning communal pool surrounded by landscaped gardens and is located in the Villagolf residential complex.
The apartment is ideally positioned, just a two-minute walk from the lively Villamartin Plaza, renowned for its array of bars, restaurants, and a supermarket, and only a three-minute walk to the internationally acclaimed Villamartin Golf Course.
Recently refurbished to a high standard, the property features quality upgrades throughout, including new flooring, modern interior doors, a stylish kitchen, updated electrics, and contemporary furniture. The bright, open-plan living and dining area flows seamlessly into the modern kitchen, while the spacious double bedroom includes fitted wardrobes. The bathroom is finished with a luxurious walk-in shower, and the enclosed terrace enhances the living space, offering. A utility room provides additional practicality, housing the hot water boiler and washing machine.
Fully furnished and equipped with air-conditioning, this turnkey property is perfect as a holiday home or a rental investment. Arrange a viewing today to experience this exceptional apartment for yourself.
[post_title] => VC3663
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3663
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:40:03
[post_modified_gmt] => 2025-06-24 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3663/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10568033
[post_author] => 0
[post_date] => 2025-06-24 01:45:06
[post_date_gmt] => 2025-06-24 00:45:06
[post_content] =>
[post_title] => 70560
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 70560
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:06
[post_modified_gmt] => 2025-06-24 00:45:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/70560/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10569306
[post_author] => 0
[post_date] => 2025-06-24 01:45:37
[post_date_gmt] => 2025-06-24 00:45:37
[post_content] =>
[post_title] => B15997
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b15997
[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/b15997/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10569527
[post_author] => 0
[post_date] => 2025-06-24 01:45:42
[post_date_gmt] => 2025-06-24 00:45:42
[post_content] =>
[post_title] => A10582
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10582
[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/a10582/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10569645
[post_author] => 0
[post_date] => 2025-06-24 01:45:45
[post_date_gmt] => 2025-06-24 00:45:45
[post_content] =>
[post_title] => A10618
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10618
[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/a10618/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10569539
[post_author] => 0
[post_date] => 2025-06-24 01:45:42
[post_date_gmt] => 2025-06-24 00:45:42
[post_content] =>
[post_title] => B11000 - Apartment in MIL PALMERAS 3 BEDROOMS
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b11000-apartment-in-mil-palmeras-3-bedrooms
[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/b11000-apartment-in-mil-palmeras-3-bedrooms/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10568796
[post_author] => 0
[post_date] => 2025-06-24 01:45:24
[post_date_gmt] => 2025-06-24 00:45:24
[post_content] =>
[post_title] => B10209
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10209
[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/b10209/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10567408
[post_author] => 0
[post_date] => 2025-06-24 01:25:16
[post_date_gmt] => 2025-06-24 00:25:16
[post_content] => New Build Apartments in Jacarilla, Alicante – Tranquility and Comfort
Modern Apartments with Private Parking and Storage
Discover this exclusive new-build residential complex in Jacarilla, offering 37 modern apartments designed for comfort and convenience. Choose between 2- and 3-bedroom layouts, with options that include:
7 ground-floor apartments featuring private interior patios.
30 first- and second-floor units with terraces with open views of the surrounding countryside.
Private parking space and storage room included with every apartment.
Each home is equipped with fully fitted bathrooms, a furnished kitchen, and pre-installation for air conditioning. The living rooms and bedrooms benefit from electric shutters, providing both convenience and security.
Prime Location in Jacarilla – A Peaceful Village with Excellent Connectivity
Located in the heart of Vega Baja, Alicante, Jacarilla is a charming traditional Spanish village known for its agricultural heritage, citrus groves, and scenic landscapes. Despite its tranquil setting, Jacarilla offers easy access to essential services, including supermarkets, restaurants, pharmacies, and more.
The town enjoys excellent road connections:
Orihuela City – 10 km.
Guardamar del Segura & Mediterranean Beaches – 15 km.
Torrevieja – 20 km.
Alicante-Elche Airport (ALC) – 50 km (40 minutes by car).
Golf Courses (Vistabella Golf, La Finca Golf & La Marquesa Golf) – Within 10-15 km.
Community Amenities – Relax and Enjoy
The residential complex is designed to offer relaxation and leisure, featuring:
Chill-out swimming pool at rooftop (8x3m, 80 cm deep).
Rooftop comunal solarium with stunning panoramic views.
An Ideal Investment or Holiday Home in the Heart of the Costa Blanca
Whether you are looking for a permanent residence, a holiday home, or a solid investment, these brand-new apartments in Jacarilla provide an excellent opportunity to enjoy the Mediterranean lifestyle in a peaceful yet well-connected location.
Contact us today to schedule a visit or receive more information about this fantastic development.
[post_title] => N8787
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8787
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:16
[post_modified_gmt] => 2025-06-24 00:25:16
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8787/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10569572
[post_author] => 0
[post_date] => 2025-06-24 01:45:43
[post_date_gmt] => 2025-06-24 00:45:43
[post_content] =>
[post_title] => F1078 - ? Discover Your Dream Residential Complex in the Jalón Valley! ?
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f1078-%f0%9f%8c%9f-discover-your-dream-residential-complex-in-the-jalon-valley-%f0%9f%8c%9f
[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/f1078-%f0%9f%8c%9f-discover-your-dream-residential-complex-in-the-jalon-valley-%f0%9f%8c%9f/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10569116
[post_author] => 0
[post_date] => 2025-06-24 01:45:32
[post_date_gmt] => 2025-06-24 00:45:32
[post_content] =>
[post_title] => B10626
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10626
[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/b10626/
[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] => 10568721
[post_author] => 0
[post_date] => 2025-06-24 01:45:22
[post_date_gmt] => 2025-06-24 00:45:22
[post_content] =>
[post_title] => B10139
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10139
[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/b10139/
[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] => 2b5f41272602cb88b94fc8aa05d452e7
[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:e40f7b83e97981ccf63a324a23944fda:0.91377900 1753173511
)