£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] => 32
            [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] => 32
            [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 372, 12
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 10566897
                    [post_author] => 0
                    [post_date] => 2025-06-24 01:15:02
                    [post_date_gmt] => 2025-06-24 00:15:02
                    [post_content] => Beautiful Bungalow in Las Chismosas, Orihuela Costa, has 2 bedrooms, bathroom, kitchen, living room and closed terrace, renovated kitchen with all appliances, bathroom with shower, PVC floors, pellet stove, fans, closed terrace, with roof top solarium, furnished, could do with some modernisation which is refelected in the asking price. 10 minutes from beaches and great coves, 5 minutes CC la Zenia, next to the municipal sports center, schools, institutes, supermarkets, restaurants.... Very quiet urbanization with large green areas, plants and fruit trees.
                    [post_title] => F1114
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => f1114
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-06-24 01:15:02
                    [post_modified_gmt] => 2025-06-24 00:15:02
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/f1114/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [1] => WP_Post Object
                (
                    [ID] => 10568201
                    [post_author] => 0
                    [post_date] => 2025-06-24 01:45:10
                    [post_date_gmt] => 2025-06-24 00:45:10
                    [post_content] => 
                    [post_title] => F0119
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => f0119
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-06-24 01:45:10
                    [post_modified_gmt] => 2025-06-24 00:45:10
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/f0119/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [2] => WP_Post Object
                (
                    [ID] => 10569461
                    [post_author] => 0
                    [post_date] => 2025-06-24 01:45:41
                    [post_date_gmt] => 2025-06-24 00:45:41
                    [post_content] => 
                    [post_title] => A10567
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => a10567
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-06-24 01:45:41
                    [post_modified_gmt] => 2025-06-24 00:45:41
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/a10567/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [3] => WP_Post Object
                (
                    [ID] => 10567968
                    [post_author] => 0
                    [post_date] => 2025-06-24 01:45:04
                    [post_date_gmt] => 2025-06-24 00:45:04
                    [post_content] => 
                    [post_title] => 5940 - Building plot with project of villa with pool in Catral
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => 5940-building-plot-with-project-of-villa-with-pool-in-catral
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-06-24 01:45:04
                    [post_modified_gmt] => 2025-06-24 00:45:04
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/5940-building-plot-with-project-of-villa-with-pool-in-catral/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [4] => WP_Post Object
                (
                    [ID] => 10569292
                    [post_author] => 0
                    [post_date] => 2025-06-24 01:45:36
                    [post_date_gmt] => 2025-06-24 00:45:36
                    [post_content] => 
                    [post_title] => A10502 - Cozy Semi-Renovated Apartment in Playa del Cura, Torrevieja with 2 BEDROOMS and 1 BATHROOM plus two STORAGE ROOMS just a short walk to the beach.
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => a10502-cozy-semi-renovated-apartment-in-playa-del-cura-torrevieja-with-2-bedrooms-and-1-bathroom-plus-two-storage-rooms-just-a-short-walk-to-the-beach
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-06-24 01:45:36
                    [post_modified_gmt] => 2025-06-24 00:45:36
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/a10502-cozy-semi-renovated-apartment-in-playa-del-cura-torrevieja-with-2-bedrooms-and-1-bathroom-plus-two-storage-rooms-just-a-short-walk-to-the-beach/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [5] => WP_Post Object
                (
                    [ID] => 10569644
                    [post_author] => 0
                    [post_date] => 2025-06-24 01:45:45
                    [post_date_gmt] => 2025-06-24 00:45:45
                    [post_content] => 
                    [post_title] => A10617 - LUXURY APARTMENT NEAR THE BEACH! 2 BEDROOMS. LARGE TERRACE.
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => a10617-luxury-apartment-near-the-beach-2-bedrooms-large-terrace
                    [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/a10617-luxury-apartment-near-the-beach-2-bedrooms-large-terrace/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

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

            [7] => WP_Post Object
                (
                    [ID] => 10569602
                    [post_author] => 0
                    [post_date] => 2025-06-24 01:45:44
                    [post_date_gmt] => 2025-06-24 00:45:44
                    [post_content] => 
                    [post_title] => A10597 - Exclusive apartment with incredible design and a prime location
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => a10597-exclusive-apartment-with-incredible-design-and-a-prime-location
                    [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/a10597-exclusive-apartment-with-incredible-design-and-a-prime-location/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

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

            [9] => WP_Post Object
                (
                    [ID] => 10568881
                    [post_author] => 0
                    [post_date] => 2025-06-24 01:45:26
                    [post_date_gmt] => 2025-06-24 00:45:26
                    [post_content] => 
                    [post_title] => A10211
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => a10211
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2025-06-24 01:45:26
                    [post_modified_gmt] => 2025-06-24 00:45:26
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://www.viewspanishproperties.com/property/a10211/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [10] => WP_Post Object
                (
                    [ID] => 10569309
                    [post_author] => 0
                    [post_date] => 2025-06-24 01:45:37
                    [post_date_gmt] => 2025-06-24 00:45:37
                    [post_content] => 
                    [post_title] => A10503
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => a10503
                    [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/a10503/
                    [menu_order] => 0
                    [post_type] => hx_property
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [11] => WP_Post Object
                (
                    [ID] => 10569566
                    [post_author] => 0
                    [post_date] => 2025-06-24 01:45:43
                    [post_date_gmt] => 2025-06-24 00:45:43
                    [post_content] => 
                    [post_title] => B10902
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => b10902
                    [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/b10902/
                    [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] => 10566897
            [post_author] => 0
            [post_date] => 2025-06-24 01:15:02
            [post_date_gmt] => 2025-06-24 00:15:02
            [post_content] => Beautiful Bungalow in Las Chismosas, Orihuela Costa, has 2 bedrooms, bathroom, kitchen, living room and closed terrace, renovated kitchen with all appliances, bathroom with shower, PVC floors, pellet stove, fans, closed terrace, with roof top solarium, furnished, could do with some modernisation which is refelected in the asking price. 10 minutes from beaches and great coves, 5 minutes CC la Zenia, next to the municipal sports center, schools, institutes, supermarkets, restaurants.... Very quiet urbanization with large green areas, plants and fruit trees.
            [post_title] => F1114
            [post_excerpt] => 
            [post_status] => publish
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => f1114
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2025-06-24 01:15:02
            [post_modified_gmt] => 2025-06-24 00:15:02
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => https://www.viewspanishproperties.com/property/f1114/
            [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] => 4b973de5622da4cc0c31d0c230173339
    [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:a20c301cb03758b7beb2ca51b1522b8b:0.89138700 1753144632
)
We found 4463 properties

Bungalow in Las Mimosas

Alicante €149,000
  • Number of Bathrooms1
  • Number of Beds 2

Beautiful Bungalow in Las Chismosas, Orihuela Costa, has 2 bedrooms, bathroom, kitchen, living room and closed terrace, renovated kitchen with all ...

Casa in Sella

PUEBLO €149,000
285sqm
  • Number of Bathrooms2
  • Number of Beds 6
...

Apartamento in Torrevieja

Habaneras €149,900
122sqm
  • Number of Bathrooms1
  • Number of Beds 2
...

Parcela in Catral

03158 €149,900
  • Number of Bathrooms
  • Number of Beds 0
...

Apartamento in Torrevieja

Playa del Cura €149,900
182sqm
  • Number of Bathrooms1
  • Number of Beds 2
...

Apartamento in Torrevieja

Playa del Cura €149,900
127sqm
  • Number of Bathrooms1
  • Number of Beds 2
...

Adosado in Torrevieja

La Siesta - El Salado - Torreta €149,900
116sqm
  • Number of Bathrooms1
  • Number of Beds 2
...

Apartamento in Torrevieja

torrevieja €149,900
100sqm
  • Number of Bathrooms1
  • Number of Beds 1
...

Apartamento in Torrevieja

torrevieja €149,900
134sqm
  • Number of Bathrooms1
  • Number of Beds 2
...

Apartamento in Torrevieja

Centro €149,900
61sqm
  • Number of Pools1
  • Number of Bathrooms1
  • Number of Beds 2
...

Planta baja in Lo Pagan

LA PUNTICA €149,900
150sqm
  • Number of Bathrooms2
  • Number of Beds 6
...

Apartamento in Torrevieja

Playa del Cura €149,900
133sqm
  • Number of Bathrooms1
  • Number of Beds 2
...

Search Properties