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 (56,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 (56,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 (56,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 21 - 40 of 752
€699,000
TSEA5155012
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 182 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 182 Area: Estepona Region: Andalucía
For sale, beautiful modern 3-bedroom semi-detached house with a large garage.
Excellent location in the centre of Estepona, just 300 metres walk from Calle Terraza, close to all amenities and the (...)
€565,000
TSEA5154889
- Benamara, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 125 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 125 Area: Estepona Region: Andalucía
Corner Townhouse beachside between San Pedro and Estepona. Recently reformed this 4 bed 3 bath property sits in the wonderful Benamara complex walking distance to the beach. Modern brand new open (...)
€955,000
TSEA5154769
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 139 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 139 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to a prestigious gated community in the heart of the Costa del Sol, located in the sought-after area of El Chaparral, just minutes from La Cala de Mijas and Fuengirola. This modern complex is (...)
€1,100,000
TSEA5153719
- Málaga, Costa Del Sol, Malaga
Beds: 4 Baths: 3 M2: 257 Lot Size: 215 Area: Malaga Region: Andalucía
Beds: 4 Baths: 3 M2: 257 Lot Size: 215 Area: Malaga Region: Andalucía
Exclusive home in Pedregalejo, beautifully designed and recently built. Quality, design and location come together in this property to create one of the most desirable houses for sale in the area. (...)
€355,000
TSEA5153524
- El Coto, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Charming townhouse in Mijas, Lagarejo area, in a private community with large communal areas, gardens, and a pool.
The property has 3 bedrooms, 1 full bathroom, and 1 toilet. Perfect for a quiet life (...)
€156,000
TSEA5153470
- Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 86 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Nerja and Malaga East Region: Andalucía
AUTHENTIC SPANISH CORNER HOUSE IN THE HEART OF COMARES
Discover this charming corner house located in the picturesque center of Comares, just 50 meters from the local supermarket and 30 meters from (...)
€1,050,000
TSEA5153440
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 203 Lot Size: 256 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 203 Lot Size: 256 Area: Mijas and Mijas Costa Region: Andalucía
Discover the ultimate blend of luxury, comfort, and lifestyle with this stunning, beautifully maintained, and elegantly furnished townhouse, located in the prestigious La Valvega residential (...)
€829,000
TSEA5152930
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 4 M2: 224 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 4 M2: 224 Area: Fuengirola Region: Andalucía
Modern Townhouse with Panoramic Sea Views – Torreblanca, Fuengirola
Wake up every morning to the sparkle of the Mediterranean, the warmth of the sun, and the privilege of calling this modern (...)
€600,000
TSEA5152867
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 5 Baths: 3 M2: 160 Area: Fuengirola Region: Andalucía
Beds: 5 Baths: 3 M2: 160 Area: Fuengirola Region: Andalucía
Your Dream Space with Potential in Los Boliches
Discover the perfect home in the quiet and exclusive upper area of Los Boliches. This spacious three-storey townhouse with 5 bedrooms and 3 bathrooms (...)
€614,000
TSEA5152636
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 5 Baths: 4 M2: 187 Lot Size: 1 Area: Fuengirola Region: Andalucía
Beds: 5 Baths: 4 M2: 187 Lot Size: 1 Area: Fuengirola Region: Andalucía
Discover this spacious 5-bedroom, 4-bathroom townhouse in Fuengirola, located right next to Higuerón and designed for those who want to enjoy the Mediterranean lifestyle to the fullest. This home is (...)
€280,000
TSEA5152213
- Coín, Costa Del Sol, Coin
Beds: 5 Baths: 2 M2: 159 Lot Size: 78 Area: Coin Region: Andalucía
Beds: 5 Baths: 2 M2: 159 Lot Size: 78 Area: Coin Region: Andalucía
Unique opportunity in the heart of Coín! This spacious 3-story townhouse combines Andalusian style with practicality. Featuring 5 bedrooms and 2 full bathrooms—one with a shower and the other with (...)
€498,000
TSEA5152081
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 1 M2: 220 Lot Size: 113 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 1 M2: 220 Lot Size: 113 Area: Nerja and Malaga East Region: Andalucía
In El Condal, Nerja, this spacious townhouse with a private pool offers comfortable and practical living, with well-planned spaces and several areas to enjoy both indoors and outdoors.
The property (...)
€449,900
TSEA5152006
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 101 Lot Size: 42 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Lot Size: 42 Area: Marbella East Region: Andalucía
Unique Stunning Ibiza-Style Townhouse with Private Garden – Cabopino Area minimalistic decorated with micro cement , wood and linen !!
Discover this beautifully renovated townhouse offering the (...)
€699,000
TSEA5151985
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 284 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 284 Area: Benalmadena Region: Andalucía
Unique opportunity in Benalmadena!
In the best area of Benalmadena, an impressive, fully renovated house is for sale, ready to move into. A property meticulously cared for, perfect as both a (...)
€359,000
TSEA5151778
- Archidona, Costa Del Sol, Antequera
Beds: 5 Baths: 5 M2: 510 Lot Size: 185 Area: Antequera Region: Andalucía
Beds: 5 Baths: 5 M2: 510 Lot Size: 185 Area: Antequera Region: Andalucía
Unique Baroque Townhouse for Sale in the Heart of Archidona, east of Antiquera. Step inside the timeless elegance of this impressive townhouse in the charming Andalusian town of Archidona. Spread (...)
€231,200
TSEA5151637
- San Roque, Costa Del Sol, San Roque
Beds: 3 Baths: 3 M2: 175 Area: San Roque Region: Andalucía
Beds: 3 Baths: 3 M2: 175 Area: San Roque Region: Andalucía
Townhouse in La Pólvora (San Roque, Costa del Sol)
In a quiet residential area of San Roque, well connected and with all amenities close at hand, lies this spacious townhouse, ideal for (...)
€495,000
TSEA5151043
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 211 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 211 Area: Mijas and Mijas Costa Region: Andalucía
Are you dreaming of a spacious home in peaceful and beautiful surroundings – close to both the coast and the mountains? Then this property is perfect for you.
3 bright bedrooms
2 bathrooms
Large (...)
€550,000
TSEA5150941
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 178 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 178 Area: Mijas and Mijas Costa Region: Andalucía
FANTASTIC PROPERTY IN A PRESTIGOUS LOCATION
We are delighted to offer this lovely duplex town house in the very convenient location of Miraflores Resort. The property comprises:- Spacious lounge with (...)
€675,000
TSEA5150860
- Atalaya, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 212 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 212 Area: Estepona Region: Andalucía
Spacious 4-Bedroom Townhouse in Sought-After Atalaya
Located in the highly desirable residential area of Atalaya—perfectly positioned between Estepona's charming old town and glamorous (...)
€435,000
TSEA5150092
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 225 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 225 Area: Estepona Region: Andalucía
Renovation Project: Stunning South-Facing Townhouse Near the Beach and Laguna Village – Motivated Seller!
Seize this fantastic renovation opportunity with endless potential in a spacious 5-bedroom, (...)
Current Featured Properties
€515,000
TSEA4941421
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Discover 19 stunning homes that combine nature and sea. With elegant details, spacious terraces and fitted kitchens, you will enjoy exceptional living in the heart of Mijas. Immerse yourself in a (...)
€640,000
TSEA4551028
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 3 M2: 193 Area: Istan Region: Andalucía
Beds: 3 Baths: 3 M2: 193 Area: Istan Region: Andalucía
STUNNING MOUNTAIN AND SEA VIEWS!!!
This new development encompasses precisely this combination of the best of the mountains and coast on Costa del Sol. Originally the location of an ancient oil mill (...)
€653,000
TSEA4428304
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 384 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 384 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
