WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 40
[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] => mn_property
[2] => newbuilds
)
[paged] => 40
[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] => 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 ASC
LIMIT 468, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10568992
[post_author] => 0
[post_date] => 2025-06-24 01:45:29
[post_date_gmt] => 2025-06-24 00:45:29
[post_content] =>
[post_title] => B10500
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10500
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:29
[post_modified_gmt] => 2025-06-24 00:45:29
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10500/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10567916
[post_author] => 0
[post_date] => 2025-06-24 01:40:03
[post_date_gmt] => 2025-06-24 00:40:03
[post_content] => This generously proportioned ground floor corner apartment is situated in the sought-after Jumilla III complex in Playa Flamenca, Orihuela Costa. Perfectly positioned near the popular La Florida district and conveniently located between Punta Prima and Playa Flamenca, the apartment offers excellent access to local beaches, shops and amenities.
Comprising two bedrooms, two bathrooms, a large kitchen, and a spacious balcony, the apartment offers comfortable and versatile living. It is currently unfurnished and does not include white goods or air conditioning, making it an ideal blank canvas for those looking to create a home tailored to their own tastes and needs.
The Jumilla III complex is well-maintained and features a large communal swimming pool set within attractive gardens, with both sunny and shaded areas to enjoy. The beaches of Playa Flamenca and Punta Prima are just a five-minute drive away, while the wider Orihuela Costa and nearby Torrevieja offer a range of additional beach options and shopping destinations.
Local amenities are within easy walking distance, including supermarkets, restaurants, cafés, and more. The nearby La Zenia Boulevard offers a wide selection of retail outlets, dining options and services, all with convenient free parking.
With year-round appeal, the Orihuela Costa area is known for its lively atmosphere, extensive leisure facilities, and easy access to golf courses such as Campoamor, Las Ramblas and Villamartín.
Whether you're looking for a permanent residence, a holiday retreat or a buy-to-let opportunity, this apartment offers the location and potential to be something truly special.
[post_title] => VC3743
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3743
[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/vc3743/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10569390
[post_author] => 0
[post_date] => 2025-06-24 01:45:39
[post_date_gmt] => 2025-06-24 00:45:39
[post_content] =>
[post_title] => 72693 - SPACIOUS APARTMENT IN LOS ANGELES - ELEVATOR
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72693-spacious-apartment-in-los-angeles-elevator
[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/72693-spacious-apartment-in-los-angeles-elevator/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10566965
[post_author] => 0
[post_date] => 2025-06-24 01:25:04
[post_date_gmt] => 2025-06-24 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] => N8679
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => n8679
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:25:04
[post_modified_gmt] => 2025-06-24 00:25:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/newbuilds/n8679/
[menu_order] => 0
[post_type] => newbuilds
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10569354
[post_author] => 0
[post_date] => 2025-06-24 01:45:38
[post_date_gmt] => 2025-06-24 00:45:38
[post_content] =>
[post_title] => A10511
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10511
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:38
[post_modified_gmt] => 2025-06-24 00:45:38
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10511/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10569028
[post_author] => 0
[post_date] => 2025-06-24 01:45:30
[post_date_gmt] => 2025-06-24 00:45:30
[post_content] =>
[post_title] => F0920 - Apartment for Sale near Torres Beach, Villajoyosa ?
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0920-apartment-for-sale-near-torres-beach-villajoyosa-%f0%9f%8c%8a
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:30
[post_modified_gmt] => 2025-06-24 00:45:30
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0920-apartment-for-sale-near-torres-beach-villajoyosa-%f0%9f%8c%8a/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10568841
[post_author] => 0
[post_date] => 2025-06-24 01:45:25
[post_date_gmt] => 2025-06-24 00:45:25
[post_content] =>
[post_title] => A10178
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10178
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:25
[post_modified_gmt] => 2025-06-24 00:45:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10178/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10568663
[post_author] => 0
[post_date] => 2025-06-24 01:45:21
[post_date_gmt] => 2025-06-24 00:45:21
[post_content] =>
[post_title] => A4803 - Apartment complex in San Pedro del Pinatar (Murcia) 300 meters from the beaches of Mar Minor
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a4803-apartment-complex-in-san-pedro-del-pinatar-murcia-300-meters-from-the-beaches-of-mar-minor
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:21
[post_modified_gmt] => 2025-06-24 00:45:21
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a4803-apartment-complex-in-san-pedro-del-pinatar-murcia-300-meters-from-the-beaches-of-mar-minor/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10568920
[post_author] => 0
[post_date] => 2025-06-24 01:45:27
[post_date_gmt] => 2025-06-24 00:45:27
[post_content] =>
[post_title] => F0854 - Great Opportunity to Generate Rental Incomes in Benidorm
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => f0854-great-opportunity-to-generate-rental-incomes-in-benidorm
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:27
[post_modified_gmt] => 2025-06-24 00:45:27
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/f0854-great-opportunity-to-generate-rental-incomes-in-benidorm/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 10569455
[post_author] => 0
[post_date] => 2025-06-24 01:45:40
[post_date_gmt] => 2025-06-24 00:45:40
[post_content] =>
[post_title] => A10566
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => a10566
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:40
[post_modified_gmt] => 2025-06-24 00:45:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/a10566/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10569392
[post_author] => 0
[post_date] => 2025-06-24 01:45:39
[post_date_gmt] => 2025-06-24 00:45:39
[post_content] =>
[post_title] => B10827 - Lomas de Cabo Roig Ground floor corner bungalow
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10827-lomas-de-cabo-roig-ground-floor-corner-bungalow
[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/b10827-lomas-de-cabo-roig-ground-floor-corner-bungalow/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10568477
[post_author] => 0
[post_date] => 2025-06-24 01:45:17
[post_date_gmt] => 2025-06-24 00:45:17
[post_content] =>
[post_title] => V193 - Comfort in the Heart of Gandia: Spacious Apartment with 4 Bedrooms and Proximity to the Railway Stat
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => v193-comfort-in-the-heart-of-gandia-spacious-apartment-with-4-bedrooms-and-proximity-to-the-railway-stat
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:17
[post_modified_gmt] => 2025-06-24 00:45:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/v193-comfort-in-the-heart-of-gandia-spacious-apartment-with-4-bedrooms-and-proximity-to-the-railway-stat/
[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] => 10568992
[post_author] => 0
[post_date] => 2025-06-24 01:45:29
[post_date_gmt] => 2025-06-24 00:45:29
[post_content] =>
[post_title] => B10500
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => b10500
[to_ping] =>
[pinged] =>
[post_modified] => 2025-06-24 01:45:29
[post_modified_gmt] => 2025-06-24 00:45:29
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/b10500/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4541
[max_num_pages] => 379
[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] => 9c5bf87c0eb770e24b4f60b472955bce
[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:90a3ee918502674e8c0ce3c9bcd9f0c7:0.05082400 1753288807
)