WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d920.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d923.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d924.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d925.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d926.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d927.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d928.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d929.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d92a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d92b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d92c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d92d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d92e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d92f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d930.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_duplicator_entities`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d933.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT j35b43_posts.* FROM j35b43_posts INNER JOIN j35b43_postmeta ON ( j35b43_posts.ID = j35b43_postmeta.post_id ) WHERE 1=1 AND ( ( j35b43_postmeta.meta_key = 'wpestate_head_foot_template' AND j35b43_postmeta.meta_value = 'wpestate_category_page' ) ) AND j35b43_posts.post_type = 'wpestate-studio' AND ((j35b43_posts.post_status = 'publish')) GROUP BY j35b43_posts.ID ORDER BY j35b43_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d935.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d936.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d937.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

Orihuela Costa - Esentya Estate

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d93d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT j35b43_posts.* FROM j35b43_posts INNER JOIN j35b43_postmeta ON ( j35b43_posts.ID = j35b43_postmeta.post_id ) INNER JOIN j35b43_postmeta AS mt1 ON ( j35b43_posts.ID = mt1.post_id ) WHERE 1=1 AND ( j35b43_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_head' ) ) ) AND j35b43_posts.post_type = 'elementor_snippet' AND ((j35b43_posts.post_status = 'publish')) GROUP BY j35b43_posts.ID ORDER BY j35b43_postmeta.meta_value+0 ASC

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d93e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT j35b43_posts.* FROM j35b43_posts INNER JOIN j35b43_postmeta ON ( j35b43_posts.ID = j35b43_postmeta.post_id ) INNER JOIN j35b43_postmeta AS mt1 ON ( j35b43_posts.ID = mt1.post_id ) WHERE 1=1 AND ( j35b43_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_body_start' ) ) ) AND j35b43_posts.post_type = 'elementor_snippet' AND ((j35b43_posts.post_status = 'publish')) GROUP BY j35b43_posts.ID ORDER BY j35b43_postmeta.meta_value+0 ASC

Properties listed in Orihuela Costa

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d943.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

39
Las Colinas Golf, Orihuela Costa
For Sale
Resale
€ 460.000

Apartment in Las Colinas Golf - EE11328

Beds:
2
Baths:
2
Size:
93 m2
Plot:
0 m2
Runar Wilhelmsen

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d949.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

51
Cabo Roig, Orihuela Costa
For Sale
Resale
€ 1.700.000

Villa in Cabo Roig - EE11359

Beds:
7
Baths:
7
Size:
463 m2
Plot:
990 m2
Esentya Estate
25
La Zenia, Orihuela Costa
For Sale
Resale
€ 279.000

Town House in Orihuela Costa – EE11357

Beds:
4
Baths:
3
Size:
120 m2
Plot:
0 m2
Esentya Estate

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d94f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

22
Orihuela Costa
For Sale
Resale
€ 287.000

Apartment in Orihuela Costa - EE11346

Beds:
2
Baths:
2
Size:
84 m2
Plot:
0 m2
Esentya Estate

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d954.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d955.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d956.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d958.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

25
Orihuela Costa
For Sale
Resale
€ 390.000

Apartment in Orihuela Costa - EE11345

Beds:
3
Baths:
2
Size:
140 m2
Plot:
0 m2
Esentya Estate

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d95e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

21
Orihuela Costa, Orihuela Costa
For Sale
Resale
€ 379.900

Apartment in Orihuela Costa - EE11310

Beds:
2
Baths:
2
Size:
88 m2
Plot:
0 m2
Esentya Estate

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d964.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

18
Las Colinas Golf, Orihuela Costa
For Sale
Resale
€ 1.200.000

Villa in Las Colinas Golf - EE7416

Beds:
3
Baths:
3
Size:
229 m2
Plot:
1 m2
Runar Wilhelmsen

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d96a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

32
Orihuela Costa
For Sale
Resale
€ 945.000

Villa in Dehesa de Campoamor - EE11247

Beds:
6
Baths:
4
Size:
268 m2
Plot:
800 m2
Esentya Estate

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d970.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

22
La Zenia, Orihuela Costa
For Sale
Resale
€ 270.000

Bungalow in Orihuela Costa - EE10773

Beds:
2
Baths:
2
Size:
70 m2
Plot:
0 m2
Alexia Paulot

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d976.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

39
Lomas De Cabo Roig, Orihuela Costa
For Sale
New Build
€ 202.500

Penthouse in Orihuela Costa - EE7403

Beds:
2
Baths:
2
Size:
69 m2
Plot:
0 m2
Christina Dahl

  • Advanced Search

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d97c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d97d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d97e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d97f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d980.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d981.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d982.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d983.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d984.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d986.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d988.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d98a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d98c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d98e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d990.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d992.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d994.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d996.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d998.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d99a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

Compare Listings

Do you want to know how much your home is worth today?

Get a free, no-obligation valuation of your property in Costa Blanca or Costa Cálida.
Our team analyses the market and guides you to sell at the best possible price.

Win a Free Property Sale

Esentya Estate is currently running a competition where we are giving away a free property sale.

From 15 December 2025 to 29 January 2026, you can enter the draw for a free property sales worth between EUR 5,000 and EUR 50,000.

Fill out the form to enter the competition.

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d99f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT j35b43_posts.* FROM j35b43_posts INNER JOIN j35b43_postmeta ON ( j35b43_posts.ID = j35b43_postmeta.post_id ) INNER JOIN j35b43_postmeta AS mt1 ON ( j35b43_posts.ID = mt1.post_id ) WHERE 1=1 AND ( j35b43_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_body_end' ) ) ) AND j35b43_posts.post_type = 'elementor_snippet' AND ((j35b43_posts.post_status = 'publish')) GROUP BY j35b43_posts.ID ORDER BY j35b43_postmeta.meta_value+0 ASC

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e51-26d9a0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`