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] => 9840191
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 01:05:03
[post_content] => A very traditional terraced bungalow is presented for sale in very good condition and has been renovated and maintained to a high standard.
The property offers 3 bedrooms, 1 bathroom accommodation on the outskirts of Los Palacios but within easy access to a multitude of amenities and services.
In side the property offers a very cozy traditional living area complete with a log burner in the lounge and air con.
From the lounge there is access to two good size bedrooms and a large third bedroom currently used as a superb dining area. A separate door opens into a modern fully fitted kitchen A door from the kitchen opens into an extended fully covered terrace area that is now part of the kitchen area. There are patio doors from the extension that open onto a lovely traditional enclosed courtyard area complete with an undercover outdoor kitchen facility, storage area and gardens. A staircase from this courtyard leads up to a small roof terrace with a garden shed for storage and lovely views of the farm land to the rear of the property.
Viewing is highly recommended for this countryside bungalow.
[post_title] => VA5175
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5175
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-23 01:05:03
[post_modified_gmt] => 2024-11-23 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5175/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 9840192
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 01:05:03
[post_content] => This superb detached 3 bed 3 bath villa is presented for sale in excellent condition and has been maintained to a very high standard.
This large spacious villa is situated perfectly on a 547m2 plot with excellent outdoor space around the entire villa. There is a large private swimming pool with ample seating and terrace space both covered and uncovered. An elevated dining / BBQ area, under a pergola is secluded behind some mature shrubs perfect for outdoor entertaining. A further elevated terrace is also available currently used for domestic uses. As you proceed further around the villa there are more shrubs and trees elegantly place in a gravelled garden.
There is a access door leading to an under build storage area.
Once back to the front of the villa there is a large detached garage area with access directly to a private drive that leads out to the road. A pedestrian door in the garage allows access from inside the property.
A staircase from the front of the property leads up to a covered terrace which in turn gives access to a large wrap around terrace at the front of the villa. Views from this terrace are overlooking the gardens, private pool and onto the distant mountains. An additional terrace leads from the larger terrace with French doors into the villa and patio doors into the master bedroom. A small staircase leads down to the outdoor dining area.
There is a door from the pool terrace that opens into a large under build area situated under the large wrap around terrace and main lounge area of the villa. This superb under build has the advantage of being actually on ground level allowing full windows for natural light. The door opens into a curved bright area complete with utility and seating areas. A central archway opens into a large living space currently used as a summer lounge.
The main villa has a large open lounge / diner with excellent access to the exterior terraces. There is a large modern fully equipped kitchen separate from the living area.
A part glazed door opens to a passageway that leads to two large bedrooms and a family size bathroom.
Another door from the lounge opens into a large master bedroom suite complete with ensuite bathroom. With the access to the villa’s vast terrace space perfectly arranged via patio doors.
Viewing is highly recommended to really appreciate the space and quality on offer.
[post_title] => VA5174
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5174
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-23 01:05:03
[post_modified_gmt] => 2024-11-23 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5174/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 9840193
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 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-23 01:05:03
[post_modified_gmt] => 2024-11-23 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
)
[3] => WP_Post Object
(
[ID] => 9840194
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 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-23 01:05:03
[post_modified_gmt] => 2024-11-23 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
)
[4] => WP_Post Object
(
[ID] => 9840195
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 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-23 01:05:03
[post_modified_gmt] => 2024-11-23 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
)
[5] => WP_Post Object
(
[ID] => 9840196
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 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-23 01:05:03
[post_modified_gmt] => 2024-11-23 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
)
[6] => WP_Post Object
(
[ID] => 9840197
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 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-23 01:05:03
[post_modified_gmt] => 2024-11-23 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
)
[7] => WP_Post Object
(
[ID] => 9840198
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 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-23 01:05:03
[post_modified_gmt] => 2024-11-23 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
)
[8] => WP_Post Object
(
[ID] => 9840199
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 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-23 01:05:03
[post_modified_gmt] => 2024-11-23 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
)
[9] => WP_Post Object
(
[ID] => 9840200
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 01:05:03
[post_content] =>
[post_title] => VA5210
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5210
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-23 01:05:03
[post_modified_gmt] => 2024-11-23 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5210/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 9840201
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 01:05:03
[post_content] => This superb Jazmine style detached villa is presented for sale in excellent condition and has been maintained to a very high standard.
This property offers a spacious 3 bedroom 2 bathroom villa distributed over two levels.
On the ground floor there is a good size lounge /diner, separate kitchen with utility cupboard under the stairs. There are two double bedrooms and a family size bathroom accessed through an archway from the lounge area. There is a feature staircase that leads to a landing area and a glazed door to a large roof terrace. Access to a master bedroom with en suite is from the same landing. The master bedroom also has patio doors onto the large roof terrace.
Out side this villa is a good area for seating and relaxing. There is access for off road parking if required.
Just a few meters walk from this villa is the communal swimming pool
This property has been beautifully furnished through out and is sold with all this furniture.
Located on the popular Jardin de Laguna II development, puts this villa within easy walk to a variety of amenities.
Viewing is highly recommended to really appreciate what this villa has to offer.
[post_title] => VA5211
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5211
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-23 01:05:03
[post_modified_gmt] => 2024-11-23 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5211/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 9840202
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 01:05:03
[post_content] => This superb 2 bedroom 1 bathroom bungalow is presented for sale in excellent condition and has been maintained to a very high standard.
This popular design bungalow is situated in the Doña Pepa region of Quesada with easy walking access to a vast selection of bars, restaurants and supermarkets.
The property offers a good size front garden area complete with private off road parking .
A couple of steps lead to a large front terrace which is part covered and part open. Sun awnings are fitted to give a great outdoor living space and takes full advantage of the south west facing aspect.
Inside, there is a good size lounge diner, breakfast bar and open kitchen. An archway from the lounge leads to 2 double bedrooms and a family size bathroom.
A glazed door from the kitchen opens into a small utility courtyard and a spiral staircase leading to a very large roof terrace with views to the surrounding areas and excellent private outdoor space.
Viewing is highly recommended to really appreciate what this property and its location has to offer
[post_title] => VA5213
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5213
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-23 01:05:03
[post_modified_gmt] => 2024-11-23 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5213/
[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] => 9840191
[post_author] => 0
[post_date] => 2024-11-23 01:05:03
[post_date_gmt] => 2024-11-23 01:05:03
[post_content] => A very traditional terraced bungalow is presented for sale in very good condition and has been renovated and maintained to a high standard.
The property offers 3 bedrooms, 1 bathroom accommodation on the outskirts of Los Palacios but within easy access to a multitude of amenities and services.
In side the property offers a very cozy traditional living area complete with a log burner in the lounge and air con.
From the lounge there is access to two good size bedrooms and a large third bedroom currently used as a superb dining area. A separate door opens into a modern fully fitted kitchen A door from the kitchen opens into an extended fully covered terrace area that is now part of the kitchen area. There are patio doors from the extension that open onto a lovely traditional enclosed courtyard area complete with an undercover outdoor kitchen facility, storage area and gardens. A staircase from this courtyard leads up to a small roof terrace with a garden shed for storage and lovely views of the farm land to the rear of the property.
Viewing is highly recommended for this countryside bungalow.
[post_title] => VA5175
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => va5175
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-23 01:05:03
[post_modified_gmt] => 2024-11-23 01:05:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/va5175/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3551
[max_num_pages] => 296
[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
)
)