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] => 9100470
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[post_content] => A superb large detached villa in the centre of Quesada is presented for sale in excellent condition and has been maintained to a very high standard. The property offers a spacious 3 bedrooms 3 bathrooms accommodation distributed over 2 floors with an added bonus of a vast basement area currently used for storage accessed from inside the main property.
The property is located just a few hundred meters from the main street in Quesada, situated on a 500m2 plot and has a desired south facing aspect for the sun.
The property has off road, under cover parking space beautiful selection of terraced areas and a sun terrace around a large private shaped swimming pool. Also, there is an exceptional outdoor kitchen / dining area fully glazed for use all year round, complete with outside toilet facilities.
Entrance to the main ground floor level is via an open terrace overlooking the pool area through glazed French doors opening into a large lounge area with a designated dining area. There is a separate kitchen. Two large double bedrooms all with ensuite bathrooms.
A curved staircase leads up to a master bedroom again with ensuite bathroom and a private sun terrace.
Also from the ground floor is a curved staircase leading down to a vast basement area which has great potential, but currently used as a storage area.
Viewing is highly recommended
[post_title] => VA5102
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5102-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5102-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 9100472
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[post_content] => A semi detached one level villa is presented for sale in excellent condition and has been maintained to a high standard. The property offers a spacious 2 bedrooms 1 bathroom accommodation with a large lounge /diner and open plan kitchen. From the kitchen is a glazed door opening into a covered utility room and storage area.
To the front of the property is a large covered terrace area, complete with Glass curtains currently used as a dining area.
A staircase from the front patio garden leads up to a very large solarium complete with a solid wooded pergola for shade.
The property is in walking distance to a selection of amenities and also has a large community pool and garden area close by.
There is private off road parking available if needed
[post_title] => VA5105
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5105-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5105-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 9100473
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[post_content] => This superb end of terrace Townhouse is presented for sale in excellent condition and has been maintained to a very high standard. The property offers a spacious 4 bedrooms 2 bathrooms accommodation, distributed over two floors. There is a large, bright lounge / diner and separate kitchen with a door to a large double bedroom suite ( garage conversion ) and a door to another double bedroom, a separate bathroom and utility room.
A staircase leads to a large landing with access to 2 further double bedrooms and a very large bathroom suite. Patio doors from this landing open onto a good size terrace and this is also joined to the large master bedroom terrace to the front of the property.
As this property is an end of terrace there is excellent out door space with a selection of seating areas available. To the front is an elevated front covered terrace taking full advantage of the south facing aspect.
A private gate from the rear of the property leads to the communal swimming pool and gardens
[post_title] => VA5108
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5108-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5108-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 9100469
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[post_content] => Here we have a lovely 2 bedroom, 1 bathroom semi detached villa located near the La Marquesa golf course in Ciudad Quesada.
The property is located just inside a safe gated community, that has a communal pool that had all the tiles repaired. The villa sits on a spacious 199m2 plot, that offers plenty of garden space to enjoy the sun all year round, as well as having plenty of storage space, and a solarium upstairs that is a sun trap with nice views of the surrounding area and the Recorral park.
Inside, the entrance is through a covered terrace, that has been glazed in with folding windows, giving the option to have a closed conservatory or an open terrace. Inside the front door opens into a living/dining room with an archway that leads into a good size kitchen. The kitchen has a back door out into a utility area and into the back garden.
A further archway from the living room leads to the 2 double bedrooms and a bathroom.
There is a pellet burner and air conditioning in the living area and the house is sold part furnished.
[post_title] => VA5099
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5099-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5099-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 9100456
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[post_content] => The villa sits perfectly south facing on a massive 1150 plot, just a 5 minute walk to the high street of Ciudad Quesada.
The property needs a bit of updating and TLC, but is a unique opportunity to produce a stunning villa in a very sought after area.
There is plenty of outdoor space, both garden and also seating and dining areas, as well as 2 driveways, one that leads to the garage. There is also a very large private swimming pool, with a covered bar and barbecue area.
Inside the property is very spacious with large rooms. Entrance is into a large open plan living/dining room and kitchen area. Doors lead of to 3 bedrooms and a bathroom.
There is also a separate accomodation with a bedroom and a toilet.
[post_title] => VA4942
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va4942-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va4942-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 9100459
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[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-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5050-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 9100468
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[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-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5097-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 9100457
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[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-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5044-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 9100455
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[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-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5028-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 9100450
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[post_content] => This superb 2 bedroom, 2 bathroom, detached villa is presented for sale in excellent condition and has been maintained to a very high standard.
The property offers a spacious lounge diner, American style, breakfast bar kitchen, two large bedrooms, master bedroom complete with ensuite bathroom and a family size, seperate bathroom.
French doors from the lounge open onto a large sun terrace with views to the lakes.
The property is situated on a nice elevated plot with ample room for off road parking and has a private swimming pool, all within easy reach of local bars and restaurants.
The property has just recently had new garage door gates and personal entrance gate, new swimming pool pump and a variety of other things such as oven , exterior lights etc.
Viewing is highly recommended
[post_title] => VA4984
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va4984-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va4984-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 9100454
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[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-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5026-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 9100458
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[post_content] => We are pleased to introduce this attractive 3 bedroom 2 bathroom villa standing on a ample 647 m2 private plot with enough room for a swimming pool. The villa is located very close to the Norwegian school and all amenities in the Ciudad Quesada centre.
[post_title] => VA5043
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5043-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5043-3/
[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] => 9100470
[post_author] => 0
[post_date] => 2024-04-17 23:31:48
[post_date_gmt] => 2024-04-17 22:31:48
[post_content] => A superb large detached villa in the centre of Quesada is presented for sale in excellent condition and has been maintained to a very high standard. The property offers a spacious 3 bedrooms 3 bathrooms accommodation distributed over 2 floors with an added bonus of a vast basement area currently used for storage accessed from inside the main property.
The property is located just a few hundred meters from the main street in Quesada, situated on a 500m2 plot and has a desired south facing aspect for the sun.
The property has off road, under cover parking space beautiful selection of terraced areas and a sun terrace around a large private shaped swimming pool. Also, there is an exceptional outdoor kitchen / dining area fully glazed for use all year round, complete with outside toilet facilities.
Entrance to the main ground floor level is via an open terrace overlooking the pool area through glazed French doors opening into a large lounge area with a designated dining area. There is a separate kitchen. Two large double bedrooms all with ensuite bathrooms.
A curved staircase leads up to a master bedroom again with ensuite bathroom and a private sun terrace.
Also from the ground floor is a curved staircase leading down to a vast basement area which has great potential, but currently used as a storage area.
Viewing is highly recommended
[post_title] => VA5102
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5102-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 23:31:48
[post_modified_gmt] => 2024-04-17 22:31:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5102-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3432
[max_num_pages] => 286
[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
)
)