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 (48,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 (48,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 (48,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 2441 - 2460 of 2656 €1,950,000
TSEA4014661
- Atalaya, Costa Del Sol, Estepona
Beds: 6 Baths: 6 M2: 412 Lot Size: 645 Area: Estepona Region: Andalucía
Beds: 6 Baths: 6 M2: 412 Lot Size: 645 Area: Estepona Region: Andalucía
WELCOME TO THE BRAND NEW PROMOTION OF 3 LUXURY MODERN VILLAS BORDERING THE NATURE IN MONTE BIARRITZ, NUEVA ATALAYA, ESTEPONA!
PLEASE, DISCOVER VILLA DUNAS!
Many of the new clients who discover (...)
€2,100,000
TSEA4014655
- New Golden Mile, Costa Del Sol, Estepona
Beds: 6 Baths: 6 M2: 418 Lot Size: 645 Area: Estepona Region: Andalucía
Beds: 6 Baths: 6 M2: 418 Lot Size: 645 Area: Estepona Region: Andalucía
WELCOME TO THE BRAND NEW PROMOTION OF 3 LUXURY MODERN VILLAS BORDERING THE NATURE IN MONTE BIARRITZ, NUEVA ATALAYA, ESTEPONA!
PLEASE, DISCOVER OUR VILLA FLORES!
Many of the new clients who discover (...)
€385,000
TSEA4004107
- Frigiliana, Costa Del Sol East
Beds: 2 Baths: 1 M2: 75 Lot Size: 1,700 Region: Andalucía
Beds: 2 Baths: 1 M2: 75 Lot Size: 1,700 Region: Andalucía
Two bedroom country house located in the Tablazos area between Nerja and Frigiliana. The property has one double and one twin bedroom, a bathroom, lounge with fireplace and a fully equipped kitchen. (...)
€1,750,000
Deatched Villa Malaga
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 186 Lot Size: 535 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 186 Lot Size: 535 Area: Malaga Region: Andalucía
A unique development of 10 villas The development offers different housing solutions that adapt to the needs of each client, choose the layout from a wide variety of options. A modern and functional (...)
€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 (...)
€2,500,000
TSEA4002823
- Estepona, Costa Del Sol, Estepona
Beds: 7 Baths: 5 M2: 714 Lot Size: 60,030 Area: Estepona Region: Andalucía
Beds: 7 Baths: 5 M2: 714 Lot Size: 60,030 Area: Estepona Region: Andalucía
GREAT PROPERTY WITH SEA VIEWS AND A PLOT OF MORE THAN 60,000M2 IN A NATURAL ENVIRONMENT A FEW MINUTES FROM ESTEPONA
Large independent villa with beautiful views of the sea and the mountains located (...)
€796,000
TSEA4002211
- Torre del Mar, Costa Del Sol East
Beds: 3 Baths: 3 M2: 445 Lot Size: 348 Region: Andalucía
Beds: 3 Baths: 3 M2: 445 Lot Size: 348 Region: Andalucía
This Villa is situated in Viña Málaga. It is in a very quiet area, but it is close to the city center, shops, pharmacies, school and the beach. It is a very modern Villa that was built in 2014 and (...)
€8,800,000
Detached Villa in Marbella
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 7 M2: 1,071 Lot Size: 2,090 Area: Marbella Region: Andalucía
Beds: 6 Baths: 7 M2: 1,071 Lot Size: 2,090 Area: Marbella Region: Andalucía
This development consists of eight contemporary villas in a gated community inside the prestigious Atalaya de Rio Verde urbanization.
All houses have more than 1.000 m2 enclosed areas with a plot (...)
€184,950
TSEA4000711
- Frigiliana, Costa Del Sol East
Beds: 1 Baths: 1 M2: 58 Lot Size: 10,000 Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Lot Size: 10,000 Region: Andalucía
3 plots of land for sale totalling approx. 10,000m2 with a ruin of 58m2.
Opportunity to renovate the ruin and enjoy the peaceful environment with fantastic panoramic views of the surrounding (...)
€375,000
TSEA4000546
- Alcaucín, Costa Del Sol East
Beds: 3 Baths: 1 M2: 121 Lot Size: 19,274 Region: Andalucía
Beds: 3 Baths: 1 M2: 121 Lot Size: 19,274 Region: Andalucía
Just outside Alcaucin and within walking distance of the village you can find this finca with a well-maintained country house of 121 m2. In front of the house there ́s a spacious terrace overlooking (...)
€1,495,000
TSEA3999574
- La Mairena, Costa Del Sol, Marbella East
Beds: 6 Baths: 5 M2: 590 Lot Size: 1,500 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 5 M2: 590 Lot Size: 1,500 Area: Marbella East Region: Andalucía
INVESTMENT OPPORTUNITY!!!
This villa set in the hills of La Mairena offering perfect views of the area. Close to German School and Hoffsass Tennis School
At present has 5 bedrooms, but could simply (...)
€446,000
TSEA3998095
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 5 Baths: 3 M2: 360 Lot Size: 360 Area: Nerja and Malaga East Region: Andalucía
Beds: 5 Baths: 3 M2: 360 Lot Size: 360 Area: Nerja and Malaga East Region: Andalucía
This is a spacious villa in Velez Malaga. It is only 250m from the courthouse, it is close to shops, restaurants, pharmacies and schools. You can access everything on foot. The house is divided into (...)
€170,000
TSEA3997588
- Cómpeta, Costa Del Sol East
Beds: 4 Baths: 2 M2: 156 Lot Size: 156 Region: Andalucía
Beds: 4 Baths: 2 M2: 156 Lot Size: 156 Region: Andalucía
We present you a great property, to either invest or simply live in Large traditional town house located in the upper part of Cómpeta near the Plaza del Carmen. It is close to pharmacies, various (...)
€449,000
TSEA3994804
- Alcaucín, Costa Del Sol East
Beds: 4 Baths: 3 M2: 234 Lot Size: 9,000 Region: Andalucía
Beds: 4 Baths: 3 M2: 234 Lot Size: 9,000 Region: Andalucía
This stylish Finca is located in an idyllic secluded location on a plot of 9000 m2. Thanks to the elevated position, there are breathtaking views of the hills and mountains. Through a solid wooden (...)
€950,000
TSEA3994801
- Benajarafe, Costa Del Sol East
Beds: 6 Baths: 2 M2: 220 Lot Size: 2,666 Region: Andalucía
Beds: 6 Baths: 2 M2: 220 Lot Size: 2,666 Region: Andalucía
Unique Seafront Property with Versatile Potential This single-story house in need of renovation is situated on a spacious 2,666 m2 plot in a prime south-facing location. With breathtaking sea and (...)
€1,049,000
TSEA3986626
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 5 Baths: 3 M2: 292 Lot Size: 752 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 3 M2: 292 Lot Size: 752 Area: Benalmadena Region: Andalucía
This spacious villa with private pool has a fantastic location in a very quiet Urbanization of Benalmadena Costa , only 10mn walk from the marina and the beach.
Built over 2 levels, it's like 2 (...)
€765,000
TSEA3979666
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 411 Lot Size: 1,400 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 411 Lot Size: 1,400 Area: Mijas and Mijas Costa Region: Andalucía
Located in the beautiful area of La Sierrezuela, very close to Fuengirola and Mijas Pueblo.
This beautiful, sunny villa is just a few minutes' walk from a small selection of shops and (...)
€2,400,000
TSEA3979624
- Costalita, Costa Del Sol, Estepona
Beds: 5 Baths: 4 M2: 600 Lot Size: 3,000 Area: Estepona Region: Andalucía
Beds: 5 Baths: 4 M2: 600 Lot Size: 3,000 Area: Estepona Region: Andalucía
SPECTACULAR VILLA IN ONE OF THE BEST AREAS OF ESTEPONA BETWEEN VILLACANA AND COSTALITA, ONE STEP FROM THE BEACH.
Incredible Villa with 690 m2 built and 1.985 m2 of land, with an impressive garden (...)
€498,000
TSEA3979042
- La Viñuela, Costa Del Sol East
Beds: 3 Baths: 1 M2: 220 Lot Size: 89,000 Region: Andalucía
Beds: 3 Baths: 1 M2: 220 Lot Size: 89,000 Region: Andalucía
Pure nature on a well-protected piece of land of 89000m2 with fully grown avocados, good for 25 to 35000 kilos per year. There are also orange and citrus trees, figs and medlars. From the cortijo you (...)
€995,000
TSEA3975967
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 4 M2: 292 Lot Size: 3,500 Area: Estepona Region: Andalucía
Beds: 6 Baths: 4 M2: 292 Lot Size: 3,500 Area: Estepona Region: Andalucía
Great villa only minutes away from the center of Estepona with open sea and mountain views. Perfectly maintained ready to move in. Offers bedrooms in the ground floor and first floor. A total of six (...)
Current Featured Properties
€2,300,240
Detached Villa in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
NO MORE NEED TO DREAM ABOUT THE PERFECT VIEW!!!
This upscale development with the best views in Fuengirola and Mijas consists of thirteen individual villas, each offering no less than four en-suite (...)
€756,413
TSEA4301248
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 283 Lot Size: 400 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 283 Lot Size: 400 Area: Estepona Region: Andalucía
A BEAUTIFUL PROPERTY IN STUNNING ESTEPONA!!!
A semi-detached villa for sale with 4 bedrooms and 4 bathrooms.
Oriented North West with frontal views of the golf course and the mountains.
A property (...)
€1,400,000
TSEA4954306
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 372 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 372 Area: Estepona Region: Andalucía
An exclusive development of seventeen designer villas located in the Estepona golf course, where luxury and sustainability come together to create unique, welcoming homes with expansive open spaces (...)
