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,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 (39,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 (39,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 841 - 860 of 1810 €285,000
TSEA5040859
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 77 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Mijas and Mijas Costa Region: Andalucía
Discover this beautifully laid-out elevated ground floor apartment featuring 2 bedrooms and 2 bathrooms, located in the tranquil and gated community of Calanova Grand Golf, Mijas.
With 104 m² of (...)
€235,000
TSEA5040703
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 89 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Casares Region: Andalucía
***Sunny Terrace with Garden Views*** This beautifully presented 2-bedroom, 2-bathroom apartment is located in the sought-after urbanisation of Casares del Sol. Surrounded by landscaped gardens and (...)
€1,590,000
TSEA5040688
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 261 Lot Size: 200 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 261 Lot Size: 200 Area: Marbella Region: Andalucía
Semi-Detached House for Sale in Hill Club, Sierra Blanca, Marbella
Discover this stunning semi-detached house in the exclusive area of Hill Club, in Sierra Blanca, Marbella. With a constructed area (...)
€790,000
TSEA5040520
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 130 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Benahavis Region: Andalucía
Welcome to this stunning property in the exclusive urbanization of La Alborada Homes in Benahavís. Completely renovated in 2022, this stylish apartment blends modern luxury, comfort, and a prime (...)
€895,000
TSEA5040505
- Limonar, Costa Del Sol
Beds: 2 Baths: 2 M2: 128 Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Region: Andalucía
New Development: Prices from 895,000 € to 2,600,000 €. [Beds: 2 - 4] [Baths: 2 - 4] [Built size: 128.00 m2 - 245.00 m2]
This project is an exclusive development of 18 luxury homes in one of the (...)
€399,900
TSEA5040331
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 92 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 92 Area: Marbella Region: Andalucía
City Living by the Sea – Marbella Central, Ricardo Soriano Meets Old Town Charm (Tourist rentals allowed)
Step into this beautiful spacious 3-bedroom apartment, perfectly positioned in one of (...)
€519,000
TSEA5040325
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 166 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 166 Area: San Pedro Region: Andalucía
Discover this beautifully fully renovated 3-bedroom apartment located in a gated community of Guadalmina Alta, Marbella. Thoughtfully designed for modern living, the property features a spacious (...)
€495,000
TSEA5040073
- Monda, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 342 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 342 Area: Marbella Region: Andalucía
Traditional Andalusian Home with Guest Apartment – Prime Location in Monda Village
Welcome to this beautifully restored village home, full of authentic charm and modern comfort, located right in (...)
€164,000
TSEA5040043
- Valle Romano, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 79 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 79 Area: Estepona Region: Andalucía
NOT SUITABLE FOR PERMANENT RESIDENCY - INVESTOR ONLY OPPORTUNITY
APARTHOTEL* Valle Romano Golf & Resort - Estepona
*This property is located in an aparthotel, making it a perfect option for (...)
€699,000
TSEA5039860
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 138 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Area: Benahavis Region: Andalucía
This charming townhouse is located in El Alto, an exclusive gated community perched at the top of the hill, offering a peaceful retreat far from the noise and hustle of daily life. The urbanisation (...)
€479,000
TSEA5039452
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 110 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 110 Area: Fuengirola Region: Andalucía
This 110-square-meter property offers an excellent investment opportunity just steps from the sea. The home features four spacious bedrooms, ideal for families or those seeking comfort and (...)
€525,000
TSEA5039365
- Guadalmar, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 134 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Malaga Region: Andalucía
Discover this delightful 3-bedroom, 2-bathroom townhouse nestled in the sought-after coastal neighbourhood of Guadalmar, Málaga — just a short stroll from the beach and local amenities.
Key (...)
€427,000
TSEA5039149
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 95 Lot Size: 200 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Lot Size: 200 Area: Marbella Region: Andalucía
Nestled in the serene enclave of Los Altos de Marbella, Marbella East, this exquisite duplex offers a harmonious blend of modern comfort and natural beauty. Spanning a built area of 95m², this (...)
€1,750,000
TSEA5039128
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 164 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 164 Area: Benahavis Region: Andalucía
This is a meticulously renovated three-level townhouse for sale located in the secure, well-maintained community of La Quinta Hills in Benahavís. Fully renovated in 2024, this property showcases a (...)
€579,000
TSEA4889908
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Estepona Region: Andalucía
New Development: Prices from 579,000 € to 936,000 €. [Beds: 2 - 4] [Baths: 2 - 3] [Built size: 94.00 m2 - 152.00 m2]
Luxury 2, 3 and 4 bedroom apartments, and 3 bedroom semi-detached villas, in (...)
€399,000
TSEA5039014
- Los Pacos, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 103 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 103 Area: Mijas and Mijas Costa Region: Andalucía
Charming Andalusian-Style Home in the Heart of Los Pacos!
Discover this beautiful Andalusian-style townhouse, located in one of the most sought-after areas of Fuengirola – right in the heart of (...)
€364,900
TSEA5038912
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Elegant Renovated Apartment in Selwo Hills 1B – Move-in Ready
Set within a beautifully maintained complex, this bright and stylish apartment offers comfort, quality, and functionality in one of (...)
€75,000
TSEA5038819
- Ronda, Costa Del Sol, Ronda
Beds: 2 Baths: 1 M2: 88 Area: Ronda Region: Andalucía
Beds: 2 Baths: 1 M2: 88 Area: Ronda Region: Andalucía
Fabulous reformed 2 Bed 1 Bathroom Townhouse in Pruna.
The house is 2 bedroom, a large living room/kitchen and diner, bathroom with shower, large roof Terrace with fabulous views over Pruna village, (...)
€635,000
TSEA5038783
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 131 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 131 Area: Estepona Region: Andalucía
Welcome to your new home at *Agra Residencial*, next to *El Campanario Golf and Country Club*—a peaceful and well-connected residential area.
This modern townhouse located on the New Golden Mile (...)
€759,000
TSEA5038780
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 160 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Marbella Region: Andalucía
Modern Ground Floor Apartment with Terrace and Pool in Marbella
Discover this bright and spacious 160 m² (138 m² usable) ground floor apartment in a modern building with elevator. It features (...)
Current Featured Properties
€1,825,000
TSEA4798249
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 142 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 142 Area: Estepona Region: Andalucía
This south facing 3 bedroom and 3-bathroom ground floor apartment has been fully renovated to the highest standards and offers delightful views of the lush landscaped gardens. With a total built area (...)
€695,000
TSEA4940635
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Perfectly combines living in natural surroundings with the comfort of being only a short distance from the center of Estepona. As well as a coastline that stretches for 20km, the town has great (...)
€585,000
TSEA4819738
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 103 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: Benahavis Region: Andalucía
The new residential is part of the renowned private urbanization "La Hacienda del Señorío de Cifuentes" with which they will share the enjoyment of its current four swimming pools with (...)
