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 201 - 220 of 7581
TSEA5153524
- El Coto, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Charming townhouse in Mijas, Lagarejo area, in a private community with large communal areas, gardens, and a pool.
The property has 3 bedrooms, 1 full bathroom, and 1 toilet. Perfect for a quiet life (...)
TSEA5153482
- Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 5 Baths: 1 M2: 235 Lot Size: 2,300 Area: Nerja and Malaga East Region: Andalucía
Beds: 5 Baths: 1 M2: 235 Lot Size: 2,300 Area: Nerja and Malaga East Region: Andalucía
UNIQUE OPPORTUNITY: Authentic Mill House in Los Dioses - A Gem Full of Potential
Discover this exceptional property in the picturesque hamlet of Los Dioses, just 1.5 km from the charming village of (...)
TSEA5153473
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 132 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Marbella Region: Andalucía
We are delighted to present this bright and elegant 3-bedroom, 2-bathroom duplex penthouse, which includes 2 parking spaces and a storage room, set within one of the most peaceful and sought-after (...)
TSEA5153470
- Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 86 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Nerja and Malaga East Region: Andalucía
AUTHENTIC SPANISH CORNER HOUSE IN THE HEART OF COMARES
Discover this charming corner house located in the picturesque center of Comares, just 50 meters from the local supermarket and 30 meters from (...)
TSEA5153440
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 203 Lot Size: 256 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 203 Lot Size: 256 Area: Mijas and Mijas Costa Region: Andalucía
Discover the ultimate blend of luxury, comfort, and lifestyle with this stunning, beautifully maintained, and elegantly furnished townhouse, located in the prestigious La Valvega residential (...)
TSEA5153434
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 88 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 88 Area: Benalmadena Region: Andalucía
Discover the comfort and charm of living in the center of Arroyo de la Miel with this completely renovated apartment. Located on the second floor of a building with no elevator, this home offers the (...)
TSEA5153413
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 202 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 202 Area: Benalmadena Region: Andalucía
Luxury duplex penthouse located on the beachfront in the famous Puerto Marina marina. A very quiet area with all amenities, including restaurants and several shops, right on the doorstep.
The (...)
TSEA5153257
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 85 Lot Size: 85 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 85 Area: Benahavis Region: Andalucía
????️♂️ Experience Golf, Sun, and Exclusivity in the Marbella – Benahavís Golf Valley ☀️
In the heart of the prestigious El Paraíso Golf Valley lies this modern 85 m² apartment, (...)
TSEA5153254
- San Roque Club, Costa Del Sol
Beds: 5 Baths: 5 M2: 658 Lot Size: 1,408 Region: Andalucía
Beds: 5 Baths: 5 M2: 658 Lot Size: 1,408 Region: Andalucía
This beautifully renovated villa is located in one of Sotogrande's most prestigious areas, just steps from the world-renowned Valderrama Golf Course. Designed in an elegant Mediterranean style and (...)
TSEA5153251
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 219 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 219 Area: San Pedro Region: Andalucía
This elegant 3-bedroom, 3-bathroom duplex penthouse is located in the prestigious area of Campos de Guadalmina, Guadalmina Alta. From its spacious terraces, you can enjoy panoramic views of the (...)
TSEA5153245
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Welcome to this brand-new, never-lived-in apartment in Mirador de Estepona Hills, one of the most prestigious residential communities in the area of Estepona. Thoughtfully designed for comfort and (...)
TSEA5153197
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
This exceptional apartment is located within the world-renowned Puente Romano Resort, right in the heart of Marbella's Golden Mile – one of the most exclusive addresses in Europe. Designed for (...)
TSEA5153194
- Bel Air, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Located in the prestigious area of Bel Air, Estepona East, this apartment offers a perfect combination of comfort, light, and accessibility. With a south-facing orientation that ensures natural (...)
TSEA5153167
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 140 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Marbella West Region: Andalucía
Discover this beautifully renovated apartment in one of Marbella's most desirable neighborhoods, just steps from Centro Plaza and only minutes from the glamour of Puerto Banús.
Designed with (...)
TSEA5153161
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 278 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 278 Area: Benahavis Region: Andalucía
Casa El Lago is a luxury apartment for sale in the prestigious Real de La Quinta urbanization, a setting that combines contemporary architecture with the natural beauty of southern Spain.
Designed (...)
TSEA5153134
- Canillas de Albaida, Costa Del Sol East
Beds: 3 Baths: 3 M2: 135 Lot Size: 2,500 Region: Andalucía
Beds: 3 Baths: 3 M2: 135 Lot Size: 2,500 Region: Andalucía
This charming country house in Canillas de Albaida, Malaga, offers a harmonious combination of rustic charm and modern comfort. The property, on one floor, is distributed in three bedrooms with (...)
TSEA5153122
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Apartment for sale in Marbella Centro, Marbella with 2 bedrooms and 1 bathroom. Regarding property dimensions, it has 71 m² built and 17 m² terrace. Has the following facilities amenities near, (...)
TSEA5153119
- Aloha, Costa Del Sol, Marbella West
Beds: 6 Baths: 7 M2: 702 Lot Size: 2,349 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 7 M2: 702 Lot Size: 2,349 Area: Marbella West Region: Andalucía
Aloha 40 is a true retreat set in the exclusive Aloha neighborhood at the heart of Marbella's Golf Valley. This impressive residence is located within a secure gated community and enjoys a privileged (...)
TSEA5153068
- Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 5 M2: 429 Lot Size: 1,250 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 5 M2: 429 Lot Size: 1,250 Area: Marbella East Region: Andalucía
Marbella – Exceptional Contemporary Villa, Sold Furnished, in the Exclusive Rio Real Area, Next to the Golf
This stunning villa, fully renovated in 2023 with the finest materials, is south-facing (...)
TSEA5153041
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 100 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Casares Region: Andalucía
We present to you this magnificent apartment located in the exclusive La Sabina development in Casares, a privileged enclave on the Costa del Sol that combines tranquillity, nature, and proximity to (...)
