WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 335
[meta_query] => Array
(
[relation] => AND
)
[order] => DESC
[meta_key] => _price
[orderby] => meta_value_num
)
[query_vars] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => mn_property
[2] => newbuilds
)
[paged] => 335
[meta_query] => Array
(
[relation] => AND
)
[order] => DESC
[meta_key] => _price
[orderby] => meta_value_num
[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_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] => all
[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
(
[0] => Array
(
[key] => _price
)
[relation] => OR
)
[relation] => AND
[meta_table] => wp_postmeta
[meta_id_column] => post_id
[primary_table] => wp_posts
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => wp_postmeta
)
[clauses:protected] => Array
(
[wp_postmeta] => Array
(
[key] => _price
[compare] => =
[compare_key] => =
[alias] => wp_postmeta
[cast] => CHAR
)
)
[has_or_relation:protected] =>
)
[date_query] =>
[request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
wp_postmeta.meta_key = '_price'
) 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 = 'mn_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')))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 DESC
LIMIT 4008, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10567912
[post_author] => 0
[post_date] => 2025-06-24 01:40:03
[post_date_gmt] => 2025-06-24 00:40:03
[post_content] => This spacious and well-presented two-bedroom corner apartment is ideally located just moments from the renowned Villamartin Plaza and golf course, offering a wide range of amenities right on your doorstep.
Situated on the first floor with lift access, the apartment enjoys a bright and airy interior with a modern design and generous living space. It is sold fully furnished and includes air conditioning, a private storage room, and allocated parking.
The open-plan lounge and dining area is filled with natural light and flows seamlessly into an American-style kitchen. From here, you can access a private balcony—an ideal spot for morning coffee. The lounge also benefits from a Juliet balcony, enhancing the sense of light and space. Both double bedrooms feature fitted wardrobes, while the stylish family bathroom includes a walk-in shower.
The apartment is part of a well-maintained community with a unique advantage—homeowners currently pay no community fees, as rental income from an on-site ATM covers the usual 200€ annual charge.
Perfectly positioned just a short stroll from Villamartin Plaza, residents have easy access to a bank, hairdressers, restaurants, bars, a taxi rank, and a bus stop. The beautiful blue-flag beaches of the Orihuela Costa and the popular Zenia Boulevard shopping centre are just a five-minute drive away.
[post_title] => VC3713
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3713
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:40:03
[post_modified_gmt] => 2025-06-24 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3713/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10568533
[post_author] => 0
[post_date] => 2025-06-24 01:45:18
[post_date_gmt] => 2025-06-24 00:45:18
[post_content] =>
[post_title] => A9514 - Beautiful apartment with large terrace, 2 bedrooms, 2 bathrooms at 500m from Archena spa and mountain views
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a9514-beautiful-apartment-with-large-terrace-2-bedrooms-2-bathrooms-at-500m-from-archena-spa-and-mountain-views
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:18
[post_modified_gmt] => 2025-06-24 00:45:18
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a9514-beautiful-apartment-with-large-terrace-2-bedrooms-2-bathrooms-at-500m-from-archena-spa-and-mountain-views/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10568404
[post_author] => 0
[post_date] => 2025-06-24 01:45:15
[post_date_gmt] => 2025-06-24 00:45:15
[post_content] =>
[post_title] => 72103 - 3 Bedroom Apartment - Third Floor - Ready to Move In
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72103-3-bedroom-apartment-third-floor-ready-to-move-in
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:15
[post_modified_gmt] => 2025-06-24 00:45:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72103-3-bedroom-apartment-third-floor-ready-to-move-in/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10569170
[post_author] => 0
[post_date] => 2025-06-24 01:45:33
[post_date_gmt] => 2025-06-24 00:45:33
[post_content] =>
[post_title] => B10681
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10681
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:33
[post_modified_gmt] => 2025-06-24 00:45:33
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10681/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10568712
[post_author] => 0
[post_date] => 2025-06-24 01:45:22
[post_date_gmt] => 2025-06-24 00:45:22
[post_content] =>
[post_title] => A15673 - Apartment in San Miguel de Salinas with unobstructed views in the center
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a15673-apartment-in-san-miguel-de-salinas-with-unobstructed-views-in-the-center
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:22
[post_modified_gmt] => 2025-06-24 00:45:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a15673-apartment-in-san-miguel-de-salinas-with-unobstructed-views-in-the-center/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10569182
[post_author] => 0
[post_date] => 2025-06-24 01:45:34
[post_date_gmt] => 2025-06-24 00:45:34
[post_content] =>
[post_title] => 72652 - APARTMENT IN CAROLINAS ALTAS - BOULEVARD DEL PLA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72652-apartment-in-carolinas-altas-boulevard-del-pla
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:34
[post_modified_gmt] => 2025-06-24 00:45:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72652-apartment-in-carolinas-altas-boulevard-del-pla/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10569381
[post_author] => 0
[post_date] => 2025-06-24 01:45:39
[post_date_gmt] => 2025-06-24 00:45:39
[post_content] =>
[post_title] => C0047
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => c0047
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:39
[post_modified_gmt] => 2025-06-24 00:45:39
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/c0047/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10569063
[post_author] => 0
[post_date] => 2025-06-24 01:45:31
[post_date_gmt] => 2025-06-24 00:45:31
[post_content] =>
[post_title] => 72426
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72426
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:31
[post_modified_gmt] => 2025-06-24 00:45:31
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72426/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10569618
[post_author] => 0
[post_date] => 2025-06-24 01:45:44
[post_date_gmt] => 2025-06-24 00:45:44
[post_content] =>
[post_title] => 72803 - Spacious, bright apartment for sale in Alicante - Carolinas Altas area
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72803-spacious-bright-apartment-for-sale-in-alicante-carolinas-altas-area
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:44
[post_modified_gmt] => 2025-06-24 00:45:44
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72803-spacious-bright-apartment-for-sale-in-alicante-carolinas-altas-area/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10566893
[post_author] => 0
[post_date] => 2025-06-24 01:15:02
[post_date_gmt] => 2025-06-24 00:15:02
[post_content] => We are pleased to offer this 2 bedroom 1 bathroom apartment in playa Flamenca on the border of La Zenia.The property is close to the La Zenia shopping centre and the popular Saturday market. The property has a communal swimming pool and it is only 10 minuet walk to the fantastic white sandy beaches of the coast. The property has intercom phone system to open block doors, living room / dining room, American style open plan kitchen and a sun balcony overlooking the baranco with sea views. The two bedrooms have fitted wardrobes, ceiling fans, exterior area for hanging laundry.There is an underground garage area where a garage space is available but at an extra cost.Playa Flamenca is conveniently situated on Spain's southern Costa Blanca, which boasts over 300 days of sunshine per year. Local shopping areas and restaurants abound including Via Park I & II, La Florida, Flamenca Beach commercial centre and the La Zenia Boulevard, all within 5 mins walk of the property. Within these areas you will find all the ingredients for an excellent holiday, including supermarkets, cafes, pubs, restaurants (a wide & varied selection of international cuisine is available), banks, town hall, tourist information office & medical clinics (doctor & dentist). There is an excellent weekly street market, held every Saturday where you can buy just about anything! It claims to be one of the biggest & best on the whole of the Costa Blanca. Approximately 20 mins walk (a few mins by car) from the villa are two lovely beaches. A third beach just along the coast at La Zenia offers water sports during high season (jet ski, banana boat & pedaloes). Sport on land is also readily available with bike hire (a local company offers free delivery & collection) & Go Karts. The Go Karts area also has quad bikes, houses a cafe and offers a free service for picking up customers from within the Playa Flamenca area. Golfers are spoilt for choice as they have the option of three 18 hole golf courses within 10 mins drive of the villa (Real Campoamar, Villa Martin & Las Ramblas), another superb course (La Finca) is within 20 mins drive and the world famous La Manga golf complex is only 45 mins drive south! For the ladies there are beauty & nail treatments available within a 5 min drive at Eduardo's de la Finca
[post_title] => F1138
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f1138
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:15:02
[post_modified_gmt] => 2025-06-24 00:15:02
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f1138/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10569279
[post_author] => 0
[post_date] => 2025-06-24 01:45:36
[post_date_gmt] => 2025-06-24 00:45:36
[post_content] =>
[post_title] => B10788
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10788
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:36
[post_modified_gmt] => 2025-06-24 00:45:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10788/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10569674
[post_author] => 0
[post_date] => 2025-06-24 01:45:46
[post_date_gmt] => 2025-06-24 00:45:46
[post_content] =>
[post_title] => B11011
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b11011
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:46
[post_modified_gmt] => 2025-06-24 00:45:46
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b11011/
[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] => 10567912
[post_author] => 0
[post_date] => 2025-06-24 01:40:03
[post_date_gmt] => 2025-06-24 00:40:03
[post_content] => This spacious and well-presented two-bedroom corner apartment is ideally located just moments from the renowned Villamartin Plaza and golf course, offering a wide range of amenities right on your doorstep.
Situated on the first floor with lift access, the apartment enjoys a bright and airy interior with a modern design and generous living space. It is sold fully furnished and includes air conditioning, a private storage room, and allocated parking.
The open-plan lounge and dining area is filled with natural light and flows seamlessly into an American-style kitchen. From here, you can access a private balcony—an ideal spot for morning coffee. The lounge also benefits from a Juliet balcony, enhancing the sense of light and space. Both double bedrooms feature fitted wardrobes, while the stylish family bathroom includes a walk-in shower.
The apartment is part of a well-maintained community with a unique advantage—homeowners currently pay no community fees, as rental income from an on-site ATM covers the usual 200€ annual charge.
Perfectly positioned just a short stroll from Villamartin Plaza, residents have easy access to a bank, hairdressers, restaurants, bars, a taxi rank, and a bus stop. The beautiful blue-flag beaches of the Orihuela Costa and the popular Zenia Boulevard shopping centre are just a five-minute drive away.
[post_title] => VC3713
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3713
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:40:03
[post_modified_gmt] => 2025-06-24 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3713/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4307
[max_num_pages] => 359
[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] => 98cb1cea178ac98f52eb7633d142adae
[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
)
[query_cache_key:WP_Query:private] => wp_query:ebb0862de19d699156f6cb22321df196:0.56091600 1752890943
)
1
2
1
