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 341 - 360 of 1810
€349,950
TSEA5121889
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
LUXURY GROUND FLOOR 2 BED 2 BATH APARTMENT MIRAFLORES.
Bright modern luxury apartment in the sought after Miraflores community. The apartment has been reformed to the highest standard. Marble floors (...)
€620,000
TSEA5121877
- Málaga Centro, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 156 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 156 Area: Malaga Region: Andalucía
Discover this spectacular 157m² complex in Malaga with 3 homes, ideal for investors who want to enjoy comfort and excellent style. Each apartment features one bedroom and a private en-suite (...)
€179,000
TSEA5121838
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 74 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 74 Area: Nerja and Malaga East Region: Andalucía
Recentely renovated corner townhouse situated in the heart of Velez Malaga, in the Plaza San Francisco near the town hall. Only 6 km from the beautiful beach in Torre Del Mar.
- Total indoor area: (...)
€678,000
TSEA5121835
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Stunning Renovated Townhouse in the Heart of Estepona's Old Town – Just Steps from the Beach.
Located in a prime south-facing corner position, this beautifully renovated townhouse combines (...)
€299,000
TSEA5121622
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
An exceptional opportunity to add value – some renovation will unlock this apartment's full potential.
This is without a doubt the best apartment in this charming boutique complex in Calahonda. (...)
€1,550,000
TSEA5121607
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 131 Lot Size: 87 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Lot Size: 87 Area: Fuengirola Region: Andalucía
Presenting an outstanding Garden Apartment located in the prestigious Higueron West, featuring its own pool and breathtaking views of both the sea and the mountains. There are only two such Garden (...)
€580,000
TSEA5121568
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 64 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 64 Area: Benalmadena Region: Andalucía
Charming Renovated Apartment in one of the Exclusive Islands of Puerto Marina Completely renovated and decorated with exquisite taste, this charming apartment is located in one of the most privileged (...)
€389,000
TSEA5121505
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 120 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Manilva Region: Andalucía
Renovated apartment with panoramic views of the sea, Gibraltar, and the African coast ✨
A refined property, designed to fully enjoy life by the sea, all year round.
This 121 m² apartment, (...)
€1,295,000
TSEA5121442
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 7 Baths: 4 M2: 478 Area: Benalmadena Region: Andalucía
Beds: 7 Baths: 4 M2: 478 Area: Benalmadena Region: Andalucía
Exceptional Beachfront Investment Opportunity 4 Turnkey Tourist Apartments in Benalmádena Costa
Presenting a rare and fabulous opportunity to acquire a one-of-a-kind beachfront investment (...)
€265,000
TSEA5121439
- Almogía, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 102 Lot Size: 93 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Lot Size: 93 Area: Malaga Region: Andalucía
Once-in-a-Lifetime Country House in Montorosso, Almogía – Ibiza Vibes in the Andalusian Hills
Fully Furnished | Saltwater Pool | Move-in Ready
Escape to your own private paradise in this (...)
€265,500
TSEA5121364
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Magnificent apartment in the heart of Estepona, with three bedrooms, two bathrooms, a fully equipped kitchen, and a living room.
The modern and well-maintained furnishings make it easy to move in (...)
€3,450,000
TSEA5121085
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 290 Lot Size: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 290 Lot Size: 120 Area: Estepona Region: Andalucía
Situated on the frontline of the New Golden Mile, between Puerto Banús and Estepona, this exceptional townhouse offers a unique blend of coastal luxury, privacy, and resort-style amenities. Located (...)
€469,000
TSEA5120977
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 112 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Area: Benahavis Region: Andalucía
OPPORTUNITY IN CAPANES DEL GOLF
Interesting opportunity in one of the best developments on the Costa del Sol, located in the Golden Triangle on the front line of the golf course, surrounded by (...)
€549,000
TSEA5120836
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 123 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Marbella East Region: Andalucía
This exceptional property is located just a 9 minutes walk to the best beaches in East Marbella and the famous Cabopino Port. Video Available! The larger than average apartment has been tastefully (...)
€499,000
TSEA5120779
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 120 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Benalmadena Region: Andalucía
Magnificent ground floor property featuring a large terrace. The apartment has been recently renovated and is located in the exclusive Santángelo area of Benalmádena.
This 160 m² south-facing (...)
€239,000
TSEA5120764
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 58 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 58 Area: Nerja and Malaga East Region: Andalucía
Totally renovated for sale in the Historic Center of Vélez-Málaga
This beautiful house is located in the picturesque old town of Vélez-Málaga, just a few steps from the main cathedral and the (...)
€514,000
TSEA5120578
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 108 Lot Size: 30 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Lot Size: 30 Area: Estepona Region: Andalucía
ESTEPONA / NEW GOLDEN MILE
Between Estepona and Puerto Banus Modern 3 bedroom 2 bathroom corner ground floor apartment with wonderful garden and swimming pool views
Homes specially designed for (...)
€995,000
TSEA5120560
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 181 Lot Size: 50 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 181 Lot Size: 50 Area: Casares Region: Andalucía
MAGNIFICENT 3-BEDROOM GROUND FLOOR APARTMENT WITH PRIVATE GARDEN ON THE BEACHFRONT
Enjoying an excellent beachfront location with direct access to the coastal path and Casares Beach, just minutes (...)
€329,950
TSEA5120545
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
This is a very rare opportunity to buy one of the best located apartments in the original Miraflores development. The gated community has 2 beautifully maintained pool and garden areas, one of which (...)
€387,000
TSEA5120518
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 77 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Torremolinos Region: Andalucía
New Development: Prices from 387,000 € to 503,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 77.00 m2 - 107.00 m2]
Located in Torremolinos, facing a Mediterranean pine forest and just steps (...)
Current Featured Properties
€570,000
TSEA4975855
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
LA PERLA DE LA HEREDIA , BENAHAVIS.
This charming townhouse is located in the cozy village of La Perla de la Heredia, just off Ronda Road. It faces south to southwest, offering lovely views of the (...)
€375,000
TSEA5155180
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 113 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Benahavis Region: Andalucía
3-bed Townhouse in Benahavís Pueblo – Costa del Sol
Set in the picturesque heart of Benahavís Pueblo, one of Andalusia's most sought-after whitewashed villages, this beautifully presented (...)
€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 (...)
