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 1541 - 1560 of 2510
€650,000
TSEA5003194
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 160 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Estepona Region: Andalucía
**Stunning 3-Bedroom Apartment in Oceana Gardens**
Discover this elegant 3-bedroom, 2-bathroom apartment in the sought-after **Oceana Gardens** community. Offering breathtaking **sea and mountain (...)
€825,000
TSEA4423774
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 279 Lot Size: 43 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 279 Lot Size: 43 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 825,000 € to 882,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 279.00 m2 - 280.00 m2]
CONSTRUCTION HAS STARTED! ¡70% OF UNITS SOLD! LAST 5 VILLAS WITH (...)
€635,000
TSEA5003053
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 140 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Estepona Region: Andalucía
Located in a quiet residential area of Bel-Air, in the coveted New Golden Mile, this charming townhouse is perfect for those looking for spaciousness, comfort and a life close to the sea. It is (...)
€1,050,000
TSEA5002924
- Málaga Centro, Costa Del Sol, Malaga
Beds: 4 Baths: 4 M2: 143 Area: Malaga Region: Andalucía
Beds: 4 Baths: 4 M2: 143 Area: Malaga Region: Andalucía
Exclusive Beachfront Home with Unrivalled Sea Views in El Palo, Málaga
We present this exceptional beachfront property located in El Palo, one of Málaga's most iconic and sought-after coastal (...)
€2,599,500
TSEA5002918
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 255 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 255 Area: Estepona Region: Andalucía
Completely renovated townhouse frontline beach on the new Golden Mile
This property has been completely renovated from scratch with very high qualities. This Townhouse offers 4 bedrooms and 4 (...)
€435,000
TSEA5002870
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 95 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Benahavis Region: Andalucía
Set within a gated development within Los Arqueros Golf Resort, this beautifully presented apartment offers stunning open views over the lush Andalusian hills.
This property offers that instant (...)
€850,000
TSEA5002369
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 204 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 204 Area: Sotogrande Region: Andalucía
Discover this luxury 3-bedroom townhouse in Los Carmenes de Almenara, Sotogrande Alto, offering a rare opportunity to enjoy golf-frontline living in one of Sotogrande's most prestigious gated (...)
€565,000
TSEA5002312
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 141 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 141 Area: Marbella East Region: Andalucía
Luxury Living in Elviria: A Stunning Apartment in Las Terrazas de Santa Maria Golf, Marbella East
Imagine waking up to the gentle sounds of birdsong and the lush green views of the Santa Maria Golf (...)
€775,000
TSEA5002309
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 122 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: La Duquesa Region: Andalucía
Middle Floor Apartment, La Duquesa, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 122 m², Terrace 32 m².
Setting : Beachfront, Beachside, Close To Golf, Close To Port, Close To Sea, Close To (...)
€649,900
TSEA5002249
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 240 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 240 Area: Estepona Region: Andalucía
In the exclusive Señorío de Cortes urbanization, you will find this magnificent townhouse, which offers spacious living and breathtaking panoramic views.
The property features five bedrooms and (...)
€232,500
TSEA5002222
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 65 m².
Setting : Town, Close To Sea.
Condition : Excellent.
Features : Lift, Fitted Wardrobes, Near Transport, Double (...)
€700,000
TSEA5002129
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 287 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 287 Area: Mijas and Mijas Costa Region: Andalucía
Charming Three-Bedroom Townhouse in Riviera del Sol
Discover this delightful three-bedroom townhouse in a sought-after gated community in Riviera del Sol, Mijas Costa. Perfectly positioned within (...)
€749,000
TSEA5002117
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 115 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Fuengirola Region: Andalucía
EXPERIENCE THE BEST OF COASTAL LIVING IN FUENGIROLA
Located on the stunning Costa del Sol, Fuengirola is a vibrant coastal town that offers an unbeatable blend of Mediterranean lifestyle, rich (...)
€820,000
TSEA5002081
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 200 Lot Size: 76 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Lot Size: 76 Area: Benahavis Region: Andalucía
Recently refurbished townhouse in an established residential area. It is located very close to the borders of Estepona and Marbella, within the municipality of Benahavís. The house consists of two (...)
€795,000
TSEA5001784
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 96 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 96 Area: Marbella West Region: Andalucía
Situated in the esteemed Andalucia del Mar development in Puerto Banus, Marbella, this beautifully renovated apartment offers the ultimate in luxury living on the Costa del Sol. Known for its glamour (...)
€375,000
TSEA5001718
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Mijas and Mijas Costa Region: Andalucía
This apartment is located in a new development in the area of Las Lagunas, Mijas Costa, Malaga, this brand-new apartment offers an exceptional living experience. Designed with modernity and comfort (...)
€165,000
TSEA5001709
- Palmones, Costa de la Luz
Beds: 3 Baths: 2 M2: 58 Region: Andalucía
Beds: 3 Baths: 2 M2: 58 Region: Andalucía
3 bedroom townhouse for sale near Los Barrios, Algeciras. Located in a charming gated community in Los Cortijillos, this inviting townhouse offers the perfect balance of comfort and convenience. Set (...)
€677,500
TSEA5001631
- Málaga Centro, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 100 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Malaga Region: Andalucía
Middle Floor Apartment, Málaga Historic Centre calle Larios area, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 100 m².
Initially 3 bedrooms now 2 bedrooms 2 kitchens possibility of 2 independent (...)
€675,000
TSEA5001583
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
A modern luxury property in Casa Banderas located within a 15 minute walk of the beach, local amenities and public transport of La Cala de Mijas. Large bright lounge diner with fully fitted kitchen, (...)
€315,000
TSEA5001475
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Spacious and bright apartment with two bedrooms and two bathrooms – the perfect choice for comfortable living or vacation! A unique feature is the enclosed terrace, offering a stunning panoramic (...)
Current Featured Properties
€370,500
TSEA4868902
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
YOU COULD NOT ASK FOR A BETTER LOCATION!!
Exclusive multi-family homes of 2 and 3 bedrooms located in the privileged surroundings of the Golden Mile of Estepona. The homes enjoy large terraces (...)
€382,000
TSEA4753921
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
New homes in Mijas!
This development is a modern residential of 75 new homes in Mijas, designed to enjoy a warm and balanced lifestyle. A project surrounded by nature, with incredible sea and (...)
€4,385,000
Luxury Beach-Side Apartments with Panoramic Views, Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 203 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 203 Area: Estepona Region: Andalucía
UNIQUE BOUTIQUE DEVELOPMENT BEACHSIDE ESTEPONA. A special opportunity to own one of 9 apartments in a new beachside development close to the marina of Estepona. This PREMIUM LUXURY apartment is (...)
