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 141 - 160 of 7581
Results 141 - 160 of 7581
TSEA5155435
New
TSEA5155435 - Torreblanca, Costa Del Sol, Fuengirola
Beds: 3   Baths: 2   M2: 113   Area: Fuengirola   Region: Andalucía   
HIGHLIGHTS Pine Hill Residences represents a unique opportunity to enjoy life on the Costa del Sol in a modern and exclusive setting. This development combines a strategic location, just minutes from (...)
Apartment Ground Floor
TSEA5155387
New
TSEA5155387 - La Quinta, Costa Del Sol, Benahavis
Beds: 4   Baths: 3   M2: 154   Area: Benahavis   Region: Andalucía   
Beautiful large fully renovated penthouse located in a gated complex in La Quinta, close to the famous Westin Hotel. The property comprises of a spacious living area with open plan kitchen, 4 (...)
Apartment Penthouse
TSEA5155384
New
TSEA5155384 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 88   Area: Estepona   Region: Andalucía   
This first-floor apartment, located in the exclusive Paseo Maritimo area in the center of Estepona, stands out for its side sea views and direct access to the promenade. Fully renovated and ready to (...)
Apartment Middle Floor
TSEA5155378
New
TSEA5155378 - Marbella, Costa Del Sol, Marbella
Beds: 1   Baths: 1   M2: 56   Area: Marbella   Region: Andalucía   
Situated in the very centre of Marbella, just a few steps from the beach, this beautifully refurbished apartment offers the rare combination of luxury, comfort, and unbeatable location. Perfect as a (...)
Apartment Middle Floor
TSEA5155372
New
TSEA5155372 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 3   M2: 72   Area: Estepona   Region: Andalucía   
This beautiful, newly built (2023) apartment is stylishly furnished and ideally located at the edge of Estepona's historic old town. Offering 2 spacious bedrooms and 2 contemporary bathrooms, the (...)
Apartment Middle Floor
TSEA5155330
New
TSEA5155330 - Torre del Mar, Costa Del Sol East
Beds: 3   Baths: 2   M2: 323   Lot Size: 201   Region: Andalucía   
This three-story Mediterranean-style home in Viña Málaga, Torre del Mar, combines charm, comfort, and functionality. It features 3 spacious bedrooms and 3 bathrooms, along with multiple living (...)
Villa Semi Detached
TSEA5155327
New
TSEA5155327 - Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4   Baths: 4   M2: 290   Lot Size: 1,000   Area: Mijas and Mijas Costa   Region: Andalucía   
For sale in one of the most sought after urbanizations of Alhaurin de la Torre with walking access to shops, schools, bus stop. On a fenced plot of 1000 meters the villa consists on the ground floor (...)
Villa Detached
TSEA5155321
New
TSEA5155321 - Almayate, Costa Del Sol East
Beds: 5   Baths: 5   M2: 850   Lot Size: 7,700   Region: Andalucía   
This villa in Almayate stands out for its spaciousness, versatility and excellent possibilities both as a family home and as an investment. The property has a large garden with a private pool and a (...)
Villa Detached
TSEA5155318
New
TSEA5155318 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 3   Baths: 2   M2: 238   Area: Benalmadena   Region: Andalucía   
Penthouse for sale in , Benalmadena with 3 bedrooms, 2 bathrooms, 1 on suite bathroom and with orientation south, with communal swimming pool, private garage (1 parking spaces) and communal garden. (...)
Apartment Penthouse
TSEA5155288
New
TSEA5155288 - La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 81   Area: Mijas and Mijas Costa   Region: Andalucía   
Luxury 2 bed, 2 bath apartment, a short flat walk to La Cala town & beach and many other local amenities. La Cala is booming and this stylish apartment is a great opportunity. In a small, (...)
Apartment Middle Floor
TSEA5155255
New
TSEA5155255 - El Coto, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 3   M2: 230   Area: Mijas and Mijas Costa   Region: Andalucía   
✨ **Villa with double plot in Campo Mijas/El Coto – where your future and lifestyle meet** ✨ Imagine living in a villa with Andalusian charm, in a quiet residential area, surrounded by the (...)
Villa Detached
TSEA5155246
New
TSEA5155246 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 2   Baths: 2   M2: 86   Area: Fuengirola   Region: Andalucía   
Exclusive Townhouse in Pueblo López, the Heart of Fuengirola ✨ Imagine living right in the center of Fuengirola, with everything at your fingertips, yet enjoying the peace and charm of a true (...)
Townhouse Semi Detached
TSEA5155237
New
TSEA5155237 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 159   Area: Estepona   Region: Andalucía   
Stunning 2-Bedroom Apartment with Sea Views in Estepona. This exquisite 2-bedroom, 2-bathroom property perfectly blends elegance, comfort, and location. With a bright, open-plan living and dining (...)
Apartment Middle Floor
TSEA5155180
New
TSEA5155180 - Benahavís, Costa Del Sol, Benahavis
Beds: 3   Baths: 2   M2: 113   Area: Benahavis   Region: Andalucía   
3-bed Townhouse in Benahavís Pueblo – Costa del Sol Set in the picturesque heart of Benahavís Pueblo, one of Andalusia's most sought-after whitewashed villages, this beautifully presented (...)
Townhouse Terraced
TSEA5155171
New
TSEA5155171 - Marbella, Costa Del Sol, Marbella
Beds: 3   Baths: 2   M2: 139   Area: Marbella   Region: Andalucía   
Beautiful duplex for sale in Marbella, Marbella with 3 bedrooms, 3 bathrooms, 1 terrace, 1 garage, 0.00 m2 of living space, 0.00 m2 built, 2nd hand with high-quality finishes, Optional furnished, (...)
 Apartment
