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 (41,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 (41,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 (41,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 601 - 620 of 3420 €599,000
TSEA5111263
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 5 M2: 233 Lot Size: 20 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 5 M2: 233 Lot Size: 20 Area: Marbella West Region: Andalucía
SEMI-DETACHED VILLA IN NUEVA ANDALUCÍA – PRIME LOCATION NEAR PUERTO BANÚS
Discover this elegant 4-bedroom, 5-bathroom semi-detached villa, ideally situated in one of Marbella's most sought-after (...)
€3,450,000
TSEA5110936
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 360 Lot Size: 1,003 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 360 Lot Size: 1,003 Area: Marbella West Region: Andalucía
Stunning villa for sale in the sought-after area of Nueva Andalucía Supermanzana H, offering an ideal combination of modern design, refined comfort, and a family-friendly atmosphere. This (...)
€1,595,000
TSEA5110864
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 5 M2: 503 Lot Size: 1,098 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 5 M2: 503 Lot Size: 1,098 Area: Mijas and Mijas Costa Region: Andalucía
Nestled in the exclusive and sought-after neighbourhood of Sierrezuela, just minutes from the heart of Fuengirola and its golden beaches, this beautifully appointed 6-bedroom, 5-bathroom villa is the (...)
€485,000
TSEA5110846
- Riogordo, Costa Del Sol East
Beds: 3 Baths: 2 M2: 177 Lot Size: 2,243 Region: Andalucía
Beds: 3 Baths: 2 M2: 177 Lot Size: 2,243 Region: Andalucía
Charming Country Home with Independent Apartment, Stunning Gardens & Excellent Access — Riogordo (Málaga, Andalusia)
We are delighted to present this beautifully maintained country estate near (...)
€1,150,000
TSEA5110819
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 120 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 120 Area: Benahavis Region: Andalucía
Luxurious Penthouse in Marbella Club Hills
Welcome to your new dream home, an unparalleled penthouse with 3 bedrooms and 3 bathrooms, located in the prestigious Marbella Club Hills. This exceptional (...)
€7,500,000
TSEA5110816
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 353 Lot Size: 1,036 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 353 Lot Size: 1,036 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular beachfront villa with panoramic views of the Mediterranean and direct access to the beach.
Recently completely renovated with a modern style, the villa is distributed over 2 spacious (...)
€2,750,000
TSEA5110717
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 450 Lot Size: 1,690 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 450 Lot Size: 1,690 Area: San Pedro Region: Andalucía
UNIQUE VILLA WITH FULL SIZE PRIVATE TENNIS COURT!
Welcome to this exceptional Mediterranean-style villa, located in the exclusive residential area of Guadalmina Baja – Casasola, Estepona. Just 300 (...)
€285,000
TSEA5110684
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
PENTHOUSE WITH SEA VIEWS NEXT TO THE BEACH
Fantastic penthouse located in the Torrequbrada area (Benalmadena costa) just a few minutes walk from the beach close to all kinds of services.
Apartment (...)
€1,300,000
TSEA5110627
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 274 Lot Size: 4,037 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 274 Lot Size: 4,037 Area: Estepona Region: Andalucía
Spectacular villa in an elevated position with stunning panoramic views of the Mediterranean Sea and the mountains. Located in the Padrón area of Estepona, surrounded by nature and just 10 minutes (...)
€990,000
TSEA5110603
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 3 M2: 267 Lot Size: 103 Area: Marbella Region: Andalucía
Beds: 6 Baths: 3 M2: 267 Lot Size: 103 Area: Marbella Region: Andalucía
A rustic town house, full of charm and character, consisting of two spacious independent apartments, one on each floor, both of which share a common entrance from the street through an elegant (...)
€425,000
TSEA5110501
- Estacion de Cartama, Costa Del Sol, Cartama
Beds: 5 Baths: 4 M2: 183 Lot Size: 8,182 Area: Cartama Region: Andalucía
Beds: 5 Baths: 4 M2: 183 Lot Size: 8,182 Area: Cartama Region: Andalucía
Finca - Cortijo, Estacion de Cartama, Inland Malaga
5 Bedrooms, 4 Bathrooms, Built 183 m², Garden/Plot 8182 m².
There are 2 semi-detached houses, they are located on top of a hill, so it has (...)
€385,000
TSEA5110435
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 128 Lot Size: 138 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Lot Size: 138 Area: Manilva Region: Andalucía
New Development: Prices from 385,000 € to 490,000 €. [Beds: 2 - 3] [Baths: 2 - 3] [Built size: 128.00 m2 - 207.00 m2]
VILLA 1
207.45 m² built on a 240 m² plot. It has 3 bedrooms, 3 (...)
€530,000
TSEA5110408
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M2: 220 Lot Size: 180 Area: Casares Region: Andalucía
Beds: 4 Baths: 4 M2: 220 Lot Size: 180 Area: Casares Region: Andalucía
MAGNIFICENT SEMI-DETACHED HOUSE WITH 4 BEDROOMS NEXT TO THE FINCA CORTESÍN GOLF COURSE
Located next to the Finca Cortesín Golf Course, one of the most prestigious golf courses in Spain, it has (...)
€329,000
TSEA5110213
- New Golden Mile, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 73 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 73 Area: Estepona Region: Andalucía
Stunning One-Level Penthouse with Panoramic Sea Views
This beautifully presented one-level penthouse offers a rare combination of style, comfort, and unbeatable location. Featuring an open and (...)
€195,000
TSEA5110204
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Opportunity! Beachfront penthouse in Manilva, in the Aparthotel Don Juan.
The apartment, located on the fifth floor, has a floor area of 104 m² and a 12 m² terrace with sea views, facing (...)
€2,000,000
TSEA5109901
- Martiricos, Costa Del Sol
Beds: 3 Baths: 3 M2: 136 Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Region: Andalucía
Welcome to the highest and most exclusive penthouse in Andalusia. Direct from the developer.. This extraordinary residence offers not only an unparalleled luxury experience, but also stunning (...)
€349,000
TSEA5109667
- Mezquitilla, Costa Del Sol East
Beds: 2 Baths: 1 M2: 98 Lot Size: 98 Region: Andalucía
Beds: 2 Baths: 1 M2: 98 Lot Size: 98 Region: Andalucía
Welcome to this charming penthouse in the coastal village of Mezquitillaa perfect blend of comfort, functionality, and Mediterranean lifestyle. This well-designed apartment stands out with two (...)
€329,000
TSEA5109616
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Brand New to the Market – Prime Coastal Location in Calahonda !
Just a three-minute walk to the beach and the renowned Calahonda Royal Beach Restaurant, Supermarkets and shops etc..
This (...)
€386,000
TSEA5109583
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
great property in the centre of Estepona very close to the beach, town hall and shopping area. very convenient to walk to all places
flat on the top floor of the building of three, has an attic area (...)
€1,200,000
TSEA5109568
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 101 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Estepona Region: Andalucía
Exclusive Beachfront Penthouses – Experience Estepona at Its Finest – Stunning Penthouses with Panoramic Sea Views
Description:
Exclusive Costa del Sol Property Listings - 5 is sold og the 7 (...)
Current Featured Properties
€649,000
TSEA3990796
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 91 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Casares Region: Andalucía
LAST CHANCE TO BUY! SEA VIEWS THAT YOU DREAM ABOUT!!!
Last 2 beds starting from 360,495€ and one last 3 bed at 558,000€!
Designed in a contemporary style, the apartments and penthouses have been (...)
€725,000
EMPTY
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 139 Lot Size: 748 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 139 Lot Size: 748 Area: Estepona Region: Andalucía
NEW GOLDEN MILE, ESTEPONA
Villa/finca in urb. El Velerin next to Hospiten Hospital just accross the road of Emare. In need to reform.
South facing, walking distance to the beach and the paseo of (...)
€1,038,000
TSEA4965829
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 90 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Benalmadena Region: Andalucía
Nestled amidst Benalmadena's vibrant centre and situated adjacent to its picturesque port, This new development offers the perfect blend of city living and seaside luxury. A distinctive project that (...)
