WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 244
[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] => 244
[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 2916, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10578880
[post_author] => 0
[post_date] => 2025-11-06 22:30:04
[post_date_gmt] => 2025-11-06 22:30:04
[post_content] => We are pleased to present this beautiful 2 bedroom townhouse for sale in Villamartin.
Recently renovated and furnished to high quality, ready for sale. This property is just waiting for someone looking for a home ready just to move in.
In a sought after area, with a range amenties close by, this property won't be around for long. So hurry up and get viewing and don't miss out.
[post_title] => VA5344
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5344-43
[to_ping] =>
[pinged] =>
[post_modified] => 2025-11-06 22:30:04
[post_modified_gmt] => 2025-11-06 22:30:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5344-43/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10566878
[post_author] => 0
[post_date] => 2025-06-24 01:05:03
[post_date_gmt] => 2025-06-24 00:05:03
[post_content] => Beautiful renovated 2 bedroom townhouse in the Filipinas area of Villamartin.
We present this immaculate townhouse, facing southwest, that has just been totally renovated and is to be sold as seen, with everything that is in the property.
There is garden/terrace areas at the front and the rear of the property, as well as a lovely roof terrace, all perfect for taking in the sun and outdoor dining.
Inside, there is an open plan living/dining room and kitchen area, as well as a toilet. Upstairs there are 2 double bedrooms and a shower room. Internal stairs lead up to the roof terrace.
The property is perfect for anyone wanting to move in and not do any work. It comes with extras such as air conditioning and having access to a communal pool.
[post_title] => VA5290
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5290
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:03
[post_modified_gmt] => 2025-06-24 00:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5290/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10578411
[post_author] => 0
[post_date] => 2025-10-31 10:30:02
[post_date_gmt] => 2025-10-31 10:30:02
[post_content] => We are pleased to present this beautiful 2 bedroom townhouse for sale in Villamartin.Recently renovated and furnished to high quality, ready for sale. This property is just waiting for someone looking for a home ready just to move in. In a sought after area, with a range amenties close by, this property won't be around for long. So hurry up and get viewing and don't miss out.
[post_title] => VA5344
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5344-30
[to_ping] =>
[pinged] =>
[post_modified] => 2025-10-31 10:30:02
[post_modified_gmt] => 2025-10-31 10:30:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5344-30/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10578731
[post_author] => 0
[post_date] => 2025-11-04 22:30:03
[post_date_gmt] => 2025-11-04 22:30:03
[post_content] => We are pleased to present this beautiful 2 bedroom townhouse for sale in Villamartin.
Recently renovated and furnished to high quality, ready for sale. This property is just waiting for someone looking for a home ready just to move in.
In a sought after area, with a range amenties close by, this property won't be around for long. So hurry up and get viewing and don't miss out.
[post_title] => VA5344
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5344-39
[to_ping] =>
[pinged] =>
[post_modified] => 2025-11-04 22:30:03
[post_modified_gmt] => 2025-11-04 22:30:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5344-39/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10579830
[post_author] => 0
[post_date] => 2025-11-18 22:30:18
[post_date_gmt] => 2025-11-18 22:30:18
[post_content] => We are pleased to present this beautiful 2 bedroom townhouse for sale in Villamartin.
Recently renovated and furnished to high quality, ready for sale. This property is just waiting for someone looking for a home ready just to move in.
In a sought after area, with a range amenties close by, this property won't be around for long. So hurry up and get viewing and don't miss out.
[post_title] => VA5344
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5344-67
[to_ping] =>
[pinged] =>
[post_modified] => 2025-11-18 22:30:18
[post_modified_gmt] => 2025-11-18 22:30:18
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5344-67/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10577942
[post_author] => 0
[post_date] => 2025-10-25 11:30:40
[post_date_gmt] => 2025-10-25 10:30:40
[post_content] => We are pleased to present this beautiful 2 bedroom townhouse for sale in Villamartin.Recently renovated and furnished to high quality, ready for sale. This property is just waiting for someone looking for a home ready just to move in. In a sought after area, with a range amenties close by, this property won't be around for long. So hurry up and get viewing and don't miss out.
[post_title] => VA5344
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5344-18
[to_ping] =>
[pinged] =>
[post_modified] => 2025-10-25 11:30:40
[post_modified_gmt] => 2025-10-25 10:30:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5344-18/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10578262
[post_author] => 0
[post_date] => 2025-10-29 10:30:06
[post_date_gmt] => 2025-10-29 10:30:06
[post_content] => We are pleased to present this beautiful 2 bedroom townhouse for sale in Villamartin.Recently renovated and furnished to high quality, ready for sale. This property is just waiting for someone looking for a home ready just to move in. In a sought after area, with a range amenties close by, this property won't be around for long. So hurry up and get viewing and don't miss out.
[post_title] => VA5344
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5344-26
[to_ping] =>
[pinged] =>
[post_modified] => 2025-10-29 10:30:06
[post_modified_gmt] => 2025-10-29 10:30:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5344-26/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10578518
[post_author] => 0
[post_date] => 2025-11-01 22:30:06
[post_date_gmt] => 2025-11-01 22:30:06
[post_content] => We are pleased to present this beautiful 2 bedroom townhouse for sale in Villamartin.Recently renovated and furnished to high quality, ready for sale. This property is just waiting for someone looking for a home ready just to move in. In a sought after area, with a range amenties close by, this property won't be around for long. So hurry up and get viewing and don't miss out.
[post_title] => VA5344
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5344-33
[to_ping] =>
[pinged] =>
[post_modified] => 2025-11-01 22:30:06
[post_modified_gmt] => 2025-11-01 22:30:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5344-33/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10570154
[post_author] => 0
[post_date] => 2025-07-01 11:30:10
[post_date_gmt] => 2025-07-01 10:30:10
[post_content] => Beautiful renovated 2 bedroom townhouse in the Filipinas area of Villamartin.
We present this immaculate townhouse, facing southwest, that has just been totally renovated and is to be sold as seen, with everything that is in the property.
There is garden/terrace areas at the front and the rear of the property, as well as a lovely roof terrace, all perfect for taking in the sun and outdoor dining.
Inside, there is an open plan living/dining room and kitchen area, as well as a toilet. Upstairs there are 2 double bedrooms and a shower room. Internal stairs lead up to the roof terrace.
The property is perfect for anyone wanting to move in and not do any work. It comes with extras such as air conditioning and having access to a communal pool.
[post_title] => VA5290
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5290-5
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-01 11:30:10
[post_modified_gmt] => 2025-07-01 10:30:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5290-5/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10579553
[post_author] => 0
[post_date] => 2025-11-15 10:30:04
[post_date_gmt] => 2025-11-15 10:30:04
[post_content] => We are pleased to present this beautiful 2 bedroom townhouse for sale in Villamartin.
Recently renovated and furnished to high quality, ready for sale. This property is just waiting for someone looking for a home ready just to move in.
In a sought after area, with a range amenties close by, this property won't be around for long. So hurry up and get viewing and don't miss out.
[post_title] => VA5344
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5344-60
[to_ping] =>
[pinged] =>
[post_modified] => 2025-11-15 10:30:04
[post_modified_gmt] => 2025-11-15 10:30:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5344-60/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10567188
[post_author] => 0
[post_date] => 2025-06-24 01:25:10
[post_date_gmt] => 2025-06-24 00:25:10
[post_content] => New Build Apartments in Pilar de la Horadada with private Jacuzzi
Prime Location in the Heart of Pilar de la Horadada
Located in the vibrant center of Pilar de la Horadada, Alicante, this exclusive new development offers an unbeatable combination of modern living and Mediterranean charm. Pilar de la Horadada is a picturesque Spanish town in the southernmost part of Costa Blanca, known for its welcoming community, charming plazas, and proximity to stunning beaches.
Apartment Options and Features
The residential complex consists of seven meticulously designed apartments, offering a range of layouts to suit diverse needs:
Ground Floor: A spacious 3-bedroom apartment including a private rooftop solarium.
First Floor: Four apartments featuring 1 or 2 bedrooms, each with individual solariums.
Penthouses: Two exclusive 3-bedroom apartments with expansive private terraces.
All apartments boast high-end finishes, including:
Fully equipped kitchens with modern appliances.
Pre-installed ducted air conditioning for your convenience.
Aluminum exterior carpentry with thermal break for enhanced insulation.
Double glazing (4+14+4 Climalit or similar) for energy efficiency.
Stylish bathrooms with suspended WC (Roca Gap or similar), rain-effect showers, and included mirrors and enclosures.
Private jacuzzis for each house, perfect for relaxation.
Additional Amenities for Elevated Living
The development offers:
A parking space for each apartment located on the ground floor.
An elevator providing access from the ground floor to the solarium level.
A summer kitchen in each solarium, ideal for outdoor entertaining.
Convenient Access to Key Points of Interest
This location provides easy access to essential amenities and attractions:
Beaches: The sandy shores of Torre de la Horadada and Mil Palmeras are just 3 km away, a 5-minute drive or a scenic bike ride.
Golf Courses: The nearest golf course is 8 km away, perfect for golf enthusiasts.
Shopping Centers: Zenia Boulevard, one of the largest shopping malls in the area, is 12 km away.
Airports: Corvera (Murcia) Airport is 40 minutes (40 km), and Alicante Airport is 55 minutes (55 km) by car.
Discover the Mediterranean Lifestyle
Pilar de la Horadada combines the tranquility of a coastal town with the convenience of modern living, offering supermarkets, restaurants, bars, and vibrant plazas within walking distance.
Schedule Your Visit Today
Don’t miss the opportunity to own your dream home in this sought-after area of Costa Blanca. Contact us now to arrange a viewing or for more information!
[post_title] => N8596
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8596
[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/n8596/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10577900
[post_author] => 0
[post_date] => 2025-10-24 23:30:05
[post_date_gmt] => 2025-10-24 22:30:05
[post_content] => We are pleased to present this beautiful 2 bedroom townhouse for sale in Villamartin.Recently renovated and furnished to high quality, ready for sale. This property is just waiting for someone looking for a home ready just to move in. In a sought after area, with a range amenties close by, this property won't be around for long. So hurry up and get viewing and don't miss out.
[post_title] => VA5344
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5344-17
[to_ping] =>
[pinged] =>
[post_modified] => 2025-10-24 23:30:05
[post_modified_gmt] => 2025-10-24 22:30:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5344-17/
[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] => 10578880
[post_author] => 0
[post_date] => 2025-11-06 22:30:04
[post_date_gmt] => 2025-11-06 22:30:04
[post_content] => We are pleased to present this beautiful 2 bedroom townhouse for sale in Villamartin.
Recently renovated and furnished to high quality, ready for sale. This property is just waiting for someone looking for a home ready just to move in.
In a sought after area, with a range amenties close by, this property won't be around for long. So hurry up and get viewing and don't miss out.
[post_title] => VA5344
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5344-43
[to_ping] =>
[pinged] =>
[post_modified] => 2025-11-06 22:30:04
[post_modified_gmt] => 2025-11-06 22:30:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5344-43/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 14687
[max_num_pages] => 1224
[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] => 4e4f70b6290378d22dfc171120042c79
[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:60d3e77678c248df4273967291f573b4:0.87747800 1765739895
)
1
1
2
