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 (31,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 (31,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 (31,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 421 - 440 of 4730
€325,000
TSEA5142982
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 85 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Benalmadena Region: Andalucía
Discover your new home in this spectacular, fully renovated apartment, just a 5-minute walk from the beach! With a charming terrace offering stunning sea views, this space is perfect for enjoying the (...)
€309,000
TSEA5142808
- Mijas, 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
Middle Floor, 2 Bed, 2 Bath Apartment in Mijas, Costa del Sol
Discover this charming middle-floor apartment located in the picturesque area of Mijas, Costa del Sol. This property offers an ideal (...)
€429,000
TSEA5142796
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 77 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Marbella East Region: Andalucía
This is a great apartment for sale tight in the famous port of Cabopino in East Marbella. Originally this was a very large 1 bedroom apartment, but the owner has cleverly converted it into a two (...)
€390,000
TSEA5142793
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 59 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 59 Area: Estepona Region: Andalucía
Elegant Penthouse with Rooftop Jacuzzi and Breathtaking Sea Views
This beautifully renovated penthouse is located in the sought-after Sun Gardens urbanization in Estepona East. The community offers (...)
€300,000
TSEA5142781
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 119 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 119 Area: Estepona Region: Andalucía
Fully Renovated Duplex Penthouse with Enclosed Terrace & Private Parking
Experience comfort and exclusivity in this fully renovated duplex penthouse, where the owners have added numerous extras (...)
€840,000
TSEA5142754
- El Rosario, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 213 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 213 Area: Marbella East Region: Andalucía
Incredible 3-bedroom penthouse with stunning views of the sea and Marbella Golf course! Located in the exclusive El Lagar del Rosario residential area, this property is perfect for those looking for (...)
€575,000
TSEA5142745
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Marbella West Region: Andalucía
Andalusian Charm Meets Modern Comfort in the Heart of Nueva Andalucía
Welcome to La Maestranza, a unique residential complex built in the style of a traditional Spanish village, complete with (...)
€378,000
TSEA5142739
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
We are pleased to offer for sale this fabulous well-maintained 3 bedroom 2 bathroom apartment close to amenities and near the beach.
The apartment is an elevated ground floor and benefits a closed (...)
€445,000
TSEA5142721
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 109 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 109 Area: Marbella West Region: Andalucía
Beautiful garden apartment in Le Village, one of the most complete urbanisations in Nueva Andalucía, Marbella.
This apartment has two bedrooms and two bathrooms, one of which is en suite. There is (...)
€769,000
TSEA5142685
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 155 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 155 Area: Estepona Region: Andalucía
Elegant 2-Bedroom Apartment for Sale in Bahía de la Plata – Frontline Beach, Estepona
Bright Two Bedroom First-Floor Corner Apartment with Sunny Terrace, Sea Views & Privacy in Prime (...)
€510,000
TSEA5142682
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
This duplex penthouse with touristic license, comes fully furnished and beautifully decorated, and offers incredible panoramic views of La Concha Mountain, El Paraiso Golf Course, and the (...)
€360,000
TSEA5142676
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 131 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 131 Area: Estepona Region: Andalucía
2-bedroom apartment for sale with wonderful views in the centre of Estepona
Located on the highest floor of the building, offering wonderful views, in the centre of Estepona.
Built in 2006, (...)
€490,000
TSEA5142649
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
EXCLUSIVE MODERN PROPERTY IN ONE OF ESTEPONA'S MOST SOUGHT-AFTER AREAS, WITH HIGH-QUALITY FINISHES, TWO PARKING SPACES AND A STORAGE ROOM.Prime location in one of Estepona's most desirable and (...)
€450,000
TSEA5142637
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 122 Area: Estepona Region: Andalucía
Fully renovated garden apartment in Estepona Port's boutique community – La Fragata.
Beautifully refurbished 2-bedroom garden apartment in the exclusive La Fragata community, a boutique complex (...)
€230,000
TSEA5142619
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 76 Area: Mijas and Mijas Costa Region: Andalucía
Loveley one bedroom property , which could be good for a permenant living or a holiday home. apartment located between Mijas Pueblo ( pictures Andalusian village ) and Fuengirola (very busy sea side (...)
€359,000
TSEA5142613
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 64 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 64 Area: Benalmadena Region: Andalucía
Beautiful apartment for sale in Puerto Marina, Benalmadena
???? APARTMENT FOR SALE IN PUERTO MARINA, BENALMÁDENA! ???? Unbeatable location, next to the marina. ✨ With a holiday rental license – (...)
€400,000
TSEA5142571
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 100 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Benahavis Region: Andalucía
Discover this exclusive apartment in a quiet residential area located in Puerto del Almendro/Los Arqueros, with a large terrace, creating a unique space to enjoy the sun and the Mediterranean (...)
€320,000
TSEA5142562
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 73 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 73 Area: La Duquesa Region: Andalucía
Stylish south facing two bedroom, two bathroom apartment located within this much sought after urbanisation of Vistalmar, between Sotogrande and La Duquesa marina. Set within a secure gated and quiet (...)
€605,000
TSEA5142559
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Stunning Renovated Apartment in the Heart of Marbella!
Discover elegance and comfort in this magnificently renovated 78 m² apartment, perfectly situated in the vibrant center of Marbella. Nestled (...)
€1,250,000
TSEA5142550
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 130 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Marbella East Region: Andalucía
Luxury 3-Bedroom Duplex Apartment with Sea and Garden View – Hacienda de Nagüeles, Marbella
Discover this stunning recently renovated 3-bedroom duplex apartment located in the prestigious (...)
Current Featured Properties
€455,000
Beautiful contemporary apartments with stunning rooftop pool!
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 83 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 83 Area: Marbella West Region: Andalucía
CLOSE TO FABULOUS PUERTO BANUS AND THE BEACHES.
Offering homes from 90m2 to 150m2 with finishes of first QUALITY AND MODERN design. All have a large private terrace, garage space in the building (...)
€890,000
TSEA4939027
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
This is the opportunity of living in Spain, in the best equipped residential complex in Marbella, located in a privileged spot near the golf club and with premium quality specifi cations. You will (...)
€399,000
TSEA4693576
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 86 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Torremolinos Region: Andalucía
LOCATED IN ONE OF THE BEST AREAS OF TORREMOLINOS!!!
Bringing to life a new residential concept in Torremolinos. Designed to enjoy the Mediterranean and the endless light of the Costa del Sol. A (...)
