WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 1
[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] => 1
[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 0, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 9191408
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[post_content] => A detached villa with 6 bedrooms and 3 bathrooms is presented for sale in excellent condition and has been maintained to a very high standard.
The property is located the central area of Ciudad Quesada just a few mins walk from the town centre and just a few hundred meters from the variety of amenities of the Doña Pepa development.
The property sits on a large 770m2 plot with the 232m2 construction taking full advantage of the south facing aspect.
Large open gardens and paved terraces surround the property with a large private swimming pool and plenty of off road parking available. There is a large roof terrace with excellent views over the surrounding areas.
Inside, this property offers a spacious open plan accommodation with 4 double bedrooms and 2 bathrooms with a completely separate annex consisting of 2 bedrooms and one bathroom.
The interior finish of the property is a very high quality and modern fitted kitchens.
Viewing is highly recommended as this property has many extras and the size must be seen to really appreciate
[post_title] => VA5112
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5112-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5112-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 9191409
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[post_content] =>
[post_title] => VA5114
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5114-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5114-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 9191412
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[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-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5120-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 9191407
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[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-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[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
)
[4] => WP_Post Object
(
[ID] => 9191413
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[post_content] => LOCAL CIUDAD QUESADA SALE OR RENT
Its location is unbeatable, surrounded by multiple shops and services together with the Gama Supermarket, Health Center, El Canal Pharmacy, La Laguna Hotel, Sabadell Bank, International Ophthalmology Center, Euromarina sales offices, Consum Supermarket, restaurants, hairdressers, cafeterias,... and also with easy access, parks and parking areas. Southeast orientation which gives it light all day.
What are you waiting for, make your dream come true and start your own business in a safe enclave in continuous expansion on our coast.
Ask us we will be happy to assist you.
[post_title] => VA5123
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5123-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5123-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 9191403
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[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-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[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
)
[6] => WP_Post Object
(
[ID] => 9191402
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[post_content] => This south facing 2 bedroom 1 bathroom has just hit the market and is sure to be a hit straight away.The property has a spacious front garden that will get sun all day and all year round, complete with garden areas as well as a stone bbq.A few steps lead up into a glazed in terrace area, which then leads into an open plan living room and kitchen area. An archway leads through to the 2 double bedrooms and bathroom. There is also a patio/gallery area ideal for the washing machine.The bungalow is to be sold furnished and benifits from not being on a community. The municipal swimming pool that is open in the summer months is just a 5 minute walk away, as well as having bars and shops within a 5 minute walk.
[post_title] => VA5092
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5092-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5092-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 9191411
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[post_content] => This superb Townhouse is presented for sale in excellent condition and has been maintained to a very high standard.
This property offers a spacious modern 2 bedroom, 1 bathroom accommodation within easy access to a variety of amenities.
There are many extras to this property and viewing is highly recommended.
Well maintained home in compound of 26 homes (all painted in 06/23)
Parking space car in front of house (not on the street)
Entrance with security door and intercom
Separate toilet (ground floor) and toilet in the bathroom upstairs
Aircon with split circuits for both levels
Infrared heating with thermostat in living room and kitchen (06/21)
All windows have fly screens & strong grills
Ceiling fans with remote control in living room and master bedroom (08/21)
Sliding windows with lock (living room and bedrooms)
Blinds windows bedrooms
New water boiler BOSCH (09/23)
Washing machine and dryer in good condition
Renovated kitchen, fully equipped with new appliances (oven, dishwasher,induction plate) (11/22)
New tiled floors on the rear terrace and front driveway (03/
[post_title] => VA5116
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5116-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5116-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 9191405
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[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-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[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
)
[9] => WP_Post Object
(
[ID] => 9191410
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[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-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5100-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 9191406
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[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] => 5023
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5023-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/5023-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 9191404
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[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-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[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
)
)
[post_count] => 12
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 9191408
[post_author] => 0
[post_date] => 2024-05-15 23:30:35
[post_date_gmt] => 2024-05-15 22:30:35
[post_content] => A detached villa with 6 bedrooms and 3 bathrooms is presented for sale in excellent condition and has been maintained to a very high standard.
The property is located the central area of Ciudad Quesada just a few mins walk from the town centre and just a few hundred meters from the variety of amenities of the Doña Pepa development.
The property sits on a large 770m2 plot with the 232m2 construction taking full advantage of the south facing aspect.
Large open gardens and paved terraces surround the property with a large private swimming pool and plenty of off road parking available. There is a large roof terrace with excellent views over the surrounding areas.
Inside, this property offers a spacious open plan accommodation with 4 double bedrooms and 2 bathrooms with a completely separate annex consisting of 2 bedrooms and one bathroom.
The interior finish of the property is a very high quality and modern fitted kitchens.
Viewing is highly recommended as this property has many extras and the size must be seen to really appreciate
[post_title] => VA5112
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5112-3
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-15 23:30:35
[post_modified_gmt] => 2024-05-15 22:30:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5112-3/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3220
[max_num_pages] => 269
[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] =>
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => d691754cf933d9d7b1e648ba8669bd72
[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
6
