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 (70,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 (70,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 (70,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 381 - 400 of 3305 €421,000
TSEA5128690
- Ciudad Jardín, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 178 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 178 Area: Marbella Region: Andalucía
Hello! I want to offer you an excellent opportunity in a quiet area of Málaga Capital: a charming townhouse located in Monte Dorado. This property is distributed over two floors and has a small (...)
€2,500,000
TSEA5128684
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 8 M2: 573 Lot Size: 2,500 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 8 M2: 573 Lot Size: 2,500 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful Villa for sale in La Cala de Mijas
2500m2 plot
Over 500m 2 built
4 beds
4 baths
€780,000
TSEA5127550
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 2 M2: 300 Lot Size: 2,554 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 2 M2: 300 Lot Size: 2,554 Area: Mijas and Mijas Costa Region: Andalucía
3547-V For sale spectacular villa of more than 300 meters on a plot of 2500 meters, consists on the ground floor of a living room with fireplace, an independent fitted kitchen with utility room, two (...)
€5,500,000
TSEA5127520
- Aloha, Costa Del Sol, Marbella West
Beds: 7 Baths: 8 M2: 710 Lot Size: 1,291 Area: Marbella West Region: Andalucía
Beds: 7 Baths: 8 M2: 710 Lot Size: 1,291 Area: Marbella West Region: Andalucía
Stunning frontline golf villa with panoramic mountain views to La Concha as well as overlooking the beautiful Aloha Golf course.
The Villa is situated on a quiet cul-de-sac, just a short distance to (...)
€395,000
TSEA5127508
- Cómpeta, Costa Del Sol East
Beds: 5 Baths: 2 M2: 287 Lot Size: 8,008 Region: Andalucía
Beds: 5 Baths: 2 M2: 287 Lot Size: 8,008 Region: Andalucía
For Sale: Beautiful Villa with separate guesthouse, Between Cómpeta and Torrox, Andalusia
Discover a peaceful Andalusian retreat nestled between the whitewashed villages of Cómpeta and Torrox. (...)
€565,000
TSEA5127385
- Churriana, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 300 Lot Size: 1,000 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 300 Lot Size: 1,000 Area: Malaga Region: Andalucía
LOCATION – CHURRIANA, MÁLAGA.
This independent villa sits in the peaceful residential area of Cortijo Maza, one of the most sought-after urbanisations in Churriana, Málaga.
You're just 5 minutes (...)
€565,000
TSEA5127343
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 4 Baths: 4 M2: 235 Lot Size: 861 Area: Alhaurin el Grande Region: Andalucía
Beds: 4 Baths: 4 M2: 235 Lot Size: 861 Area: Alhaurin el Grande Region: Andalucía
Welcome to your dream home in Alhaurín el Grande, provincia de Málaga! This detached independent villa is ready to move in and boasts of everything you need for a comfortable living. With 4 (...)
€895,000
TSEA5127301
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 3 M2: 325 Lot Size: 530 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 3 M2: 325 Lot Size: 530 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive detached villa for sale in Alhaurín de la Torre (Málaga)
Built in 2021, this elegant 325 m² property stands on a generous 530 m² plot, offering a modern, comfortable, and private (...)
€690,000
TSEA5127274
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 204 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 204 Area: Marbella Region: Andalucía
Exclusive 3-Bedroom Townhouse in One of Marbella's Finest Areas
Discover this magnificent three-storey home located in a peaceful and well-maintained gated community of just 36 houses, in one of the (...)
€595,000
TSEA5127184
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 210 Lot Size: 715 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 210 Lot Size: 715 Area: Mijas and Mijas Costa Region: Andalucía
� Unique Opportunity on the Costa del Sol! Villa with Panoramic Sea Views Just Steps from the Beach �
Looking to invest in a property with a privileged location, breathtaking sea views, and (...)
€1,260,000
TSEA5127163
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 276 Lot Size: 770 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 276 Lot Size: 770 Area: Marbella Region: Andalucía
Investment Opportunity – Distinctive Villa Within Walking Distance to the Beach | Marbella East
This is your chance to acquire a truly unique villa in the desirable area of Marbella East, just a (...)
€598,000
TSEA5127148
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 5 Baths: 6 M2: 250 Area: Benalmadena Region: Andalucía
Beds: 5 Baths: 6 M2: 250 Area: Benalmadena Region: Andalucía
For sale: A wonderful detached house located in a quiet area of Benalmádena Pueblo, with stunning sea views. It is divided into three completely independent units, one of which is currently rented, (...)
€5,900,000
TSEA5127067
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 7 M2: 1,904 Lot Size: 36,498 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 7 M2: 1,904 Lot Size: 36,498 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic opportunity to adquire a villa located within 3 plots in Cerro del Aguila.
Villa with Islamic architecture, this wonderful property will surprise you! On the first floor we can find a (...)
€4,000,000
TSEA5127016
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 621 Lot Size: 1,600 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 621 Lot Size: 1,600 Area: Marbella West Region: Andalucía
Detached Villa, Nueva Andalucía, Costa del Sol.
6 Bedrooms, 6 Bathrooms, Built 621 m², Garden/Plot 1600 m².
Setting : Town, Commercial Area, Village, Close To Golf, Close To Shops, Close To Sea, (...)
€2,466,000
TSEA5126986
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 6 Baths: 7 M2: 995 Lot Size: 2,552 Area: Sotogrande Region: Andalucía
Beds: 6 Baths: 7 M2: 995 Lot Size: 2,552 Area: Sotogrande Region: Andalucía
Modern Villa in La Reserva de Sotogrande
Located in La Reserva, one of the most exclusive areas of Sotogrande, this spectacular detached villa offers elegance, comfort, and contemporary style in a (...)
€850,000
TSEA5126953
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 180 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: San Pedro Region: Andalucía
We are pleased to offer this distinguished townhouse in the prestigious Costa del Sol, located just a 5-minute walk from the emblematic seafront promenade of San Pedro de Alcántara.
Strategically (...)
€419,500
TSEA5126938
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 140 Area: Mijas and Mijas Costa Region: Andalucía
Bright and spacious three-storey townhouse, located in the charming Sitio de Calahonda. Just a short walk from the vibrant shopping centres and delicious restaurants along Avenida de España, this (...)
€2,500,000
TSEA5126911
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 7 Baths: 6 M2: 516 Lot Size: 1,316 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 7 Baths: 6 M2: 516 Lot Size: 1,316 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular 7-Bedroom Designer Villa in La Finca de La Cala
Welcome to one of the most exquisite villas in La Finca de La Cala — a truly unique, fully furnished 7-bedroom residence that blends (...)
€2,700,000
TSEA5126596
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 280 Lot Size: 808 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 280 Lot Size: 808 Area: Marbella West Region: Andalucía
This lovely four-bedroom, newly renovated villa is located in the residential area of Nueva Andalucía, within the secure, gated community of Marbella Country Club.
The property features stunning (...)
€346,000
TSEA5126557
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 85 Lot Size: 30 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 30 Area: Marbella East Region: Andalucía
Renovated townhouse with sea views in Reserva de Marbella
Located in one of the quietest areas of Reserva de Marbella, this townhouse offers the perfect combination of comfort, natural light, and (...)
Current Featured Properties
€673,000
TSEA4107058
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
€1,535,000
TSEA5021377
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 282 Lot Size: 528 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 282 Lot Size: 528 Area: Mijas and Mijas Costa Region: Andalucía
The villas are located in the exclusive Las Farolas Urbanisation of Mijas Costa, an area that blends tranquillity with close proximity to top-tier amenities. Just a few minutes' walk from the (...)
€6,895,000
World class design-led villas with spectacular views
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía
400,000€ discount if you purchase before completion! This is a sustainable luxury development of 18 individually designed villas situated in the 200-hectare country club estate of Real de La (...)
