WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 24
[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] => newbuilds
[2] => mn_property
)
[paged] => 24
[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] =>
[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 276, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10430211
[post_author] => 0
[post_date] => 2025-05-15 01:40:02
[post_date_gmt] => 2025-05-15 00:40:02
[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-05-15 01:40:02
[post_modified_gmt] => 2025-05-15 00:40:02
[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
)
[1] => WP_Post Object
(
[ID] => 10431343
[post_author] => 0
[post_date] => 2025-05-15 01:45:29
[post_date_gmt] => 2025-05-15 00:45:29
[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-05-15 01:45:29
[post_modified_gmt] => 2025-05-15 00:45:29
[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] => 10431792
[post_author] => 0
[post_date] => 2025-05-15 01:45:40
[post_date_gmt] => 2025-05-15 00:45:40
[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-05-15 01:45:40
[post_modified_gmt] => 2025-05-15 00:45:40
[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
)
[3] => WP_Post Object
(
[ID] => 10431090
[post_author] => 0
[post_date] => 2025-05-15 01:45:23
[post_date_gmt] => 2025-05-15 00:45:23
[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-05-15 01:45:23
[post_modified_gmt] => 2025-05-15 00:45:23
[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
)
[4] => WP_Post Object
(
[ID] => 10429320
[post_author] => 0
[post_date] => 2025-05-15 01:25:05
[post_date_gmt] => 2025-05-15 00:25:05
[post_content] => Regenerated Residential Complex in Lomas de Cabo Roig – Renovated Apartments
Apartments in a Prime Location
Discover this exclusive opportunity to own a renovated apartment in Lomas de Cabo Roig, a sought-after area in Orihuela Costa. This residential complex, originally built in 2008, is undergoing a renovation of some units and will be delivered in June 2025. A show home is available for viewing, allowing you to see the quality finishes firsthand.
Property Options to Suit Every Need
This development offers 27 refurbished apartments, with a variety of layouts:
1 and 2-bedroom units, ideal for holiday homes or investment.
Ground-floor apartments with private gardens, perfect for outdoor living.
Middle-floor apartments with spacious terraces, ideal for enjoying the Mediterranean climate.
Penthouses with private solariums, offering open views and maximum privacy.
Each home is delivered with shower screens in the bathrooms and fully equipped kitchens with appliances, ensuring a turnkey solution for buyers.
Exclusive Community Amenities
The residential complex is designed for comfort and relaxation, featuring:
A communal swimming pool surrounded by beautiful landscaped gardens.
An elevator for easy access to all floors.
Optional underground parking spaces available at an additional cost.
An Unbeatable Location in Orihuela Costa
Lomas de Cabo Roig is a prestigious residential area located just 2 km from the coastline of Cabo Roig, home to some of the most beautiful beaches in Orihuela Costa. The area is well-connected by road and offers a wide range of services, including shops, restaurants, supermarkets, and shopping centers.
Distances to key points of interest:
Beaches of Cabo Roig and Campoamor – 5-minute drive.
Zenia Boulevard Shopping Center – 5 km.
Villamartín Golf Course – 4 km.
Alicante Airport – 30 minutes by car.
Murcia-Corvera Airport – 1 hour by car.
A Smart Investment in the Costa Blanca
With its excellent location, fully renovated apartments, and top-tier amenities, this development is an ideal opportunity for investment, holiday living, or permanent residence. Don’t miss out on this unique chance to own a home in one of the most desirable areas of the Costa Blanca at an unbeatable price.
Contact us today for more information or to schedule a visit!
[post_title] => N8679
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8679
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-15 01:25:05
[post_modified_gmt] => 2025-05-15 00:25:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8679/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10429548
[post_author] => 0
[post_date] => 2025-05-15 01:25:10
[post_date_gmt] => 2025-05-15 00:25:10
[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] => N8789
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8789
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-15 01:25:10
[post_modified_gmt] => 2025-05-15 00:25:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8789/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10431570
[post_author] => 0
[post_date] => 2025-05-15 01:45:34
[post_date_gmt] => 2025-05-15 00:45:34
[post_content] =>
[post_title] => B10642
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10642
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-15 01:45:34
[post_modified_gmt] => 2025-05-15 00:45:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10642/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10431882
[post_author] => 0
[post_date] => 2025-05-15 01:45:42
[post_date_gmt] => 2025-05-15 00:45:42
[post_content] =>
[post_title] => F1049 - Great Opportunity in Cala de Finestrat! 🌊✨
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f1049-great-opportunity-in-cala-de-finestrat-%f0%9f%8c%8a%e2%9c%a8
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-15 01:45:42
[post_modified_gmt] => 2025-05-15 00:45:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f1049-great-opportunity-in-cala-de-finestrat-%f0%9f%8c%8a%e2%9c%a8/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10431616
[post_author] => 0
[post_date] => 2025-05-15 01:45:35
[post_date_gmt] => 2025-05-15 00:45:35
[post_content] =>
[post_title] => B10681
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10681
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-15 01:45:35
[post_modified_gmt] => 2025-05-15 00:45:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10681/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10431174
[post_author] => 0
[post_date] => 2025-05-15 01:45:25
[post_date_gmt] => 2025-05-15 00:45:25
[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-05-15 01:45:25
[post_modified_gmt] => 2025-05-15 00:45:25
[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
)
[10] => WP_Post Object
(
[ID] => 10429549
[post_author] => 0
[post_date] => 2025-05-15 01:25:10
[post_date_gmt] => 2025-05-15 00:25:10
[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-05-15 01:25:10
[post_modified_gmt] => 2025-05-15 00:25:10
[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
)
[11] => WP_Post Object
(
[ID] => 10431030
[post_author] => 0
[post_date] => 2025-05-15 01:45:21
[post_date_gmt] => 2025-05-15 00:45:21
[post_content] =>
[post_title] => 72261
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72261
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-15 01:45:21
[post_modified_gmt] => 2025-05-15 00:45:21
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72261/
[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] => 10430211
[post_author] => 0
[post_date] => 2025-05-15 01:40:02
[post_date_gmt] => 2025-05-15 00:40:02
[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-05-15 01:40:02
[post_modified_gmt] => 2025-05-15 00:40:02
[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
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3587
[max_num_pages] => 299
[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] => 3ea92e322a27db5484bca7b34f1e5734
[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
)
)
1
1
1
