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 2521 - 2540 of 2656 €335,000
TSEA3662555
- Totalán, Costa Del Sol East
Beds: 1 Baths: 1 M2: 80 Lot Size: 60,000 Region: Andalucía
Beds: 1 Baths: 1 M2: 80 Lot Size: 60,000 Region: Andalucía
Totalán is a village located in Malaga's Axarquía, just half an hour from Malaga city center and the airport. The farm has 60,000 m2 with mango and avocado trees and vines of various kinds of (...)
€320,000
TSEA3650831
- Alcaucín, Costa Del Sol East
Beds: 3 Baths: 1 M2: 299 Lot Size: 3,600 Region: Andalucía
Beds: 3 Baths: 1 M2: 299 Lot Size: 3,600 Region: Andalucía
Before the professional cultivation of avocado and mango came to Axarquía not so many years ago, it was mainly almond and olive trees that shaped the landscape on the Costa del Sol. Even today, (...)
€1,100,000
TSEA3649730
- Caleta de Vélez, Costa Del Sol East
Beds: 4 Baths: 4 M2: 229 Lot Size: 901 Region: Andalucía
Beds: 4 Baths: 4 M2: 229 Lot Size: 901 Region: Andalucía
Independent house, Caleta de Vélez boasts of being the most important fishing port in the province of Malaga. You can walk along the pier and see how the fishermen prepare their fising nets and, at (...)
€3,300,000
TSEA3630323
- El Paraiso, Costa Del Sol, Estepona
Beds: 10 Baths: 6 M2: 878 Lot Size: 2,278 Area: Estepona Region: Andalucía
Beds: 10 Baths: 6 M2: 878 Lot Size: 2,278 Area: Estepona Region: Andalucía
Dream villa with panoramic sea and mountain views in El Paraiso.
A beautiful south facing villa - full of light - with 10 spacious bedrooms, 6 bathrooms, 1 guest toilet, fully equipped modern (...)
€1,600,000
TSEA3614063
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 120 Lot Size: 608 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Lot Size: 608 Area: Estepona Region: Andalucía
The property has a private, heated swimming pool which is positioned almost on the beach itself. The gardens and pool have sunshine all day.
The house has three bedrooms, all with air-conditioning (...)
€2,350,000
TSEA3605285
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 8 Baths: 7 M2: 654 Lot Size: 3,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 8 Baths: 7 M2: 654 Lot Size: 3,000 Area: Mijas and Mijas Costa Region: Andalucía
Classical and large villa located in the lower part of Calahonda, just 600 meters from the beach and 500 meters from the A7 and shopping centers, supermarkets, banks, bars etc.
Suitable as a bed (...)
€790,000
TSEA3591829
- Frigiliana, Costa Del Sol East
Beds: 3 Baths: 3 M2: 162 Lot Size: 309 Region: Andalucía
Beds: 3 Baths: 3 M2: 162 Lot Size: 309 Region: Andalucía
GREAT OPPORTUNITY! Bright and spacious house located in the sought after area of Puerto Blanquillo in Frigiliana, with un interrupted views over the valley towards Nerja and the Mediterranean Sea. (...)
€2,500,000
TSEA3585085
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 4 M2: 567 Lot Size: 1,400 Area: Marbella Region: Andalucía
Beds: 7 Baths: 4 M2: 567 Lot Size: 1,400 Area: Marbella Region: Andalucía
7 bedroom villa in Nagueles, Marbella Golden Mile
Mediterranean style villa with 567 m2 built on a beautiful plot of 1,400 m2 in the residential area of Nagüeles, on the Golden Mile of (...)
€3,595,000
TSEA3576427
- Ojén, Costa Del Sol, Ojen
Beds: 8 Baths: 7 M2: 950 Lot Size: 240,000 Area: Ojen Region: Andalucía
Beds: 8 Baths: 7 M2: 950 Lot Size: 240,000 Area: Ojen Region: Andalucía
Dream finca/country estate located in the natural park Sierra de las Nieves, very close to the Refugio de Juanar. This unique property offers magnificent views, absolute tranquility and yet is only a (...)
€191,000
TSEA3574294
- Cómpeta, Costa Del Sol East
Beds: 4 Baths: 1 M2: 92 Lot Size: 40 Region: Andalucía
Beds: 4 Baths: 1 M2: 92 Lot Size: 40 Region: Andalucía
Great town house in Cómpeta. If you are looking for a home in a quiet place, without noise or pollution, with good views, with all the services of a city at hand and at a very reasonable price, this (...)
€2,350,000
TSEA3574252
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 4 Baths: 4 M2: 465 Lot Size: 1,215 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 4 M2: 465 Lot Size: 1,215 Area: Algeciras Region: Andalucía
Off plan luxury villa with turnkey project located in La Alcaidesa with views of the Mediterranean Sea and Gibraltar.
The area is a golfers paradise were you find some of the best golf courses in (...)
€2,350,000
TSEA3574243
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 4 Baths: 4 M2: 484 Lot Size: 1,215 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 4 M2: 484 Lot Size: 1,215 Area: Algeciras Region: Andalucía
Off Plan Villa Project with a fantastic plot overlooking the Mediterranean Sea with views of Gibraltar located in La Alcaidesa.
For those who love calm and tranquility, this is the perfect spot to (...)
€3,250,000
TSEA3575629
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 6 Baths: 8 M2: 802 Lot Size: 1,020 Area: Benahavis Region: Andalucía
Beds: 6 Baths: 8 M2: 802 Lot Size: 1,020 Area: Benahavis Region: Andalucía
Newly built contemporary villa, finished on two floors plus basement, plus roof top, accessible by stairs and elevator. It is located in a natural environment, surrounded by golf and mountain, (...)
€2,300,000
TSEA3550327
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 428 Lot Size: 940 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 428 Lot Size: 940 Area: Marbella Region: Andalucía
Large, attractive family home in very quiet area close to Marbella and next to a Natural Park. Beautiful open south and south-west views. Large, fully equipped kitchen with fireplace and sea views. (...)
€2,995,000
TSEA3542665
- El Rosario, Costa Del Sol, Marbella East
Beds: 5 Baths: 4 M2: 270 Lot Size: 1,071 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 4 M2: 270 Lot Size: 1,071 Area: Marbella East Region: Andalucía
Magnificent villa with stunning sea views. The villa has 5 bedrooms and 4 bathrooms, located in the El Rosario area,
3 bedrooms are located on the ground floor, each with its own bathroom. On the (...)
€2,495,000
TSEA3549622
- La Mairena, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 521 Lot Size: 1,744 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 521 Lot Size: 1,744 Area: Marbella East Region: Andalucía
Amazing new built villa in La Mairena with high quality finishing and beautiful pool area. The villa offers on three levels, five bedrooms with en-suite bathrooms, a lovely and bright living room (...)
€1,375,000
TSEA3537112
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 5 M2: 465 Lot Size: 1,768 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 5 M2: 465 Lot Size: 1,768 Area: Mijas and Mijas Costa Region: Andalucía
Wonderful Finca/Cortijo of the year 1876 with independent and modern apartment with panoramic views of the sea, countryside and mountains, located between Fuengirola and Mijas Pueblo a short distance (...)
€849,000
TSEA3533635
- Cabopino, Costa Del Sol, Marbella East
Beds: 5 Baths: 4 M2: 204 Lot Size: 845 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 4 M2: 204 Lot Size: 845 Area: Marbella East Region: Andalucía
INVESTMENT, VILLA FOR RENOVATION! NEW on THE MARKET! Welcome to this bright investment opportunity in Cabopino, Marbella. This villa (230 square meters) sits on a plot of over 800 square meters with (...)
€850,000
TSEA3531565
- Torrox, Costa Del Sol East
Beds: 3 Baths: 2 M2: 210 Lot Size: 5,100 Region: Andalucía
Beds: 3 Baths: 2 M2: 210 Lot Size: 5,100 Region: Andalucía
If you are looking for the perfect house, with spectacular views, well built and with a unique design, absolute privacy and tranquility, and with a first occupancy license in a country house (...)
€1,590,000
Contemporary Villas in Exclusive El Campanario, Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 5 M2: 368 Lot Size: 471 Area: Estepona Region: Andalucía
Beds: 4 Baths: 5 M2: 368 Lot Size: 471 Area: Estepona Region: Andalucía
FABULOUS COSTA DEL SOL VILLA - LAST ONE LEFT.
We are delighted to launch 6 CONTEMPORARY STYLE first line golf villas with luxury qualities and exceptional finishes which are located in a privileged (...)
Current Featured Properties
€1,590,000
Contemporary Villas in Exclusive El Campanario, Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 5 M2: 368 Lot Size: 471 Area: Estepona Region: Andalucía
Beds: 4 Baths: 5 M2: 368 Lot Size: 471 Area: Estepona Region: Andalucía
FABULOUS COSTA DEL SOL VILLA - LAST ONE LEFT.
We are delighted to launch 6 CONTEMPORARY STYLE first line golf villas with luxury qualities and exceptional finishes which are located in a privileged (...)
€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 (...)
€3,495,000
TSEA4366912
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 508 Lot Size: 1,302 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 508 Lot Size: 1,302 Area: Marbella West Region: Andalucía
THIS STUNNING PROPERTY IS LOCATED IN THE HIGHLY SOUGHT AFTER ARE OF NUEVA ANDALUCIA.
Property boasts of 4 bedrooms and 5 bathrooms, making it ideal for larger families or those who enjoy having (...)
