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 (36,42,43,44,45)
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 (36,42,43,44,45)
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 (36,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 121 - 140 of 2642
€5,995,000
TSEA5145121
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 720 Lot Size: 2,000 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 720 Lot Size: 2,000 Area: Marbella East Region: Andalucía
This substantial property is set in a privileged position within walking distance of the beach and all amenities, offering a high level of privacy being accessed via a private cul-de-sac. There is a (...)
€14,000,000
TSEA5145118
- New Golden Mile, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 880 Lot Size: 2,610 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 880 Lot Size: 2,610 Area: Estepona Region: Andalucía
Luxury Beachfront Villa in Casasola – New Golden Mile, Estepona
Introducing a classic beachfront villa in Casasola, one of the most prestigious residential areas on Estepona's New Golden Mile. (...)
€1,460,000
TSEA5145040
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 336 Lot Size: 505 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 336 Lot Size: 505 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to your beachfront retreat! This recently refurbished villa, perfectly situated between Fuengirola and La Cala de Mijas, is designed for both comfort and seaside living. With five bedrooms (...)
€299,000
TSEA5144968
- Calypso, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 72 Lot Size: 205 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Lot Size: 205 Area: Mijas and Mijas Costa Region: Andalucía
Charming South-Facing Bungalow in Calypso – Walking Distance to the Beach!
Discover this delightful bungalow in the sought-after area of Calypso, perfectly located just a short stroll from the (...)
€535,000
TSEA5144878
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M2: 131 Lot Size: 5,740 Area: Coin Region: Andalucía
Beds: 4 Baths: 2 M2: 131 Lot Size: 5,740 Area: Coin Region: Andalucía
Located just a few minutes from the charming village of Coín, this delightful country house offers the perfect combination of tranquillity, privacy and comfort, right in the heart of the Andalusian (...)
€895,000
TSEA5144848
- Torre del Mar, Costa Del Sol East
Beds: 6 Baths: 5 M2: 410 Lot Size: 558 Region: Andalucía
Beds: 6 Baths: 5 M2: 410 Lot Size: 558 Region: Andalucía
This stunning villa with 6 bedrooms and 5 bathrooms is located in one of Torre del Mar's most sought-after areas, offering the perfect blend of modern comfort and classic Mediterranean charm. With a (...)
€3,500,000
TSEA5144812
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 4 Baths: 4 M2: 367 Lot Size: 2,900 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 4 M2: 367 Lot Size: 2,900 Area: Sotogrande Region: Andalucía
New Development: Prices from 3,500,000 € to 3,500,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 367.00 m2 - 367.00 m2]
Located among golf courses, this villa embodies a life of serenity and (...)
€695,000
TSEA5144791
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 230 Lot Size: 1,382 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 230 Lot Size: 1,382 Area: Mijas and Mijas Costa Region: Andalucía
With incredible views down the valley to the coast of Málaga and the sea, this impressive, detached villa can be used as either a spacious family home or has the possibility of being a high-end (...)
€349,000
TSEA5144194
- Cártama, Costa Del Sol, Cartama
Beds: 3 Baths: 2 M2: 233 Lot Size: 2,536 Area: Cartama Region: Andalucía
Beds: 3 Baths: 2 M2: 233 Lot Size: 2,536 Area: Cartama Region: Andalucía
Located on the outskirts of the village of Villafranco, this delightful country property enjoys excellent road access and is just a 5-minute drive from the A357 motorway, and 10 minutes from both (...)
€239,000
TSEA5144152
- Almachar, Costa Del Sol East
Beds: 3 Baths: 2 M2: 109 Lot Size: 3,869 Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Lot Size: 3,869 Region: Andalucía
This charming Spanish home is set entirely on one level and is located just a nine-minute drive from Almáchar. The road leading to the property is mostly paved, with the final four kilometers along (...)
€429,000
TSEA5144131
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 2 M2: 138 Lot Size: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 2 M2: 138 Lot Size: 80 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular 3-storey semi-detached villa for sale very close to La Cala de Mijas! This modern, spacious and very bright 4-bedroom, 3-bathroom villa is built to the highest standards. It has air (...)
€2,390,000
TSEA5144125
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 296 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 296 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular villa that perfectly blends Mediterranean style with contemporary design, combining traditional charm with modern comfort and top-quality finishes. Located in the prestigious Buena Vista (...)
€985,000
TSEA5144044
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 6 Baths: 4 M2: 218 Area: Fuengirola Region: Andalucía
Beds: 6 Baths: 4 M2: 218 Area: Fuengirola Region: Andalucía
Corner villa in Puebla Lucía, the most exclusive residential area in Fuengirola
In the heart of Fuengirola, within the prestigious and gated community of Puebla Lucía, lies this bright (...)
€850,000
TSEA5143966
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 3 M2: 132 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 3 M2: 132 Area: Nerja and Malaga East Region: Andalucía
Cartujano Villas – Luxury and Privacy Just Steps from Burriana Beach
Discover Cartujano Villas, an exclusive collection of only four detached villas in the heart of Nerja, just a short walk from (...)
€645,000
TSEA5143933
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 4 Baths: 3 M2: 227 Lot Size: 4,375 Area: Alhaurin el Grande Region: Andalucía
Beds: 4 Baths: 3 M2: 227 Lot Size: 4,375 Area: Alhaurin el Grande Region: Andalucía
Fabulous Four Bedroom Finca
This exceptional property is the very definition of a country finca. From its spacious four-bedroom accommodation to its extensive landscaped gardens, this meticulously (...)
€995,000
TSEA5143927
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 3 M2: 580 Lot Size: 701 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 3 M2: 580 Lot Size: 701 Area: Nerja and Malaga East Region: Andalucía
This historic property is a large renovated old Mill, previously a working flour mill for the Larios family until approximately 60 years ago named Molino San Jose. The villa has three bedrooms, three (...)
€1,695,000
TSEA5143909
- La Mairena, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 254 Lot Size: 2,750 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 254 Lot Size: 2,750 Area: Marbella East Region: Andalucía
Spacious Family Villa with Panoramic Views in La Mairena
This beautifully presented villa in La Mairena was originally built in 2009 and tastefully renovated in 2021, bringing it up to modern (...)
€1,869,000
TSEA5143879
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M2: 210 Area: Casares Region: Andalucía
Beds: 4 Baths: 4 M2: 210 Area: Casares Region: Andalucía
Luxury villa with unrivalled Mediterranean views – Camarate del Golf, Casares Costa
In the privileged setting of Camarate del Golf, one of the most exclusive residential areas of Casares Costa, (...)
€685,000
TSEA5143825
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 5 M2: 287 Lot Size: 630 Area: Coin Region: Andalucía
Beds: 4 Baths: 5 M2: 287 Lot Size: 630 Area: Coin Region: Andalucía
STUNNING FOUR BEDROOM, FIVE BATHROOM VILLA
A must-see, substantially built and deceptively spacious, four-bedroom detached villa with four en-suite bathrooms, located within an exclusive and (...)
€1,395,000
TSEA5143783
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 195 Lot Size: 420 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 195 Lot Size: 420 Area: San Pedro Region: Andalucía
Discover this spectacular modern design villa for sale! Located on a 420 m² plot and with 195 m² of usable area, this property offers an exclusive and sophisticated lifestyle. Upon entering, you'll (...)
Current Featured Properties
€2,750,000
TSEA4446295
- Manilva, Costa Del Sol, Manilva
Beds: 5 Baths: 7 M2: 480 Lot Size: 1,400 Area: Manilva Region: Andalucía
Beds: 5 Baths: 7 M2: 480 Lot Size: 1,400 Area: Manilva Region: Andalucía
SEIZE THE OPPORTUNITY: SPECTACULAR HOME WITH MODERN AMENITIES AWAITS!!
With 5 bedrooms and 7 bathrooms, it is perfect for a large family or for those who love to entertain guests. The property (...)
€6,395,000
Detached Villa in Benahavis
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 498 Lot Size: 2,406 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 498 Lot Size: 2,406 Area: Benahavis Region: Andalucía
A PROPERTY IN A DIFFERENT LEAGUE!!
400,000€ discount if you purchase before completion! This is a sustainable luxury development of 18 individually designed villas situated in the 200-hectare (...)
€8,096,900
TSEA4372201
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 583 Lot Size: 1,150 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 583 Lot Size: 1,150 Area: Benahavis Region: Andalucía
This is a luxury residential complex of 53 unique 4, 5 villas sitting gently on the side of a hill, with every villa standing on a different height. The prestigious position is over looking the (...)
