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 21 - 40 of 4003
€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, (...)
€530,000
TSEA5158819
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 104 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Marbella Region: Andalucía
Situated in the heart of Marbella Centro, this unique first floor apartment offers a rare opportunity with its south orientation and an large private terrace that spans the entire building and (...)
€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 (...)
€849,000
TSEA5158765
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 137 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 137 Area: Marbella West Region: Andalucía
Exclusive Duplex Penthouse in El Dorado – Nueva Andalucía
Discover this unique and fully renovated duplex penthouse in the sought-after El Dorado, a charming complex within walking distance to (...)
€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 (...)
€495,000
TSEA5158228
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 127 Lot Size: 28 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 28 Area: Algeciras Region: Andalucía
Everyone wants outside space.
Everyone wants walk to beach, shops, a few restaurants.
And every wants a sea view. These are our common requests.
What if you can get all of the above, a little sea (...)
€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 (...)
€750,000
TSEA5158210
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 227 Lot Size: 270 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 227 Lot Size: 270 Area: Benahavis Region: Andalucía
Spectacular ground floor duplex flat located in the exclusive gated community of Riverside, in the village of Benahavís, a secure environment where residents enjoy peace and privacy. One of the most (...)
€745,000
TSEA5158165
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 106 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 106 Area: Estepona Region: Andalucía
Apartment for sale – Benatalaya Urbanization
Discover this spacious and bright ground floor apartment, ideal for enjoying life on the coast. With 250 m² built and 206 m² useful, this property (...)
€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 (...)
€750,000
TSEA5158048
- Sotogrande Marina, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 137 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Sotogrande Region: Andalucía
???? Duplex Apartment with Solarium and Marina Views in Sotogrande
Located in one of the most exclusive areas of the Costa del Sol, this stunning apartment in the Sotogrande Marina offers generous (...)
€299,000
TSEA5158045
- Estepona, 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
Beautiful 2 bedroom ground floor apartment in the old town of Estepona, The property has a large living room with semi open plan kitchen, two double bedrooms, large bathroom and courtyard patio,
It (...)
€955,000
TSEA5157919
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 161 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 161 Area: Estepona Region: Andalucía
Luxury Seafront Residence in the Exclusive Bahía de la Plata Complex, Estepona
Exclusive seafront residence located in the prestigious Bahía de la Plata complex in Estepona. The complex enjoys an (...)
Current Featured Properties
€1,150,000
TSEA4742692
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 153 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 153 Area: Estepona Region: Andalucía
Located on the Costa del Sol, this boutique complex of 24 homes overlooks the Mediterranean and offers a wonderful spectacle of light and tranquility. Live the lifestyle you deserve in this dreamlike (...)
€1,599,900
TSEA4624528
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 103 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Fuengirola Region: Andalucía
This brand new development stands out! An exclusive residential complex with spacious layouts and top-tier construction. The residences have been built with the highest-quality materials and feature (...)
€510,000
TSEA4116655
- Málaga Este, Costa Del Sol, Malaga City
Beds: 2 Baths: 2 M2: 74 Area: Malaga City Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Malaga City Region: Andalucía
VIEWS THAT SEEM TO GO ON FOR MILES!!!!
This is an exclusive development with terraces and sea views enabling you to wake up to views of the Mediterranean horizon. A total of 41 south- and southeast (...)
