SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND p.approved = 1 AND pm.cat_id IN (63,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND `p`.`featured` IN ('1') AND p.approved = 1 AND pm.cat_id IN (63,42,43,44,45)
GROUP BY p.id
ORDER BY RAND()
SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id
FROM psi48_iproperty AS p
LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id
WHERE pm.cat_id > 0 AND p.approved = 1 AND pm.cat_id IN (63,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 221 - 240 of 2642 €1,695,000
TSEA5134261
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 490 Lot Size: 737 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 490 Lot Size: 737 Area: San Pedro Region: Andalucía
We are thrilled to present our exclusive listing; an unparalleled opportunity to own an exquisite and modern villa located in the highly sought-after area of San Pedro de Alcantara. Renovated and in (...)
€850,000
TSEA5133661
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 194 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 194 Area: San Pedro Region: Andalucía
This exceptional semi-detached house, the largest of the sought-after Señorío de Mainake complex, is located in the heart of San Pedro Alcántara and stands out for its generous distribution on (...)
€1,095,000
TSEA5133601
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 8 M2: 757 Lot Size: 1,383 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 8 M2: 757 Lot Size: 1,383 Area: Mijas and Mijas Costa Region: Andalucía
This exquisite villa offers a harmonious combination of quality and comfort. The owner built the house himself 20 years ago, which guarantees quality throughout. It is a perfect home for the large (...)
€595,000
TSEA5133370
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M2: 521 Lot Size: 803 Area: Coin Region: Andalucía
Beds: 4 Baths: 2 M2: 521 Lot Size: 803 Area: Coin Region: Andalucía
Boho style villa, located in once of Southern Spain's best inland towns. The property was designed by a Swedish architect and is a fantastic family home. Houses of this style and quality, are (...)
€369,000
TSEA5133334
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
SEMI-DETACHED HOUSE IN LAS LAGUNAS (IN EXCELLENT LOCATION)
PLOT CALIFICATION POP-2 (means can do a Ground Floor + 2 storeys + penthouse) nice for invest
POSSIBILITY TO DESTROY AND BUILD GROUND FLOOR (...)
€160,000
TSEA5133130
- Jimena de la Frontera, Costa de la Luz
Beds: 5 Baths: 3 M2: 400 Lot Size: 50 Region: Andalucía
Beds: 5 Baths: 3 M2: 400 Lot Size: 50 Region: Andalucía
Semi-Detached House, Jimena de la Frontera, Costa de la Luz.
5 Bedrooms, 3 Bathrooms, Built 400 m², Terrace 10 m², Garden/Plot 50 m².
Setting : Commercial Area, Village, Mountain Pueblo, Close To (...)
€255,000
TSEA5133121
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 88 Lot Size: 45 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 88 Lot Size: 45 Area: Benalmadena Region: Andalucía
Charming casa mata for sale, ideally located in the very center of Arroyo de la Miel, in a quiet residential area with all essential services nearby. Supermarkets, train station, health centers, (...)
€625,000
TSEA5132815
- Ojén, Costa Del Sol, Ojen
Beds: 5 Baths: 3 M2: 447 Lot Size: 600 Area: Ojen Region: Andalucía
Beds: 5 Baths: 3 M2: 447 Lot Size: 600 Area: Ojen Region: Andalucía
✨ Live Your Mediterranean Dream in This Gem of Ojén ✨
Imagine waking up each morning to the sound of the breeze through the pine trees and breathtaking views—where the deep blue sea meets the (...)
€1,800,000
TSEA5132668
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 7 M2: 446 Lot Size: 3,600 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 7 M2: 446 Lot Size: 3,600 Area: Mijas and Mijas Costa Region: Andalucía
Villa for sale in , Mijas with 7 bedrooms, 7 bathrooms and with orientation south, with private swimming pool, private garage and private garden. Regarding property dimensions, it has 446 m² built (...)
€2,300,000
TSEA5132662
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 736 Lot Size: 3,000 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 736 Lot Size: 3,000 Area: Benahavis Region: Andalucía
Villa Benahavís is an exceptional property for sale in one of the most coveted areas of the Costa del Sol, offering an unparalleled blend of luxury, tranquility, and natural beauty. Nestled within (...)
€575,000
TSEA5132515
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 101 Lot Size: 25 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 101 Lot Size: 25 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to this amazing house with beautiful sea views!!
This property has been completely renovated last year and is definitely a must-see.
It has a very cozy, spacious living room with an open (...)
€470,000
TSEA5132500
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
New Development: Prices from 470,000 € to 470,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 74.00 m2 - 74.00 m2]
The new development offers a carefully selected mix of 1, 2 and 3 bedroom (...)
€1,750,000
TSEA5132254
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 2 M2: 356 Lot Size: 601 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 2 M2: 356 Lot Size: 601 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,750,000 € to 1,750,000 €. [Beds: 5 - 5] [Baths: 2 - 2] [Built size: 356.00 m2 - 356.00 m2]
Exclusive Villa under construction in Riviera del Sol with Sea View
We (...)
€1,295,000
TSEA5132158
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 211 Lot Size: 1,272 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 211 Lot Size: 1,272 Area: San Pedro Region: Andalucía
Nestled in the peaceful residential enclave of Alta Vista, perfectly positioned between San Pedro de Alcántara and Guadalmina, this inviting single-level villa presents a rare opportunity to create (...)
€399,950
TSEA5132149
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 2 M2: 176 Lot Size: 145 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 2 M2: 176 Lot Size: 145 Area: Nerja and Malaga East Region: Andalucía
New Development: Prices from 399,950 € to 449,950 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 176.00 m2 - 179.00 m2]
We present to you an exclusive residential development of 30 semi-detached (...)
€2,295,000
TSEA5132125
- La Capellania, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 265 Lot Size: 601 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 265 Lot Size: 601 Area: Fuengirola Region: Andalucía
Located next to La Capellanía, just five minutes from the charming Benalmádena Pueblo and directly beneath the iconic Buddhist Stupa in Retamar, this exceptional single-level villa has been (...)
€689,000
TSEA5131834
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 2 M2: 110 Lot Size: 6,902 Area: Ojen Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Lot Size: 6,902 Area: Ojen Region: Andalucía
Can you imagine waking up every morning surrounded by pure nature, in a private estate with panoramic views stretching across the Mediterranean, Gibraltar, and Africa? This hidden gem in the Altos de (...)
€495,000
TSEA5131741
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 179 Lot Size: 602 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 179 Lot Size: 602 Area: Mijas and Mijas Costa Region: Andalucía
Traditional house in El Faro in Mijas-Costa with two levels and with beautiful sea views offering in the main residence a living room with separate dining room and bright terrace, kitchen, two (...)
€850,000
TSEA5131735
- La Viñuela, Costa Del Sol East
Beds: 6 Baths: 4 M2: 320 Lot Size: 4,418 Region: Andalucía
Beds: 6 Baths: 4 M2: 320 Lot Size: 4,418 Region: Andalucía
This charming villa in Los Romanes, Málaga, perfectly combines traditional Spanish architecture with modern comfort. The main house features 4 bedrooms, including a spacious master suite, 3 full (...)
€449,000
TSEA5131732
- Arenas, Costa Del Sol East
Beds: 3 Baths: 1 M2: 176 Lot Size: 5,976 Region: Andalucía
Beds: 3 Baths: 1 M2: 176 Lot Size: 5,976 Region: Andalucía
Nestled in the beautiful hills of Arenas, this charming property offers breathtaking views of both the mountains and the Mediterranean Sea. Its the perfect retreat for those seeking peace, nature, (...)
Current Featured Properties
€1,150,000
TSEA4366900
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 330 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 330 Area: Mijas and Mijas Costa Region: Andalucía
STYLISH DESIGN, CLOSE TO THE MIJAS COAST.
An exclusive development of 15 detached Villas, 8 left, built by a leading design company specialising in SOUGHT AFTER CONTEMPORARY STYLING. The large (...)
€3,890,000
Detached Villa in Nueva Andalucia
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 229 Lot Size: 1,008 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 229 Lot Size: 1,008 Area: Marbella West Region: Andalucía
THE ULTIMATE LUXURY LIVING!!!
Combining luxury and nature in an exceptional environment. Two unique villas built on one floor and designed to enjoy the Mediterranean lifestyle in a relaxed way, (...)
€2,300,240
Detached Villa in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
NO MORE NEED TO DREAM ABOUT THE PERFECT VIEW!!!
This upscale development with the best views in Fuengirola and Mijas consists of thirteen individual villas, each offering no less than four en-suite (...)
