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,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 (41,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 (41,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 1524
€299,000
TSEA5159593
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 112 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Manilva Region: Andalucía
Townhouse, Manilva, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 112 m², Terrace 72 m².
Setting : Country, Village, Close To Shops, Close To Schools, Urbanisation.
Orientation : North (...)
€220,000
TSEA5159560
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 46 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Marbella Region: Andalucía
We offers a SUPERB STUDIO IN MARBELLA.
Located 5 minutes from the beach and the hospital, just 1 minute from the Old Town.
Property located in the heart of Puerto Banús, Marbella, in one of the (...)
€525,000
TSEA5159521
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 56 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 56 Area: Mijas and Mijas Costa Region: Andalucía
SECOND LINE BEACH. This is a lovely 2 bedroom penthouse apartment with fantastic pool, garden and sea views from the enclosed terrace and solarium. Situated in a great location very close to the (...)
€1,290,000
TSEA5159458
- La Capellania, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 130 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Fuengirola Region: Andalucía
Penthouse, La Capellania, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 100 m².
Setting : Close To Sea, Urbanisation.
Orientation : South, South West.
Condition : Excellent.
Pool : (...)
€425,000
TSEA5159269
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 3 M2: 180 Area: Manilva Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: Manilva Region: Andalucía
Magnificent property situated in a prime beachfront location in the coveted area of Aldea Beach, just a stone's throw from the charming Puerto de La Duquesa. A unique opportunity for those (...)
€1,100,000
TSEA5159263
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 137 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 137 Area: Estepona Region: Andalucía
EXCEPTIONAL BEACHFRONT PENTHOUSE WITH PANORAMIC VIEWS OF THE SEA, MOUNTAINS, AND THE AFRICAN COASTLINE, FEATURING TWO SPACIOUS TERRACES TOTALING 100m². This exclusive property is located in the (...)
€1,250,000
TSEA5159074
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Stunning, south-facing fully renovated, three bedroom beachfront apartment in the heart of Estepona's charming Old Town offering spectacular panoramic sea views. With a large usable space, the home (...)
€470,000
TSEA5159014
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 230 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 230 Area: Estepona Region: Andalucía
Discover this magnificent townhouse located in an exclusive gated community, just a short distance from the new high-resolution hospital and frontline to a spectacular golf course, offering (...)
€530,000
TSEA5158819
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 104 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Marbella Region: Andalucía
Situated in the heart of Marbella Centro, this unique first floor apartment offers a rare opportunity with its south orientation and an large private terrace that spans the entire building and (...)
€495,000
TSEA5158807
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 70 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 70 Area: Torremolinos Region: Andalucía
This impeccably maintained home, spanning 118 square meters, offers a harmonious blend of luxurious living and serene comfort.
Upon entering, you are greeted by a spacious living area, distinguished (...)
€634,900
TSEA5158789
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 4 M2: 149 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 4 M2: 149 Area: Fuengirola Region: Andalucía
Exclusive New Development in Torreblanca del Sol – Fuengirola ✨
Just 500 metres from the beach and with excellent commuter train connections, Mirador del Limonar offers contemporary homes that (...)
€630,000
TSEA5158777
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 134 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 134 Area: San Pedro Region: Andalucía
Beachside, 5 minutes from Puerto Banús
Large semi-detached house with 4 bedrooms, 3 bathrooms, a spacious living-dining room with beautiful views of the pool and gardens, in a gated community. It (...)
€449,000
TSEA5158285
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 148 Lot Size: 89 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Lot Size: 89 Area: Istan Region: Andalucía
"Istan" is a town of Arabic origin, located in the Natural Park of Sierra de las Nieves and just 15 kilometres from the beaches of Marbella.
This beautifully completely renovated house can (...)
€875,000
TSEA5158270
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 198 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 198 Area: Manilva Region: Andalucía
A stunning newly built four-story townhouse, this exceptional residence offers three double bedrooms, a spacious south-facing terrace, and an expansive rooftop solarium with panoramic views of the (...)
€485,000
TSEA5158084
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 125 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Istan Region: Andalucía
This beautiful townhouse has been TOTALLY RENOVATED to a high standard and is located in Zahara de Istan, just an 8-minute drive from Marbella's Golden Mile.
The property features a spacious living (...)
€750,000
TSEA5158048
- Sotogrande Marina, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 137 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Sotogrande Region: Andalucía
???? Duplex Apartment with Solarium and Marina Views in Sotogrande
Located in one of the most exclusive areas of the Costa del Sol, this stunning apartment in the Sotogrande Marina offers generous (...)
€160,000
TSEA5157484
- El Padron, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 49 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Estepona Region: Andalucía
Spectacular panoramic views of the sea and mountains
Brand new, fully renovated duplex penthouse with a separate bedroom on the upper level, a full bathroom with a large shower and window.
Ground (...)
€630,000
TSEA5157463
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 136 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Area: Marbella West Region: Andalucía
Bright Semi-Detached Home in Los Naranjos de Marbella, Just 1.5 km from the Beach and Puerto Banús
Located in the prestigious Los Naranjos de Marbella urbanization, this bright and modern (...)
€620,000
TSEA5157445
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 106 Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Region: Andalucía
Penthouse Living at Its Best
Step into a world of style and comfort with this stunning penthouse apartment. Featuring two elegant bathrooms – one with a sleek shower and the other with a luxurious (...)
€320,000
TSEA5157442
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
This beautifully renovated townhouse is located in Mijas Golf within walking distance to all amenities and public transport. It is set in the tranquil gardens of a gated, secure community.There are (...)
Current Featured Properties
€1,015,000
Top Floor Apartment in Nueava Andalucia
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Area: Marbella West Region: Andalucía
LAST PENTHOUSE REMAINING!!!!
Situated in a privileged position on a hill with the best panoramic views over the "Viejo del Angel" water reservoir, the Marbella coastline and the golf (...)
€570,000
TSEA4975855
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
LA PERLA DE LA HEREDIA , BENAHAVIS.
This charming townhouse is located in the cozy village of La Perla de la Heredia, just off Ronda Road. It faces south to southwest, offering lovely views of the (...)
€1,190,000
TSEA5002087
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Discover the beauty of the natural surroundings of your community. Enjoy the serenity of a home committed to nature, which cares for the environment and is committed to replanting native vegetation (...)
