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 (39)
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 (39)
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 (39)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 261 - 280 of 1069 €299,000
TSEA5112307
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 95 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Benahavis Region: Andalucía
*** Frontline Golf ***
Modern ground floor 2 bed 2 bath apartment
A practical hassle-free investment and holiday home!
This property offers the perfect blend of resort hotel services and amenities (...)
€240,000
TSEA5112277
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 1 M2: 93 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 1 M2: 93 Area: Benahavis Region: Andalucía
Apartment for sale. Benahavis
Property located in one of the most popular areas of the Costa del Sol, just minutes from all kinds of services: supermarkets, schools, restaurants and green areas. An (...)
€590,000
TSEA5112061
- Tarifa, Costa de la Luz
Beds: 2 Baths: 1 M2: 110 Region: Andalucía
Beds: 2 Baths: 1 M2: 110 Region: Andalucía
2-bedroom apartment in Tarifa facing the sought-after Los Lances beach, just 200 meters from it, with sea views from its terrace. It has 110 m2 distributed over 2 spacious bedrooms, 1 bathroom, and a (...)
€339,000
TSEA5111674
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 75 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 75 Area: Estepona Region: Andalucía
First line Beach Apartment in Estepona
We are delighted to present this well maintained ground-floor apartment, perfectly positioned on the first line in Estepona. Offering an exceptional (...)
€349,000
TSEA5111605
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
AMAZING OPPORTUNITY - Spacious 2 bedroom apartment in this luxury development enjoys all the facilities of a five star hotel - free to residents - set in spectacular countryside above Elviria (...)
€525,000
TSEA5111362
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 68 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 68 Area: Marbella Region: Andalucía
Experience Coastal Living at Alvarito Playa: A 3-Bedroom Beach Apartment in Marbella
Perfectly situated near the renowned Alicate Playa in Marbella, this spacious apartment at Alvarito Playa offers (...)
€260,000
TSEA5110831
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Cozy Apartment with Sunny Southeast-Facing Terrace – Miraflores Golf Club
Charming and bright, this apartment features 2 spacious bedrooms, 2 modern bathrooms, and an independent fully-equipped (...)
€228,000
TSEA5110648
- Algeciras, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 100 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Algeciras Region: Andalucía
Ground Floor Apartment with Private Patio in Algeciras, Cádiz
This cozy three-bedroom ground-floor apartment offers a prime location near the center of Algeciras, in a quiet, well-connected private (...)
€239,000
TSEA5110246
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 90 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: La Duquesa Region: Andalucía
Stunning Apartment for Sale – La Colina, Princesa Kristina, Manilva!
Dreaming of owning a Costa del Sol property?
This 2-bedroom, 2-bathroom apartment in the exclusive La Colina, Princesa Kristina (...)
€465,000
TSEA5109757
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 5 M2: 193 Lot Size: 193 Area: Casares Region: Andalucía
Beds: 3 Baths: 5 M2: 193 Lot Size: 193 Area: Casares Region: Andalucía
Off-Market Listing – Ground Floor Luxury in Majestic Gardens, Casares, Málaga
Discover a rare off-market opportunity in the prestigious enclave of Majestic Gardens, Casares. This elegantly (...)
€375,100
TSEA5109613
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 1 Baths: 1 M2: 49 Lot Size: 62 Area: Nerja and Malaga East Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Lot Size: 62 Area: Nerja and Malaga East Region: Andalucía
Ground-Floor Apartment with Private Terrace and Natural Light – Costa del Sol
This charming ground-floor apartment is located in a prime position by the sea, in one of the most desirable areas of (...)
€435,600
TSEA5109589
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 57 Lot Size: 68 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 57 Lot Size: 68 Area: Nerja and Malaga East Region: Andalucía
Ground-Floor Apartment with Private Terrace and Sea Views – Costa del Sol
This modern apartment enjoys an exceptional seafront location in one of the most sought-after areas of the Costa del (...)
€445,000
TSEA5109409
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
If you're looking for a spacious, modern, and key-ready apartment with a large private terrace perfect for entertaining, this stunning ground floor property in La Cala Golf Resort is a must-see. (...)
€485,000
TSEA5109214
- Centro Histórico, Costa Del Sol
Beds: 1 Baths: 2 M2: 125 Region: Andalucía
Beds: 1 Baths: 2 M2: 125 Region: Andalucía
Spacious exterior apartment in the historic centre of Malaga, on the fourth floor with a south orientation.
The apartment is located in the heart of the historic centre of Malaga, on the fourth (...)
€195,000
TSEA5109190
- Antequera, Costa Del Sol, Antequera
Beds: 3 Baths: 2 M2: 134 Area: Antequera Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Antequera Region: Andalucía
Located in the vibrant heart of Antequera town centre, this beautifully reformed 3-bedroom, 2-bathroom apartment offers the perfect blend of modern comfort and Andalusian charm. Set on one of the (...)
€1,060,000
TSEA5109178
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 80 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Malaga Region: Andalucía
Living on the beachfront of La Malagueta means much more than having a home by the sea: it is about experiencing the very essence of Málaga every day. This 8th-floor apartment combines the comfort (...)
€820,000
TSEA5109163
- La Capellania, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 219 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 219 Area: Fuengirola Region: Andalucía
Spectacular apartment in Benalmádena with frontal views to the sea that you can enjoy from the living room and the master bedroom. It consists of 3 bedrooms, one of them en suite, and the other two (...)
€233,500
TSEA5109067
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 73 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 73 Area: Marbella Region: Andalucía
If you're looking for a home with natural light, open views, and an excellent location, this property could be just what you're looking for. Located on the seventh floor in the heart of Marbella, it (...)
€445,000
TSEA5108974
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 149 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 149 Area: Estepona Region: Andalucía
Located within a very pleasant, secure residential community offering 24/7 security, this beautifully presented apartment combines comfort and resort-style amenities. Residents enjoy access to three (...)
€593,000
TSEA5108602
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Modern property with private garden and sea views in Paraíso Pueblo
Located in one of the most exclusive and well-equipped residential gated complexes on the Costa del Sol, this bright and (...)
Current Featured Properties
€685,000
TSEA4440064
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 204 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 204 Area: Estepona Region: Andalucía
FANTASTIC OPPORTUNITY IN BEAUTIFUL ESTEPONA.
This new development is located in Estepona just a short walk to the fabulous port and historic old town. The properties will be 2, 3 and 4 beds, with (...)
€480,000
TSEA4791484
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
We are delighted to introduce this fabulous new development in in the beautiful area of Arroyo Enmedio in Estepona – an exclusive new development featuring 48 two and 3-bedroom apartments and (...)
€608,000
TSEA4752202
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 106 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Estepona Region: Andalucía
IDEALLY SITUATED BETWEEN ESTEPONA AND PUERTO BANUS!!!
Your new home is more than just rooms and features, it must fit in with your lifestyle. We have created a floor-plan that is spacious designed to (...)