TSEA5155156
New
TSEA5155156 - Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 74   Area: Mijas and Mijas Costa   Region: Andalucía   
Investment Opportunity – Las Lagunas de Mijas Discover this excellent property located in the heart of Las Lagunas de Mijas, within a well-connected residential area and just steps away from all (...)
Apartment Ground Floor
TSEA5155150
New
TSEA5155150 - Málaga Este, Costa Del Sol, Nerja and Malaga East
Beds: 3   Baths: 1   M2: 73   Area: Nerja and Malaga East   Region: Andalucía   
8th Floor Apartment, Málaga East el Palo, Costa del Sol. 2.5 Bedrooms, 1 Bathroom, Built 73 m². With turistic licence Setting : Town, Close To Sea. Condition : Excellent, Recently (...)
Apartment Middle Floor
TSEA5155144
New
TSEA5155144 - Torremolinos, Costa Del Sol, Torremolinos
Beds: 2   Baths: 2   M2: 72   Area: Torremolinos   Region: Andalucía   
Beautifully Presented Elevated Duplex in Gated Urbanisation – Torremolinos This elevated ground floor duplex, set within a desirable community combines comfort, style, and an unbeatable (...)
 Apartment
TSEA5155126
New
TSEA5155126 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4   Baths: 4   M2: 201   Lot Size: 30   Area: Marbella West   Region: Andalucía   
Welcome to this newly renovated duplex ground floor apartment in the heart of Nueva Andalucia, Marbella. This property is very unique because of its spacious rooms , terraces , private garden and (...)
Apartment Ground Floor
TSEA5155111
New
TSEA5155111 - Málaga Centro, Costa Del Sol, Malaga
Beds: 2   Baths: 1   M2: 74   Area: Malaga   Region: Andalucía   
Middle Floor Apartment, Málaga Historic Centre Uncibay area, Costa del Sol. 2 Bedrooms, 1 Bathroom, Built 74 m². Video Setting : Town. Condition : Excellent, Recently Renovated. Features : Lift, (...)
Apartment Middle Floor