WP_Query Object
(
[query] => Array
(
[posts_per_page] => 12
[suppress_filters] =>
[post_type] => Array
(
[0] => hx_property
[1] => newbuilds
[2] => mn_property
)
[paged] => 202
[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] => 202
[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 = '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')))
ORDER BY wp_posts.post_date DESC
LIMIT 2412, 12
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 10423062
[post_author] => 0
[post_date] => 2025-05-13 01:45:05
[post_date_gmt] => 2025-05-13 00:45:05
[post_content] =>
[post_title] => 72703 - APARTMENT IN VIRGEN DEL REMEDIO AREA IN ALICANTE FOR SALE WITH TENANTS
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72703-apartment-in-virgen-del-remedio-area-in-alicante-for-sale-with-tenants
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:45:05
[post_modified_gmt] => 2025-05-13 00:45:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72703-apartment-in-virgen-del-remedio-area-in-alicante-for-sale-with-tenants/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 10423063
[post_author] => 0
[post_date] => 2025-05-13 01:45:05
[post_date_gmt] => 2025-05-13 00:45:05
[post_content] =>
[post_title] => 70190 - IMPRESSIVE COMMERCIAL PREMISES FOR SALE IN ALICANTE IN VILLAFRANQUEZA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 70190-impressive-commercial-premises-for-sale-in-alicante-in-villafranqueza
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:45:05
[post_modified_gmt] => 2025-05-13 00:45:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/70190-impressive-commercial-premises-for-sale-in-alicante-in-villafranqueza/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 10423064
[post_author] => 0
[post_date] => 2025-05-13 01:45:05
[post_date_gmt] => 2025-05-13 00:45:05
[post_content] =>
[post_title] => 70200 - CHALET EN VENTA EN BANYERES DE MARIOLA
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 70200-chalet-en-venta-en-banyeres-de-mariola
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:45:05
[post_modified_gmt] => 2025-05-13 00:45:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/70200-chalet-en-venta-en-banyeres-de-mariola/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 10423065
[post_author] => 0
[post_date] => 2025-05-13 01:45:05
[post_date_gmt] => 2025-05-13 00:45:05
[post_content] =>
[post_title] => V165 - Duplex Penthouse in Front Line Beach
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => v165-duplex-penthouse-in-front-line-beach
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:45:05
[post_modified_gmt] => 2025-05-13 00:45:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/v165-duplex-penthouse-in-front-line-beach/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 10423066
[post_author] => 0
[post_date] => 2025-05-13 01:45:05
[post_date_gmt] => 2025-05-13 00:45:05
[post_content] =>
[post_title] => 8373 - Wonderful detached villa in Ciudad Quesada
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 8373-wonderful-detached-villa-in-ciudad-quesada
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:45:05
[post_modified_gmt] => 2025-05-13 00:45:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/8373-wonderful-detached-villa-in-ciudad-quesada/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 10423017
[post_author] => 0
[post_date] => 2025-05-13 01:40:03
[post_date_gmt] => 2025-05-13 00:40:03
[post_content] => 3 bedroom, 2 bathroom townhouse for sale in Entregolf, Pau 26, Villamartin. The property has had only 1 owner since construction, and is sold as seen with white goods and air-conditioning. Part of a community with the use of a lovely communal pool and garden areas just nearby.
The living accommodation on the ground floor comprises of a bright lounge-dining area, a separate kitchen with access to a rear terrace, and a downstairs bathroom with walk-in shower. Outside there is a tiled patio area with a covered porch. Upstairs there are 3 bedrooms with fitted wardrobes, and a family bathroom. The master bedroom offers a private balcony. Internal stairs from the landing leads up to the L shape roof solarium, perfect for sunbathing and entertaining on with sunshine all day!
The property is a short drive to the Villamartin Plaza, the Zenia Boulevard and the beaches. Within 10 minutes walk is an ALDI supermarket, along with other bars and restaurants in Via Park III.
[post_title] => VC3730
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3730
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:40:03
[post_modified_gmt] => 2025-05-13 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3730/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 10423018
[post_author] => 0
[post_date] => 2025-05-13 01:40:03
[post_date_gmt] => 2025-05-13 00:40:03
[post_content] => Bright South-facing penthouse apartment with two bedrooms, two bathrooms, and an expansive private roof solarium, located in the sought-after Dream Hills II community in Los Altos, Orihuela Costa. Enjoy all-day sunshine thanks to its ideal orientation, with access to a communal pool and parking. Conveniently situated within walking distance of a supermarket and the Via Park III commercial centre, offering a variety of bars, restaurants, and shops.
The apartment features a well-proportioned lounge and dining area, a separate kitchen to the rear, two bedrooms with fitted wardrobes, and two bathrooms. Additional storage cupboards are located in the hallway. French doors from the lounge open onto a covered south-facing balcony, with an external staircase leading to the impressive private roof solarium—an ideal space for barbecues, entertaining, or simply soaking up the sun. Sold furnished and equipped with air conditioning.
Dream Hills II sits on the border between Orihuela Costa and Torrevieja (Los Balcones), providing excellent access to the AP-7 motorway and N-332 coastal road. Alicante Airport is less than a 45-minute drive away.
Early viewing recommended.
[post_title] => VC3732
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3732
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:40:03
[post_modified_gmt] => 2025-05-13 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3732/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 10423019
[post_author] => 0
[post_date] => 2025-05-13 01:40:03
[post_date_gmt] => 2025-05-13 00:40:03
[post_content] => 3-bedroom villa with communal swimming pool for sale in the residential complex of La Pinada in Playa Flamenca. Ideally situated within walking distance to local bars, restaurants, shops, the popular Saturday street market, and the Zenia Boulevard shopping mall with over 155 shops. This villa is nestled inside the community away from any passing traffic, offering peaceful retreat.
The property is distributed over two levels. On the ground floor, you'll find a front tiled garden with gated driveway, the main entrance leading into a bright lounge-dining area and a separate fully equipped kitchen with access to a rear terrace. Also on this level is a versatile third bedroom—ideal as a guest room, or home office. Upstairs, there are two double bedrooms with fitted wardrobes, both offering access to private sunny balconies, as well as a family bathroom. Sold furnished with white goods, and air-conditioning.
This villa offers excellent value in a fantastic location, close to the beach and a wide range of amenities. La Pinada is a charming, well-maintained community with access to a communal swimming pool.
Contact us today to arrange your viewing!
[post_title] => VC3739
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3739
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:40:03
[post_modified_gmt] => 2025-05-13 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3739/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 10423020
[post_author] => 0
[post_date] => 2025-05-13 01:40:03
[post_date_gmt] => 2025-05-13 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-05-13 01:40:03
[post_modified_gmt] => 2025-05-13 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
)
[9] => WP_Post Object
(
[ID] => 10423021
[post_author] => 0
[post_date] => 2025-05-13 01:40:03
[post_date_gmt] => 2025-05-13 00:40:03
[post_content] => Set on a generous 432m2 plot, this characterful semi-detached villa enjoys excellent outdoor space, including a private pool with surrounding terrace, rooftop solarium, and a private garage with separate storage room.
Inside, the accommodation is arranged over one level. An entrance hallway leads into a bright lounge and dining area, complete with feature fireplace, and a separate fitted kitchen. A small hallway connects two double bedrooms with built-in wardrobes, a family bathroom, and a second bathroom with walk-in shower and utility area. There is a second living area just off the main lounge, which could be converted into a third bedroom if desired. The property benefits from air conditioning and gas-oil central heating and is offered furnished, including white goods.
Homes offering this amount of outdoor space in Lomas del Golf, and the wider Orihuela Costa are increasingly difficult to come by. Quietly situated yet just a short walk to the renowned Villamartin Plaza and golf course, and only an 8-minute drive to the beaches and Zenia Boulevard.
Early viewing is recommended.
[post_title] => VC3744
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3744
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:40:03
[post_modified_gmt] => 2025-05-13 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3744/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 10423022
[post_author] => 0
[post_date] => 2025-05-13 01:40:03
[post_date_gmt] => 2025-05-13 00:40:03
[post_content] => This beautifully refurbished two-bedroom, one-bathroom apartment offers stylish ground-floor living in a highly desirable area of Castillo de Don Juan, near Lomas de Cabo Roig & La Fuente. Just minutes from La Zenia Boulevard, local supermarkets, and the stunning beaches of Orihuela Costa, it’s ideally located for both everyday convenience and coastal relaxation.
The property stands out with its private garden and swimming pool. The front terrace, thoughtfully designed with a solar shower and glass-enclosed seating area, provides the perfect setting for unwinding in the sun or entertaining year-round, whatever the weather. Inside, the home has been tastefully modernised with an open-plan layout. The living and dining space is spacious and air-conditioned, complemented by a pellet burner for the cooler months. The contemporary kitchen is fully fitted and includes a separate utility room for additional appliances and storage. Both bedrooms are generous doubles, complete with fitted wardrobes and air conditioning. The bathroom has been fully updated, featuring a walk-in shower and sleek, modern fittings for a clean and calming finish. Sold furnished subject to price.
In addition to the private pool, residents also have access to a larger communal pool, well-kept gardens, and a small football pitch within the community.
Whether you're after a low-maintenance permanent residence or a well-located holiday home, this property combines comfort, practicality, and modern style in one impressive package.
Viewings highly advised!
[post_title] => VC3745
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3745
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:40:03
[post_modified_gmt] => 2025-05-13 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3745/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 10423023
[post_author] => 0
[post_date] => 2025-05-13 01:40:03
[post_date_gmt] => 2025-05-13 00:40:03
[post_content] => This generously sized five-bedroom, three-and-a-half-bathroom detached villa is located in the sought-after Montegolf area of Villamartin. Ideally positioned within easy reach of local amenities, it’s just a short drive from beautiful beaches and several renowned golf courses. Backing directly onto the Villamartin golf course, the villa also enjoys attractive distant sea views from the upper sun terrace.
The property spans three levels. The main floor includes a welcoming front terrace, a bright and spacious lounge with access to a sun terrace, a double bedroom, and a separate WC. Upstairs, the first floor hosts a large master bedroom with its own sun terrace, an additional double bedroom, and a family bathroom. From the lounge, stairs lead down to the lower level where you’ll find a generously proportioned fitted kitchen, a double bedroom with en-suite bathroom, and a second en-suite double bedroom. A glazed sunroom adjoins the kitchen and opens onto the rear garden, which features a heated private swimming pool—ideal for year-round enjoyment.
Additional features include a garden to the front and side with off-road parking, a storage room, hot and cold air conditioning throughout, gas central heating, a pellet burner for added comfort, and access to a well-maintained communal pool.
[post_title] => VC3746
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vc3746
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:40:03
[post_modified_gmt] => 2025-05-13 00:40:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/vc3746/
[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] => 10423062
[post_author] => 0
[post_date] => 2025-05-13 01:45:05
[post_date_gmt] => 2025-05-13 00:45:05
[post_content] =>
[post_title] => 72703 - APARTMENT IN VIRGEN DEL REMEDIO AREA IN ALICANTE FOR SALE WITH TENANTS
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 72703-apartment-in-virgen-del-remedio-area-in-alicante-for-sale-with-tenants
[to_ping] =>
[pinged] =>
[post_modified] => 2025-05-13 01:45:05
[post_modified_gmt] => 2025-05-13 00:45:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.viewspanishproperties.com/property/72703-apartment-in-virgen-del-remedio-area-in-alicante-for-sale-with-tenants/
[menu_order] => 0
[post_type] => hx_property
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 3610
[max_num_pages] => 301
[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] => f33a93000917031a162146bfa2385e16
[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
)
)
1
2
3
