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 181 - 200 of 4003
€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 (...)
€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 (...)
€495,000
TSEA5150911
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
This beautiful, fully exterior apartment stands out for its excellent location and natural brightness throughout. Located in a peaceful residential area of Marbella, it is just 400 meters from 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. (...)
€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 (...)
€1,090,000
TSEA5150803
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
HIGHLIGHTS
Exquisite apartment located in the prestigious Marbella Club Hills development. A 5-star residence set within a privileged natural environment, in collaboration with the iconic Marbella (...)
€550,000
TSEA5150794
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
HIGHLIGHTS
This apartment offers a unique investment opportunity in one of the most sought-after areas of Marbella. With its proximity to Puerto Banús and the beach, this property has enormous (...)
€395,000
TSEA5150782
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse with Panoramic Views of Fuengirola and the Mediterranean
This spacious penthouse in Sierrezuela offers one of the most spectacular terraces you can find – a 50 m² outdoor space with sun (...)
€525,000
TSEA5150773
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Modern and spacious 3-bedroom apartment in exclusive Belaire, Estepona!
Welcome to thiS 3-bedroom apartment located in the sought-after Belaire community in Bel-Air, Estepona. With its modern (...)
€1,875,000
TSEA5150743
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 4 M2: 316 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 4 M2: 316 Area: La Duquesa Region: Andalucía
Unique Penthouse in Puerto de la Duquesa with 360° Views
• A truly unique property on the market: a 3-bedroom, 4-bathroom penthouse with a wrap-around panoramic terra
360° views of the sea, (...)
€335,000
TSEA5150740
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
This charming apartment, located on the first and top floor, perfectly combines comfort, style, and an unbeatable location. Fully renovated and tastefully furnished, it offers modern, functional (...)
€950,000
TSEA5150737
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 73 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 73 Area: Marbella East Region: Andalucía
This unique penthouse is located in a renowned and well-established beachfront urbanization, with direct access to one of the best beaches on the Costa del Sol and its promenade.
As soon as you step (...)
€390,000
TSEA5150722
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Magnificent apartment with stunning views in Mijas Golf.
Discover this magnificent apartment located in a prime location for golf lovers, where tranquility and light blend perfectly.
This property (...)
€1,399,000
TSEA5150578
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 3 M2: 159 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 3 M2: 159 Area: Marbella West Region: Andalucía
In the heart of Puerto Banús Marina, this modern apartment with sea views is now available for sale. With its two-bedroom, two-bathroom en-suite (plus one guist toilet) it is prime positioned (...)
Current Featured Properties
€318,250
TSEA4930297
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 54 Lot Size: 39 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 54 Lot Size: 39 Area: Mijas and Mijas Costa Region: Andalucía
We welcome you to this new development in Mijas a large multi-family building that offers 76 homes distributed over five floors plus an attic. The residential complex has common areas that include a (...)
€611,000
TSEA5138941
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
This is not simply a place to live. It's a lifestyle ecosystem. From sunrise swims in your private pool to sunset walks along the coastal path, this is more than just a home — it's a (...)
€2,695,000
TSEA5143117
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Located between Marbella and Estepona, Bahía del Velerín is a prestigious community with a beautiful pool area, a snack bar, lush tropical gardens, and 24/7 security.
This fully renovated penthouse (...)
