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 (63,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 (63,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 (63,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 41 - 60 of 2642
€900,000
TSEA5154904
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 280 Lot Size: 407 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 280 Lot Size: 407 Area: Marbella West Region: Andalucía
For Sale in Nueva Andalucía – La Campana
We present a beautiful house in Nueva Andalucía, located in the La Campana area and in excellent condition. The property features three spacious (...)
€1,800,000
TSEA5154859
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 419 Lot Size: 419 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 419 Lot Size: 419 Area: Estepona Region: Andalucía
New Development: Prices from 1,800,000 € to 1,800,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 419.00 m2 - 419.00 m2]
Discover the collection of eight exclusive designed residential villas, (...)
€2,650,000
TSEA5154856
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 372 Lot Size: 567 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 372 Lot Size: 567 Area: Estepona Region: Andalucía
New Development: Prices from 2,650,000 € to 2,650,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 372.00 m2 - 372.00 m2]
Discover the collection of eight exclusive designed residential villas, (...)
€3,495,000
TSEA5154823
- Gaucín, Costa Del Sol, Gaucin
Beds: 4 Baths: 5 M2: 525 Lot Size: 40,000 Area: Gaucin Region: Andalucía
Beds: 4 Baths: 5 M2: 525 Lot Size: 40,000 Area: Gaucin Region: Andalucía
Stunning Rural Villa in Gaucín with Panoramic Views
Nestled in the picturesque Andalusian countryside, this impressive villa built in 2008 offers a perfect blend of rustic charm and modern comfort. (...)
€244,000
TSEA5154787
- San Roque, Costa Del Sol, San Roque
Beds: 3 Baths: 1 M2: 95 Area: San Roque Region: Andalucía
Beds: 3 Baths: 1 M2: 95 Area: San Roque Region: Andalucía
Detached house in Carteya (San Roque Pueblo, Costa del Sol)
In the heart of the historic center of San Roque, next to the Church and the Mirador Poeta Domingo de Mena, lies this detached house that (...)
€695,000
TSEA5153797
- Arenas, Costa Del Sol East
Beds: 3 Baths: 3 M2: 183 Lot Size: 4,284 Region: Andalucía
Beds: 3 Baths: 3 M2: 183 Lot Size: 4,284 Region: Andalucía
Are you dreaming of a life under the Spanish sun, surrounded by peace, space and ultimate comfort? This bright and elegant villa, located between Vélez-Málaga and the charming village of Arenas, (...)
€2,295,000
TSEA5153674
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 3 M2: 222 Lot Size: 721 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 3 M2: 222 Lot Size: 721 Area: Marbella West Region: Andalucía
Detached Andalusian-Style Villa in Nueva Andalucía — Walk to Puerto Banús & the Beach
Tucked away in a quiet cul-de-sac, this charming Andalusian-style villa offers privacy, stunning views (...)
€1,092,500
TSEA5153542
- Los Pacos, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 349 Lot Size: 250 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 349 Lot Size: 250 Area: Mijas and Mijas Costa Region: Andalucía
Appointments for viewing is in January 2026 -The property is rented until end of June 2026. Contact us for more informacion.
Amazing independent villa for sale in Los Pacos -beautiful seaviews, (...)
€340,000
TSEA5153530
- San Roque, Costa Del Sol, San Roque
Beds: 4 Baths: 3 M2: 270 Lot Size: 2,500 Area: San Roque Region: Andalucía
Beds: 4 Baths: 3 M2: 270 Lot Size: 2,500 Area: San Roque Region: Andalucía
Spacious Independent Villa in San Roque Pueblo – Private Pool, Garden, and Special Land Offer!
Discover this elegant independent house in the charming heart of San Roque Pueblo, built in 2005 and (...)
€288,000
TSEA5153482
- Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 5 Baths: 1 M2: 235 Lot Size: 2,300 Area: Nerja and Malaga East Region: Andalucía
Beds: 5 Baths: 1 M2: 235 Lot Size: 2,300 Area: Nerja and Malaga East Region: Andalucía
UNIQUE OPPORTUNITY: Authentic Mill House in Los Dioses - A Gem Full of Potential
Discover this exceptional property in the picturesque hamlet of Los Dioses, just 1.5 km from the charming village of (...)
€2,200,000
TSEA5153254
- San Roque Club, Costa Del Sol
Beds: 5 Baths: 5 M2: 658 Lot Size: 1,408 Region: Andalucía
Beds: 5 Baths: 5 M2: 658 Lot Size: 1,408 Region: Andalucía
This beautifully renovated villa is located in one of Sotogrande's most prestigious areas, just steps from the world-renowned Valderrama Golf Course. Designed in an elegant Mediterranean style and (...)
€578,000
TSEA5153134
- Canillas de Albaida, Costa Del Sol East
Beds: 3 Baths: 3 M2: 135 Lot Size: 2,500 Region: Andalucía
Beds: 3 Baths: 3 M2: 135 Lot Size: 2,500 Region: Andalucía
This charming country house in Canillas de Albaida, Malaga, offers a harmonious combination of rustic charm and modern comfort. The property, on one floor, is distributed in three bedrooms with (...)
€10,900,000
TSEA5153119
- Aloha, Costa Del Sol, Marbella West
Beds: 6 Baths: 7 M2: 702 Lot Size: 2,349 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 7 M2: 702 Lot Size: 2,349 Area: Marbella West Region: Andalucía
Aloha 40 is a true retreat set in the exclusive Aloha neighborhood at the heart of Marbella's Golf Valley. This impressive residence is located within a secure gated community and enjoys a privileged (...)
€5,900,000
TSEA5153068
- Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 5 M2: 429 Lot Size: 1,250 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 5 M2: 429 Lot Size: 1,250 Area: Marbella East Region: Andalucía
Marbella – Exceptional Contemporary Villa, Sold Furnished, in the Exclusive Rio Real Area, Next to the Golf
This stunning villa, fully renovated in 2023 with the finest materials, is south-facing (...)
€1,200,000
TSEA5152990
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 4 Baths: 3 M2: 413 Lot Size: 1,167 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 3 M2: 413 Lot Size: 1,167 Area: Sotogrande Region: Andalucía
Elegant Villa in Sotogrande Alto with Mediterranean Charm and Open Views
Located in one of the most peaceful and established areas of Sotogrande Alto, this villa combines traditional Mediterranean (...)
€2,600,000
TSEA5152978
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 5 M2: 420 Lot Size: 395 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 5 M2: 420 Lot Size: 395 Area: San Pedro Region: Andalucía
Welcome to this spectacular corner semi-detached house, located just 250 meters from the promenade and the vibrant San Pedro boulevard! This area is renowned for being one of the most sought-after on (...)
€600,000
TSEA5152948
- Pelayo, Costa de la Luz
Beds: 7 Baths: 3 M2: 500 Lot Size: 11,711 Region: Andalucía
Beds: 7 Baths: 3 M2: 500 Lot Size: 11,711 Region: Andalucía
Exclusive urban estate set on three plots totaling 11,000 m², located in Pelayo just 5 minutes from Algeciras and 15 minutes from Tarifa, bordering Los Alcornocales Natural Park and offering an (...)
€1,390,000
TSEA5152159
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 346 Lot Size: 534 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 346 Lot Size: 534 Area: Marbella West Region: Andalucía
Modern beautiful newly renovated 3 floor villa located in the heart of Nueva Andalucia very close to famous padelclub Real Club Padel.
The villa has a private pool beautiful garden and parking. (...)
€2,195,000
TSEA5152036
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 382 Lot Size: 609 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 382 Lot Size: 609 Area: San Pedro Region: Andalucía
Welcome to this charming beachside villa with private pool in San Pedro!
Just 300 meters from the golden sands of the Mediterranean, this stunning 4-bedroom villa offers the perfect blend of coastal (...)
€595,000
TSEA5152030
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 6 Baths: 4 M2: 418 Lot Size: 4,905 Area: Alhaurin el Grande Region: Andalucía
Beds: 6 Baths: 4 M2: 418 Lot Size: 4,905 Area: Alhaurin el Grande Region: Andalucía
Exclusively with us! Attention investors and large families! This could be your opportunity! This is a very large country house with a built area of 368m2, a 50m2 pool, and a 4905m2 plot (...)
Current Featured Properties
€2,900,000
TSEA4679083
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 5 M2: 271 Lot Size: 11 Area: Estepona Region: Andalucía
Beds: 3 Baths: 5 M2: 271 Lot Size: 11 Area: Estepona Region: Andalucía
Located in a picturesque and coveted setting amidst nature's splendour, This luxury development comprises a collection of twelve sophisticated and exclusive villas boasting contemporary aesthetics. (...)
€1,800,000
TSEA5063395
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 385 Lot Size: 10,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 385 Lot Size: 10,000 Area: Mijas and Mijas Costa Region: Andalucía
Immerse yourself in the captivating charm of this refined utterly peaceful country home, affording absolute privacy and breathtaking panoramic views, which unfold before you as far as the sea and the (...)
€3,890,000
Detached Villa in Nueva Andalucia
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 229 Lot Size: 1,008 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 229 Lot Size: 1,008 Area: Marbella West Region: Andalucía
THE ULTIMATE LUXURY LIVING!!!
Combining luxury and nature in an exceptional environment. Two unique villas built on one floor and designed to enjoy the Mediterranean lifestyle in a relaxed way, (...)
