WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 294
[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] => 294
[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 3516, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 9833005
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[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] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[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
)
[1] => WP_Post Object
(
[ID] => 9833006
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[post_content] => It is a home located on the 4th floor of the building. DONT HAVE A ELEVATOR
It has a constructed area of 68 m2 distributed in a living-dining room, a separate kitchen with a gallery, 2 bedrooms, 1 bathroom and a large terrace with sea views.Southeast orientation.Just 200 meters from the downtown beach and next to all services. Ideal location.The house is sold furnished.Optional very large garage: €18,000Community: €160 per yearIBI: €141
[post_title] => 1202
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1202
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1202/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 9833007
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[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.
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] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[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
)
[3] => WP_Post Object
(
[ID] => 9833008
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[post_content] => This is a Bungalow located in Altos de la Bahía with a 27 m2 terrace with barbecue.
The house has 60 m2 according to a simple note distributed in a large living room, separate kitchen with gallery, 1 full bathroom and 2 bedrooms.It is sold furnished and is in perfect condition, ready to move into.Just 600 meters from the sea and next to all services.Community pool and parking areaCommunity: €200 per yearIBI: €168
[post_title] => 1204
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1204
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1204/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 9833009
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[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] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[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
)
[5] => WP_Post Object
(
[ID] => 9833010
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[post_content] => This is a duplex bungalow located in the Balcón de la Rosaleda (Los Frutales), in a private urbanization with 2 communal pools.Just 600 meters from the coves of Torrevieja.The house has a total area of about 100 m2 including the house and terraces.On the main floor we have independent access from the street to our 23 m2 porch, once inside we find the living-dining room, the kitchen, a bedroom and a toilet.On the first floor we have a full bathroom and 2 bedrooms, one of them with access to a small terrace.Above we have a small storage room and a solarium with a little sea view.East facingCommunity: €500 per year
[post_title] => 1216
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1216
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1216/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 9833011
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[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] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[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] => 9833012
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[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] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[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] => 9833013
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[post_content] => This is a house located in the private urbanization of Viñamar 6. Just 300 meters from the beach and in the best area of La Mata.
The house has 60 m2 distributed in a living room, 2 bedrooms, 1 full bathroom, an open-plan kitchen and a large north-facing terrace overlooking the community pool of the urbanization.
It is located on the 2nd floor and has 2 elevators.
It is in perfect condition, ready to move into, the sellers have taken very good care of it.
The house has an optional closed garage.
Optional Garage: €20,000
Community: €530 per year
IBI: €186
[post_title] => 1219
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1219
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1219/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 9833014
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[post_content] => It is a house located in La Mata just 200 meters from the best beaches in a quiet residential area.
The house has 57 m2 distributed in 2 bedrooms, open-plan kitchen, living room, 1 bathroom and a north-facing terrace with sea views.
It is completely renovated, impeccable.
Equipped with air conditioning and heating
Communal pool
3rd floor with elevator
Community: €400 per year
IBI: €146
[post_title] => 1220
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 1220
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/1220/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 9832996
[post_author] => 0
[post_date] => 2024-11-21 01:10:02
[post_date_gmt] => 2024-11-21 01: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-11-21 01:10:02
[post_modified_gmt] => 2024-11-21 01: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
)
[11] => WP_Post Object
(
[ID] => 9832997
[post_author] => 0
[post_date] => 2024-11-21 01:10:02
[post_date_gmt] => 2024-11-21 01: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-11-21 01:10:02
[post_modified_gmt] => 2024-11-21 01: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
)
)
[post_count] => 12
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 9833005
[post_author] => 0
[post_date] => 2024-11-21 01:10:03
[post_date_gmt] => 2024-11-21 01:10:03
[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] => 2024-11-21 01:10:03
[post_modified_gmt] => 2024-11-21 01:10:03
[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
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3570
[max_num_pages] => 298
[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] => 991fc6496fb031849be3e07c15e5ea09
[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
)
)