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 2541 - 2560 of 2656 €649,000
TSEA3525412
- Jimena de la Frontera, Costa de la Luz
Beds: 5 Baths: 4 M2: 246 Lot Size: 4,000 Region: Andalucía
Beds: 5 Baths: 4 M2: 246 Lot Size: 4,000 Region: Andalucía
NOW WITH ADDITIONAL BATHROOM AND SOLAR PANELS
This lovely Villa is just outside the historic town of Jimena de la Frontera, set in a green and lush plot of 4,000 square meters. The first floor (...)
€3,500,000
TSEA3237742
- Almayate, Costa Del Sol East
Beds: 10 Baths: 4 M2: 1,607 Lot Size: 32,000 Region: Andalucía
Beds: 10 Baths: 4 M2: 1,607 Lot Size: 32,000 Region: Andalucía
The Cortijo de la Finca "El Recreo" is a house more than 100 years old, in which all the elements of the typical Andalusian Cortijo-Houses have been preserved. It has a central Andalusian (...)
€2,100,000
TSEA3508726
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 387 Lot Size: 5,520 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 387 Lot Size: 5,520 Area: Estepona Region: Andalucía
Beautiful and elegant villa in an idyllic and quiet location close to laguna beach and Estepona. Nearby you will find restaurants and supermarkets. The property has a large landscaped garden with (...)
€680,000
TSEA3467848
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 3 M2: 160 Lot Size: 8,000 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 3 M2: 160 Lot Size: 8,000 Area: Nerja and Malaga East Region: Andalucía
8,000 m2 irrigated farm with mango production. The villa has 160 m2 with a 60 m2 solarium, 4 bedrooms all with two windows or balconies (2 on the ground floor and another 2 bedrooms on the upper (...)
€241,500
TSEA3465778
- Las Zorrillas, Costa Del Sol East
Beds: 4 Baths: 1 M2: 300 Region: Andalucía
Beds: 4 Baths: 1 M2: 300 Region: Andalucía
Beautiful detached house in quiet area with many original features. In earlier days this was a bodega, in the basement the old wine barrels and the antique grape press are still kept and can still be (...)
€10,000,000
TSEA3454348
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 7 Baths: 7 M2: 1,592 Lot Size: 2,559 Area: Marbella West Region: Andalucía
Beds: 7 Baths: 7 M2: 1,592 Lot Size: 2,559 Area: Marbella West Region: Andalucía
Built in 2002, is undoubtedly one of the most desirable homes in the area. With an image of luxury and ostentation in true Marbella style, it is characterized by the high quality used in its (...)
€1,900,000
TSEA3455071
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 6 Baths: 5 M2: 528 Area: Benalmadena Region: Andalucía
Beds: 6 Baths: 5 M2: 528 Area: Benalmadena Region: Andalucía
This private spacious villa offers stunning open views across the Mediterranean Sea. A solid high quality build villa in the traditional hacienda style boasting ample entertaining space, set over (...)
€420,000
TSEA3426682
- Canillas de Aceituno, Costa Del Sol East
Beds: 3 Baths: 1 M2: 120 Lot Size: 8,000 Region: Andalucía
Beds: 3 Baths: 1 M2: 120 Lot Size: 8,000 Region: Andalucía
Beautiful 8000 sq. mts. farmhouse near the town of Rubite. The house has a covered terrace, three bedrooms, one bathroom, a lounge with fireplace, kitchen and a garage. Outside, on the upper part of (...)
€490,000
TSEA3441994
- Ojén, Costa Del Sol, Ojen
Beds: 4 Baths: 3 M2: 195 Lot Size: 659 Area: Ojen Region: Andalucía
Beds: 4 Baths: 3 M2: 195 Lot Size: 659 Area: Ojen Region: Andalucía
Fantastic rustic finca, located at the entrance to Ojen, a few minutes from Marbella. The main house consists of a living room with two fireplaces, a dining room and kitchen, three bedrooms, a main (...)
€2,440,000
TSEA3437890
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 5 M2: 404 Lot Size: 1,063 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 5 M2: 404 Lot Size: 1,063 Area: Marbella East Region: Andalucía
This beautifully decorated villa is comprised of a grand hallway, fully equipped kitchen with a breakfast area, a spacious dining room / lounge with a fireplace and access to the terrace and garden, (...)
€1,490,000
Control your home with your smart device!
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 371 Lot Size: 323 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 371 Lot Size: 323 Area: Benahavis Region: Andalucía
ULTIMATE IN DESIGNER LIVING IN BEAUTIFUL MARBELLA!!!
Villas in a unique project with an emphasis on design to meet the requirements of the most demanding client. Located on a privileged plot, the (...)
€2,700,000
TSEA3397030
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 7 M2: 173 Lot Size: 980 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 7 M2: 173 Lot Size: 980 Area: Mijas and Mijas Costa Region: Andalucía
AN IMPRESSIVE, UNIQUE AND ORIGINAL VILLA WHICH IS TOTALLY FRONT-LINE BEACH IN EL CHAPARRAL WITH PRIVATE DIRECT ACCESS TO THE BEACH. IT HAS BEEN DESIGNED TO REPLICATE A BOAT WITH THE RESULTING (...)
€187,000
TSEA3377023
- Alora, Costa Del Sol, Älora
Beds: 3 Baths: 2 M2: 115 Lot Size: 10,000 Area: Älora Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Lot Size: 10,000 Area: Älora Region: Andalucía
Complete privacy and TRANQUILITY
. Perfect spot for a retreat
. Disconnect ......
Tucked away between low hills, this finca takes the word "hideaway" to its highest level.
Though there (...)
€2,625,000
TSEA3370573
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 340 Lot Size: 970 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 340 Lot Size: 970 Area: Marbella Region: Andalucía
Unique, south facing villa with panoramic sea views .
Situated in a very peaceful and green hills of Marbella town .It is a perfect location for all year around living ,walking distance to a few well (...)
€6,000,000
PALATIAL REFORMED VILLA, WALK TO THE BEACHES
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 8 Baths: 8 M2: 900 Area: San Pedro Region: Andalucía
Beds: 8 Baths: 8 M2: 900 Area: San Pedro Region: Andalucía
PALATIAL REFORMED VILLA, WALK TO THE BEACHES!!!
A totally reformed substantial palatial Arabian styled villa which offers 8 BEDROOM SUITES which incorporate 2 self-contained suites. The villa has (...)
€975,000
TSEA3367234
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 5 M2: 1,080 Lot Size: 600 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 5 M2: 1,080 Lot Size: 600 Area: Mijas and Mijas Costa Region: Andalucía
Elegant Villa for Sale in Mijas Costa – Where Style Meets Lifestyle
If you've been dreaming of a luxury escape on Spain's sun-drenched Costa del Sol, this magnificent villa in Mijas Costa could be (...)
€950,000
TSEA3363418
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 155 Lot Size: 832 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 155 Lot Size: 832 Area: Marbella East Region: Andalucía
Grand independent villa overlooking the Cabopino Golf course with panoramic views from the very expansive roof terrace. 3 fully fitted bedrooms with built in wardrobes and views from every room. The (...)
€250,000
TSEA3332437
- El Borge, Costa Del Sol East
Beds: 1 Baths: 1 M2: 84 Lot Size: 86,900 Region: Andalucía
Beds: 1 Baths: 1 M2: 84 Lot Size: 86,900 Region: Andalucía
This nice farm has a total extension of 86.900 m2 and has two sheds from 42 m2 each, also boasts 300 mangos, 100 avocado and along the entrance lane about 100 trees of tangerines. The property also (...)
€469,000
TSEA3340210
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 90 Lot Size: 1,600 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 90 Lot Size: 1,600 Area: Marbella Region: Andalucía
Great little finca just minutes from San Pedro, set on a plot of 1600 m2 with an abundance of fruit trees and its own well, this 2 bedroom properties is perfect for nature lovers and very close to (...)
€2,200,000
TSEA3339724
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 430 Lot Size: 1,000 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 430 Lot Size: 1,000 Area: Marbella Region: Andalucía
Modern five bedroom villa located steps to the beach,close to restaurants beachclubs and a short drive
to Marbella town centre.
Current Featured Properties
€2,400,000
TSEA3878038
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 337 Lot Size: 70 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 337 Lot Size: 70 Area: Benahavis Region: Andalucía
MODULAR VILLAS IN AN UPSCALE COUNTRY CLUB RESORT!!!
A gated and secure community of villas with club house, spa and gym with verdant Mediterranean gardens and amazing panoramic sea views. located in (...)
€1,990,000
TSEA4979719
- Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 504 Lot Size: 903 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 504 Lot Size: 903 Area: Marbella East Region: Andalucía
Villa Fantastica is a luxurious property located in the breathtaking surroundings of Marbella. The villa boasts 4 bedrooms, 4 bathrooms, and a built area of 504 square meters. Its exceptional German (...)
€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 (...)
