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 921 - 940 of 3420 €1,250,000
TSEA5064085
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 350 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 350 Area: Estepona Region: Andalucía
For Sale – Stunning Renovated Villa in Estepona
This beautifully renovated villa offers 4 spacious bedrooms and 4 modern bathrooms, combining luxury and comfort in every detail. Located just 5 km (...)
€368,400
TSEA5063941
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 58 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Area: Mijas and Mijas Costa Region: Andalucía
A modern apartment complex is an innovative development of 116 one-bedroom loft-style apartments, designed for those seeking style, functionality, and excellent value for money. At this residential (...)
€270,000
TSEA5063887
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 2 M2: 150 Lot Size: 650 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Lot Size: 650 Area: Alhaurin el Grande Region: Andalucía
An exciting opportunity to purchase the last, untouched detached villa located in the very heart of Alhaurin el Grande.
In less than a minute, you can be walking the main streets of Alhaurin, this (...)
€1,695,000
TSEA5063872
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 321 Lot Size: 875 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 321 Lot Size: 875 Area: Marbella West Region: Andalucía
An exceptional bright, spacious and contemporary villa. This four double bedroom property is situated in Nueva Andalucia, one of the best areas of Marbella and within walking distance to the prestige (...)
€1,200,000
TSEA5063863
- Elviria, Costa Del Sol, Marbella East
Beds: 7 Baths: 6 M2: 450 Lot Size: 1,311 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 6 M2: 450 Lot Size: 1,311 Area: Marbella East Region: Andalucía
This fantastic location is an absolute gift, a short walking distance to the sandy Elviria
beaches, next to the most glamorous beach bars, hotel beach clubs, traditional
chiringuitos with the true (...)
€6,250,000
TSEA5063695
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 4 M2: 589 Lot Size: 92 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 4 M2: 589 Lot Size: 92 Area: Marbella West Region: Andalucía
Perched in the heart of Marbella's coveted Golden Mile, this development represents the pinnacle of luxury and modern design in a locale renowned for its sophistication and exclusivity.
This (...)
€840,000
TSEA5063614
- La Capellania, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 201 Lot Size: 460 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 201 Lot Size: 460 Area: Fuengirola Region: Andalucía
Panoramic Sea & Bay Views – Villa in La Capellanía, Benalmádena
Detached villa with open views, private parking, and walking distance to the beach
Set in the prestigious hillside community (...)
€1,800,000
TSEA5063395
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 385 Lot Size: 10,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 385 Lot Size: 10,000 Area: Mijas and Mijas Costa Region: Andalucía
Immerse yourself in the captivating charm of this refined utterly peaceful country home, affording absolute privacy and breathtaking panoramic views, which unfold before you as far as the sea and the (...)
€350,000
TSEA5063392
- Alozaina, Costa Del Sol, Alozaina
Beds: 5 Baths: 5 M2: 100 Lot Size: 17,867 Area: Alozaina Region: Andalucía
Beds: 5 Baths: 5 M2: 100 Lot Size: 17,867 Area: Alozaina Region: Andalucía
Rustic Property with Tourist License and 2 Horse Stables
Welcome to this magnificent rustic estate, an oasis of tranquility and beauty in the mountains, ideal for those looking for a unique getaway (...)
€949,000
TSEA5063374
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 260 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 260 Area: Estepona Region: Andalucía
The apartment is located in the heart of Estepona's old town – central yet peacefully tucked away. The charming little square outside has become a symbol of the house itself. Here, you live among (...)
€2,800,000
TSEA5063356
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 6 M2: 523 Area: Estepona Region: Andalucía
Beds: 3 Baths: 6 M2: 523 Area: Estepona Region: Andalucía
For sale: an iconic beachfront restaurant-chiringuito located literally on the shores of the Mediterranean in Estepona. A true jewel of the Costa del Sol, offering completely unobstructed sea views (...)
€775,000
TSEA5063350
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Stunning Beachfront Penthouse in Estepona
Wake up to breathtaking views of Playa del Cristo and across the sea to Gibraltar from this beautifully renovated penthouse apartment. Boasting a prime (...)
€2,200,000
TSEA5063341
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 175 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 175 Area: Estepona Region: Andalucía
Experience luxury living in this spectacular and unique penthouse located in the heart of Estepona, just a 1-minute walk from the charming old town and a mere 5 minutes from the beach. This stunning (...)
€1,780,000
TSEA5063281
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 230 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 230 Area: Marbella Region: Andalucía
Gated community with security at night and during the summer from 6:00 p.m. to 6:00 a.m.
Ideal investment as a vacation home or boutique hotel.
Newly renovated villa with a minimalist style and (...)
€585,000
TSEA5063140
- Caleta de Vélez, Costa Del Sol East
Beds: 5 Baths: 2 M2: 170 Lot Size: 390 Region: Andalucía
Beds: 5 Baths: 2 M2: 170 Lot Size: 390 Region: Andalucía
This charming two-story home in Caleta de Vélez offers 169.38 m2 of usable space and 220 m2 built, including terraces, in a privileged location with sea views and a swimming pool. The design blends (...)
€1,595,000
TSEA5063116
- Ojén, Costa Del Sol, Ojen
Beds: 3 Baths: 2 M2: 115 Area: Ojen Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Ojen Region: Andalucía
Elegant Penthouse with Breathtaking Panoramic Views in Palo Alto, Marbella
Discover a refined lifestyle in this elegant penthouse located in the exclusive Palo Alto community—just a 10-minute drive (...)
€630,000
TSEA5063113
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 2 M2: 150 Lot Size: 8,900 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 2 M2: 150 Lot Size: 8,900 Area: Nerja and Malaga East Region: Andalucía
Country Villa with Sea Views and Avocado Farm – Nerja, Río Seco
Located just 10 minutes from the beach, this charming country villa sits in the peaceful Río Seco area of Nerja and offers both (...)
€1,425,000
TSEA5063107
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 133 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Mijas and Mijas Costa Region: Andalucía
RARE TO FIND! EXCLUSIVE UNIQUE PROPERTY!
Spacious two-storey penthouse.
The first floor has an entrance with an office area which is ideal for
home office or for digital nomads.
After climbing the (...)
€2,850,000
TSEA5063056
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 5 Baths: 5 M2: 622 Lot Size: 2,090 Area: Sotogrande Region: Andalucía
Beds: 5 Baths: 5 M2: 622 Lot Size: 2,090 Area: Sotogrande Region: Andalucía
EXCLUSIVE PROPERTY
This stunning south-facing villa with pool, sea & golf views is located in Sotogrande Alto, set on a 2,090 m² plot with 622 m² of built area.
It boasts breathtaking sea (...)
€1,150,000
TSEA5062984
- Alora, Costa Del Sol, Älora
Beds: 10 Baths: 8 M2: 435 Lot Size: 113,000 Area: Älora Region: Andalucía
Beds: 10 Baths: 8 M2: 435 Lot Size: 113,000 Area: Älora Region: Andalucía
Take advantage of the opportunity to acquire this impressive property, which covers more than eleven hectares of land and has a beautiful manor villa of more than 400 m² constructed area.
The (...)
Current Featured Properties
€890,000
TSEA4939027
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Marbella Region: Andalucía
This is the opportunity of living in Spain, in the best equipped residential complex in Marbella, located in a privileged spot near the golf club and with premium quality specifi cations. You will (...)
€626,500
TSEA4557622
- Aloha, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 114 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Marbella West Region: Andalucía
Private residential complex with an innovative design inspired by the architecture of the area. 70 spacious 2 and 3 bedroom flats with magnificent terraces and 24 hour security. Each flat offers an (...)
€1,700,000
TSEA4201453
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 139 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 139 Area: Fuengirola Region: Andalucía
LAST ONE!!! FANTASTIC LOCATION JUST 350 METERS FROM THE SEA!!!!
This new development in the heart of Fuengirola will comprise 33 luxury apartments and penthouses with the most modern equipment and (...)
