WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 2
[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] => 2
[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 12, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 9143936
[post_author] => 0
[post_date] => 2024-04-30 11:30:06
[post_date_gmt] => 2024-04-30 10:30:06
[post_content] => Stunning detached villa in Ciudad Quesada very close to the Recorral park.
This villa is situated on a 500 sqm plot and has a build size of 213 sqm. The property is split over two levels. On the main floor, it offers a large living room area, a separate kitchen and a seperate dining rooms. There are also three double bedrooms and two bathrooms, one being en/suite in the master bedroom. On the lower floor and with a completely separate access there is an apartment, that is made up of a living area with a kitchen, bathroom and a large bedroom.
Outside, the villa offers a large swimming pool surrounded by lovely seating and dining areas. Entrance to the property is through a covered terrace that has also been glazed-in, but with fold back glass so it can be opened up as well. The villa also has a solarium, with amazing views of the Recorral park, and even the salt lakes in the distance.
We fully recommend viewing this property that is to be sold fully furnished and comes with extras such as a garage, air conditioning, solarium and a swimming pool.
[post_title] => VA5130
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5130-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:06
[post_modified_gmt] => 2024-04-30 10:30:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5130-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 9143939
[post_author] => 0
[post_date] => 2024-04-30 11:30:06
[post_date_gmt] => 2024-04-30 10:30:06
[post_content] => Here we have a large 3 bedroom 2 bathroom semi detached villa sitting on a lovely corner plot that has plenty of outdoor as well as indoor space.The property faces east at the front, and west at the back, so you have sun and shade all day long in the U shaped garden. Inside the property has a spacious living/dining room, a separate kitchen with a back door, a shower room and a double bedroom on the ground floor.Upstairs there are 2 great sized double bedrooms and a massive bathroom complete with a bath and a shower. There are also 2 terraces, one being private for the main bedroom.The garage is a great size, big enough for a car and storage. There is also room on the drive for a car without putting it in the garage.The property has access to a lovely communal pool and garden area to the rear of the property.There are plenty of extras such as mains gas central heating throughout as well as air conditioning. The property is sold furnished.
[post_title] => VA5137
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5137-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:06
[post_modified_gmt] => 2024-04-30 10:30:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5137-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 9143929
[post_author] => 0
[post_date] => 2024-04-30 11:30:06
[post_date_gmt] => 2024-04-30 10:30:06
[post_content] =>
[post_title] => VA5114
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5114-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:06
[post_modified_gmt] => 2024-04-30 10:30:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5114-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 9143923
[post_author] => 0
[post_date] => 2024-04-30 11:30:06
[post_date_gmt] => 2024-04-30 10:30:06
[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-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:06
[post_modified_gmt] => 2024-04-30 10:30:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5097-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 9143934
[post_author] => 0
[post_date] => 2024-04-30 11:30:06
[post_date_gmt] => 2024-04-30 10:30:06
[post_content] => A twenty minute walk from the centre of Ciudad Quesada, this detached, 2 bedroom 2 bathroom villa has private parking, a large, extended solarium and access to a gorgeous communal pool. Open plan living/dining area, one double bedroom, a bathroom and separate kitchen with utility room are all on the ground floor. Upstairs are the main bedroom, bathroom and solarium. A lovely property in a sought after area of Ciudad Quesada, this is one to view as soon as you can.
With a population of around thirteen thousand, Ciudad Quesada is situated in the Southeastern part of the Valencian region within the province of Alicante. Founded as an urbanisation in the 1970s by local entrepreneur Justo Quesada, Ciudad Quesada is now one of the most vibrant and well-known towns in the South of the Alicante province.
Over the last fifty or so years, it has proven popular with both tourists and ex-patriots resulting in what is today, a thriving multi-cultural community. A large part of Ciudad Quesada’s success is down to its location; it’s forty minutes by car from Alicante city centre, thirty from El Altet airport, about an hour from Murcia’s new Corvera airport and is serviced by the Mediterranean Motorway, the AP-7, which stretches the length of Spain’s Mediterranean coast. The regional capital, Valencia, is approximately two and a half hours away by car, whilst Murcia city centre is somewhat closer and can be reached in about forty-five to fifty minutes.
As one may expect, Ciudad Quesada is something of a cultural melting pot in almost every aspect of its existence. Local business is no exception; the British, Irish, Dutch, Belgian, German and Scandinavian populations are represented in many of the local businesses such as restaurants, bars, hair and beauty salons, gyms, estate agencies, legal firms, furniture stores, builders, electricians, butchers, bakers and yes, probably candlestick makers!
Over the past few years, Ciudad Quesada and the surrounding towns have seen massive investment in their infrastructure. As recently as summer 2020, an extensive project to re-modernise Avenida de las Naciones (effectively Ciudad Quesada’s “High Street”) was completed making the area even more accessible to tourists and locals alike as well as improving things for local businesses. Other very recent projects have included the construction of large supermarkets, new shopping centres, the development and expansion of local park areas, large scale road resurfacing and the construction of numerous cycle paths.
[post_title] => VA5128
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5128-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:06
[post_modified_gmt] => 2024-04-30 10:30:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5128-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 9143937
[post_author] => 0
[post_date] => 2024-04-30 11:30:06
[post_date_gmt] => 2024-04-30 10:30:06
[post_content] => We are delighted to present a good quality, typical Spanish house, with a plot of more than 2.000 m2!
Set in one of the popular streets in Ciudad Quesada, the house is located 10 min walk from the center, and a short walk to pharmacy, medical enter, bars and restaurants.
At the entrance to the house there is a spacious sunlit conservatory that connect with the kitchen and rest of the house. The house is on one level, and consist of 3 bedrooms, 3 bathrooms, and the fourth bathroom outside. The main bedroom have a good size bathroom.
In the garden you find olive trees, pine trees and fruit trees. The private pool of 10x5m have sun all day.
There is 3 entrances to the garden, and the plot could be divided if needed.
- Aircontition in all rooms
- Reformed in 2019
- Basement
- Storage
- Lights in the pool
- Water filter
[post_title] => VA5131
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5131-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:06
[post_modified_gmt] => 2024-04-30 10:30:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5131-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 9143932
[post_author] => 0
[post_date] => 2024-04-30 11:30:06
[post_date_gmt] => 2024-04-30 10:30:06
[post_content] => Beautiful villa in a quiet area of Ciudad Quesada.
The house consists of 3 bedrooms, 2 bathrooms with underfloor heating, build in terrasse and independent kitchen. From the conservatory there is direct access to the garden. The villa is on one level, and the plot is 504m2 with a private swimmingpool. In the garden there is a conservatory, with glass so you can look directly out to the lovely pool area.
At the entrance to the property there is space for 1 car, and it's possible to park in the street.
There is a large terrace at the entrance with table and chairs. The house is nicely furnished.
- Storage
- Pool has newly been grouted.
Walking distance to everything! Restaurants, bars, shops, tennis courts, fitness centre, hiking areas, etc.
Really worth seeing!
[post_title] => VA5120
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5120-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:06
[post_modified_gmt] => 2024-04-30 10:30:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5120-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 9143909
[post_author] => 0
[post_date] => 2024-04-30 11:30:05
[post_date_gmt] => 2024-04-30 10:30:05
[post_content] =>
[post_title] => VA4973
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va4973-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:05
[post_modified_gmt] => 2024-04-30 10:30:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va4973-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 9143911
[post_author] => 0
[post_date] => 2024-04-30 11:30:05
[post_date_gmt] => 2024-04-30 10:30:05
[post_content] => This large detached villa is presented for sale in good condition and has been maintained well.
The property offers a spacious living accommodation with a large underbuild área currently used as a storage facility. Access to this large underbuil is via the integral garage siutable for at least 2 vehicles. From this garage there are two individual doors opening into other large rooms and further again to other áreas under the property. There is a shower room and toilet accessed from one of the underbuild rooms. Potencial to convert to a seperate living área is very good.
Entrance to the main level is via a small staircase and porch to the front door. There is a large lounge and dining área complete with feature fireplace. Large Windows in the lounge command some excellent views to the mountains and over the vega baja. A door from this lounge opens into a very large kitchen diner and an archway gives Access to two double bedrooms with ensuite to the master bedroom and a family size bathroom.
Outside the villa is a large 600m2 plot with tres shrubs and plants of all kinds. A large swinmming pool has lovely views to the mountains.
Viewing is highly recommended
[post_title] => VA5026
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5026-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:05
[post_modified_gmt] => 2024-04-30 10:30:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5026-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 9143912
[post_author] => 0
[post_date] => 2024-04-30 11:30:05
[post_date_gmt] => 2024-04-30 10:30:05
[post_content] => This superb detached 2 bed 2 bath villa is presented for sale in excellent condition and has been maintained to a very high standard.
The property is situated in the upper golf región of Quesada on a Good size plot with private off road parking and ample out door terrace space.
The villa offers a spacious lounge área following previous extentions incorporating the original terrace into the lounge área.
From the lounge is an archway into a bright fitted kitchen with rear door to the garden . Another archway gives access to two double bedrooms, with ensuite to the master bedroom and a family size bathroom.
There is a roof terrace with lovely views to the local área
There are a good selection of storage cupboards around the property for utilities and general storage uses.
Viewing is highly recommended
[post_title] => VA5028
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5028-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:05
[post_modified_gmt] => 2024-04-30 10:30:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5028-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 9143907
[post_author] => 0
[post_date] => 2024-04-30 11:30:05
[post_date_gmt] => 2024-04-30 10:30:05
[post_content] =>
[post_title] => VA4921
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va4921-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:05
[post_modified_gmt] => 2024-04-30 10:30:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va4921-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 9143913
[post_author] => 0
[post_date] => 2024-04-30 11:30:05
[post_date_gmt] => 2024-04-30 10:30:05
[post_content] => This large detached villa is presented for sale in Good conditionand is located in the town centre of Quesada, just a few minutes walk from all the amenities.
The property offers a 3 bed 2 bath accommodation, private 6x4 swimming pool situated on a large 840m2 corner plot with views to the lakes.
There is a very large underbuild área not yet developed but with great potential. There is a Good Off road parking área and a garage built in under the property.
There is also a large roof terrace with views to the lakes and to the sea.
Viewing is highly recommended
[post_title] => VA5044
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5044-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:05
[post_modified_gmt] => 2024-04-30 10:30:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5044-2/
[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] => 9143936
[post_author] => 0
[post_date] => 2024-04-30 11:30:06
[post_date_gmt] => 2024-04-30 10:30:06
[post_content] => Stunning detached villa in Ciudad Quesada very close to the Recorral park.
This villa is situated on a 500 sqm plot and has a build size of 213 sqm. The property is split over two levels. On the main floor, it offers a large living room area, a separate kitchen and a seperate dining rooms. There are also three double bedrooms and two bathrooms, one being en/suite in the master bedroom. On the lower floor and with a completely separate access there is an apartment, that is made up of a living area with a kitchen, bathroom and a large bedroom.
Outside, the villa offers a large swimming pool surrounded by lovely seating and dining areas. Entrance to the property is through a covered terrace that has also been glazed-in, but with fold back glass so it can be opened up as well. The villa also has a solarium, with amazing views of the Recorral park, and even the salt lakes in the distance.
We fully recommend viewing this property that is to be sold fully furnished and comes with extras such as a garage, air conditioning, solarium and a swimming pool.
[post_title] => VA5130
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5130-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-30 11:30:06
[post_modified_gmt] => 2024-04-30 10:30:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5130-2/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3214
[max_num_pages] => 268
[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] => 7c2065678c0eecbba82a6676b1fea994
[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
3
4
