WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 297
[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] => 297
[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 3552, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 9832961
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01: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] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01: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
)
[1] => WP_Post Object
(
[ID] => 9832962
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01:05:02
[post_content] => This superb exceptionally large, five bedroom three bathroom, colonial style family villa is presented for sale in excellent condition and has been maintained to a very high standard. This property offers a large 370 sqm living accommodation perfectly distributed over the three levels.
Situated on a large 850 sqm plot, this grand property commands superb views over the large beautifully landscaped gardens, feature private swimming pool and the local parkland area. A lovely, spacious, fully equipped garden kitchen offers the perfect outdoor life style available with this special villa.
Off road parking is also available and in keeping with the overall quality of finish and presentation of this superb villa
Viewing is highly recommended
[post_title] => VA3893
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va3893
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va3893/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 9832963
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01: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] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01: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
)
[3] => WP_Post Object
(
[ID] => 9832964
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01:05:02
[post_content] => Plot of land 550m2
Central Quesada
Ready for construction
[post_title] => VA4812
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va4812
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va4812/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 9832965
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01:05:02
[post_content] =>
[post_title] => VA4973
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va4973
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va4973/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 9832966
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01: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] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01: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
)
[6] => WP_Post Object
(
[ID] => 9832967
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01:05:02
[post_content] => This South Facing Apartment + Spanish Bar & Restaurant (FREEHOLD) in Benijofar is located in the heart of this bustling Spanish village. Situated just off the main road in a prominent position, with plenty of parking and passing trade. Close to many amenities and facilities.
The apartment can either be accessed via the spiral staircase from the commercial kitchen or via the front street door, leading in to the entrance and stairway, also used for additional storage; leading up to the first floor; comprising of an open plan lounge/dining room; a separate fully fitted kitchen with back door to the rear terrace; three double bedrooms, the master with a private covered terrace to the front, with open area + street views; and a modern, walk in family shower room. The rear terrace is an open space with several plants pots; storage space; utility area; access to the commercial kitchen below; and a set of external stairs to the extremely spacious private roof top solarium, ideal for BBQ’s and entertaining, with amazing views over the surrounding area, distant countryside and mountains; plus a storeroom up here also!
Extras are to include grills, air conditioning in the living room and 2 of the bedrooms, one set of fitted wardrobes and more…
The Restaurant + The Apartment have been modernized and updated in 2019. The Restaurant on the ground floor comprises of a modern flooring throughout with possibility of 40+ covers inside; a large fitted and Spanish style bar, with additional seating; a separate, very spacious, immaculate commercial kitchen with quality equipment and updates; two toilets, one for each gender; and a covered terrace to the front of the restaurant with gazebo + sun awnings, for around a further 16 covers… All quality and ready to go!
A superb opportunity and one not to be missed, with many other extras and info to be given, ideal for the right candidate! Don’t be too late, to take over this ready to go business & home
[post_title] => VA5050
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5050
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5050/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 9832968
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01:05:02
[post_content] => Brand new modern style villa in Almoradi with 3 bedrooms and 2 bathrooms. The property faces east on a 347m2 plot, that offers a private swimming pool, off road parking for 3 cars and plenty of space for outdoor dining and relaxing. It's very low maintainance too as all of the plot is tiled.
Inside, there is a large and bright open plan living/dining room and kitchen, with a separate utility room and laundry. A doorway leads through to a hallway that gives access to 2 double bedrooms, a smaller bedroom and 2 bathrooms. There is ducted hot and cold air conditioning throughout the house, separated with a machine for 2 separate areas, the bedrooms, and the living/dining room.
There is also a large solarium, the whole size of the house, with nice views of the area.
[post_title] => VA5055
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5055
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5055/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 9832969
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01:05:02
[post_content] => A 160m2 plot located in Rojales town centre, overlooking the River Segura. It is possible to build 100% of the plot size and also up to 3 levels.Perfect for a small townhouse or a small apartment block.The current owner also has a project planned for a small townhouse that can be used.
[post_title] => VA5097
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5097
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5097/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 9832970
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01:05:02
[post_content] => Ideally located in the heart of the town next to parks, facilities and amenities, this traditional bungalow has lots of potential with high ceilings, original features and a courtyard and solarium to enjoy the sunshine. The open plan kitchen and diner leads to the lounge area and further on to the bedrooms. There is plenty of scope to add further bedrooms or to redistribute the existing space to suit.
[post_title] => VA5023
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5023
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5023/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 9832971
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01:05:02
[post_content] =>
[post_title] => VA5114
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5114
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01:05:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5114/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 9832972
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01: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] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01: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] => 9832961
[post_author] => 0
[post_date] => 2024-11-21 01:05:02
[post_date_gmt] => 2024-11-21 01: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] => 2024-11-21 01:05:02
[post_modified_gmt] => 2024-11-21 01: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
)
[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] => 8f1e7d13e2701b9619c8156392b2b0cb
[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
)
)