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 121 - 140 of 7581
Results 121 - 140 of 7581
TSEA5156101
New
TSEA5156101 - Estepona, Costa Del Sol, Estepona
Beds: 1   Baths: 1   M2: 51   Area: Estepona   Region: Andalucía   
Apartment in the urbanization on the first line of the sea - a combination of comfort and a unique location by the sea. The complex is located on the New Golden Mile, in close proximity to the beach (...)
 Apartment
TSEA5156089
New
TSEA5156089 - Estepona, Costa Del Sol, Estepona
Beds: 3   Baths: 1   M2: 96   Area: Estepona   Region: Andalucía   
Charming Ground-Floor Apartment in Estepona's Vibrant Calvario District – Central Location and 10 Minutes from the Beach! Nestled in the heart of Zona Calvario, Estepona, this delightful 96 m² (...)
Apartment Ground Floor
TSEA5156074
New
TSEA5156074 - Cártama, Costa Del Sol, Cartama
Beds: 3   Baths: 2   M2: 200   Lot Size: 48,000   Area: Cartama   Region: Andalucía   
Wonderful finca with almost 50,000 m2 of land, totally fenced, with 5 different entrances, water from its own well plus irrigation water from the canal such us two algibes/ water deposits. T he land (...)
Villa Detached
TSEA5156059
New
TSEA5156059 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 95   Area: Mijas and Mijas Costa   Region: Andalucía   
Location! Location! Location! Nestled in the heart of Mijas Pueblo, this stunning townhouse is a true gem of the village. Completely renovated to the highest standards, this property boasts (...)
Townhouse Semi Detached
TSEA5156053
New
TSEA5156053 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3   Baths: 2   M2: 130   Area: Marbella West   Region: Andalucía   
An exceptional apartment located in the Locrimar area of ​​Marbella. This ground floor apartment features 3 double bedrooms with built-in wardrobes, 2 bathrooms, a separate furnished kitchen, a (...)
Apartment Ground Floor
TSEA5156050
New
TSEA5156050 - Puerto Banús, Costa Del Sol, Marbella West
Beds: 3   Baths: 2   M2: 136   Area: Marbella West   Region: Andalucía   
Beautiful apartment in the heart of one of the most famous ports on the Costa del Sol - Puerto Banus, with spacious terraces offering ponoramnic views to the sea, sandy beaches, port, coast of (...)
Apartment Middle Floor
TSEA5156041
New
TSEA5156041 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 3   Baths: 3   M2: 111   Area: Benalmadena   Region: Andalucía   
Apartment with magnificent views of the sea and the communal swimming pool. The property has 3 bedrooms with fitted wardrobes and 2 full bathrooms, one of which is en suite in the master bedroom, a (...)
Apartment Middle Floor
TSEA5156005
New
TSEA5156005 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 1   Baths: 1   M2: 57   Area: Fuengirola   Region: Andalucía   
One-bedroom, one-bathroom apartment on the beachfront, near the boliches area, with sea views from the bedroom and living room. Terrace with sea views, air conditioning in the living room and (...)
Apartment Middle Floor
TSEA5155993
New
TSEA5155993 - Marbella, Costa Del Sol, Marbella
Beds: 2   Baths: 2   M2: 96   Area: Marbella   Region: Andalucía   
Duplex penthouse with panoramic sea views in Marbella This exclusive penthouse apartment is located in the prestigious area near the Quirón Hospital, just a short walk from the beach. This bright (...)
Apartment Penthouse Duplex
TSEA5155978
New
TSEA5155978 - La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1   Baths: 1   M2: 70   Area: Mijas and Mijas Costa   Region: Andalucía   
Rarely available one bed apartment Totally reformed and spacious one bedroom apartment in this ever poplar development a very short walk to the village. 200 METRES WALK TO THE BEACH One full (...)
Apartment Middle Floor
TSEA5155972
New
TSEA5155972 - Torremolinos, Costa Del Sol, Torremolinos
Beds: 2   Baths: 1   M2: 85   Area: Torremolinos   Region: Andalucía   
Introducing this stunning fully renovated home, just 25 meters from the beach, located in one of the most exclusive areas of the Costa del Sol. Ideal for seaside living or as a high-return tourist (...)
Apartment Middle Floor
TSEA5155966
New
TSEA5155966 - Casares, Costa Del Sol, Casares
Beds: 3   Baths: 2   M2: 85   Area: Casares   Region: Andalucía   
Great opportunity in Hacienda de Casares! Beautiful penthouse with panoramic sea views! With all the amenities you need and just 5 minutes from the beach. The home is in a prime location, surrounded (...)
Apartment Penthouse
TSEA5155954
New
TSEA5155954 - Puerto Banús, Costa Del Sol, Marbella West
Beds: 2   Baths: 2   M2: 90   Area: Marbella West   Region: Andalucía   
???? Attention investors New listing in Puerto Banús, Marbella! Spacious 114 m² apartment with terrace and private parking space, located in one of the most exclusive and peaceful complexes in the (...)
Apartment Ground Floor
TSEA5155951
New
TSEA5155951 - Valle Romano, Costa Del Sol, Estepona
Beds: 6   Baths: 5   M2: 383   Lot Size: 1,005   Area: Estepona   Region: Andalucía   
Located on a private and tranquil street, front line to the Valle Romano golf course in Estepona, Villa 17 is a stunning modern masterpiece that radiates beauty and serenity. With panoramic sea, (...)
Villa Detached
TSEA5155927
New
TSEA5155927 - Bel Air, Costa Del Sol, Estepona
Beds: 3   Baths: 2   M2: 250   Lot Size: 60   Area: Estepona   Region: Andalucía   
HOUSE WITH SQUATTER, ONCE REFORMED AND FREE FROM SQUATTERS IT WILL HAVE A MARKET VALUE OF 800K . Bright semi-detached house in walking distance to Costalita Beach This beautiful, bright and cosy (...)
Villa Semi Detached
TSEA5155915
New
TSEA5155915 - La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2   Baths: 2   M2: 101   Area: Mijas and Mijas Costa   Region: Andalucía   
For sale: ground-floor apartment with two terraces, one at the entrance of the home and another at the front, totaling approximately 30 m2. The apartment has a constructed area of ​​99 m2, of (...)
Apartment Ground Floor
TSEA5155873
New
TSEA5155873 - Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3   Baths: 2   M2: 116   Lot Size: 56   Area: Mijas and Mijas Costa   Region: Andalucía   
New on the market!! Welcome to your dream getaway! Located on the ground floor of the prestigious Casa Banderas complex, this modern 3-bedroom, 2-bathroom apartment offers the perfect blend of (...)
Apartment Ground Floor
TSEA5155780
New
TSEA5155780 - Estepona, Costa Del Sol, Estepona
Beds: 2   Baths: 2   M2: 114   Area: Estepona   Region: Andalucía   
Beautiful renovated 114 m2 apartment with 2 bedrooms and 2 bathrooms in a residential area very close to Estepona beach. The property stands out for its brightness, freshness, and charm, offering a (...)
Apartment Ground Floor
TSEA5155720
New
TSEA5155720 - La Quinta, Costa Del Sol, Benahavis
Beds: 3   Baths: 3   M2: 145   Area: Benahavis   Region: Andalucía   
Experience Scandinavian elegance with panoramic views of the Mediterranean This 144 sqm residence has been exquisitely renovated with an emphasis on clean lines, refined design, and top-tier (...)
Apartment Middle Floor
TSEA5155711
New
TSEA5155711 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2   Baths: 3   M2: 128   Area: Marbella West   Region: Andalucía   
Fantastic Investment Opportunity in Prime Golf Valley Location, Señorio de Aloha. This 2-bedroom duplex penthouse is ideally situated in the heart of Nueva Andalucía's Golf Valley, just a short (...)
Apartment Penthouse Duplex