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 (163,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 (163,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 (163,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 341 - 360 of 2924 €450,000
TSEA5126908
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 2 M2: 95 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 2 M2: 95 Area: San Pedro Region: Andalucía
UNIQUE OPPORTUNITY IN BEST AREA OF SAN PEDRO DE ALCÁNTARA
This magnificent penthouse is located in the fastest-growing area of San Pedro de Alcántara. One of the most coveted locations in this (...)
€2,700,000
TSEA5126596
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 280 Lot Size: 808 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 280 Lot Size: 808 Area: Marbella West Region: Andalucía
This lovely four-bedroom, newly renovated villa is located in the residential area of Nueva Andalucía, within the secure, gated community of Marbella Country Club.
The property features stunning (...)
€1,550,000
TSEA5126509
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 4 M2: 311 Lot Size: 836 Area: Marbella Region: Andalucía
Beds: 5 Baths: 4 M2: 311 Lot Size: 836 Area: Marbella Region: Andalucía
Charming villa with huge potential in Urb El Mirador, Marbella
Looking for a renovation project close to Marbella center? This detached villa in El Mirador is a opportunity to create your (...)
€1,420,000
TSEA5126443
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 220 Lot Size: 638 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Lot Size: 638 Area: San Pedro Region: Andalucía
Exclusive Luxury Villa for Sale – Elegance, Comfort, and Prime Location
Discover this impressive luxury villa located in one of the most exclusive areas of the Costa del Sol. With elegant (...)
€1,550,000
TSEA5126302
- Jimena de la Frontera, Costa de la Luz
Beds: 4 Baths: 2 M2: 301 Lot Size: 104,000 Region: Andalucía
Beds: 4 Baths: 2 M2: 301 Lot Size: 104,000 Region: Andalucía
p> A truly exceptional Country Estate situated midway between the picturesque white villages of San Martin de Tesorillo and Jimena de la Frontera—a property that redefines the concept of rural (...)
€298,000
TSEA5126218
- Sedella, Costa Del Sol East
Beds: 3 Baths: 2 M2: 254 Lot Size: 254 Region: Andalucía
Beds: 3 Baths: 2 M2: 254 Lot Size: 254 Region: Andalucía
This extraordinary property blends over 400 years of history with contemporary living comfort. In 2022, it underwent a full renovation with great attention to detail and a strong focus on quality and (...)
€750,000
TSEA5126206
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 2 M2: 224 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 2 M2: 224 Area: Marbella West Region: Andalucía
La Campana area in Nueva Andalucia is a thriving community with a vast array of amenities. Offered for sale is this house situated walking distance from all local services. The property enjoys far (...)
€1,100,000
TSEA5126155
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 183 Region: Andalucía
Beds: 2 Baths: 2 M2: 183 Region: Andalucía
This spectacular brand new penthouse, located in one of the best areas of the exclusive El Higuerón.
The property is part of an exclusive residential complex of only 36 homes, with the maximum (...)
€1,595,000
TSEA5126077
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 4 M2: 257 Lot Size: 1,093 Area: Istan Region: Andalucía
Beds: 3 Baths: 4 M2: 257 Lot Size: 1,093 Area: Istan Region: Andalucía
Charming Villa with Panoramic Views in Sierra Blanca Country Club, Istán
Set on a private corner plot, this picturesque villa offers breathtaking panoramic views of the mountains, lake, and sea, (...)
€1,050,000
TSEA5126047
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 364 Lot Size: 1,450 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 364 Lot Size: 1,450 Area: Mijas and Mijas Costa Region: Andalucía
*Detached House for Sale in Mijas Golf - An Oasis of Tranquility*
Discover this charming detached villa in Mijas Golf, a true retreat that combines comfort and elegance. With a generous plot of (...)
€935,000
TSEA5125999
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 458 Lot Size: 246 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 458 Lot Size: 246 Area: Benalmadena Region: Andalucía
Experience Mediterranean living at its finest in this exceptional 4-bedroom, 5-bathroom luxury detached house located in the prestigious BigBlue residential complex in Torremuelle, Benalmádena. (...)
€1,418,000
TSEA5125873
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 180 Lot Size: 638 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Lot Size: 638 Area: San Pedro Region: Andalucía
Exclusive villa for sale in San Pedro Alcántara
Elegance, comfort, and privacy come together in this spectacular villa located in one of the most desirable areas of the Costa del Sol. With 220 m² (...)
€15,000,000
TSEA5125372
- Estepona, Costa Del Sol, Estepona
Beds: 9 Baths: 6 M2: 1,098 Lot Size: 7,962 Area: Estepona Region: Andalucía
Beds: 9 Baths: 6 M2: 1,098 Lot Size: 7,962 Area: Estepona Region: Andalucía
Situated on an extraordinary frontline beach plot of over 7,600 m², this magnificent estate offers a rare opportunity to own one of the largest and most private properties on the New Golden Mile. (...)
€350,000
TSEA5125291
- Alcaucín, Costa Del Sol East
Beds: 10 Baths: 4 M2: 274 Lot Size: 1,277 Region: Andalucía
Beds: 10 Baths: 4 M2: 274 Lot Size: 1,277 Region: Andalucía
We present you this fantastic investment opportunity near Alcaucin. It is perfect to open a charming B&B or simply rent out the four residential units, either on a long-term basis or for (...)
€1,395,000
TSEA5125186
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 196 Lot Size: 533 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 196 Lot Size: 533 Area: Manilva Region: Andalucía
FANTASTIC OPPORTUNITY ON A GREAT LOCATION !!!
Brand new luxurious built villa in La Duquesa Valley , Manilva . Just a footstep to the beautiful beaches and the port of La Duquesa.
This property (...)
€359,000
TSEA5125144
- Torrox Costa, Costa Del Sol East
Beds: 2 Baths: 1 M2: 53 Lot Size: 180 Region: Andalucía
Beds: 2 Baths: 1 M2: 53 Lot Size: 180 Region: Andalucía
Charming Sunlit Semi-Detached Home Just Steps from the Beach in Torrox Costa
Located in the sought-after Centro Internacional Urbanization, this bright and inviting semi-detached home is just 50 (...)
€750,000
TSEA5125129
- Torrox Costa, Costa Del Sol East
Beds: 3 Baths: 2 M2: 145 Lot Size: 540 Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Lot Size: 540 Region: Andalucía
Elegant Sea-View Villa with Private Pool in Torrox Costa
This stylish single-level villa with basement space is set on a 540 m² plot and offers 145 m² of beautifully designed living space. The (...)
€555,000
TSEA5125012
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 251 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 251 Area: Fuengirola Region: Andalucía
In the heart of the quiet and listed area of Los Pacos, in Fuengirola, you will find this unique one-storey villa, where serenity and comfort combine perfectly. More than a house, it is a place to (...)
€495,000
TSEA5124307
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 2 M2: 204 Lot Size: 249 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 2 M2: 204 Lot Size: 249 Area: Benalmadena Region: Andalucía
SEMI-DETACHED VILLA FOR SALE IN BENALMÁDENA!
We offer this spacious and bright semi-detached villa for sale in Benalmádena Pueblo, in the province of Málaga. Nestled on a 249 m² plot, it is (...)
€1,299,000
TSEA5124235
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 242 Lot Size: 902 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 242 Lot Size: 902 Area: Marbella West Region: Andalucía
This villa for sale in the prestigious Los Naranjos Hill Club, Marbella, presents an excellent investment opportunity for those looking to undertake a renovation project. Located in a highly (...)
Current Featured Properties
€1,695,000
TSEA5107642
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 3 M2: 200 Lot Size: 1,000 Area: Casares Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Lot Size: 1,000 Area: Casares Region: Andalucía
BEAUTIFULLY DESIGNED LUXURY VILLA FRONT-LINE CASARES GOLF COURSE
BUILDING LICENSE GRANTED
Close to Finca Cortesin Golf and a 5-star hotel. An independent, energy-efficient and sustainably ready to (...)
€10,900,000
TSEA4801294
- Benahavís, Costa Del Sol, Benahavis
Beds: 8 Baths: 10 M2: 958 Lot Size: 3,631 Area: Benahavis Region: Andalucía
Beds: 8 Baths: 10 M2: 958 Lot Size: 3,631 Area: Benahavis Region: Andalucía
This property is a stunning new-build villa by the esteemed architect and interior design firm GC Studios. Sitting on a generous elevated plot, the villa grants residents an exclusive and (...)
€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 (...)
