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,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
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.approved = 1 AND pm.cat_id IN (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
GROUP BY p.id
ORDER BY p.created DESC
Results 261 - 280 of 7581
TSEA5152024
- El Campamento, Costa de la Luz
Beds: 4 Baths: 3 M2: 276 Lot Size: 140 Region: Andalucía
Beds: 4 Baths: 3 M2: 276 Lot Size: 140 Region: Andalucía
Charming Renovated House with Private Pool and Stunning Gibraltar Views in Puente Mayorga - Campamento, San Roque!
Discover this delightful south-west facing home, perfectly positioned in the serene (...)
TSEA5152009
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Discover the perfect blend of convenience and coastal living with this fantastic apartment, located just 400 meters from the beach. This property is ideally suited for anyone seeking either a (...)
TSEA5152006
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 101 Lot Size: 42 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Lot Size: 42 Area: Marbella East Region: Andalucía
Unique Stunning Ibiza-Style Townhouse with Private Garden – Cabopino Area minimalistic decorated with micro cement , wood and linen !!
Discover this beautifully renovated townhouse offering the (...)
TSEA5151985
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 284 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 284 Area: Benalmadena Region: Andalucía
Unique opportunity in Benalmadena!
In the best area of Benalmadena, an impressive, fully renovated house is for sale, ready to move into. A property meticulously cared for, perfect as both a (...)
TSEA5151979
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Elegant Apartment with Sea Views in Lower Carvajal
Property with rental license.
Welcome to this stylish two-bedroom, two-bathroom apartment nestled in the peaceful and sought-after area of Lower (...)
TSEA5151970
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 135 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Benahavis Region: Andalucía
Stunning Two-Bedroom Penthouse Apartment in Gazules del Sol
This bright and elegant two-bedroom penthouse is located in the sought-after urbanisation Gazules del Sol.
Upon entering, you are (...)
TSEA5151955
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Breathe and enjoy life at your own rhythm. This brand new apartment development offers the space to be yourself, to focus on what matters, and to reconnect with a lifestyle that feels effort-less. (...)
TSEA5151949
- La Campana, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 47 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 47 Area: Marbella West Region: Andalucía
Ground Floor Apartment, La Campana, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 47 m².
Setting : Town, Suburban, Commercial Area, Village, Close To Shops, Close To Town, Close To (...)
TSEA5151901
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 212 Lot Size: 3,500 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 212 Lot Size: 3,500 Area: Estepona Region: Andalucía
Discover a unique opportunity with this house located in the prestigious Selwo area, on the **New Golden Mile**, Estepona. This property offers a solid foundation for a renovation project that can (...)
TSEA5151841
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Modern Renovated Apartment in Nueva Atalaya, Estepona – 2 Bedrooms, 2 Bathrooms, Private Terrace & Communal Pool
Located in the sought-after area of Nueva Atalaya, Estepona, this beautifully (...)
TSEA5151808
- Cancelada, Costa Del Sol, Estepona
Beds: 5 Baths: 4 M2: 417 Lot Size: 880 Area: Estepona Region: Andalucía
Beds: 5 Baths: 4 M2: 417 Lot Size: 880 Area: Estepona Region: Andalucía
Contemporary villa with great sea views and south facing, with large windows so all rooms are light and airy. The villa is in the municipality of Estepona, set between the mountains and the sea.
The (...)
TSEA5151799
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
Beautiful and spacious 2 bedroom apartment located in the five star urbanisation of Capanes Del Golf, Benahavis. This apartment enjoys wonderful golf, lake and mountain views. The kitchen has been (...)
TSEA5151781
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 96 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 96 Area: Estepona Region: Andalucía
Ground Floor Apartment, Estepona, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 96 m², Terrace 15 m².
Setting : Beachfront, Town, Commercial Area, Beachside, Port, Village, Close To Port, Close To (...)
TSEA5151778
- Archidona, Costa Del Sol, Antequera
Beds: 5 Baths: 5 M2: 510 Lot Size: 185 Area: Antequera Region: Andalucía
Beds: 5 Baths: 5 M2: 510 Lot Size: 185 Area: Antequera Region: Andalucía
Unique Baroque Townhouse for Sale in the Heart of Archidona, east of Antiquera. Step inside the timeless elegance of this impressive townhouse in the charming Andalusian town of Archidona. Spread (...)
TSEA5151766
- Valle Romano, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
An ideal setting...
2 bedroom, 2 bathroom open plan apartment on the fist floor of recently completed new development.
Habitat Valle Romano is perched on a gentle hilltop overlooking the bay of (...)
TSEA5151748
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 130 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Living in Finca San Antonio – A Rare Gem Near Mijas Pueblo
Step into elegance with this exceptional 2-bedroom, 2-bathroom apartment nestled in the prestigious Finca San Antonio community, (...)
TSEA5151739
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 88 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 88 Area: Fuengirola Region: Andalucía
Breathe and enjoy life at your own rhythm. This brand new apartment development offers the space to be yourself, to focus on what matters, and to reconnect with a lifestyle that feels effort-less. (...)
TSEA5151736
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
The One Residence urbanisation is an exclusive, luxury complex next to the Calanova Golf Course. This fabulous apartment is one of the best within the urbanisation providing commanding PANORAMIC SEA (...)
TSEA5151712
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 188 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 188 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 925,000 € to 1,119,950 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 188.00 m2 - 255.00 m2]
Building License Expected November 2025
Ideally located among fragrant (...)
TSEA5151661
- Cancelada, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 400 Lot Size: 900 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 400 Lot Size: 900 Area: Estepona Region: Andalucía
Luxury Villa in Cancelada – Costa del Sol
Exclusive detached villa, newly built, located in one of the most sought-after areas of the Costa del Sol. With a contemporary design and top-quality (...)
