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 2101 - 2120 of 2740 €3,700,000
TSEA4709413
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 361 Lot Size: 806 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 361 Lot Size: 806 Area: Casares Region: Andalucía
Discover an enchanting Mediterranean estate situated within the exclusive gated enclave of La Loma de Cortesin, in the esteemed Finca Cortesin resort. Crafted by esteemed architects Torras y Sierra, (...)
€4,800,000
TSEA4709353
- Casares, Costa Del Sol, Casares
Beds: 5 Baths: 5 M2: 655 Lot Size: 1,690 Area: Casares Region: Andalucía
Beds: 5 Baths: 5 M2: 655 Lot Size: 1,690 Area: Casares Region: Andalucía
Nestled within the enclave of Green 10 in the Finca Cortesin resort, this villa exudes the charm of Ibiza-style residences. The white structure, adorned with traditional Mediterranean stones, creates (...)
€8,700,000
TSEA4709350
- Casares, Costa Del Sol, Casares
Beds: 5 Baths: 6 M2: 752 Lot Size: 2,145 Area: Casares Region: Andalucía
Beds: 5 Baths: 6 M2: 752 Lot Size: 2,145 Area: Casares Region: Andalucía
Exuding opulence and refinement, this exceptional villa redefines the very notion of luxury golf resort living. Positioned on an elevated plot, it offers breathtaking panoramic views of the golf (...)
€5,900,000
TSEA4709347
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 6 Baths: 6 M2: 903 Lot Size: 1,556 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 6 M2: 903 Lot Size: 1,556 Area: Marbella East Region: Andalucía
Discover this brand-new, six-bedroom south-facing villa, situated in the prestigious gated community of Lomas del Marques, just above the renowned Puente Romano Resort on Marbella's Golden Mile. (...)
€6,500,000
TSEA4709338
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 6 M2: 552 Lot Size: 2,342 Area: Casares Region: Andalucía
Beds: 4 Baths: 6 M2: 552 Lot Size: 2,342 Area: Casares Region: Andalucía
This prestigious villa stands as a testament to architectural ingenuity, capturing the essence of uniqueness and sophistication. Designed by the visionary minds of Vicens & Ramos architects, its (...)
€5,750,000
TSEA4709332
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M2: 578 Lot Size: 1,937 Area: Casares Region: Andalucía
Beds: 4 Baths: 4 M2: 578 Lot Size: 1,937 Area: Casares Region: Andalucía
This astonishing villa is the embodiment of luxury golfside living. Meticulously designed by the esteemed architects Vicens & Romans, this opulent residence showcases an unrivalled architectural (...)
€995,000
TSEA4708732
- El Coto, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 143 Lot Size: 506 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 143 Lot Size: 506 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular Chalet/villa under construction located on a plot of 506 m2 in which a large garden, a private pool and a constructed area of 143m2 coexist. This impressive villa is located in the El (...)
€2,250,000
TSEA4707427
- El Madroñal, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 255 Lot Size: 1,666 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 255 Lot Size: 1,666 Area: San Pedro Region: Andalucía
Welcome to your dream retreat! This magnificent 4 bedroom, 4 bathroom villa is located in the popular gated community of El Madroñal. Located at entrance number 1, making the villa easily accesible, (...)
€789,000
TSEA4707409
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 133 Lot Size: 34 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 133 Lot Size: 34 Area: Mijas and Mijas Costa Region: Andalucía
TOWNHOUSE FOR SALE
The property is located right next to El Chaparral Golf & Country Club.
This is one of the best townhouse in the area, located in the highest line of the buildings in (...)
€1,450,000
TSEA4707259
- Torremuelle, Costa Del Sol, Mijas and Mijas Costa
Beds: 6 Baths: 5 M2: 351 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 6 Baths: 5 M2: 351 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
This stunning villa features 6 spacious bedrooms and 5 modern bathrooms, with terraces offering panoramic sea views. Outside, enjoy a beautiful swimming pool, garden, and a large patio area complete (...)
€450,000
TSEA4705285
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 123 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 123 Area: Marbella Region: Andalucía
Spacious town house located on a quiet pedestrian street in the old town of Marbella.
Distributed over two floors, it has several rooms and a wonderful central open patio, as well as a solarium (...)
€1,295,000
TSEA4704922
- Marbella, Costa Del Sol, Marbella
Beds: 9 Baths: 8 M2: 600 Lot Size: 2,374 Area: Marbella Region: Andalucía
Beds: 9 Baths: 8 M2: 600 Lot Size: 2,374 Area: Marbella Region: Andalucía
Have you dreamed of acquiring a spacious plot with several homes to invest in?
The plot is located in the well-named Ricmar area, surrounded by forests,privates schools, all kinds of services and (...)
€1,500,000
TSEA4700656
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 322 Lot Size: 384 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 322 Lot Size: 384 Area: San Pedro Region: Andalucía
Modern villa under construction – ready by the end of next year
Construction has already started on this 5-bedroom, 4-bathroom villa, and the building process will take around 14 months. (...)
€705,000
TSEA4700329
- Rincón de la Victoria, Costa Del Sol East
Beds: 4 Baths: 2 M2: 274 Lot Size: 274 Region: Andalucía
Beds: 4 Baths: 2 M2: 274 Lot Size: 274 Region: Andalucía
Experience the excellence of a luxurious chalet in Rincon de la Victoria! These ultra-modern new builds with breathtaking sea views are expected to be completed in the second trimester of 2024. (...)
€3,600,000
TSEA4693549
- Málaga, Costa Del Sol, Malaga
Beds: 5 Baths: 2 M2: 817 Lot Size: 480,000 Area: Malaga Region: Andalucía
Beds: 5 Baths: 2 M2: 817 Lot Size: 480,000 Area: Malaga Region: Andalucía
We are pleased to present this distinguished country property located in a privileged rural setting. This rustic house, part of a larger old manor house, offers a total land area of 480,000 square (...)
€4,895,000
TSEA4692358
- Benahavís, Costa Del Sol, Benahavis
Beds: 6 Baths: 5 M2: 480 Lot Size: 3,100 Area: Benahavis Region: Andalucía
Beds: 6 Baths: 5 M2: 480 Lot Size: 3,100 Area: Benahavis Region: Andalucía
Villa Imagine: Luxury Redefined with Endless Mediterranean Views to Gibraltar & Africa
Welcome to Villa Imagine - Where Timeless Elegance Meets Breathtaking Sea & Mountain Horizons
Nestled (...)
€162,000
TSEA4691560
- Atajate, Costa Del Sol
Beds: 5 Baths: 3 M2: 238 Region: Andalucía
Beds: 5 Baths: 3 M2: 238 Region: Andalucía
3424-V House for sale in perfect condition and completely in rule, without the need to carry out any type of renovation. It is located in the center of town, a few meters from the municipal swimming (...)
€1,250,000
TSEA4691482
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 240 Lot Size: 80 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 240 Lot Size: 80 Area: Marbella Region: Andalucía
Town house with commercial space on the ground floor, located directly on the main street of the old town, surrounded by the best restaurants and boutique hotels in the area.
The house, in addition (...)
€790,000
TSEA4691344
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 170 Lot Size: 545 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 170 Lot Size: 545 Area: Mijas and Mijas Costa Region: Andalucía
Set on a privileged golf front position in a quiet cul-de-sac street in the very heart of la Cala Golf resort, this superb detached villa enjoys sun all day and stunning golf views. Built in 2017 (...)
€4,775,000
TSEA4690111
- Marbesa, Costa Del Sol, Marbella East
Beds: 6 Baths: 4 M2: 639 Lot Size: 2,450 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 4 M2: 639 Lot Size: 2,450 Area: Marbella East Region: Andalucía
Most luxurious and stylish newly built villa offering breathtaking sea views, situated in the trendy beach resort Marbesa, just a short walk from the beautiful white sandy beach. The villa was (...)
Current Featured Properties
€2,300,240
Detached Villa in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 568 Lot Size: 281 Area: Mijas and Mijas Costa Region: Andalucía
NO MORE NEED TO DREAM ABOUT THE PERFECT VIEW!!!
This upscale development with the best views in Fuengirola and Mijas consists of thirteen individual villas, each offering no less than four en-suite (...)
€1,011,000
TSEA4391047
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 160 Lot Size: 63 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 160 Lot Size: 63 Area: Mijas and Mijas Costa Region: Andalucía
NATUTAL LIGHT FLOODS INTO THE PROPERTIES!!!
The architecture of these sixty-nine villas blends with nature and reinvents the traditional Andalusian style. A refuge where the natural beauty of the (...)
€1,500,000
TSEA4689550
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 341 Lot Size: 31 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 341 Lot Size: 31 Area: Marbella West Region: Andalucía
The projects itself as an exclusive residential complex of 15 spacious semi-detached homes, with boutique- style amenities - a fully equipped gym, spa and outdoor swimming pool - enjoying spectacular (...)
