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 (42,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 (42,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 (42,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 2001 - 2020 of 2639 €1,649,000
TSEA4656931
- Málaga, Costa Del Sol, Malaga
Beds: 6 Baths: 6 M2: 527 Lot Size: 195 Area: Malaga Region: Andalucía
Beds: 6 Baths: 6 M2: 527 Lot Size: 195 Area: Malaga Region: Andalucía
COMPLETE BUILDING IN THE CENTER OF MÁLAGA
Complete building, ideal for investment as Tourist Apartments or Hostel or if you want to have a large property in the center of Malaga. The options are (...)
€475,000
TSEA4656685
- Jimena de la Frontera, Costa de la Luz
Beds: 4 Baths: 2 M2: 281 Lot Size: 18,297 Region: Andalucía
Beds: 4 Baths: 2 M2: 281 Lot Size: 18,297 Region: Andalucía
Detached Villa, Jimena de la Frontera, Costa de la Luz.
3 Bedrooms, 2 Bathrooms, Built 281 m², Garden/Plot 18297 m².
Setting : Country, Village, Mountain Pueblo, Close To Golf, Close To Shops, (...)
€1,800,000
TSEA4655803
- 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 (...)
€2,495,000
TSEA4654399
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 310 Lot Size: 434 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 310 Lot Size: 434 Area: Marbella East Region: Andalucía
This charming villa, just a few steps from the beach is located in the heart of one of the most sought-after urbanisations of Marbella's Golden Mile. In the past, The owners have enjoyed family life (...)
€3,450,000
TSEA4652665
- El Madroñal, Costa Del Sol, San Pedro
Beds: 4 Baths: 5 M2: 364 Lot Size: 1,780 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 5 M2: 364 Lot Size: 1,780 Area: San Pedro Region: Andalucía
Exquisite Andalusian 4 bed luxury villa with lots of personality for sale in El Madroñal, Benahavis
Villa Aratina embodies the essence of a serene retreat in the enchanting Andalusian countryside, (...)
€899,000
TSEA4652110
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 250 Lot Size: 562 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 250 Lot Size: 562 Area: Mijas and Mijas Costa Region: Andalucía
Villa just 800m east of the golf course Cabopino Marbella, south west facing, community pool. Spectacular roof terrace offering stunning views 360º. Forming part of the best selection of villas (...)
€2,300,000
TSEA4651759
- Marbesa, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 344 Lot Size: 1,290 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 344 Lot Size: 1,290 Area: Marbella East Region: Andalucía
Villa for sale in Marbesa, Marbella with 4 bedrooms, 3 bathrooms, 1 toilet and with orientation south/west, with private swimming pool, private garage (3 parking spaces) and private garden. Regarding (...)
€5,500,000
TSEA4649611
- Jimena de la Frontera, Costa de la Luz, Estepona
Beds: 7 Baths: 7 M2: 1,000 Lot Size: 3,500,000 Area: Estepona Region: Andalucía
Beds: 7 Baths: 7 M2: 1,000 Lot Size: 3,500,000 Area: Estepona Region: Andalucía
Welcome to "La Morisca," a one of a kind sporting estate in the south of Spain
Situated in the scenic landscapes of Jimena de la Frontera and San Martin del Tesorillo, Cádiz, just a (...)
€4,199,999
TSEA4649410
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 4 Baths: 5 M2: 555 Lot Size: 2,500 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 5 M2: 555 Lot Size: 2,500 Area: San Pedro Region: Andalucía
UNIQUE LOCATION- EXCELLENT INVESTMENT
Extraordinary villa with a unique location on the golf course in Guadalmina Baja, just 200 meters from the sea! This fantastic property boasts four bedrooms, (...)
€1,195,000
TSEA4649023
- Elviria, Costa Del Sol, Marbella East
Beds: 5 Baths: 3 M2: 295 Lot Size: 1,000 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 3 M2: 295 Lot Size: 1,000 Area: Marbella East Region: Andalucía
Villa located in a quiet residential area of Cerrado de Elviria, 800m from the beach, close to supermarkets and restaurants and 8km from the historic centre of Marbella.
The property is completely (...)
€620,000
TSEA4648831
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 264 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 264 Area: Benahavis Region: Andalucía
The house is ideally situated in the heart of Benahavis, you'll enjoy easy access to local shops, restaurants, park and more. Four bedrooms and three bathrooms in a recently renovated space offers (...)
€1,680,000
TSEA4647706
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 315 Lot Size: 577 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 315 Lot Size: 577 Area: Mijas and Mijas Costa Region: Andalucía
This magnificent villa in just one storey and to be renovated is located on the sand of Chaparral beach. Right now it has a constructed area of 315m² on a land of 577m².
The villa is located on (...)
€4,300,000
TSEA4332157
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 730 Lot Size: 885 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 730 Lot Size: 885 Area: Marbella Region: Andalucía
Modern luxury villa with exceptional qualities, located in a gated community composed of only 15 villas. The community has 24-hour security guards and concierge services, and is located in a green (...)
€3,200,000
TSEA4647109
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 588 Lot Size: 4,162 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 588 Lot Size: 4,162 Area: Mijas and Mijas Costa Region: Andalucía
This villa is in a prime location in Calahonda, Mijas Costa, just 20 minutes from Marbella city center and just 30 minutes from Málaga city and the airport. Only 5minutes from the beach. Directly (...)
€1,345,200
TSEA4646743
- Ronda, Costa Del Sol, Ronda
Beds: 9 Baths: 3 M2: 829 Lot Size: 115,000 Area: Ronda Region: Andalucía
Beds: 9 Baths: 3 M2: 829 Lot Size: 115,000 Area: Ronda Region: Andalucía
This 115,000 m2 property, in which we find a house composed of 5 bedrooms and 3 bathrooms with more than 500 m2, a private pool and the entire roof of this house has recently been rehabilitated, (...)
€2,425,000
TSEA4646440
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 7 Baths: 5 M2: 499 Lot Size: 2,962 Area: San Pedro Region: Andalucía
Beds: 7 Baths: 5 M2: 499 Lot Size: 2,962 Area: San Pedro Region: Andalucía
Welcome to this truly unique villa for sale located in San Pedro de Alcantara, where luxury meets traditional Andalusian style offering the best of both worlds. Entering this villa feels like a world (...)
€799,000
TSEA4646260
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 219 Lot Size: 583 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 219 Lot Size: 583 Area: Estepona Region: Andalucía
This is a charming three-level home that combines tranquility with convenience. Just a short drive from Estepona town and the beach, this residence is a haven for those who want peace without (...)
€4,500,000
TSEA4644073
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 5 Baths: 5 M2: 534 Lot Size: 1,888 Area: Fuengirola Region: Andalucía
Beds: 5 Baths: 5 M2: 534 Lot Size: 1,888 Area: Fuengirola Region: Andalucía
Contemporary designer villa with breathtaking views towards the sea. The villa comprises of two floors with main entrance on the upper level. From the moment you step through the front door, you are (...)
€3,250,000
TSEA4643614
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 6 Baths: 7 M2: 600 Lot Size: 3,300 Area: Sotogrande Region: Andalucía
Beds: 6 Baths: 7 M2: 600 Lot Size: 3,300 Area: Sotogrande Region: Andalucía
ECOLOGICAL PASSIVE VILLA IN SOTOGRANDE WITH PARTIAL VIEWS OF THE SEA
This property will be constructed on 1 floor with the highest specifications possible and consisting of;
Entrance hall with (...)
€1,750,000
TSEA4643602
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 420 Lot Size: 560 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 420 Lot Size: 560 Area: Estepona Region: Andalucía
Villa located in the heart of the Costa del Sol, just 8 minutes from the beach and 15 minutes from Marbella and Sotogrande, a dream place with enormous landscape wealth where numerous beaches are (...)
Current Featured Properties
€6,900,000
EMPTY
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 890 Lot Size: 2,872 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 890 Lot Size: 2,872 Area: Marbella West Region: Andalucía
URB. LA CERQUILLA, NUEVA ANDALUCIA, MARBELLA
A great, recently renovated villa with a perfect fusion between contemporary design and Andalusian style. Located in the sought after residential area of (...)
€559,500
TSEA5019097
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 4 M2: 161 Lot Size: 500 Area: Manilva Region: Andalucía
Beds: 3 Baths: 4 M2: 161 Lot Size: 500 Area: Manilva Region: Andalucía
Charming South-Facing Villa in Peaceful Manilva – Where Comfort Meets Coastal Living
Welcome to your new sanctuary in the heart of Manilva, a quiet and picturesque corner of the Costa del Sol. This (...)
€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, (...)
