WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 261
[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] => 261
[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 3120, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 9197908
[post_author] => 0
[post_date] => 2024-05-18 01:10:03
[post_date_gmt] => 2024-05-18 00:10:03
[post_content] => This home is located in the heart of the town of La Mata. It is a 1-bedroom ground floor with a front terrace and interior patio.
The house has approximately 40 m2 and is 200 meters from the beach.
Along with all services.
It is delivered furnished
Community: €120 per year
IBI: €85
[post_title] => 1194
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1194
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:03
[post_modified_gmt] => 2024-05-18 00:10:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1194/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 9197909
[post_author] => 0
[post_date] => 2024-05-18 01:10:03
[post_date_gmt] => 2024-05-18 00:10:03
[post_content] => This is an apartment located in the center of La Mata, just 300 meters from the downtown beach.It is a first floor with an elevator and has, according to a simple note, 55 m2 built (very spacious), distributed in an American kitchen with a window to the outside, living room - dining room, 1 bathroom and 1 bedroom.It also has a large terrace facing East (morning sun)Sold unfurnished and freshly painted.OPTIONAL GARAGECommunity: €340 per yearIBI: €130
[post_title] => 1193
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1193
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:03
[post_modified_gmt] => 2024-05-18 00:10:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1193/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 9197888
[post_author] => 0
[post_date] => 2024-05-18 01:10:02
[post_date_gmt] => 2024-05-18 00:10:02
[post_content] => Magnifico Detached Chalet surrounded by nature and tranquility in the surroundings of Orihuela Town. With 240m2 built on a plot of 1.050m2 offers a perfect exterior to relax in your private pool or stroll through your garden (easy maintenance and irrigation) planted with ornamental and fruit trees where there are also gazebos of solid wood and barbecue. In the interior of the house you can appreciate the quality finishes, with spacious rooms and lots of natural lighting. The living / dining room has a wood burning fireplace. The kitchen with cherry furniture is very spacious and independent and has a laundry room. Bathroom with whirlpool bath and another bathroom incorporated into the main room. The property has a total of 4 bedrooms with fitted wardrobes. Marble floors and ceramic tile, exterior carpentry windows of aluminum oscilo sills with climalit and mosquitera, interior carpentry oak national. Double insulation chamber (with projected polyurethane foam), acoustic and thermal insulation. 2 terraces, private pool of 9x4, a parking space / garage for 2 people with wardrobes and toilet. It is delivered without furniture. Surrounded by services, 6 minutes from the center of Orihuela and 30 km from the beaches. To 30Km of the airport of San Javier and 45Km of the one of Alicante. TAX 400 euros / year.
[post_title] => NH-16381
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => nh-16381
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:02
[post_modified_gmt] => 2024-05-18 00:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/nh-16381/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 9197889
[post_author] => 0
[post_date] => 2024-05-18 01:10:02
[post_date_gmt] => 2024-05-18 00:10:02
[post_content] => Excellent commercial property located a few meters from the seafront and the beach of Playa Flamenca (Orihuela Costa). It has 160 m2 built distributed in 4 large rooms offering the possibility of dividing into 2 different units with independent access. Its location at the foot of the street is privileged because the area has a large influx of foreign tourists throughout the year, also having an Apartahotel on it.The place is located on the corner with a facade of 14 linear meters. Perfect for offices or any type of business. It also has 50 m2 of front terrace facing the street. Excellent investment opportunity in one of the best areas of Orihuela Costa.
[post_title] => NH-88684
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => nh-88684
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:02
[post_modified_gmt] => 2024-05-18 00:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/nh-88684/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 9197890
[post_author] => 0
[post_date] => 2024-05-18 01:10:02
[post_date_gmt] => 2024-05-18 00:10:02
[post_content] => Excellent opportunity! Price reduced by 20%!Luxury rustic Mediterranean-style villa with 4 bedrooms, double height living room, fireplace, radiator heating (diesel), double enclosed garage, large terraces with bar area, wood-burning oven, etc. On the farm, there is another 2 bedroom guest house, with independent access (also with heating). The pool has a mobile roof structure that will allow you to use it both in summer and winter and is heated. Next to the pool, there are leisure rooms for: Spa area with gym, jacuzzi, bathroom etc. In front of the house, a large party room with stage and DJ booth, Karaoke, large lounge area, kitchen, bathroom, 1 bedroom / office room and Underground Cellar in the basement with capacity for 3,000 bottles. DIY room with tools and machinery. In addition, the farm is planted with citrus fruits, in production and with benefits. It has a technical ship with the drip irrigation equipment of the farm, storage and heating boiler.The access to the farm is through automatic sliding doors (with remote control and opening from the intercom). There is a Playground for children with ecological swing and playground. Road traffic areas paved and sidewalks. All buildings have their respective building license and are duly registered. Light and running water. In addition, the property has the right to irrigate a large raft (around which there is a walking circuit that has rest areas and even piped music. The property is very well maintained and could be used for different uses such as:a) Recreational farm or as usual residenceb) Rural boutique hotelc) Finca for events.The distance to the beach is approximately 30 km (40 minutes by car). It is an extraordinary property worth visiting.Total built area 1,500 m2.
[post_title] => NH-19166
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => nh-19166
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:02
[post_modified_gmt] => 2024-05-18 00:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/nh-19166/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 9197891
[post_author] => 0
[post_date] => 2024-05-18 01:10:02
[post_date_gmt] => 2024-05-18 00:10:02
[post_content] => Closed garage space in the center of La Mata, recently built building.It consists of 39 meters with an elevator access from the street and very easy maneuverability.Community: € 45Annual Tax: € 69 year
[post_title] => NH-92889
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => nh-92889
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:02
[post_modified_gmt] => 2024-05-18 00:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/nh-92889/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 9197892
[post_author] => 0
[post_date] => 2024-05-18 01:10:02
[post_date_gmt] => 2024-05-18 00:10:02
[post_content] => Great opportunity to buy this central business unit with a huge attached garage next to the premises, with internal access. The local consists of a reception area, bathroom and storage room, with 420m2 of space, covering more than two streets and less than 200 meters from the sea, this local really benefits from a privileged location.
IBI: € 1,262 a year
[post_title] => NH-29174
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => nh-29174
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:02
[post_modified_gmt] => 2024-05-18 00:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/nh-29174/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 9197893
[post_author] => 0
[post_date] => 2024-05-18 01:10:02
[post_date_gmt] => 2024-05-18 00:10:02
[post_content] => It is a house built in 2004. It has 102 m2 built, terrace and private solarium.
3 bedrooms and 2 bathrooms, separate kitchen and living room.
It is sold semi-furnished.
It is renovated and very well maintained.
It is a spacious home so you can enjoy it for vacations and for the whole year.
Central, 300 meters from the beach, next to all services.
Community: €360 per year
IBI: €293
[post_title] => 1143
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1143
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:02
[post_modified_gmt] => 2024-05-18 00:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1143/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 9197894
[post_author] => 0
[post_date] => 2024-05-18 01:10:02
[post_date_gmt] => 2024-05-18 00:10:02
[post_content] => It is a duplex penthouse located in the center of La Mata, facing south, 100 meters from the beach and next to all services.The house is very well maintained, it is sold furnished.On the main floor there is a living room, bathroom, kitchen, a bedroom and a south-facing terrace with side views of the sea.On the upper floor there are 2 bedrooms, a bathroom and a 25 m2 terrace with sea views.Community: €400 per yearIBI: €180
[post_title] => 621
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 621
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:02
[post_modified_gmt] => 2024-05-18 00:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/621/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 9197895
[post_author] => 0
[post_date] => 2024-05-18 01:10:02
[post_date_gmt] => 2024-05-18 00:10:02
[post_content] => It is an apartment located in La Mata, in the urbanization area. It has 1 bedroom, an independent kitchen, a large terrace where we can see the sea a bit.
The house has been renovated except for the kitchen.
It is a 2nd floor with elevator. It is sold furnished.
It has community parking for cars and community garden.300 meters from the beach.
Along with all services.
Community: €400 per year
IBI: €108
[post_title] => 1148
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1148
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:02
[post_modified_gmt] => 2024-05-18 00:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1148/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 9197896
[post_author] => 0
[post_date] => 2024-05-18 01:10:02
[post_date_gmt] => 2024-05-18 00: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] => 2024-05-18 01:10:02
[post_modified_gmt] => 2024-05-18 00: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
)
[11] => WP_Post Object
(
[ID] => 9197897
[post_author] => 0
[post_date] => 2024-05-18 01:10:02
[post_date_gmt] => 2024-05-18 00:10:02
[post_content] => It is an apartment located in the center of La Mata, just 200 meters from the downtown beach and next to all services.It has 2 bedrooms and 1 bathroom, a large American kitchen with a window, a spacious living room and a south-facing terrace with lots of light.69 m2 built2nd floor with elevatorCommunity: €260 yearIBI: €208
[post_title] => 1156
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1156
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:02
[post_modified_gmt] => 2024-05-18 00:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1156/
[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] => 9197908
[post_author] => 0
[post_date] => 2024-05-18 01:10:03
[post_date_gmt] => 2024-05-18 00:10:03
[post_content] => This home is located in the heart of the town of La Mata. It is a 1-bedroom ground floor with a front terrace and interior patio.
The house has approximately 40 m2 and is 200 meters from the beach.
Along with all services.
It is delivered furnished
Community: €120 per year
IBI: €85
[post_title] => 1194
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1194
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:10:03
[post_modified_gmt] => 2024-05-18 00:10:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1194/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3182
[max_num_pages] => 266
[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] => 2df694d18ce5a3e0ad2de7068d28a3c9
[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
