WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 295
[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] => 295
[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 3528, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 9832998
[post_author] => 0
[post_date] => 2024-11-21 01:10:02
[post_date_gmt] => 2024-11-21 01:10:02
[post_content] => It is a duplex penthouse located in the center of La Mata, facing south, 100 meters from the beach and next to all services.The house is very well maintained, it is sold furnished.On the main floor there is a living room, bathroom, kitchen, a bedroom and a south-facing terrace with side views of the sea.On the upper floor there are 2 bedrooms, a bathroom and a 25 m2 terrace with sea views.Community: €400 per yearIBI: €180
[post_title] => 621
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 621
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:10:02
[post_modified_gmt] => 2024-11-21 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/621/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 9832973
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => This unique detached villa is oozing charm and character and sits on a very large, tranquil plot.The grounds are accessed via large gates. The garden is low maintenance and has a lot of established shrubs and plants. There is ample parking space for several cars or even a motor home. The back of the property has a beautiful seating area with views over the pine forest. Part of the forest belongs to the property but can not be built on as it is protected land. Also at the back of the property is a pool area. The pool has been constructed but not finished, meaning the new owner can finish it to their own taste and design.The main feature of the villa is the lounge. It is the central hub of of the property and has a vaulted ceiling. A corridor surrounds the lounge and gives access to all of the other rooms.There is a very large, separate kitchen which leads to a utility room.There are 5 double bedrooms and 4 bathrooms.All of the main rooms in the villa have hot and cold air-conditioning to cater for the hot and cooler months. There are solar panels on the roof for hot water.You could move straight into this delightful property as it is being sold mostly furnished throughout.Montemar is a very popular urbanization on the outskirts of Algorfa village. From the property you can walk to the Algofra Hotel which hosts regular live entertainment and also has a small convenience store and bakery. Within a few minutes walking you can find the many bars and restaurants on the La Finca Golf Resort.If you are looking to invest in a family sized home in a sought after location then this could be for you.We highly recommend you visit this property to fully appreciate the full extent of what is being offered. Contact us to arrange your viewing appointment,
[post_title] => VA5133
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5133
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5133/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 9832974
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => This superb large detached villa is presented for sale in excellent condition and has been maintained to a very high standard.
The property offers a 4 bedroom, 3 bathroom accommodation distributed over two floors.
On the ground floor there is a large double open plan lounge area with multiple French doors in the curved lounge area opening out to the garden and pool area. A glazed door opens to a good size fully equipped kitchen with a separate door leading to the garden area outside.
A passageway leads to two large double bedrooms and a family size bathroom. There is a large understairs storage area too.
A grand staircase leads up to the first floor landing that has a glazed door to a small private terrace. One door opens into a visitor’s bedroom complete with en suite shower room and toilet. Another door opens into a very large master bedroom suite and exceptionally large en suite bathroom area. Patio doors open onto a large curved south facing sun terrace overlooking the pool, gardens and further towards the salt lakes. An additional staircase leads up to a solarium with excellent views.
The exterior of this property has plenty of out door space for off road covered parking, a 12x6 swimming pool and has the added advantage of a fully self- contained, covered and glass curtained outside kitchen facility.
The property faces due south benefiting from the sun and sits nicely at the end of a quiet cul-de-sac in the popular residential area of Pueblo Bravo.
Viewing is highly recommended
[post_title] => VA4983
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va4983
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va4983/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 9832975
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => This superb 7 bedrooms 4 bathrooms villa is presented for sale in excellent condition and has been maintained to a very high standard.
The main upper floor of the property has 3 double bedrooms and 2 bathrooms, large open plan lounge / diner with a good size kitchen and breakfast bar. Glazed doors open from the lounge area to an elevated glass curtained terrace overlooking the gardens swimming pool and park area.
The basement area has a completely self- contained apartment with 4 bedrooms, 2 bathrooms Kitchen and lounge area. There is a private access door allowing numerous possibilities to the use of this additional property.
Out side are lovely terraced gardens with fruit trees and shrubs. The lower level has a large swimming pool and seating areas.
The property faces south and has a roof terrace with views to the salt lakes.
There are two gated off road parking areas to the rear of this property.
Viewing is highly recommended
[post_title] => VA5141
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5141
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5141/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 9832983
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => A superb 2 bedroom 1 bathroom apartment that has been totally refurbished to a very high quality is presented for sale in a popular location in the Quesada development.
The property is located close to all amenities and is only a short walk from the town centre.
The property comes fully furnished and including access to a private parking area for this apartment block
Viewing is highly recommended
[post_title] => VA5179
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5179
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5179/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 9832984
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => This superb semi-detached bungalow is presented for sale in excellent condition and has been maintained to a very high standard.
The property offers a spacious 3 bedrooms 1 bathroom accommodation all on one level, beautiful private garden and terrace space ideal for all outdoor living. There is a large roof terrace that overlooks the communal pool and gardens to the front of the property.
Inside the bungalow, via the front covered terrace, is a nice open lounge/ diner area complete with feature fire place. Access to the 3 bedrooms with master bedroom en suite and family bathroom is from the lounge. Also, a separate kitchen that has a door to a good size private rear patio area.
As being a semi- detached property, there is a passageway along the side of the property with access stairs to the large solarium and under stairs storage cupboard. The passage way links the front and back gardens together allowing easy access between the two.
Parking is in a private allocated area for the community and is just steps away from the entrance to the property. The front garden gate opens onto the beautiful communal gardens and swimming pool.
Viewing is highly recommeded
[post_title] => VA5171
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5171
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5171/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 9832985
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => This superb 1 bed 1 bath studio apartment has been totally reformed and is presented for sale in perfect condition and comes complete with a tourist licence.
Already used as a very successful rental property it offers a spacious living area located close to a selection of amenities and walking distance to everything.
The property has use of a public swimming pool adjacent to the apartments.
Viewing is highly recommended
[post_title] => VA5185
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5185
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5185/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 9832986
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => A lovely ground floor apartment in the popular Bravo Hill development is presented for sale, offering a spacious 2 bedroom, 1 bathroom accommodation with lounge / kitchen / diner, two good size bedrooms and family bathroom.
The front door to this property opens into the beautiful communal gardens, fountains and swimming pool areas. The rear patio doors open onto a covered terrace with excellent views to the sea and a few steps lead down to a large private garden space ideal for out door activities.
Viewing is highly recommended as these traditional apartments sell very quickly especially with the outdoor private space this property offers
[post_title] => VA5183
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5183
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5183/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 9832987
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => Upon entering through a spacious hallway, you are greeted by an expansive living room with a gas fireplace and solid panoramic windows facing west. It is an ideal gathering place year-round. The exquisite Schmidt kitchen is both stylish and fully equipped with high-quality appliances, a dining table with chairs, and direct access to the terrace, creating a seamless and bright space.
Imagine enjoying your breakfast with views of the pool and garden from the open terrace, or spending your days by the pool soaking up the warm Mediterranean sun. The exterior of this property is impressive, featuring a nearly 900m2 plot, offering ample space for outdoor activities and relaxation. The delightful private pool, built in 2011 and updated with new LED lights in 2023, is perfect for cooling off on hot days, while the covered terrace provides an ideal setting for social gatherings.
This home comes with numerous extras to enhance comfort, including air conditioning, Travertino marble, safety glass, a gas fireplace, Glava insulation, underfloor heating in the main bathroom, and anti-slip marble and anti-heat flooring around the pool. Anti-slip tiles are also installed on terraces and stairs.
Additionally, the property's ideal location ensures natural light and sunshine throughout the day, creating a warm and bright atmosphere in every corner.
Completely renovated in 2009, with the house facade newly painted in 2023. Extra tiles from the 2009 renovation have been saved. The plumbing system is entirely new, including water and drainage systems all the way to the municipal connection on the street (previously a septic tank). Insulated hot water pipes, an extra-large water trap, and storm hatch ensure no bad odors from the drainage and protect against rodents and insects. All plumbing is openly accessible under the house in the crawl space, making repairs easy if needed. Additionally, drinking water is available at all taps, with filters easily accessible from local suppliers.
The electrical system is 100% new, with Pax ventilation in all rooms and a security shutter on the terrace door. The home is sold furnished, ready for you to enjoy from day one. Don’t miss the chance to make this your new home or vacation retreat!
[post_title] => VA5189
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5189
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5189/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 9832988
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => This superb townhouse in the centre of Benijofar is presented for sale in excellent condition and has been totally reformed to a very high standard.
A spacious 3bedroom 2bathroom townhouse with large lounge dining area, separate kitchen and utility room and integral Garage. A rear patio terrace totally private gives a good outdoor space.
The property is distributed over two floors with all rooms of bigger than average size.
Viewing is highly recommended to really appreciate the size, location and quality finish to this property
[post_title] => VA5191
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5191
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5191/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 9832989
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => We present this lovely 2 bedroom ground floor apartment, for sale in Ciudad Quesada, just a 1 minute walk from shops and bar/restaurants.
The apartment is located on a quiet road, overlooking the communal swimming pool, and with stunning views out towards the lakes from the terrace.
Inside, ther is an open plan, L shaped living/dining room and kitchen area, as well as 2 good sized bedrooms and a bathroom.
The property is sold furnished and has air conditioning in the living area. We fully recommend viewing quickly, as it won't be around for long.
[post_title] => VA5198
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5198
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5198/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 9832990
[post_author] => 0
[post_date] => 2024-11-21 01:05:03
[post_date_gmt] => 2024-11-21 01:05:03
[post_content] => This superb top floor apartment is presented for sale in excellent condition and has been maintained to a very high standard.
The property offers a spacious 2 bedroom 2 bathroom accommodation, a large, bright, Lounge/ diner with a separate large kitchen and breakfast bar.
Patio doors from the lounge open onto a private large covered terrace overlooking the private parking area and communal swimming pool.
Entrance to the property is via a private passageway.
Stairs from the communal entrance lead up to a large private solarium with lovely views to the local area and over the communal gardens and pool.
Viewing is highly recommended to really appreciate the size and quality on offer with this property.
located in the popular Doña Pepa region of Quesada, a variety of services, supermarkets, bars and restaurants are within easy walking distance from this community
[post_title] => VA5199
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5199
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:05:03
[post_modified_gmt] => 2024-11-21 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5199/
[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] => 9832998
[post_author] => 0
[post_date] => 2024-11-21 01:10:02
[post_date_gmt] => 2024-11-21 01:10:02
[post_content] => It is a duplex penthouse located in the center of La Mata, facing south, 100 meters from the beach and next to all services.The house is very well maintained, it is sold furnished.On the main floor there is a living room, bathroom, kitchen, a bedroom and a south-facing terrace with side views of the sea.On the upper floor there are 2 bedrooms, a bathroom and a 25 m2 terrace with sea views.Community: €400 per yearIBI: €180
[post_title] => 621
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 621
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 01:10:02
[post_modified_gmt] => 2024-11-21 01:10:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/621/
[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] => bf1e31339acf7b184438ecd213beae4c
[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
)
)
2
3
1
