WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 315
[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] => 315
[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 3768, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10567992
[post_author] => 0
[post_date] => 2025-06-24 01:45:05
[post_date_gmt] => 2025-06-24 00:45:05
[post_content] =>
[post_title] => A5991 - COMMERCIAL PREMISES IN LA ZENIA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a5991-commercial-premises-in-la-zenia
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:05
[post_modified_gmt] => 2025-06-24 00:45:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a5991-commercial-premises-in-la-zenia/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10569582
[post_author] => 0
[post_date] => 2025-06-24 01:45:43
[post_date_gmt] => 2025-06-24 00:45:43
[post_content] =>
[post_title] => A10589
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10589
[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/a10589/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10568805
[post_author] => 0
[post_date] => 2025-06-24 01:45:24
[post_date_gmt] => 2025-06-24 00:45:24
[post_content] =>
[post_title] => F0792 - Spacious Commercial Property for Sale in the Heart of Alfaz del Pi
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0792-spacious-commercial-property-for-sale-in-the-heart-of-alfaz-del-pi
[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/f0792-spacious-commercial-property-for-sale-in-the-heart-of-alfaz-del-pi/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10569605
[post_author] => 0
[post_date] => 2025-06-24 01:45:44
[post_date_gmt] => 2025-06-24 00:45:44
[post_content] =>
[post_title] => B15134 - Experience the Mediterranean in Cabo Cervera: Duplex with Sea Views
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b15134-experience-the-mediterranean-in-cabo-cervera-duplex-with-sea-views
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:44
[post_modified_gmt] => 2025-06-24 00:45:44
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b15134-experience-the-mediterranean-in-cabo-cervera-duplex-with-sea-views/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10567368
[post_author] => 0
[post_date] => 2025-06-24 01:25:15
[post_date_gmt] => 2025-06-24 00:25:15
[post_content] => Modern New Build Apartments in Pilar de la Horadada – Comfort, Style, and Prime Location
Boutique Residential Project with Only 7 Homes
Discover an exclusive new build development in the heart of Pilar de la Horadada, offering just 7 stylish apartments with 2 or 3 bedrooms. Located only 3 km from the beach, this modern building is ideal for those seeking a tranquil coastal lifestyle with all essential services within walking distance.
Key Ready!!
The development features three floors with elevator access and secure entry control systems, ensuring safety and convenience. Whether you’re looking for a permanent residence, a vacation home, or a smart investment on the Costa Blanca, this limited-edition residential building provides an ideal opportunity.
Contemporary Design and High-Quality Finishes
Each apartment is thoughtfully designed with modern finishes, ensuring a blend of elegance and functionality. Features include:
Furnished kitchens with modern appliances included
Built-in wardrobes in all bedrooms with interior lining
Pre-installed ducted air conditioning
Fully equipped bathrooms with vanity units, mirrors, and shower screens
Motorized shutters in the living room for added comfort and light control
These homes are designed to offer maximum comfort all year round, with layouts that make the most of natural light and open living spaces.
Life in Pilar de la Horadada – Year-Round Coastal Living
Pilar de la Horadada, located in the southernmost part of Alicante, offers a perfect combination of relaxed coastal charm and modern amenities. With beautiful sandy beaches, scenic cycling routes, and excellent sports facilities, the area attracts both locals and international residents.
From your new home, you’ll enjoy easy access to shops, restaurants, parks, and medical centers—all just steps away. This peaceful town also offers proximity to natural parks and hiking trails, perfect for outdoor enthusiasts.
Key Distances to Points of Interest
Torre de la Horadada Beach – 3 km
Lo Romero Golf Course – 5 km
La Zenia Boulevard Shopping Center – 15 km
Corvera Airport (Murcia) – 40 km
Alicante Airport – 55 km
Secure Your New Home on the Costa Blanca
Don’t miss the chance to own a beautifully designed new-build apartment in a privileged location. Contact us today for more information or to arrange a viewing. Your new life in the sun awaits in Pilar de la Horadada.
[post_title] => N8803
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8803
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:15
[post_modified_gmt] => 2025-06-24 00:25:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8803/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10568915
[post_author] => 0
[post_date] => 2025-06-24 01:45:27
[post_date_gmt] => 2025-06-24 00:45:27
[post_content] =>
[post_title] => A10226
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10226
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:27
[post_modified_gmt] => 2025-06-24 00:45:27
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10226/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10568775
[post_author] => 0
[post_date] => 2025-06-24 01:45:24
[post_date_gmt] => 2025-06-24 00:45:24
[post_content] =>
[post_title] => A4851 - Complex of 18 bungalows in Alhama (Murcia)
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4851-complex-of-18-bungalows-in-alhama-murcia
[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/a4851-complex-of-18-bungalows-in-alhama-murcia/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10569086
[post_author] => 0
[post_date] => 2025-06-24 01:45:31
[post_date_gmt] => 2025-06-24 00:45:31
[post_content] =>
[post_title] => F0950 - Discover Your New Home in Benidorm's Paradise
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0950-discover-your-new-home-in-benidorms-paradise
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:31
[post_modified_gmt] => 2025-06-24 00:45:31
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0950-discover-your-new-home-in-benidorms-paradise/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10569150
[post_author] => 0
[post_date] => 2025-06-24 01:45:33
[post_date_gmt] => 2025-06-24 00:45:33
[post_content] =>
[post_title] => B10657
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10657
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:33
[post_modified_gmt] => 2025-06-24 00:45:33
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10657/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10570476
[post_author] => 0
[post_date] => 2025-07-06 23:30:02
[post_date_gmt] => 2025-07-06 22:30:02
[post_content] => Discover this beautifully reformed 3 bedroom, 1 bathroom villa in the sought-after area of Montemar, Algorfa. Offering a perfect blend of modern comfort and Spanish charm, this single-storey home is ideal for permanent living or as a holiday retreat.
Step inside to find a bright and airy lounge with feature firsplace, perfect for relaxing or entertaining. The kitchen is functional and leads to a utility room at the rear of the house. The three well-proportioned bedrooms provide plenty of space for family and guests and all have built in wardrobes. The bathroom has also been tastefully modernized and features both a bathtub and a separate shower, catering to all preferences.
Outdoor living is where this villa truly shines! The large terrace is perfect for morning coffee or al fresco dining, while the huge rooftop solarium boasts breathtaking countryside views, ideal for sunbathing, entertaining or simply unwinding in the peaceful surroundings. There is a basement accessed from the garden that has been tiled and plastered to create a sizable store room.
The communal pool is just at the top of the road offering the ideal place to cool down during the long summer days.
Situated in a fantastic location, this home is just minutes from the renowned La Finca Golf Course, making it a golfer’s paradise. The nearby La Finca Commercial Centre offers an array of bars, restaurants and shops, providing everything you need for a vibrant social life.
For beach lovers, the stunning sandy shores of Guardamar and Torrevieja are just a 15 minute drive away, perfect for a day by the sea. If shopping is your passion, the famous Zenia Boulevard, the largest shopping centre in the Costa Blanca, is also within easy reach.
Don’t miss this opportunity to own a beautiful villa in one of the most desirable locations in the region. Book your viewing today!
[post_title] => VA5240
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5240-16
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-06 23:30:02
[post_modified_gmt] => 2025-07-06 22:30:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5240-16/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10570797
[post_author] => 0
[post_date] => 2025-07-12 11:30:14
[post_date_gmt] => 2025-07-12 10:30:14
[post_content] => Discover this beautifully reformed 3 bedroom, 1 bathroom villa in the sought-after area of Montemar, Algorfa. Offering a perfect blend of modern comfort and Spanish charm, this single-storey home is ideal for permanent living or as a holiday retreat.
Step inside to find a bright and airy lounge with feature firsplace, perfect for relaxing or entertaining. The kitchen is functional and leads to a utility room at the rear of the house. The three well-proportioned bedrooms provide plenty of space for family and guests and all have built in wardrobes. The bathroom has also been tastefully modernized and features both a bathtub and a separate shower, catering to all preferences.
Outdoor living is where this villa truly shines! The large terrace is perfect for morning coffee or al fresco dining, while the huge rooftop solarium boasts breathtaking countryside views, ideal for sunbathing, entertaining or simply unwinding in the peaceful surroundings. There is a basement accessed from the garden that has been tiled and plastered to create a sizable store room.
The communal pool is just at the top of the road offering the ideal place to cool down during the long summer days.
Situated in a fantastic location, this home is just minutes from the renowned La Finca Golf Course, making it a golfer’s paradise. The nearby La Finca Commercial Centre offers an array of bars, restaurants and shops, providing everything you need for a vibrant social life.
For beach lovers, the stunning sandy shores of Guardamar and Torrevieja are just a 15 minute drive away, perfect for a day by the sea. If shopping is your passion, the famous Zenia Boulevard, the largest shopping centre in the Costa Blanca, is also within easy reach.
Don’t miss this opportunity to own a beautiful villa in one of the most desirable locations in the region. Book your viewing today!
[post_title] => VA5240
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5240-27
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-12 11:30:14
[post_modified_gmt] => 2025-07-12 10:30:14
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5240-27/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10570711
[post_author] => 0
[post_date] => 2025-07-10 23:30:05
[post_date_gmt] => 2025-07-10 22:30:05
[post_content] => Discover this beautifully reformed 3 bedroom, 1 bathroom villa in the sought-after area of Montemar, Algorfa. Offering a perfect blend of modern comfort and Spanish charm, this single-storey home is ideal for permanent living or as a holiday retreat.
Step inside to find a bright and airy lounge with feature firsplace, perfect for relaxing or entertaining. The kitchen is functional and leads to a utility room at the rear of the house. The three well-proportioned bedrooms provide plenty of space for family and guests and all have built in wardrobes. The bathroom has also been tastefully modernized and features both a bathtub and a separate shower, catering to all preferences.
Outdoor living is where this villa truly shines! The large terrace is perfect for morning coffee or al fresco dining, while the huge rooftop solarium boasts breathtaking countryside views, ideal for sunbathing, entertaining or simply unwinding in the peaceful surroundings. There is a basement accessed from the garden that has been tiled and plastered to create a sizable store room.
The communal pool is just at the top of the road offering the ideal place to cool down during the long summer days.
Situated in a fantastic location, this home is just minutes from the renowned La Finca Golf Course, making it a golfer’s paradise. The nearby La Finca Commercial Centre offers an array of bars, restaurants and shops, providing everything you need for a vibrant social life.
For beach lovers, the stunning sandy shores of Guardamar and Torrevieja are just a 15 minute drive away, perfect for a day by the sea. If shopping is your passion, the famous Zenia Boulevard, the largest shopping centre in the Costa Blanca, is also within easy reach.
Don’t miss this opportunity to own a beautiful villa in one of the most desirable locations in the region. Book your viewing today!
[post_title] => VA5240
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5240-24
[to_ping] =>
[pinged] =>
[post_modified] => 2025-07-10 23:30:05
[post_modified_gmt] => 2025-07-10 22:30:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://viewspanishproperties.com/property/va5240-24/
[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] => 10567992
[post_author] => 0
[post_date] => 2025-06-24 01:45:05
[post_date_gmt] => 2025-06-24 00:45:05
[post_content] =>
[post_title] => A5991 - COMMERCIAL PREMISES IN LA ZENIA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a5991-commercial-premises-in-la-zenia
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:05
[post_modified_gmt] => 2025-06-24 00:45:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a5991-commercial-premises-in-la-zenia/
[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] => 6b911c44fb0479e571cb728b8c350f4a
[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:821c4454c63410e188fa60d85c313acd:0.78371600 1753173804
)
2
2
1