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 861 - 880 of 3420 €1,450,000
TSEA5070412
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 166 Lot Size: 532 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 166 Lot Size: 532 Area: Estepona Region: Andalucía
New Development: Prices from 1,450,000 € to 1,990,000 €. [Beds: 3 - 3] [Baths: 4 - 4] [Built size: 166.00 m2 - 263.00 m2]
A unique collection of contemporary villas set in the privileged natural (...)
€4,750,000
TSEA5070361
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 1,030 Lot Size: 6,950 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 1,030 Lot Size: 6,950 Area: Benahavis Region: Andalucía
Perched on a rare flat double plot spanning 6.950m2 within the exclusive and secure enclave of Monte Mayor, this cortijo, style villa is a true andalucian sanctuary. Accessed via a 150meter private (...)
€880,000
TSEA5070319
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 120 Lot Size: 701 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Lot Size: 701 Area: Benalmadena Region: Andalucía
Discover your new home in Torremuelle, Benalmádena! This charming detached villa offers a built area of 120sqm on a 701sqm plot, where tranquility and sea views combine to create an idyllic (...)
€735,000
TSEA5070265
- Estacion de Cartama, Costa Del Sol, Cartama
Beds: 6 Baths: 5 M2: 400 Lot Size: 900 Area: Cartama Region: Andalucía
Beds: 6 Baths: 5 M2: 400 Lot Size: 900 Area: Cartama Region: Andalucía
Detached Villa, Estacion de Cartama, Costa del Sol.
6 Bedrooms, 5 Bathrooms, Built 400 m², Garden/Plot 900 m².
Great Villa in a quiet location in the popular town of Estacion de Cartama.
Excellent (...)
€1,856,000
TSEA5070232
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 273 Lot Size: 948 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 273 Lot Size: 948 Area: Estepona Region: Andalucía
Independent Villa in Estepona – 984 m² Plot and 273 m² Built
Main Features:
Generous 984 m² plot with 273 m² built
4 spacious and bright bedrooms
4 full bathrooms, one adapted for people (...)
€1,800,000
TSEA5070157
- Cerrado de Calderón, Costa Del Sol
Beds: 6 Baths: 3 M2: 375 Region: Andalucía
Beds: 6 Baths: 3 M2: 375 Region: Andalucía
Located in one of the most prestigious residential areas of Malaga, this impressive villa stands in the Cerrado de Calderon urbanization, offering an environment of tranquillity and (...)
€650,000
TSEA5070130
- Málaga, Costa Del Sol, Malaga
Beds: 8 Baths: 6 M2: 90 Lot Size: 5,288 Area: Malaga Region: Andalucía
Beds: 8 Baths: 6 M2: 90 Lot Size: 5,288 Area: Malaga Region: Andalucía
This charming and tastefully decorated country property is located in Campanillas, only a short drive from Málaga city. Surrounded by breathtaking nature, it offers peace, privacy, and excellent (...)
€2,000,000
TSEA5069965
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 145 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Area: Estepona Region: Andalucía
This fontal sea view penthouse is situated in the sought-after Dominion Beach area, located in Estepona East, Malaga. Offering a blend of comfort and sophistication, the property boasts a generous (...)
€3,995,000
TSEA5069938
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 7 M2: 700 Lot Size: 3,240 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 7 M2: 700 Lot Size: 3,240 Area: Benahavis Region: Andalucía
This stunning villa offers fantastic panoramic views over the Costa del Sol. Situated close to the Marbella golf club resort, within a gated community and offering 24-hour security this villa is (...)
€695,000
TSEA5069830
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 106 Lot Size: 590 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Lot Size: 590 Area: Mijas and Mijas Costa Region: Andalucía
A villa with great renovation potential in a great area Miraflores, close to the beach and the owner is OPEN TO OFFERS. Make an Offer!
Located in the exclusive area of Miraflores, this property is (...)
€350,000
TSEA5069761
- Frigiliana, Costa Del Sol East
Beds: 2 Baths: 1 M2: 90 Lot Size: 5,034 Region: Andalucía
Beds: 2 Baths: 1 M2: 90 Lot Size: 5,034 Region: Andalucía
Rustic Charm and Incredible Views: Villa with Pool in the Countryside of Frigiliana
Located in a privileged natural setting north of Frigiliana, this cozy villa offers a perfect escape from the (...)
€989,000
TSEA5069731
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 256 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 256 Area: Benalmadena Region: Andalucía
Modern property with sea views from all the three floors of the house.
Main description of the house :
The property features 4 spacious bedrooms, 4 stylish bathrooms, and a practical guest (...)
€425,000
TSEA5069719
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic 3 bedroom 2 bathroom penthouse only 11 minutes walk to La Cala beach. Located in the sought after Angel de Miraflores urbanization, this lovely penthouse also has a 70m2 solarium with (...)
€1,100,000
TSEA5069596
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 97 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Mijas and Mijas Costa Region: Andalucía
A rare opportunity to own a gorgeous beachfront penthouse located in the prestigious community of Calahonda. This stunning property boasts 2 spacious bedrooms and 2 beautifully renovated bathrooms (...)
€375,000
TSEA5069545
- Calypso, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 68 Lot Size: 150 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 68 Lot Size: 150 Area: Mijas and Mijas Costa Region: Andalucía
A typical charming Calypso bungalow. The property has 3 double bedrooms and 2 bathroom of which one ensuite. The semi open kitchen-living area with fireplace leads out to a large sunny terrace. On (...)
€449,000
TSEA5069542
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 2 M2: 121 Lot Size: 566 Area: Coin Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Lot Size: 566 Area: Coin Region: Andalucía
Detached house with infinity pool and views, opposite La Trocha – Coín.
Modern single-family home in a prime location, right across from La Trocha shopping center in Coín. Built on a 566 m² (...)
€3,200,000
TSEA5068387
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 400 Lot Size: 786 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 400 Lot Size: 786 Area: Marbella West Region: Andalucía
Detached Villa, Puerto Banús, Costa del Sol.
6 Bedrooms, 6 Bathrooms, Built 400 m², Terrace 200 m², Garden/Plot 786 m².
Setting : Port, Close To Shops, Close To Sea, Close To Town, Close To (...)
€1,499,000
TSEA5068378
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 6 M2: 415 Lot Size: 1,415 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 6 M2: 415 Lot Size: 1,415 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Villa with Sea Views in Mijas Pueblo – Ideal for Investors
High Yield | ???? 3 Units with the Possibility of Independent Living | ???? Panoramic Sea Views
Introducing an exceptional (...)
€550,000
TSEA5068321
- Coín, Costa Del Sol, Coin
Beds: 3 Baths: 4 M2: 292 Lot Size: 2,241 Area: Coin Region: Andalucía
Beds: 3 Baths: 4 M2: 292 Lot Size: 2,241 Area: Coin Region: Andalucía
This delightful finca enjoys a prime location just minutes from Coín town centre, with excellent road connections to Marbella, Málaga, and the coast.
Behind electric gates, a spacious driveway (...)
€1,450,000
TSEA5068309
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 4 M2: 389 Lot Size: 3,010 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 4 M2: 389 Lot Size: 3,010 Area: Sotogrande Region: Andalucía
Situated in one of the best streets of Sotogrande Alto, this family villa is built over 3 floors and set within a mature garden of over 3000m2.
Sotogrande is one of Southern Spain's most elegant and (...)
Current Featured Properties
€893,000
TSEA4887208
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 175 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Area: Casares Region: Andalucía
This residential complex of 36 homes with 2 and 3 bedrooms and an exceptional range of services. Each home is carefully designed using soft, organic lines that blend naturally into the surroundings, (...)
€1,038,000
TSEA4965829
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 90 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Benalmadena Region: Andalucía
Nestled amidst Benalmadena's vibrant centre and situated adjacent to its picturesque port, This new development offers the perfect blend of city living and seaside luxury. A distinctive project that (...)
€725,000
TSEA4812787
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
NO NEED TO KEEP SEARCHING, YOUR PERFECT PROPERTY IS HERE!!!
We know that searching for a new place to call home can be a complicated challenge. Your imagination is a powerful designer, capable of (...)
