£99 Viewing Trip
WP_Query Object
(
    [query] => Array
        (
            [posts_per_page] => 12
            [suppress_filters] => 
            [post_type] => Array
                (
                    [0] => hx_property
                    [1] => newbuilds
                    [2] => mn_property
                )

            [paged] => 26
            [meta_query] => Array
                (
                    [relation] => AND
                )

            [order] => DESC
            [orderby] => date
        )

    [query_vars] => Array
        (
            [posts_per_page] => 12
            [suppress_filters] => 
            [post_type] => Array
                (
                    [0] => hx_property
                    [1] => newbuilds
                    [2] => mn_property
                )

            [paged] => 26
            [meta_query] => Array
                (
                    [relation] => AND
                )

            [order] => DESC
            [orderby] => date
            [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_key] => 
            [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
                (
                )

            [relation] => AND
            [meta_table] => 
            [meta_id_column] => 
            [primary_table] => 
            [primary_id_column] => 
            [table_aliases:protected] => Array
                (
                )

            [clauses:protected] => Array
                (
                )

            [has_or_relation:protected] => 
        )

    [date_query] => 
    [request] => SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
					 FROM wp_posts 
					 WHERE 1=1  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')))
					 
					 ORDER BY wp_posts.post_date DESC
					 LIMIT 300, 12
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 10393069
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => AS015
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => as015
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/as015/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [1] => WP_Post Object
                (
                    [ID] => 10393066
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => B10718 - Beautiful ground floor corner bungalow
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => b10718-beautiful-ground-floor-corner-bungalow
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/b10718-beautiful-ground-floor-corner-bungalow/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [2] => WP_Post Object
                (
                    [ID] => 10393065
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => CAS035 - Great investment opportunity, 5 minutes from downtown Avilés
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => cas035-great-investment-opportunity-5-minutes-from-downtown-aviles
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/cas035-great-investment-opportunity-5-minutes-from-downtown-aviles/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [3] => WP_Post Object
                (
                    [ID] => 10393064
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => AS016
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => as016
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/as016/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [4] => WP_Post Object
                (
                    [ID] => 10393091
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => V342
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => v342
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/v342/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [5] => WP_Post Object
                (
                    [ID] => 10393090
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => A10463
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => a10463
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/a10463/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [6] => WP_Post Object
                (
                    [ID] => 10393093
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => 72651
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => 72651
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/72651/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [7] => WP_Post Object
                (
                    [ID] => 10393068
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => F0999 - Spacious apartment in a new residential complex
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => f0999-spacious-apartment-in-a-new-residential-complex
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/f0999-spacious-apartment-in-a-new-residential-complex/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [8] => WP_Post Object
                (
                    [ID] => 10393067
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => CAS036
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => cas036
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/cas036/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [9] => WP_Post Object
                (
                    [ID] => 10393061
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => B10716 - INDEPENDENT VILLA WITH COMMUNITY POOL. 4 BEDROOMS. 2 BATHROOMS. PLOT OF 165 M2. HOUSE OF 207 M2.
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => b10716-independent-villa-with-community-pool-4-bedrooms-2-bathrooms-plot-of-165-m2-house-of-207-m2
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/b10716-independent-villa-with-community-pool-4-bedrooms-2-bathrooms-plot-of-165-m2-house-of-207-m2/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [10] => WP_Post Object
                (
                    [ID] => 10393089
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => MPA062 - FANTASTIC PROPERTY FOR SALE COMPLETELY RENOVATED IN BARRIO DEL PILAR, MADRID
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => mpa062-fantastic-property-for-sale-completely-renovated-in-barrio-del-pilar-madrid
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/mpa062-fantastic-property-for-sale-completely-renovated-in-barrio-del-pilar-madrid/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [11] => WP_Post Object
                (
                    [ID] => 10393083
                    [post_author] => 0
                    [post_date] => 2025-05-03 01:45:38
                    [post_date_gmt] => 2025-05-03 00:45:38
                    [post_content] => 
                    [post_title] => 72648 - STUNNING AND SPACIOUS APARTMENT WITH PATIO VERY CLOSE TO THE CENTER AND SAN FERNANDO CASTLE
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => 72648-stunning-and-spacious-apartment-with-patio-very-close-to-the-center-and-san-fernando-castle
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-05-03 01:45:38
                    [post_modified_gmt] => 2025-05-03 00:45:38
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/72648-stunning-and-spacious-apartment-with-patio-very-close-to-the-center-and-san-fernando-castle/
                    [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] => 10393069
            [post_author] => 0
            [post_date] => 2025-05-03 01:45:38
            [post_date_gmt] => 2025-05-03 00:45:38
            [post_content] => 
            [post_title] => AS015
            [post_excerpt] => 
            [post_status] => publish
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => as015
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2025-05-03 01:45:38
            [post_modified_gmt] => 2025-05-03 00:45:38
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => https://www.viewspanishproperties.com/property/as015/
            [menu_order] => 0
            [post_type] => hx_property
            [post_mime_type] => 
            [comment_count] => 0
            [filter] => raw
        )

    [comment_count] => 0
    [current_comment] => -1
    [found_posts] => 3015
    [max_num_pages] => 252
    [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] => 1c695fd1641eecd325fc9d8dfa3b5202
    [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
        )

)
We found 3015 properties

Apartamento in Mieres

Mieres del Camino €115,000
214sqm
  • Number of Bathrooms2
  • Number of Beds 2

Bungalow Planta Baja in Orihuela Costa

La Florida €159,000
106sqm
  • Number of Pools1
  • Number of Bathrooms1
  • Number of Beds 2

Apartamento in Aviles

La carriona €59,000
59sqm
  • Number of Bathrooms1
  • Number of Beds 3

Piso in Aviles

La Magdalena €129,000
158sqm
  • Number of Bathrooms2
  • Number of Beds 3

Adosado in Godella

Campolivar €545,000
350sqm
  • Number of Bathrooms3
  • Number of Beds 4

Apartamento in Torrevieja

Estacion de autobuses €126,000
126sqm
  • Number of Bathrooms1
  • Number of Beds 2

Apartamento in Alicante

Virgen del remedio €80,000
151sqm
  • Number of Bathrooms1
  • Number of Beds 3

Apartamento in Alicante

Benalua €470,000
204sqm
  • Number of Pools1
  • Number of Bathrooms2
  • Number of Beds 4

Negocio in Oviedo

Fozaneldi-Tenderina €84,000
166sqm
  • Number of Bathrooms
  • Number of Beds 0

Villa in Orihuela Costa

PAU 26 €284,900
207sqm
  • Number of Pools1
  • Number of Bathrooms2
  • Number of Beds 4

Piso in Madrid

Pilar €315,000
110sqm
  • Number of Bathrooms1
  • Number of Beds 2

Piso in Alicante

Carolinas bajas €215,000
285sqm
  • Number of Bathrooms2
  • Number of Beds 3

Search Properties

×

Hello!

Click on of our representatives below to chat on WhatsApp.

× How can I help you?