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 (41,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 (41,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 (41,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 881 - 900 of 3420 €6,500,000
TSEA5068216
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 1,085 Lot Size: 1,941 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 1,085 Lot Size: 1,941 Area: Benahavis Region: Andalucía
Nestled in the verdant folds of El Herrojo Alto, Benahavís—where the hills roll with a studied indifference and the Mediterranean glimmers like a secret too delicious to share—stands Villa La (...)
€1,150,000
TSEA5068012
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 261 Lot Size: 8,226 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 261 Lot Size: 8,226 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to Finca El Ensueño, a private and spacious estate nestled in the sought-after Urbanización El Maro in the beautiful municipality of Mijas, Málaga. Set within a peaceful enclave with open (...)
€2,600,000
TSEA5067994
- Pinares de San Antón, Costa Del Sol
Beds: 4 Baths: 4 M2: 806 Lot Size: 921 Region: Andalucía
Beds: 4 Baths: 4 M2: 806 Lot Size: 921 Region: Andalucía
Nestled within the exclusive, verdant enclave of Pinares de San Antón, just a mere 7 minutes from the vibrant pulse of Málaga City Centre, Villa Haya stands as a testament to contemporary elegance (...)
€6,950,000
TSEA5067730
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 6 M2: 1,047 Lot Size: 909 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 6 M2: 1,047 Lot Size: 909 Area: Marbella West Region: Andalucía
Nestled gracefully upon the verdant slopes of Nueva Andalucía, this villa is a triumph of modern elegance and luxurious design, an embodiment of serene sophistication. As you approach the property, (...)
€625,000
TSEA5067373
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 124 Lot Size: 900 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Lot Size: 900 Area: Estepona Region: Andalucía
We offer this magnificent house for sale in the midst of a new development, located in the coastal town of Estepona, in the province of Malaga, five minutes from the well-known Laguna Beach, with (...)
€2,600,000
TSEA5067310
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 435 Lot Size: 650 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 435 Lot Size: 650 Area: Benalmadena Region: Andalucía
This south-facing contemporary villa in Benalmádena Costa offers impressive 180º views of the sea and nearby mountains. Set on a 650 m² plot with 400 m² of built space distributed over three (...)
€549,000
TSEA5067193
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 3 M2: 186 Lot Size: 860 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 3 M2: 186 Lot Size: 860 Area: Alhaurin el Grande Region: Andalucía
Discover this stunning villa just 2 km east of the vibrant village of Alhaurín el Grande. Set on a generous 860 m² flat plot, this beautiful property offers the perfect blend of comfort, pri-vacy, (...)
€81,000
TSEA5067172
- Benamargosa, Costa Del Sol East
Beds: 3 Baths: 2 M2: 106 Lot Size: 86 Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Lot Size: 86 Region: Andalucía
Right in the heart of the charming village of Benamargosa lies this authentic Andalusian village house full of character, history, and plenty of potential for personal touches. The property features (...)
€2,860,000
TSEA5067145
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 721 Lot Size: 2,500 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 721 Lot Size: 2,500 Area: San Pedro Region: Andalucía
We offers EXCLUSIVE LUXURY VILLA IN GUADALMINA ALTA, MARBELLA.
If you are looking to live in one of the most exclusive and peaceful areas of Marbella, this property - located on a 2,500 m² plot - (...)
€1,250,000
TSEA5067121
- Guadalmar, Costa Del Sol, Malaga
Beds: 7 Baths: 3 M2: 351 Area: Malaga Region: Andalucía
Beds: 7 Baths: 3 M2: 351 Area: Malaga Region: Andalucía
Do you dream of living in a modern villa, surrounded by nature, with access to all amenities and just steps from the sea? We present this stunning 350m² villa located in one of the most sought-after (...)
€525,000
TSEA5067010
- Pizarra, Costa Del Sol, Cartama
Beds: 3 Baths: 3 M2: 159 Lot Size: 10,000 Area: Cartama Region: Andalucía
Beds: 3 Baths: 3 M2: 159 Lot Size: 10,000 Area: Cartama Region: Andalucía
Luxurious 3-Bedroom Villa with Private Pool & Stunning Views
Discover a beautifully presented villa offering the perfect blend of comfort, style, and natural beauty. Set in a stunning location, (...)
€2,890,000
TSEA5066872
- Bel Air, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 581 Lot Size: 985 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 581 Lot Size: 985 Area: Estepona Region: Andalucía
New Development: Prices from 2,890,000 € to 3,290,000 €. [Beds: 5 - 5] [Baths: 6 - 6] [Built size: 581.00 m2 - 590.00 m2]
Welcome to a private enclave of 15 exclusive villas, located in the (...)
€1,995,000
TSEA5066854
- Santa Clara, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 340 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 340 Area: Marbella East Region: Andalucía
LUXURY CONTEMPORARY STYLE VILLA FOR SALE IN SANTA CLARA – LOS MONTEROS, EAST MARBELLA: ELEGANCE & COMFORT ON THE COSTA DEL SOL
Welcome to this luxury villa located in Santa Clara, the (...)
€895,000
TSEA5066818
- Cártama, Costa Del Sol, Cartama
Beds: 4 Baths: 4 M2: 483 Lot Size: 9,214 Area: Cartama Region: Andalucía
Beds: 4 Baths: 4 M2: 483 Lot Size: 9,214 Area: Cartama Region: Andalucía
A Sanctuary of Serenity in the Heart of Nature
Upon arrival at this estate, time seems to stand still. The house, surrounded by vibrant gardens and fruit trees, instantly conveys a sense of peace, (...)
€298,000
TSEA5066785
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 2 Baths: 1 M2: 82 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 1 M2: 82 Area: Sotogrande Region: Andalucía
Refurbished Apartment in Prime Village Location
Modern 2-bedroom apartment just a 1-minute walk to restaurants, bars, shops, and a supermarket. The bus station is only meters away, and Sotogrande (...)
€3,350,000
TSEA5066647
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 879 Lot Size: 1,786 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 879 Lot Size: 1,786 Area: Sotogrande Region: Andalucía
Tucked away on a quiet cul-de-sac in Sotogrande's tranquil F Zone, this striking new villa is currently under construction and set for completion in May 2025. Designed with modern living in mind, the (...)
€5,250,000
TSEA5066482
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 716 Lot Size: 329 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 716 Lot Size: 329 Area: Marbella East Region: Andalucía
Situated in the most exclusive location just a minute drive away from the 5-star luxury Puente Romano Hotel and Resort along with the sea promenade, these spectacular semi-detached villas have been (...)
€545,000
TSEA5066359
- Málaga Centro, Costa Del Sol, Malaga
Beds: 5 Baths: 2 M2: 145 Area: Malaga Region: Andalucía
Beds: 5 Baths: 2 M2: 145 Area: Malaga Region: Andalucía
Magnificent corner flat situated in a prime area of Malaga just 10 minutes' walk from Plaza de la Merced and the historic centre. This elegant luminous home boasts two open-air terraces and one (...)
€3,600,000
TSEA5066233
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 9 Baths: 10 M2: 1,084 Lot Size: 3,557 Area: Sotogrande Region: Andalucía
Beds: 9 Baths: 10 M2: 1,084 Lot Size: 3,557 Area: Sotogrande Region: Andalucía
Substantial family villa in Sotogrande Alto offering golf views over the San Roque Golf Course towards the Mediterranean Sea.
Situated in a quiet location, this southeast-.facing villa comprises, (...)
€6,000,000
TSEA5066002
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 930 Lot Size: 2,000 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 930 Lot Size: 2,000 Area: Sotogrande Region: Andalucía
Contemporary five-bedroom villa designed to offer next-level luxury situated in the heart of Sotogrande. Imagination and expertise come together in this property. Designed by celebrated by a renowned (...)
Current Featured Properties
€2,200,000
Detached Villa in Benahavis
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 288 Lot Size: 1,058 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 288 Lot Size: 1,058 Area: Benahavis Region: Andalucía
IN THE HILLS ABOVE THE COAST.!!
This new build, luxury villa is located in Puerto del Capitan close to the valley of Benahavis. Ideally oriented towards the west with afternoon and evening sun, this (...)
€890,000
TSEA4939027
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
This is the opportunity of living in Spain, in the best equipped residential complex in Marbella, located in a privileged spot near the golf club and with premium quality specifi cations. You will (...)
€564,000
TSEA4458094
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 101 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Estepona Region: Andalucía
GREAT LOCATION, MINUTES FROM THE BEACH!!!
This is a gated, modern and functional residential complex, perfect for everyday life. The development comprises 41 one-, two- and three-bedroom homes, (...)
