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 (40)
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 (40)
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 (40)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 1769
€869,000
TSEA5159548
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 150 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 150 Area: Estepona Region: Andalucía
Modern Corner Apartment in the Heart of Estepona!
Located right in the vibrant center of Estepona, just steps away from everything this charming coastal town has to offer and within easy reach of (...)
€459,000
TSEA5159533
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Spectacular Seafront Apartment in the Best Area of Fuengirola
Located on the ninth floor, this magnificent apartment boasts unbeatable panoramic views of the sea, the mountains, and the iconic (...)
€279,000
TSEA5159371
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 98 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 98 Area: Fuengirola Region: Andalucía
Bright corner apartment next to Plaza Hispanidad and the market square in Fuengirola. In the area there are several grocery stores, cafes, bakery, pharmacy, etc.
The apartment has a proper entrance (...)
€359,000
TSEA5159335
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Two bedroom apartment in the popular Calazul complex central to amenities and public transport. The apartment has a sunny terrace and park views. There are two bathrooms one is ensuite with a bath (...)
€375,000
TSEA5159209
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 2 M2: 115 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 2 M2: 115 Area: Benalmadena Region: Andalucía
In the heart of Arroyo de la Miel, just a few steps from the commuter train station and only 1.5 km from the beach, lies this magnificent 115 m² apartment an ideal home for families looking for (...)
€1,700,000
TSEA5159005
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Apartment for sale in Los Granados del Mar, Estepona with 3 bedrooms, 3 bathrooms, 2 en suite bathrooms and with orientation south/east, with communal swimming pool, communal garage (1 parking (...)
€435,000
TSEA5158933
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 240 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 240 Area: Mijas and Mijas Costa Region: Andalucía
Apartment for sale in , Mijas Costa with 3 bedrooms, 2 bathrooms, 1 on suite bathroom, 1 toilet and with orientation west, with communal swimming pool, private garage (2 parking spaces) and communal (...)
€559,000
TSEA5158861
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 117 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Benahavis Region: Andalucía
Elegant 2-Bedroom Apartment in Capanes del Golf – Where Tranquility Meets Sophistication
This beautifully appointed 2-bedroom garden apartment is located in Capanes del Golf, a prestigious gated (...)
€419,000
TSEA5158828
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 82 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Torremolinos Region: Andalucía
This fantastic 2-bedroom apartment with sea views is ideally located in the heart of Torremolinos, offering the best of the Costa del Sol lifestyle.
You're just a 10-minute walk from shops, (...)
€1,299,000
TSEA5158801
- Malagueta, Costa Del Sol
Beds: 3 Baths: 2 M2: 174 Region: Andalucía
Beds: 3 Baths: 2 M2: 174 Region: Andalucía
Luxury flat 100 metres from the sea for sale in La Malagueta - Monte Sancha
Welcome to paradise on the coast of Malaga!
We present this exclusive luxury property on Paseo de Sancha, combining (...)
€249,500
TSEA5158783
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 121 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 121 Area: Manilva Region: Andalucía
Beautiful 2-bedroom, 2-bathroom apartment in a private urbanization in Sabinillas, offering 121 m² of living space, a large south-facing terrace with pool, gardens, garage, and storage—just (...)
€229,500
TSEA5158768
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 51 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Mijas and Mijas Costa Region: Andalucía
Charming 1-Bedroom Apartment for Sale in Mijas – Ideal Location Near Beach & Shopping center
This well-maintained 1-bedroom, 1-bathroom apartment is a fantastic opportunity to own a (...)
€468,000
TSEA5158276
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 105 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: San Pedro Region: Andalucía
FANTASTIC CORNER APARTMENT, SPACIOUS AND BRIGHT NEXT TO THE GOLF AND THE BEACH IN GUADALMINA BAJA!!
In the heart of Guadalmina Baja, one of the most exclusive areas on the Costa del Sol, lies this (...)
€875,000
TSEA5158261
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 120 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 120 Area: Marbella Region: Andalucía
Unique opportunity to purchase two apartments which were united into one big apartment in the famous Torre Real in Marbella. Offering a total of 120m2 living and 98m2 terraces all around. Due to the (...)
€315,000
TSEA5158237
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 91 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Mijas and Mijas Costa Region: Andalucía
This apartment is situated in a secure, gated complex, just a stone's throw from shops, the sea only a 10 minute walk, and the vibrant town center, making it an ideal choice for holiday homes or (...)
€1,100,000
TSEA5158216
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 86 Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Region: Andalucía
Carat, Higuerón West – Unparalleled Luxury 2-Bedroom Apartment with Private Spa & Panoramic Sea Views
Introducing Carat, Higuerón West's most iconic and prestigious development to date – a (...)
€335,000
TSEA5158114
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Stunning newly renovated 2 bedroom/ 2 bathroom apartment in low Riviera del Sol with sea views from the living room, balcony and the master bedroom. Unbeatable location, right in the centre of (...)
€239,000
TSEA5158111
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 43 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 43 Area: Fuengirola Region: Andalucía
???? Apartment for Sale in Los Boliches – Fuengirola ????
A unique opportunity to acquire an apartment in the exclusive area of Los Boliches, just a few steps from the beach and surrounded by all (...)
€310,000
TSEA5158102
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 73 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 73 Area: Benahavis Region: Andalucía
Elegant Renovated 1-Bedroom Apartment in Parque Botánico, Estepona – Resort-Style Living with Premium Amenities!
Discover this impeccably renovated apartment in pristine condition, boasting modern (...)
€219,950
TSEA5158051
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 94 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Nerja and Malaga East Region: Andalucía
New Development: Prices from 219,950 € to 399,950 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 94.00 m2 - 225.00 m2]
A place designed for enjoyment, relaxation, and living with all the (...)
Current Featured Properties
€2,406,000
TSEA4942102
- Málaga, Costa Del Sol, Malaga
Beds: 4 Baths: 3 M2: 263 Area: Malaga Region: Andalucía
Beds: 4 Baths: 3 M2: 263 Area: Malaga Region: Andalucía
71 luxury homes from 1 to 4 bedrooms, on the beachfront. The building, designed by the prestigious Lamela studio, has homes up to 404m2 built with large terraces facing the sea. Among the common (...)
€1,995,000
TSEA5143639
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Bahía del Velerín is a prestigious community located between Marbella and Estepona. It boasts a beautiful pool area with a snack bar, lush tropical gardens, and 24/7 security. Set in a prime (...)
€560,000
TSEA4887199
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 93 Lot Size: 29 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Lot Size: 29 Area: Casares Region: Andalucía
This residential complex of 36 homes with 2 and 3 bedrooms and an exceptional range of services. Each home is carefully designed using soft, organic lines that blend naturally into the surroundings, (...)
