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 (43,36,37,38)
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 (43,36,37,38)
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 (43,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 21 - 40 of 306
€650,000
TSEA5147359
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 134 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 134 Area: Mijas and Mijas Costa Region: Andalucía
This stunning, newly completed modern contemporary 3 bedroom semi-detached villa in urbanisation Alya offers stylish contemporary living in a sought-after residential area. Built to the highest (...)
€429,000
TSEA5144131
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 2 M2: 138 Lot Size: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 2 M2: 138 Lot Size: 80 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular 3-storey semi-detached villa for sale very close to La Cala de Mijas! This modern, spacious and very bright 4-bedroom, 3-bathroom villa is built to the highest standards. It has air (...)
€5,995,000
TSEA5143663
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 314 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 314 Area: Marbella East Region: Andalucía
BEACHFRONT ELEGANCE ON THE GOLDEN MILE!
Discover this exceptional semi-detached home in the exclusive Oasis Club, one of the most desirable beachfront communities on Marbella's Golden Mile. Recently (...)
€190,000
TSEA5143645
- Jimena de la Frontera, Costa de la Luz
Beds: 4 Baths: 2 M2: 176 Region: Andalucía
Beds: 4 Baths: 2 M2: 176 Region: Andalucía
Semi-Detached House, Jimena de la Frontera, Costa de la Luz.
4 Bedrooms, 2 Bathrooms, Built 176 m², Terrace 16 m².
Setting : Village, Mountain Pueblo, Close To Schools, Close To Skiing, Close To (...)
€980,000
TSEA5143186
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 296 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 296 Area: Benalmadena Region: Andalucía
Exclusive House with Sea Views in Torremuelle, Benalmádena
Discover this spectacular 477 m² (terraces included) house, located in one of the most privileged and peaceful areas of Benalmádena, (...)
€225,000
TSEA5143039
- Almogía, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 145 Lot Size: 4,100 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 145 Lot Size: 4,100 Area: Malaga Region: Andalucía
Tucked away in the countryside just outside Almogía, this charming end-of-terrace home (one of only three in the row) is made for quiet, rural living. The ground floor centres on a good-sized (...)
€475,500
TSEA5141713
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 151 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 151 Area: Mijas and Mijas Costa Region: Andalucía
Semi-Detached House, Riviera del Sol, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 151 m².
Setting : Close To Golf.
Orientation : South West.
Condition : Good.
Pool : Communal.
Climate Control : (...)
€208,000
TSEA5141512
- San Enrique, Costa Del Sol, Sotogrande
Beds: 4 Baths: 2 M2: 104 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 2 M2: 104 Area: Sotogrande Region: Andalucía
Renovated Apartment in San Enrique (Sotogrande, Costa del Sol)
In the quiet, residential area of San Enrique (Sotogrande), surrounded by amenities and with excellent connections to La Línea, (...)
€254,500
TSEA5141122
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 27 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 27 Area: Mijas and Mijas Costa Region: Andalucía
This beachfront studio apartment is an excellent opportunity for those seeking a property in a prime location. The apartment is south-east facing, offering spectacular views of the Mediterranean, the (...)
€5,400,000
TSEA5140960
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 612 Lot Size: 230 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 612 Lot Size: 230 Area: Marbella West Region: Andalucía
Exclusive Villa in Puerto Banús, Marbella
Now available in the prestigious Vilas 6 gated complex:
Villa 2, unfurnished
Villa 6, fully furnished corner unit
Live in absolute luxury in this (...)
€650,000
TSEA5139805
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 262 Lot Size: 180 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 262 Lot Size: 180 Area: Casares Region: Andalucía
MAGNIFICENT 3-BEDROOM SEMI-DETACHED HOUSE WITH LARGE GARDEN 30 METERS FROM THE BEACH
Excellently located in a beachfront development with access to the Coastal Path that connects the entire Costa del (...)
€455,000
TSEA5139772
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 5 Baths: 2 M2: 161 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 2 M2: 161 Area: Benalmadena Region: Andalucía
Spacious 5-Bedroom House with Flexible Layout and Mountain Views – Arroyo de la Miel
Located in the popular town of Arroyo de la Miel, this 5-bedroom property offers generous space and a versatile (...)
€695,000
TSEA5135917
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 4 Baths: 3 M2: 241 Lot Size: 115 Area: La Duquesa Region: Andalucía
Beds: 4 Baths: 3 M2: 241 Lot Size: 115 Area: La Duquesa Region: Andalucía
Experience luxury in this refurbished and modified semi-detached home featuring 5 bedrooms, 4 bathrooms, multiple terraces, and breathtaking panoramic views. Enjoy a private garden, private pool, and (...)
€489,000
TSEA5134726
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 137 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Fuengirola Region: Andalucía
Property for Sale – Los Boliches, Fuengirola
In the very heart of Los Boliches, one of the most emblematic and sought-after areas of Fuengirola.
The property is distributed into three generously (...)
€850,000
TSEA5133661
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 194 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 194 Area: San Pedro Region: Andalucía
This exceptional semi-detached house, the largest of the sought-after Señorío de Mainake complex, is located in the heart of San Pedro Alcántara and stands out for its generous distribution on (...)
€369,000
TSEA5133334
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
SEMI-DETACHED HOUSE IN LAS LAGUNAS (IN EXCELLENT LOCATION)
PLOT CALIFICATION POP-2 (means can do a Ground Floor + 2 storeys + penthouse) nice for invest
POSSIBILITY TO DESTROY AND BUILD GROUND FLOOR (...)
€160,000
TSEA5133130
- Jimena de la Frontera, Costa de la Luz
Beds: 5 Baths: 3 M2: 400 Lot Size: 50 Region: Andalucía
Beds: 5 Baths: 3 M2: 400 Lot Size: 50 Region: Andalucía
Semi-Detached House, Jimena de la Frontera, Costa de la Luz.
5 Bedrooms, 3 Bathrooms, Built 400 m², Terrace 10 m², Garden/Plot 50 m².
Setting : Commercial Area, Village, Mountain Pueblo, Close To (...)
€575,000
TSEA5132515
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 101 Lot Size: 25 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 101 Lot Size: 25 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to this amazing house with beautiful sea views!!
This property has been completely renovated last year and is definitely a must-see.
It has a very cozy, spacious living room with an open (...)
€145,000
TSEA5131066
- Arenas, Costa Del Sol East
Beds: 3 Baths: 1 M2: 90 Lot Size: 63 Region: Andalucía
Beds: 3 Baths: 1 M2: 90 Lot Size: 63 Region: Andalucía
In the picturesque mountain village of Arenas, just a short drive from the coast, you'll find this delightful village house full of character and comfort. The property offers three spacious bedrooms, (...)
€349,000
TSEA5130643
- Antequera, Costa Del Sol, Antequera
Beds: 3 Baths: 2 M2: 162 Area: Antequera Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Antequera Region: Andalucía
New Development: Prices from 349,000 € to 349,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 162.00 m2 - 169.00 m2]
Already under construction, this exclusive development consists of just 6 (...)
Current Featured Properties
€1,580,000
TSEA4639777
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
€443,000
TSEA4027225
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
4 UNITS LEFT
DREAM AWAY LAZY EVENINGS BY LOOKING AT A STUNNING VIEW!!!
Off-plan development of contemporary semi-detached houses in Riviera del Sol, Mijas, with views over the Mediterranean. The 3 (...)
€559,500
TSEA5019097
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 4 M2: 161 Lot Size: 500 Area: Manilva Region: Andalucía
Beds: 3 Baths: 4 M2: 161 Lot Size: 500 Area: Manilva Region: Andalucía
Charming South-Facing Villa in Peaceful Manilva – Where Comfort Meets Coastal Living
Welcome to your new sanctuary in the heart of Manilva, a quiet and picturesque corner of the Costa del Sol. This (...)
