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

Advanced Search

spain
Sotogrande La Duquesa Manilva Casares Gaucin Estepona Ronda San Pedro Benahavis Marbella West Marbella Marbella East Mijas and Mijas Costa Mijas and Mijas Costa Istan Ojen Monda Guaro Coin Fuengirola Benalmadena Al Haurin de el Grande Al Haurin de la Torre Malaga Torremolinos
Results 341 - 360 of 7581
Results 341 - 360 of 7581
TSEA5149888
New
TSEA5149888 - La Mairena, Costa Del Sol, Marbella East
Beds: 2   Baths: 2   M2: 88   Area: Marbella East   Region: Andalucía   
This is a very attractive modern apartment located in an elevated spot above the beaches of Elviria and East Marbella. Located in the high end enclave of La Maiirena an area occupied by luxury (...)
Apartment Ground Floor
TSEA5149885
New
TSEA5149885 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 3   M2: 213   Lot Size: 10,545   Area: Mijas and Mijas Costa   Region: Andalucía   
A Spectacular, Self-Sufficient, Country Villa with Mature Grounds and Income Potential This stunning country estate is arguably one of, if not the best of its kind being fully self-sufficient with (...)
Villa Detached
TSEA5149873
New
TSEA5149873 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 84   Area: Estepona   Region: Andalucía   
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
Apartment Middle Floor
TSEA5149855
New
TSEA5149855 - Málaga Centro, Costa Del Sol, Malaga
Beds: 2   Baths: 1   M2: 50   Area: Malaga   Region: Andalucía   
Tourist-Licensed Apartment in the Heart of Málaga – La Merced Area Turnkey investment with proven high returns! Located just a few steps from the iconic Plaza de la Merced, this modern apartment (...)
Apartment Middle Floor
TSEA5149840
New
TSEA5149840 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 74   Area: Estepona   Region: Andalucía   
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
Apartment Middle Floor
TSEA5149831
New
TSEA5149831 - Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 93   Area: Mijas and Mijas Costa   Region: Andalucía   
The spacious apartment to reform with 2-bedroom, 2-bathroom (one en suite) is located in an exclusive frontline beach complex in Calahonda. Situated on the third floor with lift access, it boasts a (...)
Apartment Middle Floor
TSEA5149822
New
TSEA5149822 - Manilva, Costa Del Sol, Manilva
Beds: 1   Baths: 1   M2: 38   Area: Manilva   Region: Andalucía   
Situated in Playa Paraíso, Manilva, this charming duplex apartment enjoys an enviable position just a few steps from a quiet and peaceful stretch of beach. The area offers a tranquil coastal (...)
Townhouse Terraced
TSEA5149801
New
TSEA5149801 - Estepona, Costa Del Sol, Estepona
Beds: 1   Baths: 1   M2: 46   Area: Estepona   Region: Andalucía   
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
Apartment Middle Floor
TSEA5148742
New
TSEA5148742 - Elviria, Costa Del Sol, Marbella East
Beds: 3   Baths: 2   M2: 74   Area: Marbella East   Region: Andalucía   
ELVIRIA. LOVELY APARTMENT WITH GREAT POTENTIAL SITUATED ON THE TOP FLOOR IN THE CENTRAL URBANIZATION OF PARQUE ELVIRIA. THE APARTMENT IS 105 m2 INCLUDING TERRACES. THE APARTMENT HAS 3 BEDROOMS AND 2 (...)
Apartment Penthouse
TSEA5148733
New
TSEA5148733 - The Golden Mile, Costa Del Sol, Marbella East
Beds: 1   Baths: 1   M2: 71   Area: Marbella East   Region: Andalucía   
Beautiful one bedroom apartment with spacious lounge dining room, fitted kitchen and terrace. Property has air conditioning, marble floors, 1 storage room and a parking space in the underground (...)
Apartment Middle Floor
TSEA5148727
New
TSEA5148727 - Torreblanca, Costa Del Sol, Fuengirola
Beds: 1   Baths: 1   M2: 65   Area: Fuengirola   Region: Andalucía   
Discover the charm of this beautiful and spacious studio, which was originally a cozy one-bedroom apartment. Located in a prime location, you'll enjoy spectacular sea views from the comfort of your (...)
Apartment Middle Floor
TSEA5148715
New
TSEA5148715 - Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 213   Area: Mijas and Mijas Costa   Region: Andalucía   
Semi-detached house for sale located in the exclusive area of ​​Calahonda, Mijas Costa, within a quiet and well-connected residential complex. A unique opportunity to acquire a spacious home on (...)
Townhouse Terraced
TSEA5148709
New
TSEA5148709 - Istán, Costa Del Sol, Istan
Beds: 4   Baths: 5   M2: 234   Lot Size: 800   Area: Istan   Region: Andalucía   
This exceptional four-bedroom villa, occupies the best position within the prestigious gated community of Sierra Blanca Country Club. Offering 100% privacy and uninterrupted panoramic views across (...)
Villa Detached
TSEA5148703
New
TSEA5148703 - Torremolinos, Costa Del Sol, Torremolinos
Beds: 2   Baths: 1   M2: 78   Area: Torremolinos   Region: Andalucía   
FLAT FOR SALE IN TORREMOLINOS Beautiful, sunny flat for sale, built in 2007 with high-quality finishes, located on the second floor of a building with a lift and only seven neighbours, completely (...)
Apartment Middle Floor
TSEA5148673
New
TSEA5148673 - Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 128   Area: Mijas and Mijas Costa   Region: Andalucía   
spacious 3 bed 2 bath apartment centrally located large communal pool in need of some updating located close to shops and restaurants Middle Floor Apartment, Las Lagunas, Costa del Sol. 3 (...)
Apartment Middle Floor
TSEA5148664
New
TSEA5148664 - Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 1   M2: 126   Area: Mijas and Mijas Costa   Region: Andalucía   
Fantastic apartment located in Las Lagunas. Discover this fantastic 126 m2 apartment located in the coveted area of ​​Las Lagunas. The property features three bedrooms, all equipped with (...)
Apartment Middle Floor
TSEA5148604
New
TSEA5148604 - Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 3   M2: 152   Area: Mijas and Mijas Costa   Region: Andalucía   
Bright and Spacious 3 Bed Corner Apartment with Stunning Views, Private Terrace and Premium Facilities Welcome to this inviting 3-bedroom apartment in the sought-after Las Olas complex in (...)
Apartment Middle Floor
TSEA5148583
New
TSEA5148583 - Marbella, Costa Del Sol, Marbella
Beds: 4   Baths: 2   M2: 98   Area: Marbella   Region: Andalucía   
This four-bedroom flat, situated in the heart of Marbella, Malaga, presents an exceptional opportunity for those seeking a well-located property with substantial potential. Set within a gated (...)
Apartment Middle Floor
TSEA5148580
New
TSEA5148580 - Málaga Centro, Costa Del Sol, Malaga
Beds: 6   Baths: 5   M2: 157   Area: Malaga   Region: Andalucía   
Townhouse for sale in Malaga - Charming and modern Discover this magnificent, fully renovated townhouse located on Salamanca's market square in the heart of Malaga. With a floor area of 1,700 sq ft, (...)
Townhouse Semi Detached
TSEA5148568
New
TSEA5148568 - San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1   Baths: 1   M2: 60   Area: Manilva   Region: Andalucía   
*** Walk Everywhere Apartment - No Car Necessary! *** Charming apartment ideally located in the centre of San Luis de Sabinillas. **** NOTE: This is a 1 bedroom and 1 bath apartment, however, it (...)
Apartment Middle Floor