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 (70,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 (70,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 (70,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 301 - 320 of 3305 €2,790,000
TSEA5134270
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 383 Lot Size: 765 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 383 Lot Size: 765 Area: Estepona Region: Andalucía
Located in the exclusive and secure community of Resina Golf in Estepona, this fully renovated villa offers an exceptional standard of luxury living. With meticulous attention to detail and high-end (...)
€2,395,000
TSEA5134264
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 4 M2: 508 Lot Size: 624 Area: Estepona Region: Andalucía
Beds: 5 Baths: 4 M2: 508 Lot Size: 624 Area: Estepona Region: Andalucía
We present you to our new exclusive listing: a modern luxury villa located in the privilged area of Seghers in Estepona. This stunning property, built with top-quality materials, is the ideal retreat (...)
€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
TSEA5133667
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 180 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 180 Area: Estepona Region: Andalucía
This is a rare opportunity to own a beautifully renovated townhouse in one most desirable beachfront communities if Estepona West area — Bermuda Beach. Offering direct access to a peaceful, (...)
€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 (...)
€650,000
TSEA5133313
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 100 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 100 Area: San Pedro Region: Andalucía
This three-bedroom townhouse in Guadalmina Pueblo is one of those rare finds you don't come across often — especially in such a prime Marbella location. It does need a full renovation, but that's (...)
€580,000
TSEA5133244
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 483 Lot Size: 1,550 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 483 Lot Size: 1,550 Area: Mijas and Mijas Costa Region: Andalucía
Independent Villa in the Urbanización Pinos de Alhaurín.
REDUCED!!!!!!!!
Owner open to offers.
Málaga Home Sales sells, EXCLUSIVELY, excellent independent villa with a large garden, and lots of (...)
€349,000
TSEA5133154
- Diana Park, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
Townhouse to Renovate in Nueva Atalaya – Excellent Investment Opportunity
Type: Townhouse
Condition: To renovate
Built area: 109 m²
Bedrooms: 3
Bathrooms: 2
Terrace / Porch: Yes
Location: Nueva (...)
€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 (...)
€540,000
TSEA5132767
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 240 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 240 Area: Benahavis Region: Andalucía
This beautifully appointed town house is situated in the desirable Paraiso Park, Benahavis, Malaga. Offering a harmonious blend of comfort and convenience, the property boasts three spacious bedrooms (...)
€799,000
TSEA5132674
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 285 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 285 Area: Benahavis Region: Andalucía
Situated in the exclusive, frontline golf complex of Las Encinas in La Quinta, Benahavís, this beautifully renovated three-level townhouse combines modern elegance with breathtaking views of the La (...)
€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 (...)
Current Featured Properties
€980,000
TSEA4621648
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
This exclusive project with an elegant Scandinavian design blends harmoniously with the surrounding nature. The architecture of the townhouses follows seamlessly the undulating shapes of the (...)
€3,000,000
Detached Villa in Marbella
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 5 M2: 692 Lot Size: 4,396 Area: Marbella Region: Andalucía
Beds: 7 Baths: 5 M2: 692 Lot Size: 4,396 Area: Marbella Region: Andalucía
A charming property in a picturesque tranquil residential area above Marbella center, with the most magnificent La Concha backdrop. A fantastic investment opportunity located in a secure residential (...)
€443,000
TSEA4027225
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
4 UNITS LEFT
DREAM AWAY LAZY EVENINGS BY LOOKING AT A STUNNING VIEW!!!
Off-plan development of contemporary semi-detached houses in Riviera del Sol, Mijas, with views over the Mediterranean. The 3 (...)
