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 (42,68,69,70)
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 (42,68,69,70)
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 (42,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 2041 - 2060 of 2740 €4,250,000
TSEA4751965
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 910 Lot Size: 1,250 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 910 Lot Size: 1,250 Area: Mijas and Mijas Costa Region: Andalucía
LUXURIOUS VILLA WITH SEA VIEWS AND TOP FACILITIES WITHIN WALKING DISTANCE OF LA CALA DE MIJAS
Discover this fully renovated 5 bedroom, 5 bathroom villa, just a ten-minute walk from the bustling (...)
€1,200,000
TSEA4750381
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 160 Lot Size: 450 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Lot Size: 450 Area: Estepona Region: Andalucía
A beautifully renovated beachfront villa with perfect sea views. The house has been tastefully modernised to offer a large open plan living room with fully fitted modern kitchen, on the lower level (...)
€2,780,000
TSEA4749601
- Sotogrande Costa, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 592 Lot Size: 4,274 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 592 Lot Size: 4,274 Area: Sotogrande Region: Andalucía
Discover the charm and exclusivity of this unique style villa, located at the end of a quiet cul-de-sac in Sotogrande Costa Central, in zone B.
Surrounded by beautiful gardens and large wooden (...)
€410,000
TSEA4748875
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 121 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 121 Area: Malaga Region: Andalucía
We present a superb three bedroom, three bathroom townhouse located in the heart of Malaga, in the sought after area of Huelin. Just steps away from the beach, this property is in excellent condition (...)
€1,950,000
TSEA4748425
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 456 Lot Size: 350 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 456 Lot Size: 350 Area: Marbella Region: Andalucía
Introducing an exquisite newly constructed property completed in 2023, epitomizing modern living and nestled in the esteemed El Mirador area near Marbella's La Cañada Shopping Center. Set upon an (...)
€1,695,000
TSEA4748416
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 4 M2: 390 Lot Size: 1,400 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 4 M2: 390 Lot Size: 1,400 Area: Sotogrande Region: Andalucía
Nestled between the prestigious Sotogrande and the picturesque La Duquesa Marinas, this stunning five-bedroom detached villa offers a luxurious retreat just a 10-minute drive from both marinas. The (...)
€735,000
TSEA4747885
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 4 M2: 249 Lot Size: 509 Area: Marbella Region: Andalucía
Beds: 5 Baths: 4 M2: 249 Lot Size: 509 Area: Marbella Region: Andalucía
Care for Tranquility, Nature but still at 5 minute Marbella downtown? This is an independent Villa located at the outskirts of Marbella, surrounded by nature, within a small community of proprietors, (...)
€2,450,000
TSEA4747489
- El Rosario, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 323 Lot Size: 1,065 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 323 Lot Size: 1,065 Area: Marbella East Region: Andalucía
Investment Opportunity in Marbella East – Sea View Villa with Exceptional Potential
Discover a rare opportunity to transform a spacious villa with panoramic sea views into a standout luxury (...)
€1,250,000
TSEA4747441
- Artola, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 390 Lot Size: 800 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 390 Lot Size: 800 Area: Marbella East Region: Andalucía
This luxurious four-bedroom villa, located in the peaceful area of lower Artola / Hacienda Las Chapas, just 5 minuntes walk to the sea, is the epitome of elegance and comfort. Boasting a classic (...)
€4,400,000
TSEA4747429
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 567 Lot Size: 1,107 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 567 Lot Size: 1,107 Area: Marbella East Region: Andalucía
This villa set on a 1.107 square meter plot, this 4-level contemporary
designer villa in the natural hill environment of Elviria radiates
modern architectural excellence. It has a privileged (...)
€1,300,000
TSEA4746802
- Moclinejo, Costa Del Sol East
Beds: 7 Baths: 2 M2: 671 Lot Size: 85,000 Region: Andalucía
Beds: 7 Baths: 2 M2: 671 Lot Size: 85,000 Region: Andalucía
Immerse yourself in the tranquility and rustic charm of this impressive country house located in the idyllic Rincón de la Victoria. With a stone facade that exudes authenticity and character, this (...)
€1,050,000
TSEA4746721
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 242 Lot Size: 1,180 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 242 Lot Size: 1,180 Area: Estepona Region: Andalucía
Charming Villa in Monte Biarritz, Estepona with Sea Views, Pool, and Lush Garden
Nestled in the sought-after area of Monte Biarritz, Estepona, this beautifully located villa boasts stunning sea (...)
€1,995,000
TSEA4745782
- Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 5 M2: 431 Lot Size: 900 Area: Marbella Region: Andalucía
Beds: 6 Baths: 5 M2: 431 Lot Size: 900 Area: Marbella Region: Andalucía
¡Discover your oasis in Marbella! This stunning villa, located in one of the city's most exclusive areas, offers you an unparalleled experience of luxury and comfort.
With an 895 m² plot situated (...)
€4,100,000
TSEA4745365
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 6 Baths: 8 M2: 959 Lot Size: 8,050 Area: Sotogrande Region: Andalucía
Beds: 6 Baths: 8 M2: 959 Lot Size: 8,050 Area: Sotogrande Region: Andalucía
Discover this property "Casa Serena" located in the exclusive enclave of Sotogrande, strategically located, a few meters from the prestigious golf course of Valderrama, close to the (...)
€849,900
TSEA4745227
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 2 M2: 317 Lot Size: 4,825 Area: Estepona Region: Andalucía
Beds: 5 Baths: 2 M2: 317 Lot Size: 4,825 Area: Estepona Region: Andalucía
Detached Villa, Estepona, Costa del Sol.
5 Bedrooms, 2 Bathrooms, Built 317 m², Terrace 40 m², Garden/Plot 4825 m².
Setting : Country, Close To Town, Close To Forest.
Orientation : South, (...)
€2,900,000
TSEA4745128
- Estepona, Costa Del Sol, Estepona
Beds: 7 Baths: 7 M2: 557 Lot Size: 2,681 Area: Estepona Region: Andalucía
Beds: 7 Baths: 7 M2: 557 Lot Size: 2,681 Area: Estepona Region: Andalucía
EXCEPTIONAL VILLA, SET ON A LARGE PLOT WITH STUNNING SEA VIEWS, OFFERS LUXURY LIVING AND ULTIMATE PRIVACY IN ESTEPONA.
Stunning 7-Bed, 7-Bath Villa with Sea Views in Estepona.
This exceptional (...)
€895,000
TSEA4745116
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 181 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 181 Area: Estepona Region: Andalucía
This enchanting and unique townhouse is nestled within the exclusive Belgravia Club, offering direct access to Estepona Marina, the port, and the renowned El Cristo Beach.
This gated haven comprises (...)
€675,000
TSEA4744987
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 116 Lot Size: 637 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Lot Size: 637 Area: Mijas and Mijas Costa Region: Andalucía
Escape to paradise with this exceptional detached villa located in the vibrant coastal town of Mijas Costa, just a 15 minute drive away from Malaga airport. Boasting an enviable location just steps (...)
€995,000
TSEA4744636
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 150 Lot Size: 413 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Lot Size: 413 Area: Mijas and Mijas Costa Region: Andalucía
Incredible opportunity! Brand new villa located on the Mijas - Fuengirola road, with fantastic views of the Mediterranean Sea. Enjoy the privacy and comfort of this independent house with a private (...)
€1,100,000
TSEA4743592
- Cádiz, Costa de la Luz, Sotogrande
Beds: 4 Baths: 4 M2: 200 Lot Size: 884 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 4 M2: 200 Lot Size: 884 Area: Sotogrande Region: Andalucía
Introducing Villa Flora – A Sea View Villa in Prime Location Near Sotogrande
We are proud to present Villa Flora, an exclusive off-plan villa project set on a spacious 884 m² plot in the highly (...)
Current Featured Properties
€595,000
TSEA4927306
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 150 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 150 Area: Benahavis Region: Andalucía
ABSOLUTELY FABULOUS LA HEREDIA HOUSE RECENTLY REDUCED IN PRICE.
This stunning, detached, stand-alone house is one of the few original homes in the charming and picturesque village of La Heredia, (...)
€1,860,000
TSEA4238983
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 558 Lot Size: 368 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 558 Lot Size: 368 Area: Mijas and Mijas Costa Region: Andalucía
BEAUTIFUL HIGH END LUXURY VILLAS!!!
A collection of luxury villas in a gated complex with one of the best amenities on the Costa del Sol.This is the cornerstone of an exclusive gated villa complex (...)
€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 (...)
