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
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
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
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1361 - 1380 of 7575 €942,000
TSEA5121433
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 131 Lot Size: 40 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 131 Lot Size: 40 Area: Marbella West Region: Andalucía
This spectacular semi-detached house is located in one of the most sought-after areas of Nueva Andalucia. It has 4 en-suite bedrooms, a spacious living room, a fully equipped kitchen, and a storage (...)
€695,000
TSEA5121427
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 124 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Benahavis Region: Andalucía
Stunning Penthouse with Lake & Frontline Golf Views in Gated La Quinta Community – 3 Bed, 2 Bath
Discover living in this exceptional 3-bedroom, 2-bathroom penthouse ideally situated in one of (...)
€239,000
TSEA5121424
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 1 M2: 75 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 1 M2: 75 Area: San Pedro Region: Andalucía
Middle Floor Apartment, San Pedro de Alcántara, Costa del Sol.
3 Bedrooms, 1 Bathroom, Built 75 m², Terrace 5 m².
Setting : Town, Suburban, Commercial Area, Close To Shops, Close To Town, Close (...)
€265,500
TSEA5121364
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Magnificent apartment in the heart of Estepona, with three bedrooms, two bathrooms, a fully equipped kitchen, and a living room.
The modern and well-maintained furnishings make it easy to move in (...)
€380,000
TSEA5121196
- Periana, Costa Del Sol East
Beds: 3 Baths: 2 M2: 128 Lot Size: 1,574 Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Lot Size: 1,574 Region: Andalucía
Discover your own Andalusian paradise in this magnificent estate, a haven of peace and comfort designed to enjoy life to the fullest. Set on a generous 1,574 m² plot, surrounded by olive trees and (...)
€269,000
TSEA5121100
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 3 M2: 110 Lot Size: 158 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 3 M2: 110 Lot Size: 158 Area: La Duquesa Region: Andalucía
Located in the prestigious and secure urbanization of La Duquesa Village, this unique apartment, fully refurbished in June 2024, offers an exceptional living environment with one of the most stunning (...)
€3,450,000
TSEA5121085
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 290 Lot Size: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 290 Lot Size: 120 Area: Estepona Region: Andalucía
Situated on the frontline of the New Golden Mile, between Puerto Banús and Estepona, this exceptional townhouse offers a unique blend of coastal luxury, privacy, and resort-style amenities. Located (...)
€334,000
TSEA5121022
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Discover this exceptional property in El Faro, Mijas. It is situated within a residential complex, offering convenient access to essential services and amenities. The property is just a few minutes' (...)
€469,000
TSEA5120977
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 112 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Area: Benahavis Region: Andalucía
OPPORTUNITY IN CAPANES DEL GOLF
Interesting opportunity in one of the best developments on the Costa del Sol, located in the Golden Triangle on the front line of the golf course, surrounded by (...)
€487,500
TSEA5120956
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Brand New South-Facing Apartment with Stunning Sea & Golf Views – Estepona
€472,500 | 2 Bedrooms | 2 Bathrooms | Key Ready | Partly Furnished
This exceptional new-build apartment, just (...)
€930,000
TSEA5120941
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 139 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Area: Fuengirola Region: Andalucía
Contemporary 3-Bedroom villa just steps from the Beach in Fuengirola, Costa del Sol
We present this exclusive modern-design villa featuring 3 bedrooms and 2 bathrooms, set on a 439 m² plot with (...)
€549,000
TSEA5120836
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 123 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Marbella East Region: Andalucía
This exceptional property is located just a 9 minutes walk to the best beaches in East Marbella and the famous Cabopino Port. Video Available! The larger than average apartment has been tastefully (...)
€499,000
TSEA5120779
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 120 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Benalmadena Region: Andalucía
Magnificent ground floor property featuring a large terrace. The apartment has been recently renovated and is located in the exclusive Santángelo area of Benalmádena.
This 160 m² south-facing (...)
€885,000
TSEA5120770
- Campo Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 377 Lot Size: 1,220 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 377 Lot Size: 1,220 Area: Mijas and Mijas Costa Region: Andalucía
DETACHED VILLA WITH PANORAMIC SEA VIEWS IN CAMPO MIJAS – PRIVATE, SPACIOUS AND FULL OF POTENTIAL
Located in the peaceful and sought-after area of Campo mijas, this independent villa offers total (...)
€239,000
TSEA5120764
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 58 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 58 Area: Nerja and Malaga East Region: Andalucía
Totally renovated for sale in the Historic Center of Vélez-Málaga
This beautiful house is located in the picturesque old town of Vélez-Málaga, just a few steps from the main cathedral and the (...)
€575,000
TSEA5120755
- La Atalaya, Costa Del Sol, Antequera
Beds: 4 Baths: 2 M2: 196 Lot Size: 2,605 Area: Antequera Region: Andalucía
Beds: 4 Baths: 2 M2: 196 Lot Size: 2,605 Area: Antequera Region: Andalucía
Spacious Finca with Equestrian Potential in La Atalaya
Discover this charming detached villa, a unique resale opportunity located in the tranquil countryside of La Atalaya. This property, boasting a (...)
€1,230,000
TSEA5120707
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 156 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 156 Area: Benahavis Region: Andalucía
Penthouse in Flamingos Resort with the Best View
Thanks to Its Highest Position in the Complex and Unobstructed Front View!
Upon entering this luxurious penthouse, you are immediately welcomed by (...)
€2,195,000
TSEA5120677
- Las Chapas, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 360 Lot Size: 700 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 360 Lot Size: 700 Area: Marbella East Region: Andalucía
Exclusive Villa in Las Chapas, Marbella – Just Steps from the Beach with All Amenities Within Reach.
Discover this charming villa, strategically located in the prestigious area of Las Chapas, (...)
€2,250,000
TSEA5120662
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 264 Lot Size: 1,112 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 264 Lot Size: 1,112 Area: Estepona Region: Andalucía
New Development: Prices from 2,250,000 € to 2,250,000 €. [Beds: 4 - 4] [Baths: 3 - 3] [Built size: 264.00 m2 - 264.00 m2]
This modern-style villa stands out for its seamless connection between (...)
€1,595,000
TSEA5120656
- Playamar, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Luxury penthouse on the beachfront in Playamar, Torremolinos – Exclusive living by the sea
Are you looking for a unique home to enjoy true beachfront luxury?
This spectacular penthouse in Habitat (...)
Current Featured Properties
€575,000
TSEA4887661
- 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
This fantastic new development of stunning contemporary apartments and penthouses with sea views is located just a stone's throw from La Cala de Mijas. The popularity of this beautiful coastal town (...)
€860,000
TSEA4749715
- La Quinta, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 101 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Benahavis Region: Andalucía
AMAZING VIEWS FROM THE SOLARIUM! This 2-bed, 2-bath penthouse apartment sits in a BRAND NEW, EXCLUSIVE LUXURY DEVELOPMENT in a prestigious mountainside estate of low level apartments with manicured, (...)
€1,990,000
TSEA4979719
- Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 504 Lot Size: 903 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 504 Lot Size: 903 Area: Marbella East Region: Andalucía
Villa Fantastica is a luxurious property located in the breathtaking surroundings of Marbella. The villa boasts 4 bedrooms, 4 bathrooms, and a built area of 504 square meters. Its exceptional German (...)
