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,68,69,70)
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,68,69,70)
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,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 2510
€299,000
TSEA5159593
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 112 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Manilva Region: Andalucía
Townhouse, Manilva, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 112 m², Terrace 72 m².
Setting : Country, Village, Close To Shops, Close To Schools, Urbanisation.
Orientation : North (...)
€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 (...)
€425,000
TSEA5159269
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 3 M2: 180 Area: Manilva Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: Manilva Region: Andalucía
Magnificent property situated in a prime beachfront location in the coveted area of Aldea Beach, just a stone's throw from the charming Puerto de La Duquesa. A unique opportunity for those (...)
€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 (...)
€470,000
TSEA5159014
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 230 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 230 Area: Estepona Region: Andalucía
Discover this magnificent townhouse located in an exclusive gated community, just a short distance from the new high-resolution hospital and frontline to a spectacular golf course, offering (...)
€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, (...)
€495,000
TSEA5158807
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 70 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 70 Area: Torremolinos Region: Andalucía
This impeccably maintained home, spanning 118 square meters, offers a harmonious blend of luxurious living and serene comfort.
Upon entering, you are greeted by a spacious living area, distinguished (...)
€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 (...)
€634,900
TSEA5158789
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 4 M2: 149 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 4 M2: 149 Area: Fuengirola Region: Andalucía
Exclusive New Development in Torreblanca del Sol – Fuengirola ✨
Just 500 metres from the beach and with excellent commuter train connections, Mirador del Limonar offers contemporary homes that (...)
€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 (...)
€630,000
TSEA5158777
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 134 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 134 Area: San Pedro Region: Andalucía
Beachside, 5 minutes from Puerto Banús
Large semi-detached house with 4 bedrooms, 3 bathrooms, a spacious living-dining room with beautiful views of the pool and gardens, in a gated community. It (...)
€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 (...)
€449,000
TSEA5158285
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 148 Lot Size: 89 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Lot Size: 89 Area: Istan Region: Andalucía
"Istan" is a town of Arabic origin, located in the Natural Park of Sierra de las Nieves and just 15 kilometres from the beaches of Marbella.
This beautifully completely renovated house can (...)
€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 (...)
Current Featured Properties
€2,450,000
TSEA5005555
- Los Monteros, 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
Palm Beach is a secure, gated community located on Marbella's eastern coast beachfront, just a 5-minute drive from the heart of the city and situated directly along one of the region's most beautiful (...)
€323,000
TSEA4644049
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 99 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: Casares Region: Andalucía
This new development offers various golf courses within a radius of just 15 minutes, including the Casares Costa Golf complex, where the spectacular Finca Cortesín Golf & SPA is located, next to (...)
€735,000
TSEA4183138
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 133 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 133 Area: Casares Region: Andalucía
NEWLEY UPDATED AND RE RELEASED.
This development located in the prestigious Urbanization of Finca Cortesín, considered the ONE OF THE BEST GOLF RESORTS IN EUROPE and which will have a total of 51 (...)
