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 (36,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 (36,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 (36,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 101 - 120 of 2642
€3,150,000
TSEA5147011
- La Quinta, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 386 Lot Size: 765 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 386 Lot Size: 765 Area: Benahavis Region: Andalucía
Nestled in the prestigious La Quinta area of Benahavis, this stunning 303-square-meter villa (386 sqm including terraces) sits on an expansive 765-square-meter plot, offering an unparalleled blend of (...)
€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 (...)
Current Featured Properties
€4,950,000
TSEA4790245
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 488 Lot Size: 970 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 488 Lot Size: 970 Area: Marbella West Region: Andalucía
Nestled within the illustrious enclave of Nueva Andalucia, This new development provides residents a luxurious escape that embodies the true essence of luxury living. With its privileged location in (...)
€1,250,000
TSEA5020213
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 225 Lot Size: 354 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 225 Lot Size: 354 Area: Estepona Region: Andalucía
DESIGN AND FUNCTIONALITY, This new construction offers a two-story home and office with spacious rooms, access to a sun terrace and private garden on the ground floor, It is fully equipped with a (...)
€2,950,000
EMPTY
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 5 M2: 450 Lot Size: 610 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 5 M2: 450 Lot Size: 610 Area: San Pedro Region: Andalucía
We are thrilled to present this modern south facing villa, just 250m from the Mediterranean Sea near San Pedro town. The property is built over two floors plus basement and rooftop terrace with views (...)
