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 1641 - 1660 of 2510 €375,000
TSEA4979662
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 6 Baths: 6 M2: 602 Area: Nerja and Malaga East Region: Andalucía
Beds: 6 Baths: 6 M2: 602 Area: Nerja and Malaga East Region: Andalucía
600 m² built on two floors + terraces
Ground floor (325 m²) currently being used as a parking spaces with capacity for 9 cars and 10 motorcycles. It includes an old oil mill with well-preserved (...)
€475,000
TSEA4970881
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
New Development: Prices from 475,000 € to 1,019,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 124.00 m2 - 399.00 m2]
Experience the best views of the bay from your terrace
A residential (...)
€450,000
TSEA4978912
- La Campana, Costa Del Sol, Marbella West
Beds: 4 Baths: 2 M2: 178 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 2 M2: 178 Area: Marbella West Region: Andalucía
A spacious 4 bedroom apartment situated in the area of La Campana, with plenty of amenities right on the doorstep and just a 10 minute drive to the beach. The apartment is perfect for permanent (...)
€495,000
TSEA4978870
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 110 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 110 Area: Fuengirola Region: Andalucía
Located right on Fuengirola's seafront promenade, we present this spacious and bright 3-bedroom, 3-bathroom apartment with spectacular panoramic views of the sea and the port. Located on the fourth (...)
€440,000
TSEA4189933
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
New Development: Prices from 440,000 € to 592,800 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 88.00 m2 - 116.00 m2]
This is a residential complex designed to guarantee comfort for you and (...)
€259,000
TSEA4978813
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 100 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 100 Area: Estepona Region: Andalucía
APARTMENT IN BUENAS NOCHES WITH TERRACE AND SEA VIEWS.
Located in the peaceful and sought-after Buenas Noches neighborhood, this fully renovated property is an ideal option for those seeking comfort (...)
€429,900
TSEA4978714
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Living with Breathtaking Sea & Mountain Views
We are thrilled to present this beautifully designed 2-bedroom, 2-bathroom apartment, perfectly positioned in one of the best blocks of the (...)
€490,000
TSEA4977340
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 136 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Benahavis Region: Andalucía
Welcome to this wonderful apartment in the heart of La Quinta, Benahavís! Here, you will live in a peaceful and exclusive area, surrounded by lush nature and close to world-class golf courses.
The (...)
€799,000
TSEA4976992
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 180 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: Estepona Region: Andalucía
Own a Turnkey Investment in Marbella ready to move in.
Looking for a stress-free second home in Marbella that practically runs itself? This spacious, high-yield apartment has been owner-managed for (...)
€215,000
TSEA4976770
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
*** Andalusian Charm with a Modern Twist – Renovated Townhouse in Mijas Golf ***
Let yourself be seduced by the soul of this charming townhouse located in the picturesque Pueblo Mijitas (...)
€789,000
TSEA4976416
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 2 M2: 136 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 2 M2: 136 Area: Nerja and Malaga East Region: Andalucía
Townhouse in Torrecilla with large roof terrace and sea views!
Unique opportunity to aquire one of the properties that rarely comes on the market in the Torrecilla area!
HusmanHagberg proudly (...)
€375,000
TSEA4976143
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 103 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: Casares Region: Andalucía
Bright two double ensuite bedroom apartment in Casares Costa with pleasant views of the gardens and the pool.
The property is located within a popular, well established and well run community within (...)
€1,350,000
TSEA4976128
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 113 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Estepona Region: Andalucía
Exclusive Seafront Apartment on the Costa del Sol – A Mediterranean Paradise!
Discover this stunning 3-bedroom apartment in an exclusive seafront development, offering breathtaking views of the (...)
€620,000
TSEA4975945
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to a stunning corner apartment in the modern Las Banderas complex in La Cala de Mijas!
This bright and modern home offers an open view and features 3 bedrooms, 2 bathrooms, and a terrace (...)
€595,000
TSEA4975873
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 102 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 102 Area: Fuengirola Region: Andalucía
THE APARTMENT IS NOW RENTED FOR LONG TERM. IT CAN BE PURCHASED WITH THE CURRENT LEASE CONTRACT.
Brand new east facing apartment, with 3 bedrooms, 2 bathrooms, spacious living-dining room, open plan (...)
€775,000
TSEA4975858
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 3 M2: 143 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 3 M2: 143 Area: Mijas and Mijas Costa Region: Andalucía
Frontline beach house in Calahonda!
Discover your new beachfront home. This impressive house in the first-line of the beach offers you the perfect combination of luxury and comfort. With a surface (...)
€570,000
TSEA4975855
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
LA PERLA DE LA HEREDIA , BENAHAVIS.
This charming townhouse is located in the cozy village of La Perla de la Heredia, just off Ronda Road. It faces south to southwest, offering lovely views of the (...)
€420,000
TSEA4893604
- Rincón de la Victoria, Costa Del Sol East
Beds: 2 Baths: 2 M2: 77 Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Region: Andalucía
New Development: Prices from 420,000 € to 564,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 77.00 m2 - 98.00 m2]
This is a development of 22 homes of 2 and 3 bedrooms distributed in 2 blocks, (...)
€950,000
TSEA4974649
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 186 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 186 Area: Marbella West Region: Andalucía
This exquisite 3-bedroom, 3-bathroom luxury apartment is located in a small, exclusive complex of only 18 apartments, offering a serene and private living experience. Nestled in the heart of the (...)
€998,000
TSEA4974484
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 194 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 194 Area: Benalmadena Region: Andalucía
"Discover paradise in Puerto Marina, Benalmádena! This impressive 231 m² apartment offers you a unique experience with 180-degree panoramic views of the sea and the port from its spacious (...)
Current Featured Properties
€2,395,000
TSEA5143105
- Estepona, 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
This southwest-facing, fully renovated 3-bedroom, 2-bathroom apartment offers an exceptional blend of style, comfort, and panoramic views over subtropical gardens and the Mediterranean Sea. The (...)
€370,000
TSEA5149801
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€735,000
TSEA4183138
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 133 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 133 Area: Casares Region: Andalucía
NEWLEY UPDATED AND RE RELEASED.
This development located in the prestigious Urbanization of Finca Cortesín, considered the ONE OF THE BEST GOLF RESORTS IN EUROPE and which will have a total of 51 (...)
