WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 264
[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] => 264
[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 3156, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 9197863
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[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
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5043/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 9197864
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[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-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[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
)
[2] => WP_Post Object
(
[ID] => 9197865
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[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-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[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
)
[3] => WP_Post Object
(
[ID] => 9197866
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[post_content] => This "modern" style ground floor apartment overlooks a beautiful communal swimming pool and garden area, and offers a lovely 121m2 plot to enjoy the sunshine.
The property itself has 82m2 and is distributed into a spacious living/dining room and open plan kitchen area, with patio doors leading out to the terrace and garden area overlooking the pool. There are also 2 bedrooms and 2 bathrooms, 1 being en suite to the main bedroom. There are patio doors from the bedrooms out to another garden area, complete with off road parking and a large storage shed.
The property has air conditioning throughout and there is a possibility to negotiate the high quality furniture.
[post_title] => VA5056
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5056
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5056/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 9197867
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[post_content] => This superb Villa Golf style property is presented for sale in excellent condition and has been maintained to a very high standard.
The property offers a detached, two bedrooms, one bathroom villa on a good size plot with private swimming pool. The property is located in a quiet cul-de-sac in the upper golf region of Quesada with lovely views to the mountains and across the Vega Baja.
The property has a large front covered terrace overlooking the pool and a staircase leading to a private solarium with again views to the mountains.
Inside, the property offers a nice lounge / diner with a separate kitchen. An archway leads to the two double bedrooms and family size bathroom. The quality and finish to the interior of this property is very good.
To the rear of the property is a door opening into a large under build / storage area finished and currently used as extra rooms.
Viewing is highly recommended to really appreciate the potential on offer with this property
[post_title] => VA5080
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5080
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5080/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 9197868
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[post_content] => The first thing to note about this beautiful & well maintained property is that it is the perfect choice for someone who wants the beauty and quality of a new build property but without the wait for one to be built. It is a fantastic 3 bed 3 bath house with lots of outside space, and it is sold as seen. With all furniture, televisions and even kitchen appliances down to the cutlery and kettle (high standard brand, SMEG). The best start to owning a beautiful Spanish home is to own a modern home that is ready to go!
[post_title] => VA5085
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5085
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5085/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 9197869
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[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-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[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
)
[7] => WP_Post Object
(
[ID] => 9197870
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[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
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5099/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 9197871
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[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
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5102/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 9197872
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[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
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/5023/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 9197873
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[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
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5108/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 9197874
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[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
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5112/
[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] => 9197863
[post_author] => 0
[post_date] => 2024-05-18 01:05:04
[post_date_gmt] => 2024-05-18 00:05:04
[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
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-18 01:05:04
[post_modified_gmt] => 2024-05-18 00:05:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5043/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3182
[max_num_pages] => 266
[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] => e54b0b9e880d058c71d26c73d5010147
[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
2
3
