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 (41,42,43,44,45)
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 (41,42,43,44,45)
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 (41,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 701 - 720 of 3420 €6,000,000
TSEA5103706
- Ardales, Costa Del Sol, Alhaurin el Grande
Beds: 5 Baths: 5 M2: 630 Lot Size: 270,000 Area: Alhaurin el Grande Region: Andalucía
Beds: 5 Baths: 5 M2: 630 Lot Size: 270,000 Area: Alhaurin el Grande Region: Andalucía
Set on a vast 270,000 m² estate near Ardales and the popular Caminito del Rey, this stunning cortijo blends recent renovations with preserved traditional features—thick stone walls, wooden (...)
€3,000,000
TSEA5103631
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 433 Lot Size: 1,097 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 433 Lot Size: 1,097 Area: Estepona Region: Andalucía
Villa Three, located in the distinguished La Resina Golf community within Estepona's flourishing residential zone, is an architectural statement combining contemporary sophistication and practical (...)
€3,500,000
TSEA5103574
- Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 310 Lot Size: 1,804 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 310 Lot Size: 1,804 Area: Marbella East Region: Andalucía
New Development: Prices from 3,500,000 € to 3,500,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 310.00 m2 - 310.00 m2]
New Project Rio Real unbeatable views.
Where Modern Elegance Meets (...)
€2,850,000
TSEA5103538
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 5 M2: 750 Lot Size: 1,000 Area: Marbella Region: Andalucía
Beds: 6 Baths: 5 M2: 750 Lot Size: 1,000 Area: Marbella Region: Andalucía
Recently Refurbished Villa from Scratch with Heated Pool and Sea Views in Ultra Central Marbella Location.
Discover this magnificent villa, completely refurbished recently, offering a brand new (...)
€1,275,000
TSEA5103532
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 3 M2: 141 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 3 M2: 141 Area: Fuengirola Region: Andalucía
Breathtaking Penthouse in the Heart of Los Boliches Promenade – Where Every Day Feels Like a Holiday
Welcome to a truly exceptional penthouse, perched in an unbeatable location along the vibrant (...)
€519,900
TSEA5103526
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 112 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse for Sale in La Cala Hills, Mijas – Sun, Space, and Comfort All Year Round!
Discover this spectacular penthouse located in one of the most exclusive areas of Mijas: La Cala Hills. A (...)
€699,000
TSEA5103139
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 3 M2: 237 Lot Size: 593 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 3 M2: 237 Lot Size: 593 Area: La Duquesa Region: Andalucía
Striking Modern Villa in Gated Community | La Duquesa
Set within the only gated villa community in La Duquesa, this stunning contemporary home offers privacy, comfort, and unbeatable convenience. (...)
€1,200,000
TSEA5101036
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 5 M2: 540 Lot Size: 963 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 5 M2: 540 Lot Size: 963 Area: La Duquesa Region: Andalucía
Truly stunning four bedroom villa with simply stunning panoramic views over a large private garden to the sea towards Gibraltar and North Africa. This spacious villa benefits from a large private (...)
€650,000
TSEA5100988
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 181 Lot Size: 1,255 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 181 Lot Size: 1,255 Area: Mijas and Mijas Costa Region: Andalucía
Located in the sought-after area of Los Pinos, this beautiful traditional Andalusian home stands out for its unique charm, excellent location, and authentic character.
The property features 3 (...)
€259,000
TSEA5085610
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 111 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: Manilva Region: Andalucía
Excellent Investment Opportunity: whether you're looking for a main residence, a holiday home, or a buy-to-let investment, this stunning penthouse is sure to meet all your expectations. Located (...)
€1,345,000
TSEA5085568
- Torremuelle, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 340 Lot Size: 599 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 340 Lot Size: 599 Area: Mijas and Mijas Costa Region: Andalucía
Newly Renovated Villa with Sea Views & Guest Apartment in Torremuelle, Benalmádena
Set in the quiet and well-connected area of Torremuelle, this newly renovated villa combines stunning views (...)
€579,000
TSEA5084644
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 115 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Mijas and Mijas Costa Region: Andalucía
We offer this wonderful penthouse for sale in the coastal town of Mijas, province of Málaga. Located in a gated community with a communal pool and well-maintained landscaped areas, this apartment (...)
€349,000
TSEA5084263
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 145 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 145 Area: Marbella East Region: Andalucía
Penthouse with Breathtaking Views in the Heart of Nature – El Soto de La Mairena
Nestled in one of the most serene and green corners of the Costa del Sol, this exquisite penthouse in El Soto de La (...)
€1,650,000
TSEA5084113
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 6 M2: 441 Lot Size: 1,200 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 6 M2: 441 Lot Size: 1,200 Area: Mijas and Mijas Costa Region: Andalucía
This stylish modern villa is located frontline to the golf course in the sought-after La Cala Golf Resort. With clean lines, large windows, and a sleek design, the property offers bright and open (...)
€114,000
TSEA5084086
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 32 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 32 Area: Mijas and Mijas Costa Region: Andalucía
SQUATTED PROPERTY. OPPORTUNITY FOR INVESTORS.
The price of the property has been set considering that the property is being acquired by the buyer as occupied. Therefore, this price would not apply if (...)
€879,000
TSEA5084014
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 418 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 418 Area: Mijas and Mijas Costa Region: Andalucía
CHARMING DETACHED VILLA WITH PRIVATE POOL AND EXCELLENT LOCATION
Discover this bright and welcoming detached villa, located in a quiet area yet perfectly connected, with quick access to the A-7 and (...)
€1,495,000
TSEA5083999
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 413 Lot Size: 900 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 413 Lot Size: 900 Area: Mijas and Mijas Costa Region: Andalucía
Located in Las Farolas in Mijas Costa, you are no further than 2km from La Cala de Mijas and 4.5km from Fuengirola making it ideal for schools, shops and amenities. Built on a corner, elevated plot (...)
€625,000
TSEA5083954
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 123 Lot Size: 712 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 123 Lot Size: 712 Area: Fuengirola Region: Andalucía
Welcome to a charming and well-maintained single-level villa in peaceful Torreblanca, offering sea views, a lush garden, and sunlight from late morning to sunset. Enjoy the perfect balance of town (...)
€1,375,000
TSEA5083873
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 220 Lot Size: 1,630 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Lot Size: 1,630 Area: Estepona Region: Andalucía
Villa is a 3-bedroom villa located at Calle Magnolia, in the desirable El Paraiso area of Estepona. This cozy villa is a blank canvas, perfect for renovation or expansion. With ample space to create (...)
€875,000
TSEA5083846
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 200 Lot Size: 1,740 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Lot Size: 1,740 Area: Mijas and Mijas Costa Region: Andalucía
Discover the Villa of your dreams in Mijas Pueblo! This magnificent property offers a unique experience in a quiet and private area, ideal for those seeking serenity and exclusivity. With panoramic (...)
Current Featured Properties
€1,860,000
TSEA4238983
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 558 Lot Size: 368 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 558 Lot Size: 368 Area: Mijas and Mijas Costa Region: Andalucía
BEAUTIFUL HIGH END LUXURY VILLAS!!!
A collection of luxury villas in a gated complex with one of the best amenities on the Costa del Sol.This is the cornerstone of an exclusive gated villa complex (...)
€7,500,000
TSEA4797559
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 693 Lot Size: 340 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 693 Lot Size: 340 Area: Marbella East Region: Andalucía
YOU REALLY WILL WANT TO SEE THIS DEVELOPMENT!!!
The most exceptional new development, is currently underway on Marbella's fabled Golden Mile. With the most exclusive location, sublime design and just (...)
€670,000
TSEA4982797
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 127 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 127 Area: Estepona Region: Andalucía
Apartments and penthouse apartments with 2, 3 and 4 bedrooms in Selwo, Estepona this is a place where the sea and nature become one, with stunning Mediterranean sea views.
Located in an exceptional (...)
