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 (163,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 (163,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 (163,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1 - 20 of 2924
€739,000
TSEA5159641
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 470 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 470 Area: Mijas and Mijas Costa Region: Andalucía
This exceptional triplex penthouse with 470 m² of floor space and 270 m² of usable space plus terraces, garages and storage rooms redefines the concept of living on the Costa del Sol. Located in a (...)
€419,000
TSEA5159587
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Semi-detached house with no community fees in Las Lagunas (Mijas Costa)
Cozy and bright semi-detached home located in one of the most sought-after areas of Las Lagunas, close to all amenities and (...)
€735,000
TSEA5159485
- Istán, Costa Del Sol, Istan
Beds: 2 Baths: 2 M2: 203 Area: Istan Region: Andalucía
Beds: 2 Baths: 2 M2: 203 Area: Istan Region: Andalucía
Lake and Sea View Villa for Sale in Sierra Blanca Country Club, Istan – Investment Opportunity Near Marbella
Set within the prestigious gated community of Sierra Blanca Country Club in Istan, this (...)
€7,800,000
TSEA5159374
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 5 Baths: 8 M2: 734 Lot Size: 1,000 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 8 M2: 734 Lot Size: 1,000 Area: Marbella East Region: Andalucía
This fully renovated Andalusian-style villa is set in Rocío de Nagüeles, one of the most prestigious enclaves of Marbella's Golden Mile. Positioned on a 1,965m² south-facing plot beneath the (...)
€395,000
TSEA5159308
- Cártama, Costa Del Sol, Cartama
Beds: 2 Baths: 2 M2: 155 Lot Size: 2,500 Area: Cartama Region: Andalucía
Beds: 2 Baths: 2 M2: 155 Lot Size: 2,500 Area: Cartama Region: Andalucía
Charming 2/3 Bedroom Country Finca, Orchard, Stunning Gardens, A1 Condition
A wonderful opportunity to purchase a deceptively spacious, detached country finca with stunning panoramic views, located (...)
€510,000
TSEA5159173
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic opportunity to buy a Duplex penthouse in front line golf with open panoramic views
Ample 3 bedrooms and 3 bathrooms, with highest quality finishes and outstanding views to the three golf (...)
€640,000
TSEA5158999
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 2 M2: 177 Lot Size: 222 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 2 M2: 177 Lot Size: 222 Area: San Pedro Region: Andalucía
We invite you to visit this two-level, south-west facing property in the heart of San Pedro, conveniently located close to a wide range of services and infrastructure, nestled in a tranquil (...)
€749,000
TSEA5158900
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 5 Baths: 3 M2: 315 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 3 M2: 315 Area: Benalmadena Region: Andalucía
Beautiful Semi-Detached Villa in Excellent Condition – 325 m² Built
This stunning villa offers space, comfort, and an unbeatable location:
• Ground floor: large, well-kept garden with fruit (...)
€365,000
TSEA5158834
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 85 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Casares Region: Andalucía
We are pleased to present this magnificent duplex penthouse located in the exclusive Doña Julia area of Casares, a privileged setting that combines peace, elegance, and proximity to the sea. A (...)
€849,000
TSEA5158765
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 137 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 137 Area: Marbella West Region: Andalucía
Exclusive Duplex Penthouse in El Dorado – Nueva Andalucía
Discover this unique and fully renovated duplex penthouse in the sought-after El Dorado, a charming complex within walking distance to (...)
€375,000
TSEA5158255
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 1 M2: 120 Lot Size: 3,958 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 1 M2: 120 Lot Size: 3,958 Area: Alhaurin el Grande Region: Andalucía
Detached Villa with Pool and Large Plot – Fully Renovated
Discover this charming detached property, perfect for those seeking peace, privacy, and comfort. The house has been completely renovated, (...)
€719,000
TSEA5158141
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 228 Lot Size: 259 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 228 Lot Size: 259 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic semi-detached villa with private pool and two separate homes for sale on a single plot in the exclusive Capellanía residential area, Alhaurín de la Torre.
This spectacular semi-detached (...)
€399,000
TSEA5158069
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
Modern & Spacious 2-Bedroom Bungalow in Atalaya Aparta Golf Complex
Set within the prestigious Atalaya Golf Course, this modern and beautifully designed 2-bedroom bungalow combines comfort, (...)
€3,550,000
TSEA5157937
- Aloha, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 435 Lot Size: 1,038 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 435 Lot Size: 1,038 Area: Marbella West Region: Andalucía
Welcome to this exceptional modern villa located in the heart of Nueva Andalucía, offering a seamless blend of style, luxury and comfort.
Set on a generous plot of 1,038m², this beautifully (...)
€3,150,000
TSEA5157496
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 410 Lot Size: 728 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 410 Lot Size: 728 Area: Marbella West Region: Andalucía
Nestled in a quiet residential area of Nueva Andalucía and yet close to all local amenities we find this house for sale. The property has gone through an extensive refurbishment and updating (...)
€398,000
TSEA5157385
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M2: 262 Area: Coin Region: Andalucía
Beds: 4 Baths: 2 M2: 262 Area: Coin Region: Andalucía
The first time I stepped into this house, I knew it wasn't just any home.
There are places you simply visit, and others that make you pause and imagine. This was one of those.
I pictured myself (...)
€5,395,000
TSEA5157145
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 270 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 270 Area: Marbella East Region: Andalucía
Situated in the exclusive Puente Romano resort, this renovated south-facing corner penthouse offers a living experience that perfectly balances convenience with comfort. With stunning views from its (...)
€1,100,000
TSEA5157100
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 311 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 311 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,100,000 € to 1,100,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 311.00 m2 - 311.00 m2]
Luxurious and modern high tech villa with 3 bedrooms, 3 ensuite (...)
€1,380,000
TSEA5157088
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 155 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 155 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,380,000 € to 1,380,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 155.00 m2 - 155.00 m2]
Luxurious and modern high tech villa with 4 bedrooms, 4 bathrooms, (...)
€1,450,000
TSEA5157073
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 4 M2: 475 Lot Size: 979 Area: Marbella Region: Andalucía
Beds: 5 Baths: 4 M2: 475 Lot Size: 979 Area: Marbella Region: Andalucía
Spacious independent villa with a lot of character in exclusive residential area of Marbella.
This magnificent villa is built on a plot of nearly 1000 sqm and has a total built surface of 475 sqm.
It (...)
Current Featured Properties
€730,000
TSEA4890979
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 182 Lot Size: 605 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 182 Lot Size: 605 Area: Manilva Region: Andalucía
DETACHED VILLA WITH POOL 500m FROM THE BEACH!!!
If there is better value than this on Costa del Sol, we'd like to know about it! In a STYLISH, CONTEMPORARY DESIGN (very sought after!), this villa (...)
€885,000
TSEA5013214
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 142 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 142 Area: Fuengirola Region: Andalucía
Welcome to the residence, an exclusive retreat on the truly incomparable Costa del Sol. This groundbreaking project of villas with staggered construction on six levels not only symbolises (...)
€2,750,000
TSEA4446295
- Manilva, Costa Del Sol, Manilva
Beds: 5 Baths: 7 M2: 480 Lot Size: 1,400 Area: Manilva Region: Andalucía
Beds: 5 Baths: 7 M2: 480 Lot Size: 1,400 Area: Manilva Region: Andalucía
SEIZE THE OPPORTUNITY: SPECTACULAR HOME WITH MODERN AMENITIES AWAITS!!
With 5 bedrooms and 7 bathrooms, it is perfect for a large family or for those who love to entertain guests. The property (...)
