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 (162,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 (162,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 (162,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 61 - 80 of 2639
€615,000
TSEA5152024
- El Campamento, Costa de la Luz
Beds: 4 Baths: 3 M2: 276 Lot Size: 140 Region: Andalucía
Beds: 4 Baths: 3 M2: 276 Lot Size: 140 Region: Andalucía
Charming Renovated House with Private Pool and Stunning Gibraltar Views in Puente Mayorga - Campamento, San Roque!
Discover this delightful south-west facing home, perfectly positioned in the serene (...)
€800,000
TSEA5151901
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 212 Lot Size: 3,500 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 212 Lot Size: 3,500 Area: Estepona Region: Andalucía
Discover a unique opportunity with this house located in the prestigious Selwo area, on the **New Golden Mile**, Estepona. This property offers a solid foundation for a renovation project that can (...)
€2,500,000
TSEA5151808
- Cancelada, Costa Del Sol, Estepona
Beds: 5 Baths: 4 M2: 417 Lot Size: 880 Area: Estepona Region: Andalucía
Beds: 5 Baths: 4 M2: 417 Lot Size: 880 Area: Estepona Region: Andalucía
Contemporary villa with great sea views and south facing, with large windows so all rooms are light and airy. The villa is in the municipality of Estepona, set between the mountains and the sea.
The (...)
€925,000
TSEA5151712
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 188 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 188 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 925,000 € to 1,119,950 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 188.00 m2 - 255.00 m2]
Building License Expected November 2025
Ideally located among fragrant (...)
€3,100,000
TSEA5151661
- Cancelada, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 400 Lot Size: 900 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 400 Lot Size: 900 Area: Estepona Region: Andalucía
Luxury Villa in Cancelada – Costa del Sol
Exclusive detached villa, newly built, located in one of the most sought-after areas of the Costa del Sol. With a contemporary design and top-quality (...)
€396,000
TSEA5151490
- Entrerrios, Costa Del Sol
Beds: 2 Baths: 1 M2: 96 Lot Size: 11,576 Region: Andalucía
Beds: 2 Baths: 1 M2: 96 Lot Size: 11,576 Region: Andalucía
Charming country property in Entrerríos, ideal for those seeking peace, nature, and good access. With an irrigated plot of 11,576 m² and three water points, this property offers multiple (...)
€1,350,000
TSEA5151160
- Marbesa, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 295 Lot Size: 630 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 295 Lot Size: 630 Area: Marbella East Region: Andalucía
This fully renovated villa is located in the sought-after residential area of Marbesa, Marbella East. Offering both privacy and convenience, the property is just minutes away from the beach, Marbella (...)
€1,495,000
TSEA5150923
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 4 M2: 292 Lot Size: 432 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 4 M2: 292 Lot Size: 432 Area: Marbella West Region: Andalucía
Rare Investment Opportunity – Nueva Andalucía Luxury Villa
A bargain with panoramic views, 5 min from Puerto Banús
This independent villa is a unique opportunity in Nueva Andalucía, one of (...)
€399,000
TSEA5150914
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 132 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 132 Area: Torremolinos Region: Andalucía
Charming semi-detached house of 228 m², ideal for comfortable family living and conducting business. Located in a convenient place, it combines privacy, spaciousness, and functionality.
The (...)
€380,000
TSEA5150857
- Arriate, Costa Del Sol, Ronda
Beds: 6 Baths: 3 M2: 220 Lot Size: 594 Area: Ronda Region: Andalucía
Beds: 6 Baths: 3 M2: 220 Lot Size: 594 Area: Ronda Region: Andalucía
-Newly built property with 3 apartments in Arriate, ready to move into and with a valid tourist license.
In the quiet family development of Los Arroyos de Arriate, this unique, recently built (...)
€4,999,500
TSEA5150824
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 6 M2: 485 Lot Size: 1,065 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 6 M2: 485 Lot Size: 1,065 Area: Marbella West Region: Andalucía
HIGHLIGHTS
Located in the prestigious Golf Valley of Nueva Andalucía, Centauro 15 is an exceptional villa that blends contemporary architecture with Balinese boho inspiration and lush tropical (...)
€1,312,700
TSEA5150821
- Málaga Centro, Costa Del Sol, Malaga
Beds: 5 Baths: 4 M2: 271 Lot Size: 285 Area: Malaga Region: Andalucía
Beds: 5 Baths: 4 M2: 271 Lot Size: 285 Area: Malaga Region: Andalucía
HIGHLIGHTS
Ideally located to make the most of Málaga's coastal lifestyle, this semi-detached villa offers a rare combination of Andalusian charm and significant renovation potential. With 271 m² (...)
€4,975,000
TSEA5150767
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 8 M2: 475 Lot Size: 815 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 8 M2: 475 Lot Size: 815 Area: Marbella West Region: Andalucía
A Refined Retreat in Aloha / Las Brisas, Marbella
Welcome to a beautifully renovated luxury villa located in the prestigious Aloha / Las Brisas area of Marbella. This elegant home blends timeless (...)
€1,750,000
TSEA5150701
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 5 M2: 403 Lot Size: 1,250 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 5 M2: 403 Lot Size: 1,250 Area: Mijas and Mijas Costa Region: Andalucía
This large villa (400 m2) is located about 800 meters from the casino and beach, next to the Torrequebrada golf course (Benalmádena Costa).
On the main floor you will find a large living room with (...)
€495,000
TSEA5150500
- El Gastor, Costa de la Luz
Beds: 3 Baths: 2 M2: 225 Region: Andalucía
Beds: 3 Baths: 2 M2: 225 Region: Andalucía
Rustic Estate Facing the Zahara de la Sierra Reservoir – Ready to Move In
Overview
Experience Andalusian charm and absolute tranquility in this exclusive rustic estate, surrounded by nature and (...)
€872,000
TSEA5150455
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 248 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 248 Area: Estepona Region: Andalucía
New Development: Prices from 872,000 € to 1,075,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 248.00 m2 - 259.00 m2]
An exclusive residential complex: 36 apartments with 2 and 3 bedrooms, and (...)
€4,200,000
TSEA5150443
- La Mairena, Costa Del Sol, Marbella East
Beds: 5 Baths: 6 M2: 503 Lot Size: 1,529 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 6 M2: 503 Lot Size: 1,529 Area: Marbella East Region: Andalucía
Exceptional Villa Nestled in the Hills of La Mairena
This unique three-level villa has been thoughtfully designed to embrace its privileged location and breathtaking scenery. From the moment you (...)
€780,000
TSEA5150281
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 285 Lot Size: 143 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 285 Lot Size: 143 Area: Marbella East Region: Andalucía
Located in the very heart of the Golden Mile, just 1,500 meters from the beach and surrounded by an exclusive and tranquil environment, this magnificent semi-detached house is situated in Nagüeles (...)
€600,000
TSEA5150074
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 6 Baths: 5 M2: 382 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 5 M2: 382 Area: San Pedro Region: Andalucía
We offers a unique opportunity in the heart of San Pedro de Alcántara.
We present this spacious and bright semi-detached house with a floor area of 382 square meters, distributed over 4 floors (...)
€770,000
TSEA5150035
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 200 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Area: Fuengirola Region: Andalucía
Welcome to your dream home on the stunning Costa del Sol! This amazing villa offers an unparalleled living experience with its 4 spacious bedrooms and 3 luxurious bathrooms. The villa is part of a (...)
Current Featured Properties
€4,200,000
TSEA4450924
- Benahavís, Costa Del Sol, Benahavis
Beds: 7 Baths: 5 M2: 462 Lot Size: 1,034 Area: Benahavis Region: Andalucía
Beds: 7 Baths: 5 M2: 462 Lot Size: 1,034 Area: Benahavis Region: Andalucía
Monte Mayor offers an exclusive gated community with 24 hour security in a fantastic natural environment with beautiful surroundings and excellent sea views. It is just a 15 minute drive to the coast (...)
€7,500,000
TSEA4797559
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 693 Lot Size: 340 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 693 Lot Size: 340 Area: Marbella East Region: Andalucía
YOU REALLY WILL WANT TO SEE THIS DEVELOPMENT!!!
The most exceptional new development, is currently underway on Marbella's fabled Golden Mile. With the most exclusive location, sublime design and just (...)
€1,890,000
MORE THAN JUST A VILLA...A REFLECTION OF WHO YOU ARE !
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 602 Lot Size: 756 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 602 Lot Size: 756 Area: Benahavis Region: Andalucía
MORE THAN JUST A VILLA...A REFLECTION OF WHO YOU ARE!!!
A truly UNIQUE AND SPECIAL project. There is nowhere else quite like this. Designed especially for you where an authentic philosophy of life (...)
