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 (41,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 (41,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 (41,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 901 - 920 of 3420 €14,900,000
TSEA5065969
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 250 Lot Size: 500 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 250 Lot Size: 500 Area: Marbella East Region: Andalucía
Contemporary 2nd line beach villa in Puente Romano, Golden Mile-Marbella. Built on 2 levels, this property comprises a good size open plan living/ dining room with (...)
€50,000,000
TSEA5065927
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 9 Baths: 8 M2: 1,590 Lot Size: 4,893 Area: Marbella East Region: Andalucía
Beds: 9 Baths: 8 M2: 1,590 Lot Size: 4,893 Area: Marbella East Region: Andalucía
A very spacious & unique villa situated in an unrivalled front line beach position in one of Spain's most privileged location, Marbella's exclusive Golden Mile. The villa is set on a double plot (...)
€1,125,000
TSEA5065738
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 309 Lot Size: 1,925 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 309 Lot Size: 1,925 Area: Sotogrande Region: Andalucía
Charming Andalusian-style villa in Central Sotogrande, a tranquil residential area situated only 10 minutes' drive to The Royal Golf Club of Sotogrande, the Sotogrande marina and the beach.
The (...)
€530,000
TSEA5065441
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 147 Lot Size: 2,500 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 147 Lot Size: 2,500 Area: Mijas and Mijas Costa Region: Andalucía
Are you looking for peace and quiet without giving up proximity to the city and the coast? This charming detached house in El Romeral is a unique opportunity that combines the best of both worlds: (...)
€2,150,000
TSEA5065318
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 350 Lot Size: 550 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 350 Lot Size: 550 Area: Marbella West Region: Andalucía
Discover this beautifully renovated and uniquely designed villa with a private guest apartment, lift, and extraordinary panoramic sea and city views, situated in the heart of Nueva Andalucía, (...)
€1,200,000
TSEA5065273
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 255 Lot Size: 495 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 255 Lot Size: 495 Area: Estepona Region: Andalucía
This never-lived-in, newly completed 4-bedroom villa is a stunning example of contemporary luxury living, set within an exclusive development of just eight designer homes. Ideally positioned (...)
€749,000
TSEA5065222
- Algarrobo, Costa Del Sol East
Beds: 3 Baths: 2 M2: 283 Lot Size: 8,200 Region: Andalucía
Beds: 3 Baths: 2 M2: 283 Lot Size: 8,200 Region: Andalucía
The perfect view paired with the right southwest orientation, which together gives the superlative to absolute happiness. A villa which leaves nothing to be desired, built to a very high standard (...)
€1,300,000
TSEA5065210
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 426 Lot Size: 522 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 426 Lot Size: 522 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 1,300,000 € to 1,300,000 €. [Beds: 3 - 3] [Baths: 3 - 3] [Built size: 426.00 m2 - 426.00 m2]
Exclusive Development of 2 independent Luxury Villas on 2 independent (...)
€850,000
TSEA5065054
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 198 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 198 Area: Benahavis Region: Andalucía
Contemporary semi-detached residence available in Marbella Views, Benahavís. Located in a small, exclusive gated community of just 8 homes. This property is a short 10-minute drive from various golf (...)
€1,200,000
TSEA5064982
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 310 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 310 Area: Benalmadena Region: Andalucía
Contemporary detached villa of 360 m² built in Benalmádena Pueblo, in the prestigious residential area of Torremuelle.
It is a house built in 2017, it is in an unbeatable condition and consists (...)
€450,000
TSEA5064880
- Pizarra, Costa Del Sol, Cartama
Beds: 4 Baths: 3 M2: 137 Lot Size: 3,200 Area: Cartama Region: Andalucía
Beds: 4 Baths: 3 M2: 137 Lot Size: 3,200 Area: Cartama Region: Andalucía
This finca set in an elevated position has impressive mountain views all around it. The garden is split into different areas each with its own beautiful vibe. Stylish barbecue area by the pool is (...)
€5,450,000
TSEA5064691
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 5 Baths: 6 M2: 360 Lot Size: 501 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 6 M2: 360 Lot Size: 501 Area: Marbella East Region: Andalucía
Luxurious modern villa situated in the heart of the Golden Mile, 150 metres from the beach.
With a plot of 501m2, a total living area of 360 m2, it includes 5 bedrooms and 5+1 bathrooms, a (...)
€330,000
TSEA5064667
- Ojén, Costa Del Sol, Ojen
Beds: 1 Baths: 1 M2: 72 Lot Size: 1,151 Area: Ojen Region: Andalucía
Beds: 1 Baths: 1 M2: 72 Lot Size: 1,151 Area: Ojen Region: Andalucía
Country House in Puerto de Ojén, Just Minutes from Marbella
Discover this fantastic opportunity surrounded by nature: a plot of over 5,000 m² with great potential, located in a privileged setting (...)
€2,600,000
TSEA5064649
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M2: 333 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 4 M2: 333 Area: Marbella West Region: Andalucía
Located in prime of Puerto Banús, this exceptional apartment offers a luxurious lifestyle with unbelievable sea and mountain views. The property is a generous 333 m² of living space, featuring a (...)
€1,200,000
TSEA5064568
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 233 Lot Size: 824 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 233 Lot Size: 824 Area: Marbella Region: Andalucía
Detached Villa at the renowned and consolidated residential area of El Mirador de Marbella. A house designed for relax and enjoyment, near schools, supermarkets and just a stone's throw away from the (...)
€4,500,000
TSEA5064529
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 525 Lot Size: 1,054 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 525 Lot Size: 1,054 Area: Marbella West Region: Andalucía
New Development: Prices from 4,500,000 € to 4,500,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 525.00 m2 - 525.00 m2]
EXCLUSIVE VILLA UNDER CONSTRUCTION IN NUEVA ANDALUCÍA, MARBELLA
We are (...)
€1,395,000
TSEA5064280
- Cabopino, Costa Del Sol, Marbella East
Beds: 5 Baths: 3 M2: 314 Lot Size: 309 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 3 M2: 314 Lot Size: 309 Area: Marbella East Region: Andalucía
This stunning semi-detached villa offers panoramic views of the Mediterranean Sea and the lush Cabopino Golf Course, set within the exclusive gated community of Green Hill Marbella. Surrounded by (...)
€1,248,000
TSEA5064178
- Algarrobo, Costa Del Sol East
Beds: 6 Baths: 6 M2: 692 Lot Size: 6,600 Region: Andalucía
Beds: 6 Baths: 6 M2: 692 Lot Size: 6,600 Region: Andalucía
Imagine waking up each day to the soothing embrace of the Mediterranean in this exquisite villa. A true architectural masterpiece, this home offers an unparalleled lifestyle, seamlessly combining (...)
€985,000
TSEA5064166
- Algarrobo, Costa Del Sol East
Beds: 7 Baths: 5 M2: 430 Lot Size: 2,373 Region: Andalucía
Beds: 7 Baths: 5 M2: 430 Lot Size: 2,373 Region: Andalucía
This impressive villa in Málaga, Spain, offers a harmonious blend of space, luxury, and modern design. Spanning 395.8 m2 across two floors, the property boasts 7 bedrooms and 5 bathrooms, making it (...)
€618,000
TSEA5064103
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 220 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 220 Area: Fuengirola Region: Andalucía
This exceptional duplex penthouse, located just 70 m from the beach, offers not only a privileged location but also an unrivalled lifestyle in the vibrant Fuengirola.
- Total built: 220 m²
- (...)
Current Featured Properties
€2,400,000
TSEA4657528
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 189 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 189 Area: Benahavis Region: Andalucía
The construction is proposed in two phases, corresponding to the 2 distinct levels of the prime hillside position thereby taking full advantage of the privileged position on which will sit our finest (...)
€773,000
TSEA5032279
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 127 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 127 Area: Estepona Region: Andalucía
This development is placed in an excellent location.
Situated on an elevated plot that also benefits from being in front of a park and a sports area, guaranteeing sea views.
The development offers 2, (...)
€535,000
TSEA4122289
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 111 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Area: Casares Region: Andalucía
PROVIDING MAXIMUM COMFORT!!!
This is a gated development with a total of 58 apartments with 2 or 3 bedrooms, distributed over 4 buildings which offer ground-floor homes with private gardens, (...)
