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,68,69,70)
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,68,69,70)
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,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 2021 - 2040 of 2740
€1,250,000
TSEA4767484
- Rincón de la Victoria, Costa Del Sol East
Beds: 5 Baths: 4 M2: 658 Lot Size: 2,197 Region: Andalucía
Beds: 5 Baths: 4 M2: 658 Lot Size: 2,197 Region: Andalucía
Welcome to this magnificent villa, a true gem nestled in the most exclusive residential area of Rincón de la Victoria. Located in the lower part of Cotomar, this property offers a privileged (...)
€850,000
TSEA4767454
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 3 M2: 344 Lot Size: 942 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 3 M2: 344 Lot Size: 942 Area: Mijas and Mijas Costa Region: Andalucía
In a beautiful and quiet urbanization of Alhaurín de la Torre is this beautiful house with Mozarabic style details, a true haven of peace and elegance. The house has five spacious and bright (...)
€610,000
TSEA4766995
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 2 M2: 144 Lot Size: 284 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 2 M2: 144 Lot Size: 284 Area: Nerja and Malaga East Region: Andalucía
This recently renovated detached villa offers both luxury and comfort, the perfect blend of modern amenities and breathtaking natural views. With South facing orientation you are guaranteed plenty of (...)
€1,850,000
TSEA4766893
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 283 Lot Size: 800 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 283 Lot Size: 800 Area: Manilva Region: Andalucía
Stunning Independent Villa in the Heart of Sabinillas 1.850.000€
This beautiful modern villa is ideally located in the vibrant town of Sabinillas, offering both comfort and convenience. The (...)
€629,000
TSEA4766677
- Coín, Costa Del Sol, Coin
Beds: 5 Baths: 3 M2: 275 Lot Size: 2,151 Area: Coin Region: Andalucía
Beds: 5 Baths: 3 M2: 275 Lot Size: 2,151 Area: Coin Region: Andalucía
Spectacular detached villa with 3 separate living accommodations, situated in an extremely private location, walking distance to town.
The main house on 2 levels comprises ground floor with entrance (...)
€5,060,000
TSEA4766122
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 7 Baths: 8 M2: 1,255 Lot Size: 2,212 Area: Sotogrande Region: Andalucía
Beds: 7 Baths: 8 M2: 1,255 Lot Size: 2,212 Area: Sotogrande Region: Andalucía
1.009,10 m2 the surface of the house is distributed in three floors that go down the plot of 2.209,00 m2.
6 BEDROOMS. All bedrooms have a dressing area and a study. They have direct lighting and (...)
€599,000
TSEA4765870
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
These impressive homes, set over 4 floors provide 3 bedrooms, 2.5 bathrooms, an ample basement area, private parking, garden, solarium and multiple terraces. The blend of sleek design with the (...)
€1,600,000
TSEA4765366
- Las Chapas, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 475 Lot Size: 1,252 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 475 Lot Size: 1,252 Area: Marbella East Region: Andalucía
Luxury villa built on two floors plus a basement and a large garage for several cars, located in Hacienda Las Chapas, near Marbella and Malaga airport and Malaga city. Close to all services and near (...)
€1,950,000
TSEA4764469
- Tarifa, Costa de la Luz
Beds: 9 Baths: 3 M2: 189 Region: Andalucía
Beds: 9 Baths: 3 M2: 189 Region: Andalucía
HOUSE IN THE HISTORIC CENTER OF TARIFA ON THE MEDIEVAL WALL.
A unique property, a large corner house overlooking the plaza and with access from two streets, unique because it is located directly on (...)
€1,600,000
TSEA4764316
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 4 M2: 300 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 4 M2: 300 Area: Marbella East Region: Andalucía
Spacious townhouse in the Golden Mile next to the Hotel Puente Romano and the Hotel Alanda Marbella, and walking distance to the beach.
The house is distributed over four levels: the main floor (...)
€1,459,000
TSEA4763152
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 265 Lot Size: 1,058 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 265 Lot Size: 1,058 Area: Mijas and Mijas Costa Region: Andalucía
This is a fantastic opportunity to create, to design and to have built a contemporary modern home set in the glorious countryside that surrounds the picturesque historic town of Mijas. Starting with (...)
€4,600,000
TSEA4762864
- El Madroñal, Costa Del Sol, San Pedro
Beds: 5 Baths: 5 M2: 757 Lot Size: 2,283 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 5 M2: 757 Lot Size: 2,283 Area: San Pedro Region: Andalucía
Exceptional luxury villa on a double plot and with spectacular panoramic views for sale
VIEWS VIEWS VIEWS and Luxury living!!
Location highlights
* Exclusive, secure, private, peaceful and (...)
€149,000
TSEA4762087
- Serrato, Costa Del Sol
Beds: 2 Baths: 2 M2: 150 Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Region: Andalucía
Charming and modern village house, with incredible views, located in the quiet village of Serrato, just an hour's drive from Málaga and the airport, and 30 minutes to Ronda.
The property has a (...)
€3,500,000
TSEA4760671
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 592 Lot Size: 1,526 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 592 Lot Size: 1,526 Area: Marbella West Region: Andalucía
Charming 6-Bedroom Villa with Panoramic Views in Nueva Andalucia
Discover this exquisite 6-bedroom, 6-bathroom villa nestled in a serene cul-de-sac next to Las Brisas Golf, offering unparalleled (...)
€995,000
TSEA4754470
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 366 Lot Size: 61 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 366 Lot Size: 61 Area: Mijas and Mijas Costa Region: Andalucía
Immerse in the enchanting landscape of Mijas Pueblo, where the sun-kissed coast meets the majestic mountains, in this stunning villa. Offering an exceptional blend of luxury and comfort, this home (...)
€3,250,000
TSEA4753129
- Nagüeles, Costa Del Sol, Marbella
Beds: 5 Baths: 5 M2: 624 Lot Size: 1,700 Area: Marbella Region: Andalucía
Beds: 5 Baths: 5 M2: 624 Lot Size: 1,700 Area: Marbella Region: Andalucía
Beautiful villa with Andalusian cortijo style and character located in the exclusive area of Rocio de Nagüeles, in the heart of Marbella's world famous Golden Mile.
The villa has an imposing (...)
€940,000
TSEA4753036
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 4 M2: 265 Area: Manilva Region: Andalucía
Beds: 4 Baths: 4 M2: 265 Area: Manilva Region: Andalucía
9 magnificent independent modern villas of high quality on plots of approx. 600m2. with 4 bedrooms all en suite, toilet, large living room-kitchen, private pool, private natural garden and private (...)
€1,750,000
TSEA4752859
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 200 Lot Size: 2,300 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 200 Lot Size: 2,300 Area: Mijas and Mijas Costa Region: Andalucía
INVESTORS OPPORTUNITY !!!
VILLA WITH MORE THAN 2500 M2 OF PLOT, WITH AN EXCELLENT LOCATION AND BEAUTIFUL VIEWS TO THE SEA AND THE MOUNTAIN WITH UNBEATABLE ACCESS FROM 4 ENTRANCES TO THE (...)
€535,000
TSEA4752382
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 229 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 229 Area: Marbella West Region: Andalucía
Townhouse with 3 frontages in Nueva Andalucia
This renovated townhouse is a unique gem, located in a privileged area. With 3 bedrooms, 3 bathrooms, a communal pool and an open plan kitchen, it (...)
€1,300,000
TSEA4752265
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 300 Lot Size: 1,073 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 300 Lot Size: 1,073 Area: Mijas and Mijas Costa Region: Andalucía
Brand new villa in a west orientated plot of 1073 sq mtrs in a quiet area in the heart of Mijas Golf,enjoying the magnificent views to the mountains and golf.
The villa enjoys light all day, and (...)
Current Featured Properties
€1,485,000
TSEA5115535
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 136 Lot Size: 195 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 136 Lot Size: 195 Area: Estepona Region: Andalucía
NEW DEVELOPMENT – Elegance and Exclusivity on the Costa del Sol!
Discover this new luxury project, a prestigious complex of 14 independent villas located in an exceptional setting in Estepona, (...)
€4,200,000
TSEA4450924
- Benahavís, Costa Del Sol, Benahavis
Beds: 7 Baths: 5 M2: 462 Lot Size: 1,034 Area: Benahavis Region: Andalucía
Beds: 7 Baths: 5 M2: 462 Lot Size: 1,034 Area: Benahavis Region: Andalucía
Monte Mayor offers an exclusive gated community with 24 hour security in a fantastic natural environment with beautiful surroundings and excellent sea views. It is just a 15 minute drive to the coast (...)
€1,011,000
TSEA4391047
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 160 Lot Size: 63 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 160 Lot Size: 63 Area: Mijas and Mijas Costa Region: Andalucía
NATUTAL LIGHT FLOODS INTO THE PROPERTIES!!!
The architecture of these sixty-nine villas blends with nature and reinvents the traditional Andalusian style. A refuge where the natural beauty of the (...)
