WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e18-24f2f5.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-3b3e18-24f2f8.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-3b3e18-24f2f9.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-3b3e18-24f2fa.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-3b3e18-24f2fb.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-3b3e18-24f2fc.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-3b3e18-24f2fd.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-3b3e18-24f2fe.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-3b3e18-24f2ff.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-3b3e18-24f300.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-3b3e18-24f301.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-3b3e18-24f302.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-3b3e18-24f303.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-3b3e18-24f304.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-3b3e18-24f305.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-3b3e18-24f308.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-3b3e18-24f30a.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-3b3e18-24f30b.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-3b3e18-24f30c.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-3b3e18-24f312.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-3b3e18-24f313.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-3b3e18-24f318.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`

11
Las Filipinas, Orihuela Costa
For Sale
New Build
€ 488.000

Villa in Orihuela Costa - EE11045

Beds:
3
Baths:
2
Size:
113 m2
Plot:
282 m2
Esentya Estate

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

39
La Zenia, Orihuela Costa
For Sale
Our Property
Resale
€ 1.550.000

Villa in La Zenia, Orihuela Costa - EE11027

Beds:
6
Baths:
5
Size:
257 m2
Plot:
1,001 m2
Alexia Paulot

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

47
Campoamor, Orihuela Costa
For Sale
Resale
€ 349.900

Apartment in Orihuela Costa - EE11148

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

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

36
Playa Flamenca, Orihuela Costa
For Sale
New Build
€ 469.000

Apartment in Orihuela Costa - EE11138

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

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

40
Playa Flamenca, Orihuela Costa
For Sale
New Build
€ 625.000

Penthouse in Orihuela Costa - EE11136

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

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

33
Playa Flamenca, Orihuela Costa
For Sale
Resale
€ 495.000

Penthouse in Orihuela Costa - EE8282

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

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

37
Villamartin, Orihuela Costa
For Sale
Resale
€ 639.000

Villa in Villamartin - EE10932

Beds:
3
Baths:
3
Size:
140 m2
Plot:
956 m2
Alexia Paulot
42
La Florida, Orihuela Costa
For Sale
New Build
€ 363.500

Townhouse in La Florida, Orihuela Costa – EE4944

Beds:
3
Baths:
2
Size:
86 m2
Plot:
144 m2
Alexia Paulot
13
Los Dolses, Orihuela Costa
For Sale
New Build
€ 549.900

Villa in Orihuela Costa – EE5504

Beds:
3
Baths:
2
Size:
97 m2
Plot:
151 m2
Alexia Paulot

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

2
Playa Flamenca, Orihuela Costa
For Sale
New Build
€ 325.000

Apartment in Orihuela Costa - EE6270

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

  • Advanced Search

WordPress database error: [Disk full (/tmp/#sql-temptable-3f0-3b3e18-24f348.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-3b3e18-24f349.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-3b3e18-24f34a.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-3b3e18-24f34b.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-3b3e18-24f34c.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-3b3e18-24f34d.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-3b3e18-24f34e.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-3b3e18-24f34f.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-3b3e18-24f351.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-3b3e18-24f353.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-3b3e18-24f355.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-3b3e18-24f357.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-3b3e18-24f359.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-3b3e18-24f35b.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-3b3e18-24f35d.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-3b3e18-24f35f.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-3b3e18-24f361.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-3b3e18-24f366.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-3b3e18-24f367.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `j35b43_options`