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 (39,36,37,38)
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 (39,36,37,38)
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 (39,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 181 - 200 of 1080 €775,000
TSEA5127328
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 110 Lot Size: 55 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Lot Size: 55 Area: Benahavis Region: Andalucía
Located in the charming and modern Paraiso Pueblo urbanisation in Benahavís, we present this spacious ground-floor apartment with 3 bedrooms and 2 bathrooms. The property offers both a front and (...)
€845,000
TSEA5127307
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 200 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Area: Estepona Region: Andalucía
Fantastic 201m2 built,183 m2 usable ground floor south oriented apartment (elevated 2 meters above ground floor), fully furnished in a new beach side urbanization located in the heart of the (...)
€390,000
TSEA5127271
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 102 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Manilva Region: Andalucía
Immaculate 2-Bedroom Apartment with Stunning Sea Views near Sotogrande.
This recently updated and beautifully maintained apartment offers 2 spacious bedrooms with fitted wardrobes and 2 bathrooms (...)
€330,000
TSEA5127244
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 103 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: Marbella East Region: Andalucía
Beautiful ground floor two bedroom luxury apartment with outstanding panoramic views.
Quality fittings throughout.
Superbly maintained ready to move in.
Extra addition of glass curtains creating more (...)
€379,000
TSEA5127223
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 106 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 106 Area: Manilva Region: Andalucía
Modern Apartment with Sea Views and Private Terrace – La Paloma Manilva, Costa del Sol
This elegant apartment, measuring 105.9 m² (plus a 15.08 m² terrace), offers light, comfort, and a peaceful (...)
€399,000
TSEA5127004
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 140 Lot Size: 40 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 140 Lot Size: 40 Area: Benahavis Region: Andalucía
Frontline Golf Apartment for Sale in La Quinta – Ground Floor with Garden and Pool Access
A rare opportunity to own a beautiful and spacious 2-bedroom, 2-bathroom ground floor apartment in one of (...)
€615,000
TSEA5126917
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
Luxury Garden Apartment in Bahía de Marbella – Renovated Elegance, Open Spaces, and Unbeatable Location.
Discover the quintessential coastal lifestyle with this spectacular garden apartment, (...)
€185,000
TSEA5126527
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 70 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 70 Area: Benahavis Region: Andalucía
Charming Apartment in La Pacheca – Benahavís
Located in the peaceful and picturesque urbanisation La Pacheca, just minutes from the charming village center of Benahavís, this delightful apartment (...)
€599,500
TSEA5126506
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 112 Lot Size: 62 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Lot Size: 62 Area: Benahavis Region: Andalucía
We are delighted to present this beautiful 3-bedroom, 2-bathroom apartment, located in an elevated ground floor position that combines privacy, comfort, and exceptional outdoor living. With its (...)
€399,000
TSEA5126488
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 82 Lot Size: 35 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Lot Size: 35 Area: Marbella West Region: Andalucía
Welcome to this fantastic ground-floor apartment in the sought-after area of Señorio de Gonzaga, located in the heart of charming Nueva Andalucía – Aloha.
This ground-floor apartment is situated (...)
€1,590,000
TSEA5126305
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 160 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Marbella East Region: Andalucía
Welcome to Balcon de Puente Romano – a gated community on Marbella's prestigious Golden Mile.
This 3-bedroom ground-floor property offers a sophisticated single-level living, complemented by a (...)
€315,000
TSEA5126065
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Apartment for Sale with Sea Views in Fuengirola – Comfort, Natural Light, and Prime Location
Beautiful ground-floor apartment with a private entrance directly from the street, located in a quiet (...)
€449,000
TSEA5125966
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 154 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 154 Area: Estepona Region: Andalucía
Stunning Elevated Ground Floor Apartment in Las Olas – Fully Furnished & Key Ready
This beautifully appointed 2-bedroom, 2-bathroom apartment is located in the highly sought-after boutique (...)
€195,000
TSEA5125924
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 1 Baths: 1 M2: 55 Area: La Duquesa Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: La Duquesa Region: Andalucía
This charming raised ground floor one bedroom, one bathroom apartment, is situated in a sought-after gated community in the area of Duquesa. The property is in excellent condition and offers a (...)
€890,000
TSEA5125681
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 104 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Malaga Region: Andalucía
Experience elevated coastal living in this beautifully designed 2 bedroom apartment located in a boutique building on the prestigious Paseo Reding in the heart of Málaga.
Currently undergoing a (...)
€219,000
TSEA5125396
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 2 M2: 57 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 2 M2: 57 Area: Mijas and Mijas Costa Region: Andalucía
We offer this beautiful apartment for sale in the Riviera del Sol development, in the Flores de Riviera complex, in a quiet community with large green areas and a communal pool, in Mijas Costa, (...)
€749,000
TSEA5125243
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 107 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 107 Area: San Pedro Region: Andalucía
Welcome to this beautifully renovated ground floor apartment in Guadalmina Baja – Steps from the Beach and Golf!
Located in the sought-after area of Guadalmina Baja, just a short walk from the (...)
€395,000
TSEA5125240
- El Paraiso, 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
Spacious two bedroom ground floor apartment with direct access to the community gardens and pool area.
Privately situated in the heart of the complex, this apartment is the perfect place to relax (...)
€418,900
TSEA5125225
- La Trinidad, Costa Del Sol
Beds: 2 Baths: 2 M2: 62 Region: Andalucía
Beds: 2 Baths: 2 M2: 62 Region: Andalucía
A unique opportunity in the Trinidad area! This lot of two studios for sale is ideal for those seeking a secure investment in an area with high tourist potential. Both studios are fully furnished and (...)
€825,000
TSEA5125183
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Marbella West Region: Andalucía
EXCLUSIVE - BRAND NEW TO MARKET!
Beachfront Urbanisation - Playa Rocio, Puerto Banus-Marbella!
Unbeatable location with direct access onto the promenade and beach and a short 5 minute walk to the (...)
Current Featured Properties
€665,000
TSEA4358878
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 112 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Fuengirola Region: Andalucía
A DEVELOPMENT THAT YOU WILL WANT TO VIEW!!!
Spectacular new development of 60 luxury apartments in the most sought-after area of El Higuerón, in a gated exclusive community with gym, heated pool, (...)
€570,000
TSEA4581883
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
New development. Two- and three-bedrooms apartments with all kinds of leisure services that will change your life.
Modern units with large spaces, big windows, and wide terraces. Southwest (...)
€440,000
TSEA5071168
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 110 Lot Size: 34 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Lot Size: 34 Area: Casares Region: Andalucía
Discover this exclusive new development consisting of 99 apartments and penthouses, each with 2 or 3 bedrooms, designed to help you find where you truly belong. Situated in the prime location of (...)
