WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 205
[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] => 205
[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 = 'newbuilds' 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')))
ORDER BY wp_posts.post_date DESC
LIMIT 2448, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10167381
[post_author] => 0
[post_date] => 2025-02-23 01:10:02
[post_date_gmt] => 2025-02-23 01:10:02
[post_content] => Rustic property of 46,816 m2 (the minimum to build a legal home is 10,000 m2) with a house to reform and more than enough water supply to irrigate it all.
Located 3 km from the center of Callosa de Segura and Cox, with all services.
Recreational farm, to live and or spend seasonsAgrobusiness operation. With provision of water to plant the typical crops of the garden: citrus fruits, vegetables, greens...House - Rural hotel: By reforming the house, a very profitable business could be carried out, taking into account, above all, that the pandemic has modified the preferences of tourists for this type of accommodation in the countryside. The constructed area could be expanded because a buildable area of 2% of the land is allowed (almost 1000 m2) and there are only 100 m2 in the existing house.A few minutes from the Callosa mountain, with hiking trails, trekking, its via ferrata, etc. Also near the monumental historic center of the city of Orihuela.25 minutes from the beaches (Guardamar, La Mata, Orihuela Costa) and less than an hour from Alicante airport.It has 2 accesses by car and is close to other houses.Excellent views of the mountains and the orchard landscape of Vega Baja.
[post_title] => Finca Callosa
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => finca-callosa
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:10:02
[post_modified_gmt] => 2025-02-23 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/finca-callosa/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10167382
[post_author] => 0
[post_date] => 2025-02-23 01:10:02
[post_date_gmt] => 2025-02-23 01:10:02
[post_content] => This home is located in the center of La Mata, just 300 meters from the beach and next to all services.
It is a building built in 2007.
The house has approximately 70 m2 and is distributed in a separate kitchen, 2 bedrooms, 2 full bathrooms, living room and a terrace.
It faces east
It has never been inhabited by anyone.
It is a 2nd floor with an elevatorCommunity: €520 per yearIBI: €233
[post_title] => 1172-2N
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1172-2n
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:10:02
[post_modified_gmt] => 2025-02-23 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1172-2n/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10167383
[post_author] => 0
[post_date] => 2025-02-23 01:10:02
[post_date_gmt] => 2025-02-23 01:10:02
[post_content] => It is a home located in a private urbanization with a communal pool, 200 meters from the beach and a 5-minute walk to the center of town.
It has 2 bedrooms and 1 bathroom.
American kitchen
58 square meters
Terrace
North orientation
3rd floor with elevator
Freshly painted, sold as it appears in the photosCommunity: €380 per year
IBI: €165
[post_title] => 1198
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1198
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:10:02
[post_modified_gmt] => 2025-02-23 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1198/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10167384
[post_author] => 0
[post_date] => 2025-02-23 01:10:02
[post_date_gmt] => 2025-02-23 01:10:02
[post_content] => It is a home located in the heart of La Mata, next to all services and just 200 meters from the beach.
It has a constructed area of 78 m2, distributed in 2 bedrooms, living room, bathroom, interior patio and terrace.
West orientation.
It has 3 very large closets and the house is sold furnished.
1st floor with elevator
Community: €400 per year
IBI: €280 per year
[post_title] => 1201
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1201
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:10:02
[post_modified_gmt] => 2025-02-23 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1201/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10167385
[post_author] => 0
[post_date] => 2025-02-23 01:10:02
[post_date_gmt] => 2025-02-23 01:10:02
[post_content] => It is a Duplex located in La Mata just 300 meters from the beach.
It is completely renovated with quality materials.
It has a constructed area of 100 m2 distributed in living room, 3 bedrooms, 2 bathrooms, basement, storage room, solarium and south-facing terrace.
It is sold furnished except TV's and Refrigerator.
It is impeccable, ready to move into.
Quiet residential.OPTIONAL GARAGE
IBI: €271
[post_title] => 1203
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1203
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:10:02
[post_modified_gmt] => 2025-02-23 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1203/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10167386
[post_author] => 0
[post_date] => 2025-02-23 01:10:02
[post_date_gmt] => 2025-02-23 01:10:02
[post_content] => This is an apartment located in the centre of La Mata, just 300 metres from the central beach.
It is a first floor with a lift and has, according to a simple note, 55 m2 built (very spacious), distributed in an open-plan kitchen with a window to the outside, a living-dining room, 1 bathroom and 1 bedroom.
It also has a large terrace facing East (morning sun)
Sold furnished1 floor with liftYear of construction: 1992Community: €340 per yearIBI: €156
[post_title] => 1211
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1211
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:10:02
[post_modified_gmt] => 2025-02-23 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1211/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10167387
[post_author] => 0
[post_date] => 2025-02-23 01:10:02
[post_date_gmt] => 2025-02-23 01:10:02
[post_content] => It is an apartment located in the center of La Mata, located on the 2nd line of the beach just 50 meters from the water and in the center next to all services.It has a constructed area of 75 m2 distributed in a living room, kitchen, 3 bedrooms and bathroom.It has a terrace facing East (Sun in the morning)It is sold furnished1st floor without elevatorCommunity: € 110 per yearIBI: € 187
[post_title] => 1215
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1215
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:10:02
[post_modified_gmt] => 2025-02-23 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1215/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10167388
[post_author] => 0
[post_date] => 2025-02-23 01:10:02
[post_date_gmt] => 2025-02-23 01:10:02
[post_content] => It is a house located in the center of La Mata, just 300 meters from the beach.
It has a constructed area of 60 m2 and a useful area of 52 m2.
2 bedrooms, 1 full bathroom, living room, separate kitchen and a terrace facing north, overlooking the pool.
It is the only building in the center of the town that has a communal pool.
5th floor with elevator.
Sold furnished.
Community: €500 per year
IBI: €200
[post_title] => 1217
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1217
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:10:02
[post_modified_gmt] => 2025-02-23 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1217/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10167389
[post_author] => 0
[post_date] => 2025-02-23 01:10:02
[post_date_gmt] => 2025-02-23 01:10:02
[post_content] => It is a house located just 50 meters from the beach, located in the center of the town of La Mata, next to all services.
It has a useful area of 42 m2 distributed in living room, kitchen, bathroom and bedroom.
It has an East facing terrace.
It is a 1st floor with elevator.
The house is sold furnished.
Community: €360 per year
IBI: €143
[post_title] => 1221
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1221
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:10:02
[post_modified_gmt] => 2025-02-23 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1221/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10167359
[post_author] => 0
[post_date] => 2025-02-23 01:05:03
[post_date_gmt] => 2025-02-23 01:05:03
[post_content] => This large 4 bedroom detached villa is presented for sale in excellent condition and has been maintained to a very high standard. The Villa is set on a 412M2 plot with garden area, lovely private pool and stunning outside kitchen and bbq area. This entire outside area only just in the past few days has been completely re tiled to a very high quality so enhancing the area for outside entertaining.
Inside with a build of a 124M2 which can be entered via the street side or by the pool side, you have a large lounge, kitchen and master bedroom with patio doors to the pool. There is a shower room here also and storage room. On the upper level there are 3 double bedrooms, with 2 having superb private terraces. This house comes with brand new dual air-con units in all rooms and full central heating in all rooms including a top of range boiler. This property is being offered for sale part furnished and has been repainted internally throughout.
Located in the popular Atalaya Park development, just a short walk from the Quesada main street area, makes this property very attractive and viewing is highly recommended to really appreciate the quality of build, location and size that is on offer.
[post_title] => VA5142
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5142
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:05:03
[post_modified_gmt] => 2025-02-23 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5142/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10167366
[post_author] => 0
[post_date] => 2025-02-23 01:05:03
[post_date_gmt] => 2025-02-23 01:05:03
[post_content] =>
[post_title] => VA5210
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5210
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:05:03
[post_modified_gmt] => 2025-02-23 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5210/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10167367
[post_author] => 0
[post_date] => 2025-02-23 01:05:03
[post_date_gmt] => 2025-02-23 01:05:03
[post_content] => This superb Jazmine style detached villa is presented for sale in excellent condition and has been maintained to a very high standard.
This property offers a spacious 3 bedroom 2 bathroom villa distributed over two levels.
On the ground floor there is a good size lounge /diner, separate kitchen with utility cupboard under the stairs. There are two double bedrooms and a family size bathroom accessed through an archway from the lounge area. There is a feature staircase that leads to a landing area and a glazed door to a large roof terrace. Access to a master bedroom with en suite is from the same landing. The master bedroom also has patio doors onto the large roof terrace.
Out side this villa is a good area for seating and relaxing. There is access for off road parking if required.
Just a few meters walk from this villa is the communal swimming pool
This property has been beautifully furnished through out and is sold with all this furniture.
Located on the popular Jardin de Laguna II development, puts this villa within easy walk to a variety of amenities.
Viewing is highly recommended to really appreciate what this villa has to offer.
[post_title] => VA5211
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5211
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:05:03
[post_modified_gmt] => 2025-02-23 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5211/
[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] => 10167381
[post_author] => 0
[post_date] => 2025-02-23 01:10:02
[post_date_gmt] => 2025-02-23 01:10:02
[post_content] => Rustic property of 46,816 m2 (the minimum to build a legal home is 10,000 m2) with a house to reform and more than enough water supply to irrigate it all.
Located 3 km from the center of Callosa de Segura and Cox, with all services.
Recreational farm, to live and or spend seasonsAgrobusiness operation. With provision of water to plant the typical crops of the garden: citrus fruits, vegetables, greens...House - Rural hotel: By reforming the house, a very profitable business could be carried out, taking into account, above all, that the pandemic has modified the preferences of tourists for this type of accommodation in the countryside. The constructed area could be expanded because a buildable area of 2% of the land is allowed (almost 1000 m2) and there are only 100 m2 in the existing house.A few minutes from the Callosa mountain, with hiking trails, trekking, its via ferrata, etc. Also near the monumental historic center of the city of Orihuela.25 minutes from the beaches (Guardamar, La Mata, Orihuela Costa) and less than an hour from Alicante airport.It has 2 accesses by car and is close to other houses.Excellent views of the mountains and the orchard landscape of Vega Baja.
[post_title] => Finca Callosa
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => finca-callosa
[to_ping] =>
[pinged] =>
[post_modified] => 2025-02-23 01:10:02
[post_modified_gmt] => 2025-02-23 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/finca-callosa/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 2491
[max_num_pages] => 208
[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] => 123eb59302b886914f1382b000caab25
[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
