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 (40,68,69,70)
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 (40,68,69,70)
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 (40,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1521 - 1540 of 2510
€355,000
TSEA5006287
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Modern 2-bedroom apartment for sale in Cancelada – Ready to move in!
Discover contemporary living in the charming village of Cancelada with this stunning brand-new 2-bedroom, 2-bathroom apartment, (...)
€849,000
TSEA5006125
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 264 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 264 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to this stunning three-story townhouse nestled in a peaceful and sought-after residential area of Mijas Costa. Boasting 4 spacious bedrooms and 3 modern bathrooms, this recently renovated (...)
€375,000
TSEA5006053
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Sea View Apartment for Sale in Estepona Port – Fully Furnished, Prime Location, Excellent Investment
We're proud to present this beautifully located apartment for sale in Estepona, just steps away (...)
€2,250,000
TSEA5005582
- Los Monteros, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 130 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Marbella East Region: Andalucía
This spectacular fully remodeled beachfront apartment is located in a beachfront luxury community. Palm Beach perfectly combines luxury living with prime accessibility. A newly built promenade links (...)
€220,000
TSEA5005558
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 4 Baths: 3 M2: 137 Lot Size: 176 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 3 M2: 137 Lot Size: 176 Area: Algeciras Region: Andalucía
EXCLUSIVE SEMI-DETACHED HOUSE IN A PRIVILEGED DEVELOPMENT – ALCAIDESA
BANK OPPORTUNITY
Opportunity for investors, flat for sale WITHOUT POSSESSION, the property comes from a (...)
€2,450,000
TSEA5005555
- Los Monteros, 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
Palm Beach is a secure, gated community located on Marbella's eastern coast beachfront, just a 5-minute drive from the heart of the city and situated directly along one of the region's most beautiful (...)
€399,000
TSEA5005489
- Monda, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 221 Lot Size: 140 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 221 Lot Size: 140 Area: Marbella Region: Andalucía
Large Urban Townhouse with Studio
. Fabulous views of the village and Castillo de Monda
. So many options. Now 1 Bed but was originally a 3 bedroom property
. Separate studio
. Open plan (...)
€360,000
TSEA5005135
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 102 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Estepona Region: Andalucía
Apartment for Sale in Estepona – Less Than 5 Minutes from the Beach
Discover this wonderful apartment located in one of the best areas of Estepona, just a few steps from the sea. The property (...)
€790,000
TSEA5005087
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 140 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Area: Marbella West Region: Andalucía
Stunning 3-Bedroom Apartment for Sale in Nueva Andalucía – €790,000
This beautiful and spacious apartment, located in the sought-after area of Nueva Andalucía, offers the perfect combination (...)
€360,000
TSEA5004820
- Benajarafe, Costa Del Sol East
Beds: 3 Baths: 2 M2: 104 Region: Andalucía
Beds: 3 Baths: 2 M2: 104 Region: Andalucía
If you're looking for a home by the sea, this villa in Benajarafe is a magnificent option!
Located in a residential area with a pool, just a few minutes' walk from the beach, its promenade, and its (...)
€675,000
TSEA5004523
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 143 Lot Size: 154 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 143 Lot Size: 154 Area: Marbella West Region: Andalucía
Spectacular semi-detached villa for sale in Nueva Andalucia, Marbella!
This modern, spacious, and very bright villa with 4 bedrooms, 2 bathrooms, and 1 toilet is located in a beautiful area, (...)
€1,190,000
TSEA4871788
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 89 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Fuengirola Region: Andalucía
New Development: Prices from 1,190,000 € to 2,200,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 89.00 m2 - 116.00 m2]
The residence design is inspired in Higuerón Hotel, following the same (...)
€399,000
TSEA5004208
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Fantastic 3 bed 2 bath apartment just 150m from the Marina of Estepona. Incredible nice views to the
Harbour, Gibraltar and Northern Africa. Best location in Estepona. In the salesprice included is a (...)
€588,000
TSEA5004163
- Los Flamingos, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 170 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 170 Area: Estepona Region: Andalucía
Fantastic apartment in the prestigious Los Flamingos area of Benahavís.
The home features 2 double bedrooms with built-in wardrobes, 2 full bathrooms, a fully equipped kitchen, a (...)
€450,000
TSEA4675144
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 92 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Malaga Region: Andalucía
New Development: Prices from 450,000 € to 550,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 92.00 m2 - 105.00 m2]
This is a new development consisting of 35 1 and 2 bedroom apartments, (...)
€1,812,500
TSEA4920574
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 162 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 162 Area: Malaga Region: Andalucía
New Development: Prices from 1,812,500 € to 2,012,500 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 162.00 m2 - 162.00 m2]
In the heart of the historic centre of Malaga, we offer you a unique (...)
€1,991,000
TSEA5003710
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 359 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 359 Area: Marbella Region: Andalucía
NEWLY REFURBISHED
This beautifully presented contemporary townhouse has been recently renovated with high-quality materials offering luxury finishes and incredible use of space. This south-facing (...)
€520,000
TSEA5003557
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 120 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Benahavis Region: Andalucía
Fantastic Apartment with Panoramic Views in Los Arqueros Golf, Benahavís
Welcome to this bright and spacious apartment, ideally located in the exclusive area of Los Arqueros Golf in Benahavís. (...)
€749,000
TSEA5003443
- Malagueta, Costa Del Sol
Beds: 5 Baths: 2 M2: 165 Region: Andalucía
Beds: 5 Baths: 2 M2: 165 Region: Andalucía
???? Spacious Apartment on Paseo de Reding with Great Potential!
???? Location: Paseo de Reding, just a few minutes' walk from the beach and the seafront promenade.
???? Bedrooms: 5
???? Bathrooms: (...)
€699,000
TSEA5003200
- Nagüeles, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 226 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 226 Area: Marbella Region: Andalucía
Townhouse Ideal for Airbnb - High Demand Profitability in Marbella. Semi-detached villa located in the exclusive area of Marbella's golden mile Nagüeles. The property is distributed over four (...)
Current Featured Properties
€520,000
TSEA5106760
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Discover, an incredible new development in one of Estepona's most exclusive areas. This private residential complex features apartments, including flats, penthouses, and ground-floor units with 2, 3, (...)
€965,000
TSEA4955521
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 167 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 167 Area: Casares Region: Andalucía
A private beach right on your doorstep. Turquoise waters in a tropical setting. An exclusive Mediterranean-style residential complex. Homes with large terraces and high-quality finishes. 38 (...)
€3,650,000
TSEA4450162
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 364 Lot Size: 106 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 364 Lot Size: 106 Area: Estepona Region: Andalucía
Discover coastal living in this exquisite townhome, ideally situated with views of the serene ocean waves . Boasting breathtaking views of both sunrises and sunsets, this home is a true masterpiece (...)
