WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0064.MAD' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0066.MAD' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_favethemes_insights`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0068.MAD' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0069.MAD' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b006a.MAD' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b006c.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b006d.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b006e.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b006f.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0070.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0071.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0072.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0073.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0074.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0075.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0076.MAD' (Errcode: 28 "No space left on device")]
SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'template/template-compare.php' ) ) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0077.MAD' (Errcode: 28 "No space left on device")]
SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'template/user_dashboard_favorites.php' ) ) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0078.MAD' (Errcode: 28 "No space left on device")]
SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'template/template-thankyou.php' ) ) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC

Bungalow In Pilar De La Horadada, Spain - European.realestate

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b007b.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b007c.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b007f.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

Advanced
Search

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0081.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

For Sale

Bungalow In Pilar De La Horadada, Spain

  • €370.000

Overview

Property ID: EU-1198591
  • Bungalow
  • Property Type
  • 87
  • Area Size
  • 56
  • Land Area
  • 3
  • Bedrooms
  • 2
  • Bathrooms
  • Newly build
  • Condition

Description

NEW BUILD RESIDENTIAL COMPLEX IN TORRE DE LA HORADADA

New Build residential complex of bungalow apartments with communal pool in Torre de la Horadada located 800m from the beach.

All properties has 3 bedrooms, 2 bathrooms, open plan kitchen with the lounge area, fitted wardrobes and terrace.
All properties has private gardens and parking space. Plus bungalows on the top floor has private solarium.

Torre de la Horadada is located south of Alicante in a beautiful location on the coast.

The beautiful beaches of Torre de la Horadada and Mil Palmeras have fine sand beautiful promenade.

There are lots of restaurants, bars and shops, also water sports, diving and snorkelling.

It is well connected just 40 minutes from Alicante and Murcias Corvera airports, with large commercial shopping centres and multiple golf courses all within easy reach.

Advertisment

Address

Open on Google Maps
  • Address: Pilar de la Horadada, Alicante (Costa Blanca), Spain
  • Country: Spain

Details

Updated on July 6, 2025 at 7:33 am
  • Property ID EU-1198591
  • Price €370.000
  • Property Size 87 m²
  • Land Area 56 m²
  • Bedrooms 3
  • Bathrooms 2
  • Property Type Bungalow
  • Property Status For Sale
  • Condition Newly build
  • Ref. number RSG-19248

Energy Class

  • Energetic class: A
  • A+
  • | Energy class A
    A
  • B
  • C
  • D
  • E
  • F
  • G
  • H

Mortgage Estimation

Schedule a Tour

Tour Type

Similar Listings

For Sale
  • €460.000

Charming Bungalow For Sale In Pilar De La Horadada, Spain

Pilar de la Horadada, Alicante (Costa Blanca), Spain
  • 78 m²
  • 26 m²
  • Beds: 3
  • Baths: 2
  • Bungalow
Details
Red Palm Estate
11 hours ago
For Sale
  • €460.000

Charming Bungalow For Sale In Pilar De La Horadada, Spain

Pilar de la Horadada, Alicante (Costa Blanca), Spain
  • 78 m²
  • 26 m²
  • Beds: 3
  • Baths: 2
  • Bungalow
Details
Red Palm Estate
11 hours ago
For Sale
  • €460.000

Charming Bungalow For Sale In Pilar De La Horadada, Spain

Pilar de la Horadada, Alicante, Spain
  • 78 m²
  • Beds: 3
  • Baths: 2
  • Bungalow
Details
House In Spain Invest
12 hours ago
For Sale
  • €599.000

Charming Bungalow For Sale In Rojales, Spain

Rojales, Alicante (Costa Blanca), Spain
  • 258 m²
  • 200 m²
  • Beds: 4
  • Baths: 3
  • Bungalow
Details
Red Palm Estate
1 day ago
Disclaimer: Please note that this property listing is an automatically generated advertisement. The descriptions have been rewritten by our AI agent and should not be considered official property particulars. While European.realestate requires all advertisers to provide accurate information, we do not independently verify the details and cannot accept liability for any inaccuracies. Always contact the listing agent directly for the most accurate and up-to-date information about the property. We strongly recommend obtaining independent legal advice before proceeding with any property purchase.

Notice something incorrect? Help us improve by reporting any issues. You can let us know what you've found by clicking here: Report a problem.

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0086.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b0087.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-468-68a639-1b008c.MAD' (Errcode: 28 "No space left on device")]
SELECT p.ID, pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id = p.ID WHERE pm.meta_key = 'fts_included_options' AND p.post_type = 'fts_builder' AND p.post_status = 'publish' AND (pm.meta_value LIKE '%"standard-global"%' OR pm.meta_value LIKE '%"standard-single-listing"%' OR pm.meta_value LIKE '%"property|all"%' OR pm.meta_value LIKE '%"post-1198591"%' OR pm.meta_value LIKE '%"tax-50693-single-property_type"%' OR pm.meta_value LIKE '%"tax-35-single-property_status"%' OR pm.meta_value LIKE '%"tax-143-single-property_feature"%' OR pm.meta_value LIKE '%"tax-109-single-property_country"%' OR pm.meta_value LIKE '%"tax-68-single-property_feature"%') ORDER BY p.post_date DESC