WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 328
[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] => mn_property
[2] => newbuilds
)
[paged] => 328
[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] => 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
(
)
[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 3924, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10566877
[post_author] => 0
[post_date] => 2025-06-24 01:05:03
[post_date_gmt] => 2025-06-24 00:05:03
[post_content] => This is a traditional style detached villa in central Quesada presented for sale in good condition with great potential.
The property offers a 3 bedoom and 2 bathroom accommodation with a traditional lounge layout, open plan kitchen and separate dining area accessed through classic double doors.
The property is situated on a good 500m2 corner plot within easy walking distance to the town centre. The gardens around the property are divided into a number of private seating areas with mature shrubs and trees all round. There is a vehicle access gate to a private attached garage. To the rear of the property is a lovely private pool area and outdoor kitchen.
Entrance to the property is via a large covered and glazed feature terrace, perfectly positioned on the south side of the property.
Entering the property in the large open lounge & kitchen area with traditional double doors opening into a spacious dining area currently used as an office space.
Through an archway from the lounge leads to two large double bedrooms and a family size bathroom.
Outside the property is a staircase that leads to a private roof terrace and access to a complete independent roof top apartment with large lounge area kitchen bedroom and bathroom.
Viewing is highly recommended to appreciate the potential this property has to offer.
[post_title] => VA5282
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5282
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:03
[post_modified_gmt] => 2025-06-24 00:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5282/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10566878
[post_author] => 0
[post_date] => 2025-06-24 01:05:03
[post_date_gmt] => 2025-06-24 00:05:03
[post_content] => Beautiful renovated 2 bedroom townhouse in the Filipinas area of Villamartin.
We present this immaculate townhouse, facing southwest, that has just been totally renovated and is to be sold as seen, with everything that is in the property.
There is garden/terrace areas at the front and the rear of the property, as well as a lovely roof terrace, all perfect for taking in the sun and outdoor dining.
Inside, there is an open plan living/dining room and kitchen area, as well as a toilet. Upstairs there are 2 double bedrooms and a shower room. Internal stairs lead up to the roof terrace.
The property is perfect for anyone wanting to move in and not do any work. It comes with extras such as air conditioning and having access to a communal pool.
[post_title] => VA5290
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5290
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:03
[post_modified_gmt] => 2025-06-24 00:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5290/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10566879
[post_author] => 0
[post_date] => 2025-06-24 01:05:03
[post_date_gmt] => 2025-06-24 00:05:03
[post_content] => This superb detached villa is presented for sale in excellent condition and has been maintained to an exceptional standard
The property offers as large 3 bedroom 2 bathroom accommodation situated on a good size 450m2 plot with plenty of outside space, private swimming pool and an integral garage along with off road parking space.
The entire property has been modernised and complete exterior recover.
There is a spacious curved covered front terrace to this property that has commanding views over the La Marquesa Golf course and on to the entire Vega baja.
Full length and full width glass doors from this terrace lead into an enlarged lounge / dining area and so keeping the panoramic views throughout. There is a separate kitchen off from the lounge and an archway leading to two double bedrooms and a family bathroom.
A door from the dining area opens into a master bedroom suite complete with ensuite.
Out side there is a stair access to a small roof terrace on one side of the villa with a separate stair access to a large curved front roof terrace enhancing the already amazing views available.
There is a private 10x5m swimming pool located in the front garden area taking full advantage of the sun and its location.
A door from the pool terrace next to the garage that opens into a vast under build area extending under the entire property divided into various rooms and into the garage. This gives excellent potential to be converted as required. All walls, ceilings and floors have already been prepared.
Viewing is highly recommended to appreciate the space and the views this property has to offer
[post_title] => VA5289
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5289
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:03
[post_modified_gmt] => 2025-06-24 00:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5289/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10566880
[post_author] => 0
[post_date] => 2025-06-24 01:05:03
[post_date_gmt] => 2025-06-24 00:05:03
[post_content] => This superb large detached villa is presented for sale in excellent condition and has been maintained to a very high standard.
The property offers a 4 bedroom, 3 bathroom accommodation distributed over two floors.
On the ground floor there is a large double open plan lounge area with multiple French doors in the curved lounge area opening out to the garden and pool area. A glazed door opens to a good size fully equipped kitchen with a separate door leading to the garden area outside.
A passageway leads to two large double bedrooms and a family size bathroom. There is a large understairs storage area too.
A grand staircase leads up to the first floor landing that has a glazed door to a small private terrace. One door opens into a visitor’s bedroom complete with en suite shower room and toilet. Another door opens into a very large master bedroom suite and exceptionally large en suite bathroom area. Patio doors open onto a large curved south facing sun terrace overlooking the pool, gardens and further towards the salt lakes. An additional staircase leads up to a solarium with excellent views.
The exterior of this property has plenty of out door space for off road covered parking, a 10x5 swimming pool and has the added advantage of a fully self- contained, covered and glass curtained outside kitchen facility.
The property faces due south benefiting from the sun and sits nicely at the end of a quiet cul-de-sac in the popular residential area of Pueblo Bravo.
Viewing is highly recommended
[post_title] => VA5291
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5291
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:03
[post_modified_gmt] => 2025-06-24 00:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5291/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10566881
[post_author] => 0
[post_date] => 2025-06-24 01:05:03
[post_date_gmt] => 2025-06-24 00:05:03
[post_content] =>
[post_title] => VA5293
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5293
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:03
[post_modified_gmt] => 2025-06-24 00:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5293/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10566882
[post_author] => 0
[post_date] => 2025-06-24 01:05:03
[post_date_gmt] => 2025-06-24 00:05:03
[post_content] => The property offers a spacious three bedroom, two bathroom, accommodation situated perfectly in the La Fiesta region of Quesada.
Entrance to the property is via a covered terrace overlooking the private front garden .
Inside there is a large open lounge with an adjoining glazed feature area used as a dining room. From the rear of the lounge there is access to a large kitchen, complete with a separate utility space. A door from the kitchen gives access to a good size rear patio garden and the open side of the plot.
Also from the rear of the lounge area is access to a large double bedroom and family size shower room.
A staircase leads up to the first floor landing and two very large double bedrooms each with their own private terraces. There is a lovely view to the salt lakes from the master bedroom terrace. A large family bathroom is situated between both bedrooms.
A large communal swimming pool and gardens is just a short walk from this property
Located close to the national park area, viewing is highly recommended.
[post_title] => VA5298
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5298
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:03
[post_modified_gmt] => 2025-06-24 00:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5298/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10566883
[post_author] => 0
[post_date] => 2025-06-24 01:05:03
[post_date_gmt] => 2025-06-24 00:05:03
[post_content] =>
[post_title] => VA5301
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5301
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:03
[post_modified_gmt] => 2025-06-24 00:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5301/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10566884
[post_author] => 0
[post_date] => 2025-06-24 01:05:03
[post_date_gmt] => 2025-06-24 00:05:03
[post_content] =>
[post_title] => VA5300
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5300
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:03
[post_modified_gmt] => 2025-06-24 00:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5300/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10566854
[post_author] => 0
[post_date] => 2025-06-24 01:05:02
[post_date_gmt] => 2025-06-24 00:05:02
[post_content] => These absolutely stunning Palatial style villas are presented for sale in impeccable condition and have been maintained to a standard which is second to none. These villas have everything you would ever expect from properties of this size and much more.
Palatial is the only description that can be attributed to these villas, there are 80 photographs that can describe these villas better than any words. These properties are beautifully positioned in the La Fiesta region of Quesada commanding spectacular views to the south, the lakes and the sea.
Viewing will be an incredible experience
[post_title] => VA3858
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va3858
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:02
[post_modified_gmt] => 2025-06-24 00:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va3858/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10566855
[post_author] => 0
[post_date] => 2025-06-24 01:05:02
[post_date_gmt] => 2025-06-24 00:05:02
[post_content] => This large 3 bed 2 bath villa sits perfectly on a 900m2 in the heart of Quesada and within walking distance to a range of amenities.
The villa itself faces south east and overlooks a private pool, complete with a jacuzzi, as well as a full outside summer kitchen and bar area. There is off road parking space for various cars. There are also 2 solariums that offer nice views of the lakes.
Inside it has been completely renovated and modernized, and offers extras such as ducted air conditioning throughout.
We recommend viewing this property to fully appreciate all it has to offer.
[post_title] => VA4675
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va4675
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:02
[post_modified_gmt] => 2025-06-24 00:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va4675/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10566856
[post_author] => 0
[post_date] => 2025-06-24 01:05:02
[post_date_gmt] => 2025-06-24 00:05:02
[post_content] => This superb large classic style villa is presented for sale in excellent condition and has been maintained to a very high standard.
Situated in the popular Pueblo Bravo área of Quesada the property is positioned perfectly, south facing on a 1300m2 plot with views to the lakes and onto the sea.
The large plot is divided into a selection of recreational and seating áreas with a large private swimming pool, terraces covered and open, jacuzzi spa, games área and a large detached garage. There is a fully equipped out door courtyard bar/ kitchen facility with some covered and open áreas complete with large dining table etc.
The property offers a very large family home with 5 bedrooms, 6 bathrooms with a games lounge all distributed over three floors.
On the ground floor facing the pool terrace is a self-contained apartment with lounge, kitchenette and bathroom. There is a door leading to a very large gaming área with full size snooker table and a further room with gaming equipment and pool table. There is also a toilet and shower room attached.
An external staircase leads to the main floor of this villa. Entrance is via a very large glazed terrace/ lounge área over looking the gardens and pool. Once inside there is a very large lounge with feature fire place, seperate dining área, seperate kitchen and utility área. There is a door that leads to two large double/ triple bedroom complete with ensuite bathrooms.
A closed in staircase leads up to the third floor where there are additional two large bedrooms and clssic style bathrooms patio doors from both bedroom open onto a shared terrace with exceptional views to the lakes.
Viewing is highly recommended as there are so many extras included in the superb detached large property
[post_title] => VA5007
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5007
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:02
[post_modified_gmt] => 2025-06-24 00:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5007/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10566857
[post_author] => 0
[post_date] => 2025-06-24 01:05:02
[post_date_gmt] => 2025-06-24 00:05:02
[post_content] => Words do not even begin to describe this property. If there ever was a “wow factor” then this is it.Viewing is a must, to really appreciate what this total renovated villa has to offer.Location … PerfectOrientation …perfectSize….. PerfectQuality of finish…. exemplary
[post_title] => VA5100
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5100
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:02
[post_modified_gmt] => 2025-06-24 00:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5100/
[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] => 10566877
[post_author] => 0
[post_date] => 2025-06-24 01:05:03
[post_date_gmt] => 2025-06-24 00:05:03
[post_content] => This is a traditional style detached villa in central Quesada presented for sale in good condition with great potential.
The property offers a 3 bedoom and 2 bathroom accommodation with a traditional lounge layout, open plan kitchen and separate dining area accessed through classic double doors.
The property is situated on a good 500m2 corner plot within easy walking distance to the town centre. The gardens around the property are divided into a number of private seating areas with mature shrubs and trees all round. There is a vehicle access gate to a private attached garage. To the rear of the property is a lovely private pool area and outdoor kitchen.
Entrance to the property is via a large covered and glazed feature terrace, perfectly positioned on the south side of the property.
Entering the property in the large open lounge & kitchen area with traditional double doors opening into a spacious dining area currently used as an office space.
Through an archway from the lounge leads to two large double bedrooms and a family size bathroom.
Outside the property is a staircase that leads to a private roof terrace and access to a complete independent roof top apartment with large lounge area kitchen bedroom and bathroom.
Viewing is highly recommended to appreciate the potential this property has to offer.
[post_title] => VA5282
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5282
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:05:03
[post_modified_gmt] => 2025-06-24 00:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5282/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3960
[max_num_pages] => 330
[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] => 599b8fa248e8be20374e44c0c56b12d3
[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:b21168ea984809a9b222569504612696:0.17842800 1752322971
)