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 (31,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 (31,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 (31,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 241 - 260 of 6631
€530,000
TSEA5151739
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 88 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 88 Area: Fuengirola Region: Andalucía
Breathe and enjoy life at your own rhythm. This brand new apartment development offers the space to be yourself, to focus on what matters, and to reconnect with a lifestyle that feels effort-less. (...)
€850,000
TSEA5151736
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
The One Residence urbanisation is an exclusive, luxury complex next to the Calanova Golf Course. This fabulous apartment is one of the best within the urbanisation providing commanding PANORAMIC SEA (...)
€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 (...)
€880,000
TSEA5151628
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 199 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 199 Area: Benahavis Region: Andalucía
Luxurious Ground-Floor Apartment in Capanes del Golf – Resort Living within El Higueral Golf course close to Marbella, Benahavis & Estepona
Discover this very spacious apartment in Capanes del (...)
€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 (...)
€325,000
TSEA5151052
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 60 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Estepona Region: Andalucía
New Development: Prices from 325,000 € to 995,000 €. [Beds: 1 - 3] [Baths: 1 - 2] [Built size: 60.00 m2 - 147.00 m2]
This is an exclusive residential complex in the Las Mesas area, combining (...)
€340,000
TSEA5150992
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 1 M2: 96 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 1 M2: 96 Area: Marbella East Region: Andalucía
Apartment for sale in La Reserva de Marbella, Marbella with 2 bedrooms, 1 bathroom and with orientation south, with communal swimming pool and communal garden. Regarding property dimensions, it has (...)
€349,000
TSEA5150977
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 68 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 68 Area: Benalmadena Region: Andalucía
Just a two-minute walk from the beach, this home combines a prime location with comfort. Surrounded by shops, restaurants, and all kinds of services, it's an ideal place to live year-round or to (...)
€275,000
TSEA5150956
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 56 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Benalmadena Region: Andalucía
APARTMENT IN BENALMÁDENA COSTA
We present this exclusive, newly renovated 56 m² apartment, located in the well-known building in Arroyo de la Miel, one of the most sought-after areas of (...)
€379,000
TSEA5150953
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 58 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Area: Marbella Region: Andalucía
Elegant 1-Bedroom Home in "Golden Banus" – Steps from Puerto Banús
This inviting apartment is located in the sought-after Golden Banus development, offering the perfect mix of comfort (...)
€375,000
TSEA5150938
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 123 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Marbella West Region: Andalucía
This apartment in Nueva Andalucía, in the La Campana area, is an excellent opportunity for those seeking comfort and a good location. The property has three bedrooms and two bathrooms, offering a (...)
€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 (...)
€325,000
TSEA5150899
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 140 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 140 Area: Benahavis Region: Andalucía
We would like to offer a list of selling points for our apartment.
A top location in the village of 'Benahavis' with a stunning view from the terrace
3 minutes walk from the center of the village, (...)
€229,000
TSEA5150893
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 49 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Fuengirola Region: Andalucía
Breathe and enjoy life at your own rhythm. This brand new apartment development offers the space to be yourself, to focus on what matters, and to reconnect with a lifestyle that feels effort-less. (...)
€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 (...)
€275,000
TSEA5150836
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 81 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 81 Area: Manilva Region: Andalucía
Investment Apartment for Sale
Become the owner of a stunning penthouse duplex apartment – perfect as your own holiday home or as a smart investment.
Highlights:
Just a short walk to the (...)
€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 (...)
Current Featured Properties
€510,000
TSEA4791997
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
We are delighted to introduce this fabulous new development in in the beautiful area of Arroyo Enmedio in Estepona – an exclusive new development featuring 48 two and 3-bedroom apartments and (...)
€565,000
TSEA5116939
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 130 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: San Pedro Region: Andalucía
The origin of a new way of living in Marbella
The first residential project in a new district set to transform the lifestyle in Marbella.
More than just a new development, this development is the (...)
€6,875,000
TSEA4567357
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 380 Lot Size: 960 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 380 Lot Size: 960 Area: Marbella West Region: Andalucía
More than a villa, it is a masterpiece of design and functionality nestled in the serene beauty of the first line of golf. This residence masterfully combines luxury, entertainment and an (...)
