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 621 - 640 of 3420
€560,000
TSEA5109427
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 123 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 123 Area: Fuengirola Region: Andalucía
Welcome to our large penthouse with 4 bedrooms and 125m2 terrace with Jacuzzi, located just around the corner from the Fuengirola Castle and the enormous shoppingcenter of Miramar in Fuengirola. This (...)
€449,000
TSEA5109421
- Villanueva De La Concepcion, Costa Del Sol, Malaga
Beds: 5 Baths: 5 M2: 195 Lot Size: 5,267 Area: Malaga Region: Andalucía
Beds: 5 Baths: 5 M2: 195 Lot Size: 5,267 Area: Malaga Region: Andalucía
Authentic villa with panoramic views of El Torcal – including two casitas
Just a ten-minute drive from the lively village of Villanueva de la Concepción, this charming detached villa offers (...)
€690,000
TSEA5109379
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 301 Lot Size: 809 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 301 Lot Size: 809 Area: Mijas and Mijas Costa Region: Andalucía
"Discover your dream home in Mijas! This impressive single-story villa is perfect for families seeking comfort and space. With 4 spacious bedrooms and 3 bathrooms, every corner of this property (...)
€5,475,000
TSEA5109376
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 6 M2: 552 Lot Size: 1,250 Area: Marbella Region: Andalucía
Beds: 5 Baths: 6 M2: 552 Lot Size: 1,250 Area: Marbella Region: Andalucía
A stunning contemporary beachside villa nestled in the exclusive residential area of El Rosario, Beach Urb. Las Chapas, Marbella.
Set on a generous 1,250 m² plot with a desirable south-facing (...)
€2,100,000
TSEA5109355
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 4 M2: 554 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 4 M2: 554 Area: Benahavis Region: Andalucía
"This villa in Vega del Colorado, La Quinta Benahavís, is simply stunning. Located in an exclusive and peaceful environment, it offers the luxury and comfort one would expect in a high-end (...)
€1,395,000
TSEA5109319
- Manilva, Costa Del Sol, Manilva
Beds: 5 Baths: 4 M2: 308 Lot Size: 1,245 Area: Manilva Region: Andalucía
Beds: 5 Baths: 4 M2: 308 Lot Size: 1,245 Area: Manilva Region: Andalucía
Classical Villa with Stunning Sea Views in La Paloma, Manilva
Discover this exceptional classical-style villa that perfectly blends elegance, comfort, and breathtaking sea views, ideally located in (...)
€616,000
TSEA5109250
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 150 Lot Size: 1,079 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Lot Size: 1,079 Area: Mijas and Mijas Costa Region: Andalucía
Stunning detached house/villa located in Cerros Del Aguila, Mijas Costa.
This charming house with three bedrooms and two bathrooms, one of them en suite, is a true haven of peace, designed for those (...)
€1,290,000
TSEA5109166
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 5 Baths: 6 M2: 312 Lot Size: 466 Area: Fuengirola Region: Andalucía
Beds: 5 Baths: 6 M2: 312 Lot Size: 466 Area: Fuengirola Region: Andalucía
This stunning villa, perfectly positioned near the beach and Castillo Sohail, offers a unique blend of modern design, comfort, and breathtaking views.
The entrance level welcomes you with a bright (...)
€1,950,000
TSEA5109133
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 6 Baths: 5 M2: 463 Lot Size: 980 Area: San Pedro Region: Andalucía
Beds: 6 Baths: 5 M2: 463 Lot Size: 980 Area: San Pedro Region: Andalucía
Charming traditional rustic style family villa situated in the exclusive Guadalmina Alta Golf Estate, walking distance to the Clubhouse. South facing with a lot of privacy.
The house is ideal as a (...)
€619,000
TSEA5108869
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 114 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Marbella Region: Andalucía
Located in the well-established and sought-after residential area of San Pedro Alcántara, Marbella, this stylish duplex penthouse is just 700 metres from the beach, within a well-maintained gated (...)
€397,100
TSEA5108644
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 62 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 62 Area: Nerja and Malaga East Region: Andalucía
This elegant penthouse with 2 bedrooms and 2 bathrooms is located in a prestigious residential complex that offers a full range of amenities and enjoys a privileged position with panoramic sea (...)
€729,000
TSEA5108566
- Almayate, Costa Del Sol East
Beds: 5 Baths: 5 M2: 287 Lot Size: 2,104 Region: Andalucía
Beds: 5 Baths: 5 M2: 287 Lot Size: 2,104 Region: Andalucía
Unique opportunity in Almayate Costa, ideal for B&B or yoga retreats
Nestled in the hills of Almayate Costa, just 5 minutes from the village and 10 minutes from the beautiful beaches of Torre (...)
€2,650,000
TSEA5108539
- Elviria, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 746 Lot Size: 1,019 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 746 Lot Size: 1,019 Area: Marbella East Region: Andalucía
Discover the epitome of luxury living in Elviria, Marbella East, with this captivating south-facing villa boasting unrivaled panoramic views of the Mediterranean Sea.
This cozy andalucian villa, (...)
€395,000
TSEA5108365
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 2 M2: 117 Area: Ojen Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Ojen Region: Andalucía
Stunning 2-Bedroom Penthouse with Breathtaking Coastal Views – For Sale in La Mairena
Located just 10 minutes above Elviria and Marbella's renowned beaches, this immaculate two-bedroom, (...)
€475,000
TSEA5108314
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 2 M2: 307 Lot Size: 1,569 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 2 M2: 307 Lot Size: 1,569 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic opportunity to purchase this one storey villa in Piños de Alhaurín, Alhaurín de la Torre.
The property is located near the top of the urbanisation. You can enter the property which is (...)
€4,350,000
TSEA5108221
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 6 M2: 241 Lot Size: 855 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 6 M2: 241 Lot Size: 855 Area: Marbella West Region: Andalucía
Welcome to a beautifully reimagined single-level villa nestled in the heart of Nueva Andalucía, just minutes from the renowned Los Naranjos Golf Course.
Designed and developed by a very famous (...)
€239,000
TSEA5107909
- Málaga, Costa Del Sol, Malaga
Beds: 1 Baths: 1 M2: 53 Area: Malaga Region: Andalucía
Beds: 1 Baths: 1 M2: 53 Area: Malaga Region: Andalucía
Unique Investment Opportunity – Penthouse with Sun-Kissed Roof Terrace in Málaga!
Welcome to this stylish west-facing penthouse, ideally located just outside central Málaga. Enjoy the best of (...)
€1,695,000
TSEA5107642
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 3 M2: 200 Lot Size: 1,000 Area: Casares Region: Andalucía
Beds: 4 Baths: 3 M2: 200 Lot Size: 1,000 Area: Casares Region: Andalucía
BEAUTIFULLY DESIGNED LUXURY VILLA FRONT-LINE CASARES GOLF COURSE
BUILDING LICENSE GRANTED
Close to Finca Cortesin Golf and a 5-star hotel. An independent, energy-efficient and sustainably ready to (...)
€1,050,000
TSEA5107402
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 3 M2: 404 Lot Size: 300 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 3 M2: 404 Lot Size: 300 Area: San Pedro Region: Andalucía
Semi-Detached House, San Pedro de Alcántara, Costa del Sol.
5 Bedrooms, 3 Bathrooms, Built 404 m², Terrace 20 m², Garden/Plot 300 m².
Setting : Town, Commercial Area, Village, Close To Shops, (...)
€875,000
TSEA5107372
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 125 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Benahavis Region: Andalucía
Bright and well-planned apartment with stunning views and rooftop terrace in La Quinta
Welcome to this bright and well-designed apartment located in the highly sought-after area of La Quinta! You'll (...)
Current Featured Properties
€1,190,000
TSEA4648012
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 89 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Fuengirola Region: Andalucía
This new development is an ambitious project consisting of 164 homes surrounded by the natural landscape of El Higueron. The properties are made up of 70 deluxe apartments, 49 garden villas, 25 sky (...)
€756,413
TSEA4301248
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 283 Lot Size: 400 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 283 Lot Size: 400 Area: Estepona Region: Andalucía
A BEAUTIFUL PROPERTY IN STUNNING ESTEPONA!!!
A semi-detached villa for sale with 4 bedrooms and 4 bathrooms.
Oriented North West with frontal views of the golf course and the mountains.
A property (...)
€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 (...)
