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 (51,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 (51,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 (51,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 101 - 120 of 2660
€550,000
TSEA5146912
- Ronda, Costa Del Sol, Ronda
Beds: 3 Baths: 2 M2: 229 Area: Ronda Region: Andalucía
Beds: 3 Baths: 2 M2: 229 Area: Ronda Region: Andalucía
✨ Charming country house with private pool and tourist license 10 minutes from Ronda ✨
We present a unique country house that combines nature, comfort, and versatility in a privileged setting. (...)
€770,000
TSEA5146741
- Pizarra, Costa Del Sol, Cartama
Beds: 11 Baths: 6 M2: 515 Area: Cartama Region: Andalucía
Beds: 11 Baths: 6 M2: 515 Area: Cartama Region: Andalucía
Exclusive estate with 5 independent homes in Pizarra – Property with valid AFO
Are you looking for a large family estate or a unique investment opportunity in the heart of the Guadalhorce (...)
€1,695,000
TSEA5146693
- Elviria, Costa Del Sol, Marbella East
Beds: 5 Baths: 4 M2: 259 Lot Size: 1,003 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 4 M2: 259 Lot Size: 1,003 Area: Marbella East Region: Andalucía
Charming villa with a rustic touch, reformed (2002) with very good construction quality. Located in a residential area of Elviria. Beautiful views, sea, golf and mountain. Air aconditioning (...)
€2,550,000
TSEA5146249
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 534 Lot Size: 1,700 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 534 Lot Size: 1,700 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular south facing five bedroom villa in El Chaparral, Mijas Costa. Set within an extensive private plot that offers total tranquillity and magnificent panoramic views of the coast and the (...)
€1,750,000
TSEA5146186
- Setenil de las Bodegas, Costa de la Luz
Beds: 6 Baths: 6 M2: 616 Lot Size: 5,101 Region: Andalucía
Beds: 6 Baths: 6 M2: 616 Lot Size: 5,101 Region: Andalucía
A Rare Blend of Heritage & Modern Innovation Experience a truly extraordinary property, a beautifully converted historic watermill set against the dramatic backdrop of rural Andalusia. Just 24 km (...)
€825,000
TSEA5145994
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 137 Lot Size: 563 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 137 Lot Size: 563 Area: Estepona Region: Andalucía
Detached Villa in Atalaya Baja, Estepona – Spacious, Bright & Full of Potential
Located in the exclusive Atalaya Baja urbanization, this charming detached villa sits on a generous 563 m² (...)
€1,484,700
TSEA5145973
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 303 Lot Size: 1,149 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 303 Lot Size: 1,149 Area: Benalmadena Region: Andalucía
SPECTACULAR AND MODERN VILLA WITH SEA VIEWS
We are delighted to present this very special villa with its unique, modernist-inspired design, located in one of the most privileged and growing areas of (...)
€1,900,000
TSEA5145913
- El Paraiso, Costa Del Sol, Estepona
Beds: 6 Baths: 5 M2: 458 Lot Size: 1,271 Area: Estepona Region: Andalucía
Beds: 6 Baths: 5 M2: 458 Lot Size: 1,271 Area: Estepona Region: Andalucía
Discover a fantastic opportunity to create your dream home in the sought-after area of El Paraiso, Estepona. This spacious 6-bedroom, 5-bathroom villa is ready for a complete reform and is perfectly (...)
€1,790,000
TSEA5145895
- Hacienda Las Chapas, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 456 Lot Size: 1,664 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 456 Lot Size: 1,664 Area: Marbella East Region: Andalucía
FOR INVESTORS!
VILLA WITH SEA VIEWS & RENOVATION POTENTIAL IN HACIENDA LAS CHAPAS.
Located in the prestigious gated community of Hacienda Las Chapas, this villa presents an excellent investment (...)
€975,000
TSEA5145856
- Valtocado, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 112 Lot Size: 3,533 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Lot Size: 3,533 Area: Mijas and Mijas Costa Region: Andalucía
For Sale – Authentic Andalusian Finca with Sea Views, Private Pool, Casita & Wellness Features in Mijas
Perched in the hills above the Costa del Sol, this exquisite Andalusian finca offers the (...)
€1,295,000
TSEA5145832
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 327 Lot Size: 1,005 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 327 Lot Size: 1,005 Area: Mijas and Mijas Costa Region: Andalucía
Set in the peaceful surroundings of Mijas Golf, this frontline golf villa offers a blend of privacy, comfort, and Mediterranean charm. With a 1,005 m² plot and 327 m² built, the property is (...)
€400,000
TSEA5145808
- La Línea, Costa Del Sol, San Roque
Beds: 3 Baths: 2 M2: 150 Area: San Roque Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: San Roque Region: Andalucía
Incredible 3-Bedroom Chalet for Sale in Venta Melchor with Views of Gibraltar
This magnificent home has been designed to make the most of natural light, allowing it to flow through every room and (...)
€829,000
TSEA5145739
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 240 Lot Size: 500 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 240 Lot Size: 500 Area: Fuengirola Region: Andalucía
This exclusive luxury villa, combines modern architecture with top-quality construction and a carefully designed layout. The home is filled with natural light thanks to large floor-to-ceiling windows (...)
€4,500,000
TSEA5145691
- Benahavís, Costa Del Sol, Benahavis
Beds: 8 Baths: 9 M2: 883 Lot Size: 4,746 Area: Benahavis Region: Andalucía
Beds: 8 Baths: 9 M2: 883 Lot Size: 4,746 Area: Benahavis Region: Andalucía
This exclusive villa is a classic jewel of Mediterranean style in a prestigious location.
With direct access to the golf course.
Situated in the prestigious Marbella Club Golf Resort on the Costa (...)
€748,000
TSEA5145256
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 3 M2: 188 Lot Size: 289 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 3 M2: 188 Lot Size: 289 Area: Nerja and Malaga East Region: Andalucía
Located between Frigiliana and Nerja, this charming Andalusian-style property combines a comfortable main house with extraordinary exteriors, set on a spectacular plot of over 6,000 m2. Surrounded by (...)
€1,500,000
TSEA5145217
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 209 Lot Size: 5,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 209 Lot Size: 5,000 Area: Mijas and Mijas Costa Region: Andalucía
Property Description: Casanicky – Luxury Villa, Boutique B&B & Rare Investment Opportunity in Mijas
Welcome to Casanicky, a unique property in the heart of Mijas, Málaga province, offered (...)
€2,100,000
TSEA5145193
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 350 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 350 Area: Marbella West Region: Andalucía
Nice Villa with espectacular open mountain, landscape and pool views, in Nueva Andalucia,
Located in a peaceful and private location just a few minutes from Puerto Banus and Marbella at walking (...)
€349,000
TSEA5145187
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 68 Lot Size: 290 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 68 Lot Size: 290 Area: Mijas and Mijas Costa Region: Andalucía
Charming two bedroom detached bungalow in the popular area of El Faro, just a 5 minute drive to both Fuengirola and La Cala village. The beach is just a short 300 metre stroll away! This property has (...)
€365,000
TSEA5145154
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 141 Lot Size: 10,000 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Lot Size: 10,000 Area: Alhaurin el Grande Region: Andalucía
Rustic finca with great potential in Alhaurín el Grande
Discover this charming finca on a fully fenced plot of no less than 10,000 m², located in the green heart of Alhaurín el Grande. Here you (...)
€5,995,000
TSEA5145121
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 720 Lot Size: 2,000 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 720 Lot Size: 2,000 Area: Marbella East Region: Andalucía
This substantial property is set in a privileged position within walking distance of the beach and all amenities, offering a high level of privacy being accessed via a private cul-de-sac. There is a (...)
Current Featured Properties
€2,548,000
TSEA4300519
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 397 Lot Size: 833 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 397 Lot Size: 833 Area: Mijas and Mijas Costa Region: Andalucía
THE ULTIMATE LUXURY LIVING!!!
Experience the ultimate in luxury living with this latest development of three stunning, open plan villas located just steps from the sea. These spacious and bright (...)
€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 (...)
€2,400,000
TSEA3878038
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 337 Lot Size: 70 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 337 Lot Size: 70 Area: Benahavis Region: Andalucía
MODULAR VILLAS IN AN UPSCALE COUNTRY CLUB RESORT!!!
A gated and secure community of villas with club house, spa and gym with verdant Mediterranean gardens and amazing panoramic sea views. located in (...)
