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 (39,36,37,38)
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`.`featured` IN ('1') AND p.approved = 1 AND pm.cat_id IN (39,36,37,38)
GROUP BY p.id
ORDER BY RAND()
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 (39,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 121 - 140 of 1080 €495,000
TSEA5135899
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 93 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Estepona Region: Andalucía
Exclusive Opportunity in Luna Blanca Golf –
Discover this magnificent ground-floor apartment located in one of the most sought-after areas of the Costa del Sol. Luna Blanca Golf, in (...)
€339,000
TSEA5135836
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 339,000 € to 576,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 75.00 m2 - 117.00 m2]
NEW APARTMENTS WITH GREAT VIEWS FOR SALE IN MIJAS, MÁLAGA, COSTA DEL (...)
€259,000
TSEA5135461
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 100 Lot Size: 65 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Lot Size: 65 Area: Mijas and Mijas Costa Region: Andalucía
Superb south east facing garden apartment in secure Urbanization in Riviera del Sol, just a few minutes driving to the beach, next to the Golf Course, 2 bedrooms, 2 bathrooms, fully fitted kitchen. (...)
€948,000
TSEA5135356
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Discover a modern and luxurious lifestyle in this stunning apartment located in the sought-after area of Atalaya on the Costa del Sol. Situated within a gated community with 24-hour security, this (...)
€560,000
TSEA5135326
- La Carihuela, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Spacious 4-Bedroom Apartment Near the Beach
This bright and spacious 4-bedroom apartment is located on the 1st floor of a quiet residential urbanization, offering both comfort and convenience.
The (...)
€235,000
TSEA5135320
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 1 M2: 52 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: San Pedro Region: Andalucía
No viewings before September 8
Ground floor apartment for sale, recently completely renovated. Located in the central area, very quiet and family-friendly. All kinds of businesses at street level (...)
€337,000
TSEA5135293
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 50 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Area: Marbella Region: Andalucía
Viewings as of 8th of September
Wonderful, fully renovated apartment on the Golden Mile with one bedroom, one laundry and storage room, one bathroom, an open-plan kitchen, and a terrace. It was fully (...)
€275,000
TSEA5135242
- Benamara, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 40 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 40 Area: Estepona Region: Andalucía
Benamara, Estepona – Charming One-Bedroom Apartment
This inviting ground-floor apartment is set within a well-established residential community, surrounded by beautifully maintained, mature (...)
€275,000
TSEA5135161
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Lot Size: 15 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 15 Area: Estepona Region: Andalucía
✨ Spacious Ground-Floor Apartment with Sea & Golf Views – Fully Renovated 3 Years Ago
If you're the kind of person who never settles for average and always seeks the best, this stunning (...)
€480,000
TSEA5135146
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 72 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Area: Estepona Region: Andalucía
New Development: Prices from 480,000 € to 480,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 72.00 m2 - 72.00 m2]
At this development, we have 1, 2 and 3 bedroom homes with large terraces, (...)
€580,000
TSEA5135134
- Teatinos, Costa Del Sol
Beds: 3 Baths: 2 M2: 181 Region: Andalucía
Beds: 3 Baths: 2 M2: 181 Region: Andalucía
We present this spectacular ground-floor apartment located in the most valued and sought-after residential area of Teatinos. A modern, bright, and meticulously designed home, perfect for those (...)
€380,000
TSEA5135122
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Spacious 2 bedroom apartment with spacious terrace in the well sought after gated community Las Adelfas in Finca Dona Maria in Torrequebrada.
The views are mesmerizing: panoramic golf and sea views. (...)
€429,000
TSEA5134747
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Ground Floor 3-Bedroom Apartment in Prime Beachside Location
This three-bedroom apartment is located in the Costalita urbanisation in Estepona East. As you enter the apartment, you'll find the (...)
€265,000
TSEA5134741
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 85 Lot Size: 97 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 85 Lot Size: 97 Area: Fuengirola Region: Andalucía
2-Bedroom Raised Ground Floor Apartment with Sea & Mountain Views
Spacious and bright 2-bedroom apartment on a raised ground floor, offering beautiful views of the Mediterranean Sea and (...)
€330,000
TSEA5134723
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Lovely ground floor apartment located on the main strip of Calahonda, it's an excellent opportunity for an investment, holiday home or family home. This apartment has 2 very good size bedrooms, a (...)
€1,200,000
TSEA5134417
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 144 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Area: Fuengirola Region: Andalucía
NEW ON THE MARKET: Newly completed luxury residence in Reserva del Higuerón – €1,200,000 – ready for immediate viewing!
This stunning resale unit has just been completed and is move-in ready. (...)
€639,000
TSEA5134273
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 102 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 102 Area: Malaga Region: Andalucía
In the very heart of Málaga's historic centre, on the corner of two charming pedestrian streets, lies one of those treasures that makes the hearts of architecture lovers beat faster. This is not a (...)
€530,000
TSEA5133631
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 85 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Marbella West Region: Andalucía
Located in one of the newest blocks of the sought-after Los Naranjos de Marbella complex, this beautifully presented ground-floor apartment offers the perfect blend of modern convenience, abundant (...)
€740,000
TSEA5133550
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 170 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 170 Area: Marbella West Region: Andalucía
This stunning two-bedroom ground floor apartment, located in one of the most prestigious urbanisations in Puerto Banús with 24-hour security, is a true gem. Recently renovated to the highest (...)
€1,895,000
TSEA5133517
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 126 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 126 Area: Estepona Region: Andalucía
Beachfront luxury apartment close to Estepona town!
This ground-floor apartment offers the perfect blend of luxury and tranquility. The apartment has direct access to a private terrace and lush (...)
Current Featured Properties
€318,250
TSEA4930297
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 54 Lot Size: 39 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 54 Lot Size: 39 Area: Mijas and Mijas Costa Region: Andalucía
We welcome you to this new development in Mijas a large multi-family building that offers 76 homes distributed over five floors plus an attic. The residential complex has common areas that include a (...)
€1,350,000
Spacious and contemporary apartments
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 194 Lot Size: 60 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 194 Lot Size: 60 Area: Sotogrande Region: Andalucía
STUNNING NEW HOMES IN VILLAGE COMMUNITY SETTING.
Exclusive Village Community in prestigious Sotogrande area. SPACIOUS AND CONTEMPORARY apartments have been created around an exclusive Village (...)
€480,000
TSEA4646746
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
This is a magnificent development comprising fifty-one 2-, 3- and 4-bedroom homes, which also include penthouses with suntrap terraces and community facilities featuring a kiddies' paddling pool, a (...)
