WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 19
[meta_query] => Array
(
[relation] => AND
)
[order] => ASC
[meta_key] => _price
[orderby] => meta_value_num
)
[query_vars] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 19
[meta_query] => Array
(
[relation] => AND
)
[order] => ASC
[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] =>
[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 ASC
LIMIT 216, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10428285
[post_author] => 0
[post_date] => 2025-05-14 01:45:41
[post_date_gmt] => 2025-05-14 00:45:41
[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-05-14 01:45:41
[post_modified_gmt] => 2025-05-14 00:45:41
[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
)
[1] => WP_Post Object
(
[ID] => 10427887
[post_author] => 0
[post_date] => 2025-05-14 01:45:32
[post_date_gmt] => 2025-05-14 00:45:32
[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-05-14 01:45:32
[post_modified_gmt] => 2025-05-14 00:45:32
[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
)
[2] => WP_Post Object
(
[ID] => 10425931
[post_author] => 0
[post_date] => 2025-05-14 01:25:10
[post_date_gmt] => 2025-05-14 00:25:10
[post_content] => NEW BUILD KEY READY RESIDENTIAL COMPLEX IN AGUILAS
The residential is composed of 114 apartments with 2 community pools and is only 10 units left.
An apartment and penthouses consists of one large living room, 2 bedrooms, a furnished kitchen, 2 bathrooms and a large terrace.
Each apartment has a covered parking space.
The stunning sea views from the large terraces and the pool are on the most valuable attractions of these apartments.
Residential complex is located in a residential area that offers a pleasant and calm area, sea and mountains views, and is well connected at the same time with the beach and all the services and leisure options you need on a daily basis, like supermarkets, restaurants, chiringuitos, health centre, fitness centre, scuba diving, ect.
The flats, built in 2008 and recently renovated, are delivered furnished, with lighting package, white goods and air conditioning.
Residential located in exceptional area on Costa Cálida at only 50 minutes from the new Murcia or Almeria airport and 1h30 from Alicante airport.
The area is connected through highway with the cities of Cartagena, Alicante and the rest of the beaches of Murcia and Almeria.
The place is accessible by local trains.
Located in Aguilas it is a small city with many amenities, a long beach to walk and relax in the sun.
It has 28 kilometers of coastline in which there are 35 beaches with different types of sand thickness located in different landscapes, from coves and virgin beaches in natural settings to the urban beaches of the town of Aguilas.
Its warm desert climate is present all year round with an annual average of 22º with mild temperatures in winter and very hot in summer.
Aguilas is a perfect enclave for diving, water sports, hiking and golf.
[post_title] => N7961
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n7961
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:25:10
[post_modified_gmt] => 2025-05-14 00:25:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n7961/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10428272
[post_author] => 0
[post_date] => 2025-05-14 01:45:41
[post_date_gmt] => 2025-05-14 00:45:41
[post_content] =>
[post_title] => B10814
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10814
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:41
[post_modified_gmt] => 2025-05-14 00:45:41
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10814/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10428040
[post_author] => 0
[post_date] => 2025-05-14 01:45:35
[post_date_gmt] => 2025-05-14 00:45:35
[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-05-14 01:45:35
[post_modified_gmt] => 2025-05-14 00:45:35
[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
)
[5] => WP_Post Object
(
[ID] => 10427479
[post_author] => 0
[post_date] => 2025-05-14 01:45:22
[post_date_gmt] => 2025-05-14 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-05-14 01:45:22
[post_modified_gmt] => 2025-05-14 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
)
[6] => WP_Post Object
(
[ID] => 10427142
[post_author] => 0
[post_date] => 2025-05-14 01:45:15
[post_date_gmt] => 2025-05-14 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-05-14 01:45:15
[post_modified_gmt] => 2025-05-14 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
)
[7] => WP_Post Object
(
[ID] => 10425681
[post_author] => 0
[post_date] => 2025-05-14 01:25:04
[post_date_gmt] => 2025-05-14 00:25:04
[post_content] => Regenerated Residential Complex in Lomas de Cabo Roig – Renovated Apartments
Apartments in a Prime Location
Discover this exclusive opportunity to own a renovated apartment in Lomas de Cabo Roig, a sought-after area in Orihuela Costa. This residential complex, originally built in 2008, is undergoing a renovation of some units and will be delivered in June 2025. A show home is available for viewing, allowing you to see the quality finishes firsthand.
Property Options to Suit Every Need
This development offers 27 refurbished apartments, with a variety of layouts:
1 and 2-bedroom units, ideal for holiday homes or investment.
Ground-floor apartments with private gardens, perfect for outdoor living.
Middle-floor apartments with spacious terraces, ideal for enjoying the Mediterranean climate.
Penthouses with private solariums, offering open views and maximum privacy.
Each home is delivered with shower screens in the bathrooms and fully equipped kitchens with appliances, ensuring a turnkey solution for buyers.
Exclusive Community Amenities
The residential complex is designed for comfort and relaxation, featuring:
A communal swimming pool surrounded by beautiful landscaped gardens.
An elevator for easy access to all floors.
Optional underground parking spaces available at an additional cost.
An Unbeatable Location in Orihuela Costa
Lomas de Cabo Roig is a prestigious residential area located just 2 km from the coastline of Cabo Roig, home to some of the most beautiful beaches in Orihuela Costa. The area is well-connected by road and offers a wide range of services, including shops, restaurants, supermarkets, and shopping centers.
Distances to key points of interest:
Beaches of Cabo Roig and Campoamor – 5-minute drive.
Zenia Boulevard Shopping Center – 5 km.
Villamartín Golf Course – 4 km.
Alicante Airport – 30 minutes by car.
Murcia-Corvera Airport – 1 hour by car.
A Smart Investment in the Costa Blanca
With its excellent location, fully renovated apartments, and top-tier amenities, this development is an ideal opportunity for investment, holiday living, or permanent residence. Don’t miss out on this unique chance to own a home in one of the most desirable areas of the Costa Blanca at an unbeatable price.
Contact us today for more information or to schedule a visit!
[post_title] => N8680
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8680
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:25:04
[post_modified_gmt] => 2025-05-14 00:25:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8680/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10427961
[post_author] => 0
[post_date] => 2025-05-14 01:45:33
[post_date_gmt] => 2025-05-14 00:45:33
[post_content] =>
[post_title] => B10635 - Duplex penthouse with private solarium and communal pool in Calas Blancas, Torrevieja.
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10635-duplex-penthouse-with-private-solarium-and-communal-pool-in-calas-blancas-torrevieja
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:45:33
[post_modified_gmt] => 2025-05-14 00:45:33
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10635-duplex-penthouse-with-private-solarium-and-communal-pool-in-calas-blancas-torrevieja/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10427280
[post_author] => 0
[post_date] => 2025-05-14 01:45:18
[post_date_gmt] => 2025-05-14 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-05-14 01:45:18
[post_modified_gmt] => 2025-05-14 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
)
[10] => WP_Post Object
(
[ID] => 10426619
[post_author] => 0
[post_date] => 2025-05-14 01:40:03
[post_date_gmt] => 2025-05-14 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-05-14 01:40:03
[post_modified_gmt] => 2025-05-14 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
)
[11] => WP_Post Object
(
[ID] => 10426613
[post_author] => 0
[post_date] => 2025-05-14 01:40:03
[post_date_gmt] => 2025-05-14 00:40:03
[post_content] => This well presented two-bedroom ground-floor apartment is situated in the San Jose IV community in La Zenia. Ideally positioned within walking distance of La Zenia’s popular Zenia Boulevard, a variety of restaurants, shops, and amenities, as well as the bustling Cabo Roig strip renowned for its vibrant nightlife. Residents also enjoy access to a beautifully maintained communal pool.
The apartment features a front and rear garden area with gated driveway, plus a raised terrace area, perfect for al-fresco dining. Inside you will find a bright and airy lounge-dining area with open kitchen to the rear, which offers access to the rear garden with gated driveway. To the side of the lounge is a small hallway, from which you can access the 2 bedrooms, and a renovated bathroom with walk-in shower. The property is sold furnished with white goods.
Perfectly situated between La Zenia and Cabo Roig. Viewings are highly recommended to fully appreciate this fantastic home.
[post_title] => VC3687
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3687
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-14 01:40:03
[post_modified_gmt] => 2025-05-14 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3687/
[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] => 10428285
[post_author] => 0
[post_date] => 2025-05-14 01:45:41
[post_date_gmt] => 2025-05-14 00:45:41
[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-05-14 01:45:41
[post_modified_gmt] => 2025-05-14 00:45:41
[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
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3575
[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] => 5f2fbb87247bf9d0752974c3439d8e33
[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
)
)