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
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
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
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1461 - 1480 of 7575 €680,000
TSEA5118118
- Limonar, Costa Del Sol
Beds: 2 Baths: 1 M2: 76 Region: Andalucía
Beds: 2 Baths: 1 M2: 76 Region: Andalucía
Imagine waking up every morning in this cozy penthouse, full of light, charm, and warmth. Built in 1989 with care, it's a home made to be felt.
As you open the reinforced glass doors to the living (...)
€320,000
TSEA5118100
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Stunning top floor apartment with rooftop terrace in the upper part of Calahonda. Located in the peaceful community of El Porton, this beautiful top floor apartment offers unobstructed sea views and (...)
€324,000
TSEA5118091
- Torre del Mar, Costa Del Sol East
Beds: 3 Baths: 2 M2: 165 Region: Andalucía
Beds: 3 Baths: 2 M2: 165 Region: Andalucía
Stylish Renovated Duplex Apartment in Torre del Mar!
Discover this beautifully renovated duplex apartment, located in Torre del Mar, walking distance from the beach. With its convenient location (...)
€7,000,000
TSEA5118079
- El Madroñal, Costa Del Sol, San Pedro
Beds: 6 Baths: 7 M2: 868 Lot Size: 3,035 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 7 M2: 868 Lot Size: 3,035 Area: San Pedro Region: Andalucía
Stunning contemporary villa located in the heart of Madroñal, Benahavis, with breathtaking panoramic sea views. This luxury 6 bedroom home is located within an exclusive gated community with 24 hour (...)
€398,000
TSEA5118049
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 105 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: Manilva Region: Andalucía
This new development of two and three-bedroom apartments in a magnificent urbanisation in an extraordinary location. The project combines modern design architecture with perfectly studied landscaping (...)
€7,200,000
TSEA5118037
- El Paraiso, Costa Del Sol, Estepona
Beds: 6 Baths: 9 M2: 1,182 Lot Size: 1,283 Area: Estepona Region: Andalucía
Beds: 6 Baths: 9 M2: 1,182 Lot Size: 1,283 Area: Estepona Region: Andalucía
Exclusive Luxury Villa in El Paraíso Alto – Modern, Spacious, and Just Minutes from Puerto Banús & Estepona
Discover this stunning brand-new villa (2025) located in El Paraíso Alto, one of (...)
€795,000
TSEA5118034
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 141 Lot Size: 226 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Lot Size: 226 Area: Estepona Region: Andalucía
Modern and elegant villa with extraordinary panoramic views of the sea, the mountains, Gibraltar, and Africa, located in a privileged area with direct access to beautiful beaches via a convenient (...)
€515,000
TSEA5118022
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 2 Baths: 3 M2: 205 Area: Marbella Region: Andalucía
Beds: 2 Baths: 3 M2: 205 Area: Marbella Region: Andalucía
Live in paradise with sea and mountain views!
Duplex in Altos de Marbella – Lomas de los Monteros
Discover this spectacular 205m² duplex apartment, located in one of the most exclusive (...)
€920,000
TSEA5118016
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 387 Lot Size: 1,038 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 387 Lot Size: 1,038 Area: Benalmadena Region: Andalucía
Detached house with garden and pool
Property Description
Very close to the city center of Benalmádena, the famed Parque de la Paloma, and within walking distance to the beach, sits this cozy (...)
€3,500,000
TSEA5118007
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 386 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 386 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive 5-Bedroom Duplex Penthouse in Mijas Costa with Unbeatable Views
This one-of-a-kind 5-bedroom duplex penthouse in Santa Barbara Heights, Mijas Costa, offers an unparalleled lifestyle of (...)
€720,000
TSEA5117986
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Spacious 3-Bedroom Apartment in the Prestigious Las Mesas Urbanization, Estepona
A stylish and modern apartment is offered in one of the most sought-after residential complexes in Estepona — Las (...)
€223,000
TSEA5117980
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 1 M2: 67 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 1 M2: 67 Area: Torremolinos Region: Andalucía
We present a stunning apartment located in a prime area, surrounded by services and shops that meet all your daily needs. Just steps from the local outpatient clinic, this property stands out for its (...)
€259,000
TSEA5117962
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 67 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 67 Area: Benalmadena Region: Andalucía
Located in a privileged setting, close to a supermarket, health center, and golf course, this bright apartment offers a perfect combination of comfort and location.
The home features:
One spacious (...)
€1,480,000
TSEA5117947
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 210 Lot Size: 754 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 210 Lot Size: 754 Area: Estepona Region: Andalucía
Detached Villa, Bel Air, Costa del Sol.
3 Bedrooms, 2.5 Bathrooms, Built 210 m², Terrace 79 m², Garden/Plot 754 m².
Setting : Commercial Area, Close To Golf, Close To Shops.
Orientation : South (...)
€243,000
TSEA5117938
- Málaga, Costa Del Sol, Malaga
Beds: 1 Baths: 1 M2: 45 Area: Malaga Region: Andalucía
Beds: 1 Baths: 1 M2: 45 Area: Malaga Region: Andalucía
New Development: Prices from 243,000 € to 381,000 €. [Beds: 1 - 3] [Baths: 1 - 1] [Built size: 45.00 m2 - 79.00 m2]
Contemporary Living in the Heart of Málaga
This exclusive new residential (...)
€960,000
TSEA5117926
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Stunning 3-Bedroom Penthouse with Private Pool & Panoramic Views in the Heart of La Cala de Mijas
Welcome to your dream coastal escape this exquisite 3-bedroom, 2-bathroom penthouse apartment in (...)
€1,300,000
TSEA5117905
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 4 M2: 400 Lot Size: 1,035 Area: Marbella Region: Andalucía
Beds: 7 Baths: 4 M2: 400 Lot Size: 1,035 Area: Marbella Region: Andalucía
LARGE MARBELLA VILLA WITH GARDEN – WALK TO SHOPS, TOWN, AND THE SEA
Located in one of Marbella's most sought-after residential areas, this spacious 7-bedroom villa sits on a generous 1,035 m² (...)
€410,000
TSEA5117887
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 87 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: La Duquesa Region: Andalucía
Fantastic opportunity!! Stunning new build apartment with sea views!
Situated in Pure South, the best new development in La Duquesa, this stunning elevated ground floor apartment offers everything (...)
€249,000
TSEA5117866
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 1 M2: 102 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 1 M2: 102 Area: La Duquesa Region: Andalucía
Frontline port views at a bargain price!
This property is in the heart of Duquesa Port. It is a 2 Bedroom, 1 Bathroom, middle floor property with 100m2+.
What makes this property very interesting (...)
€410,000
TSEA5117848
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 116 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Marbella West Region: Andalucía
Flat for sale in Nueva Andalucia in the modern urbanisation of Albatros complex, 5mn drive to the vibrant Puertos Banus and 10 mn to Marbella centre.
The beach is a 5mn drive away, ideal for families (...)
Current Featured Properties
€995,000
TSEA4777597
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
LIGHT FLOODS INTO THE PROPERTY!!!
We will change weight for square meters, color for avant-garde architectural design, clarity for light and size for the best qualities and certified construction (...)
€1,490,000
TSEA4657525
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 147 Lot Size: 111 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 147 Lot Size: 111 Area: Benahavis Region: Andalucía
The construction is proposed in two phases, corresponding to the 2 distinct levels of the prime hillside position thereby taking full advantage of the privileged position on which will sit our finest (...)
€673,000
TSEA4107058
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
