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 (163,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 (163,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 (163,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 361 - 380 of 2924 €4,000,000
TSEA5124232
- Churriana, Costa Del Sol, Malaga
Beds: 5 Baths: 7 M2: 361 Lot Size: 1,710 Area: Malaga Region: Andalucía
Beds: 5 Baths: 7 M2: 361 Lot Size: 1,710 Area: Malaga Region: Andalucía
Casa Lux is a striking modern villa that embodies contemporary sophistication and luxury living, ideally located in the prestigious El Olivar neighborhood of Churriana, Malaga. Offered for sale at 4 (...)
€599,000
TSEA5124175
- Lauro Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 210 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 210 Area: Mijas and Mijas Costa Region: Andalucía
Very spacious home in the scenic Golf Resort near Malaga.
The area and the golf course are a big favorite among golfers, who are attracted by the 27 holes in top quality.
Weekly tournaments and (...)
€599,000
TSEA5124142
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 203 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 203 Area: Mijas and Mijas Costa Region: Andalucía
Very spacious home in the scenic Golf Resort near Malaga.
The area and the golf course are a big favorite among golfers, who are attracted by the 27 holes in top quality.
Weekly tournaments and (...)
€995,000
TSEA5124043
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 3 M2: 286 Lot Size: 545 Area: Estepona Region: Andalucía
Beds: 6 Baths: 3 M2: 286 Lot Size: 545 Area: Estepona Region: Andalucía
Spacious 6-Bedroom Villa with Sea & Mountain Views in Estepona – €995,000
Located in the peaceful residential area of La Gaspara in Estepona, this charming villa on Calle Tierra 50 offers a (...)
€1,285,000
TSEA5124019
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 4 M2: 249 Lot Size: 380 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 4 M2: 249 Lot Size: 380 Area: Fuengirola Region: Andalucía
Exclusive Villa with Panoramic Views in Torreblanca!
Discover this stunning, recently renovated villa in the sought-after area of Torreblanca (Fuengirola), originally built in 2003 and completely (...)
€515,000
TSEA5123968
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
In the heart of Estepona's charming old town lies this magnificent and spacious casa mata, a gem with an unbeatable location. Located in the heart of the town, this property combines the authenticity (...)
€3,950,000
TSEA5123887
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 5 M2: 478 Lot Size: 1,016 Area: Marbella Region: Andalucía
Beds: 5 Baths: 5 M2: 478 Lot Size: 1,016 Area: Marbella Region: Andalucía
REDUCED TO 3.950.000 €
Discover the epitome of luxury living with this stunning semi-detached villa, perfectly situated by the beach in Marbella. Boasting five spacious bedrooms and 5.5 bathrooms, (...)
€2,495,000
TSEA5123872
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 527 Lot Size: 3,120 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 527 Lot Size: 3,120 Area: Benahavis Region: Andalucía
Spectacular Sea and Mountain Views From This Elegant Villa in Monte Mayor, Benahavís
A Rare Gem of Serenity...
The only property in the entire community to offer complete privacy, surrounded (...)
€3,500,000
TSEA5123764
- Marbesa, Costa Del Sol, Marbella East
Beds: 6 Baths: 5 M2: 468 Lot Size: 805 Area: Marbella East Region: Andalucía
Beds: 6 Baths: 5 M2: 468 Lot Size: 805 Area: Marbella East Region: Andalucía
Located in the highly sought-after residential area of Marbesa, just a short stroll from the beach, this stunning villa combines contemporary design with ultimate comfort. Built in 2023 and completed (...)
€2,390,000
TSEA5123296
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 239 Lot Size: 981 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 239 Lot Size: 981 Area: Marbella West Region: Andalucía
Discover this elegant villa located in the prestigious Los Naranjos Hill Club, Nueva Andalucía. Situated in a peaceful cul-de-sac, this charming home offers a perfect blend of privacy, comfort, and (...)
€650,000
TSEA5123272
- Benajarafe, Costa Del Sol East
Beds: 4 Baths: 3 M2: 277 Lot Size: 713 Region: Andalucía
Beds: 4 Baths: 3 M2: 277 Lot Size: 713 Region: Andalucía
Discover your dream home in the charming seaside village of Benajarafe! This beautifully modernized property offers everything you need for luxurious Mediterranean living. The main house features two (...)
€875,000
TSEA5123266
- Algarrobo, Costa Del Sol East
Beds: 3 Baths: 3 M2: 310 Lot Size: 5,210 Region: Andalucía
Beds: 3 Baths: 3 M2: 310 Lot Size: 5,210 Region: Andalucía
For sale is a breathtaking villa located in the picturesque area of Algarrobo, fulfilling all your desires and expectations for a luxurious home. This fantastic property not only impresses with its (...)
€995,000
TSEA5123257
- Macharaviaya, Costa Del Sol East
Beds: 7 Baths: 9 M2: 500 Lot Size: 18,313 Region: Andalucía
Beds: 7 Baths: 9 M2: 500 Lot Size: 18,313 Region: Andalucía
We present you this wonderful hotel/B&B close to the charming town of Macharaviaya. The property has a plot of 18,313 m2. The hotel itself has 500 m2, perfect to realize your dream of owning a (...)
€379,000
TSEA5123182
- Villanueva De La Concepcion, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 146 Lot Size: 18,000 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 146 Lot Size: 18,000 Area: Malaga Region: Andalucía
The house is 146 m2 and has two spacious bedrooms on the ground floor and a large attic, which could possibly be converted into two bedrooms.
One bathroom, kitchen, and living room with fireplace. (...)
€1,650,000
TSEA5123161
- San Roque Club, Costa Del Sol, San Roque
Beds: 6 Baths: 3 M2: 737 Lot Size: 2,528 Area: San Roque Region: Andalucía
Beds: 6 Baths: 3 M2: 737 Lot Size: 2,528 Area: San Roque Region: Andalucía
Located in the prestigious residential environment of San Roque Club, surrounded by golf courses, nature and with excellent connections to Sotogrande, the coast and international schools, this (...)
€1,695,000
TSEA5122984
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 320 Lot Size: 6,200 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 320 Lot Size: 6,200 Area: Estepona Region: Andalucía
We proudly present one of the most authentic and beautiful Andalusian Cortijos with stables separate guest house in the Estepona area!
Dream location on the New golden Mile between Marbella and (...)
€600,000
TSEA5122945
- Campanillas, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 156 Lot Size: 370 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 156 Lot Size: 370 Area: Marbella Region: Andalucía
Exceptional Finca with Pool, Stables & Panoramic Rural Setting
Discover this rare and versatile opportunity just 5 minutes from Málaga's Technological Park, a fully equipped finca set on a (...)
€1,850,000
TSEA5122906
- Los Monteros, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 238 Lot Size: 694 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 238 Lot Size: 694 Area: Marbella East Region: Andalucía
Elegant Semi-Detached Beachside Villa in Los Monteros, Marbella East – Just 150m from the Beach
Located in the exclusive and secure beachside enclave of Los Monteros in Marbella East, this (...)
€1,750,000
TSEA5122768
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 183 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 183 Area: Benalmadena Region: Andalucía
Contemporary Coastal Luxury State-of-the-Art Villa in Exclusive Urbanization Marae, Benalmádena Costa
Welcome to this stunning fusion of cutting-edge design, breathtaking views, and luxury living, (...)
€365,000
TSEA5122759
- La Viñuela, Costa Del Sol East
Beds: 3 Baths: 2 M2: 113 Lot Size: 600 Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Lot Size: 600 Region: Andalucía
La Alzambra de La Viñuela
3-bedroom, 2-bathroom villas on plots over 600 m², just 15 min from the coast and 45 min from Málaga Airport.
Fully equipped kitchen, furniture and appliances, PVC (...)
Current Featured Properties
€795,000
TSEA4358863
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 101 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Fuengirola Region: Andalucía
ACT NOW, THESE WILL GO FAST!!!
Spectacular new development of 60 luxury apartments in the most sought-after area of El Higuerón, in a gated exclusive community with gym, heated pool, jacuzzis and (...)
€4,500,000
TSEA4780684
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 370 Lot Size: 884 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 370 Lot Size: 884 Area: Estepona Region: Andalucía
AWARD WINNING DESIGN BRINGS YOU BEACHFRONT PERFECTION. The exclusive urbanisation is a unique village development on the famous New Golden Mile, only 7 minutes from Puerto Banus. All properties in (...)
€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 (...)
