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,36,37,38)
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,36,37,38)
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,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 121 - 140 of 4003
€295,000
TSEA5153683
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 59 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 59 Area: Fuengirola Region: Andalucía
Brand New Apartment (2024) with Tourist License – Just 200m from the Beach & 2 Minutes from the Train Station
Beautiful 2-bedroom, 2-bathroom apartment in a newly built building from 2024, (...)
€349,000
TSEA5153662
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 94 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 94 Area: Fuengirola Region: Andalucía
Unique Opportunity in the Heart of Fuengirola!
Welcome to this bright and spacious apartment with an unbeatable location in the very center of Fuengirola – right next to the bus station yet (...)
€399,000
TSEA5153656
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Impressive terraces with views of the sea and the mountains. More than 60 square meters of terraces, covered and uncovered. Immaculate penthouse with two floors. Interior brick staircase to access (...)
€439,000
TSEA5153653
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 96 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Area: Fuengirola Region: Andalucía
✨ Ideal Apartment for Sale in Fuengirola – Close to the Beach and Train Station!
Discover this bright and spacious 3-bedroom apartment located in one of the most convenient and well-connected (...)
€359,000
TSEA5153647
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Stylish Renovated Apartment by the Beach in Estepona
Discover this beautifully renovated apartment, perfectly located in a sought-after beachfront urbanization in the very heart of Estepona. Just (...)
€675,000
TSEA5153557
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 128 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Area: Marbella West Region: Andalucía
We are pleased to present this impeccably designed, Scandinavian-style ground-floor apartment, located in the prestigious and highly sought-after urbanisation of Aldea Blanca. This property offers an (...)
€410,000
TSEA5153545
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 88 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Marbella West Region: Andalucía
Superb penthouse in the Nueva Andalucía area. Comprising 2 bedrooms, 2 bathrooms, and a living/dining room with access to a spacious 25 m² terrace.
The gated and well-maintained community offers a (...)
€869,999
TSEA5153473
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 132 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Marbella Region: Andalucía
We are delighted to present this bright and elegant 3-bedroom, 2-bathroom duplex penthouse, which includes 2 parking spaces and a storage room, set within one of the most peaceful and sought-after (...)
€275,000
TSEA5153434
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 88 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 88 Area: Benalmadena Region: Andalucía
Discover the comfort and charm of living in the center of Arroyo de la Miel with this completely renovated apartment. Located on the second floor of a building with no elevator, this home offers the (...)
€1,850,000
TSEA5153413
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 202 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 202 Area: Benalmadena Region: Andalucía
Luxury duplex penthouse located on the beachfront in the famous Puerto Marina marina. A very quiet area with all amenities, including restaurants and several shops, right on the doorstep.
The (...)
€344,900
TSEA5153257
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 85 Lot Size: 85 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 85 Area: Benahavis Region: Andalucía
????️♂️ Experience Golf, Sun, and Exclusivity in the Marbella – Benahavís Golf Valley ☀️
In the heart of the prestigious El Paraíso Golf Valley lies this modern 85 m² apartment, (...)
€480,000
TSEA5153251
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 219 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 219 Area: San Pedro Region: Andalucía
This elegant 3-bedroom, 3-bathroom duplex penthouse is located in the prestigious area of Campos de Guadalmina, Guadalmina Alta. From its spacious terraces, you can enjoy panoramic views of the (...)
€975,000
TSEA5153245
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Welcome to this brand-new, never-lived-in apartment in Mirador de Estepona Hills, one of the most prestigious residential communities in the area of Estepona. Thoughtfully designed for comfort and (...)
€2,985,000
TSEA5153197
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
This exceptional apartment is located within the world-renowned Puente Romano Resort, right in the heart of Marbella's Golden Mile – one of the most exclusive addresses in Europe. Designed for (...)
€350,000
TSEA5153194
- Bel Air, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Located in the prestigious area of Bel Air, Estepona East, this apartment offers a perfect combination of comfort, light, and accessibility. With a south-facing orientation that ensures natural (...)
€750,000
TSEA5153167
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 140 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Marbella West Region: Andalucía
Discover this beautifully renovated apartment in one of Marbella's most desirable neighborhoods, just steps from Centro Plaza and only minutes from the glamour of Puerto Banús.
Designed with (...)
€1,650,000
TSEA5153161
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 278 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 278 Area: Benahavis Region: Andalucía
Casa El Lago is a luxury apartment for sale in the prestigious Real de La Quinta urbanization, a setting that combines contemporary architecture with the natural beauty of southern Spain.
Designed (...)
€378,000
TSEA5153122
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Apartment for sale in Marbella Centro, Marbella with 2 bedrooms and 1 bathroom. Regarding property dimensions, it has 71 m² built and 17 m² terrace. Has the following facilities amenities near, (...)
€520,000
TSEA5153041
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 100 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Casares Region: Andalucía
We present to you this magnificent apartment located in the exclusive La Sabina development in Casares, a privileged enclave on the Costa del Sol that combines tranquillity, nature, and proximity to (...)
€350,000
TSEA5153017
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
In the heart of the Costa del Sol, we present this spacious flat located in the quiet area of Seghers, in Estepona. Strategically located just a few steps from the marina, the beach and the charming (...)
Current Featured Properties
€1,660,000
TSEA4648282
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 114 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 114 Area: Fuengirola Region: Andalucía
This new development is an ambitious project consisting of 164 homes surrounded by the natural landscape of El Higueron. The properties are made up of 70 deluxe apartments, 49 garden villas, 25 sky (...)
€404,400
TSEA5018557
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 97 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Area: Benalmadena Region: Andalucía
This brand new development is located on Calle Menta in Benalmadena (Málaga). It is the new residential in Benalmadena, Málaga. The private urbanization has 70 homes of 2 and 3 bedrooms, in (...)
€2,295,000
EMPTY
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
The development is located in a prime enclave, surrounded by parks and landscaped areas, close to a wide variety of sports, healthcare, commercial spaces, and universities. Just 10 minutes from the (...)
