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 (70,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 (70,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 (70,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 701 - 720 of 3305
€450,000
TSEA5080915
- Monda, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 163 Lot Size: 1,760 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 163 Lot Size: 1,760 Area: Marbella Region: Andalucía
Charming property with views, pool and covered terrace - near Marbella
Just 15 minutes from Marbella and 2 minutes from the cosy village of Monda is this charming 3-bedroom house, surrounded by (...)
€285,000
TSEA5080864
- Torrox Costa, Costa Del Sol East
Beds: 2 Baths: 1 M2: 70 Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Region: Andalucía
Great location of this townhouse in Torrox Costa, close to the beach and to all amenities. Also a public school is just a few minutes away. The townhouse offers a patio at the entrance, a large (...)
€435,000
TSEA5080747
- Montemar, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 96 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 96 Area: Torremolinos Region: Andalucía
Set in peaceful Montemar, this beautifully kept 4-bedroom townhouse delivers easy Costa living with everything on your doorstep. The ground floor offers a generous semi open-plan kitchen—fully (...)
€830,000
TSEA5080618
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 3 M2: 295 Lot Size: 6,000 Area: Estepona Region: Andalucía
Beds: 6 Baths: 3 M2: 295 Lot Size: 6,000 Area: Estepona Region: Andalucía
Charming country house with a 6,000 m² plot and panoramic views
Located in a privileged natural setting, this spectacular country house offers a perfect combination of comfort, privacy, and nature. (...)
€1,595,000
TSEA5080336
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 385 Lot Size: 178 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 385 Lot Size: 178 Area: Marbella West Region: Andalucía
Discover this charming and unique townhouse for sale in Aloha, located within the exclusive gated community of Aloha Real in the heart of Nueva Andalucía, Marbella. Perfectly positioned along the (...)
€1,150,000
TSEA5080309
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 204 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 204 Area: Marbella East Region: Andalucía
Discover a residence that beautifully blends traditional Andalusian charm with modern-day sophistication, located in the highly sought-after Lomas del Marbella Club Pueblo. Just under one kilometre (...)
€1,350,000
TSEA5080300
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 3 M2: 210 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 3 M2: 210 Area: Marbella East Region: Andalucía
Tucked away in the enchanting and prestigious enclave of Lomas del Marbella Club Pueblo less than a kilometer from Marbella's golden coastline. This tastefully renovated 3-bedroom townhouse blends (...)
€509,000
TSEA5080270
- Cómpeta, Costa Del Sol East
Beds: 2 Baths: 2 M2: 229 Lot Size: 2,497 Region: Andalucía
Beds: 2 Baths: 2 M2: 229 Lot Size: 2,497 Region: Andalucía
Exclusive Charming white villa located close to the village of Cómpeta, offering peace, privacy, and beautiful views of the surrounding countryside. This well-kept detached property is distributed (...)
€1,800,000
TSEA5080252
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 421 Lot Size: 10,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 421 Lot Size: 10,000 Area: Mijas and Mijas Costa Region: Andalucía
In an English Country Garden, in a beautiful Country House you think of beautiful flowers like hydrangea, foxglove, sea pea, roses, and well kept lawns, but, here in Spain we are going to present (...)
€1,200,000
TSEA5080243
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 503 Lot Size: 755 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 503 Lot Size: 755 Area: Mijas and Mijas Costa Region: Andalucía
NEW EXCLUSIVE LISTING!!
Perfect clever investment in Lower Calahonda, Mijas Costa.
5 LARGE BEDROOMS AND 4 BATHS
Build 503m²
Basement 200m²
Terrace 100m²
Garden 755m²
Located on a quiet (...)
€640,000
TSEA5080234
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 187 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 187 Area: Estepona Region: Andalucía
Large Family Townhouse in Estepona – Prime Location on Calle Juan Blanco
Discover this beautifully maintained 3-bedroom, 3-bathroom townhouse, perfectly positioned in the heart of Estepona. (...)
€650,000
TSEA5080180
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 122 Lot Size: 515 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 122 Lot Size: 515 Area: Nerja and Malaga East Region: Andalucía
Charming Detached Villa with Private Pool & Panoramic Views in Nerja
Nestled between the sought-after areas of Capistrano Pueblo and San Juan de Capistrano, this beautifully traditional detached (...)
€760,000
TSEA5080183
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 160 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 160 Area: Estepona Region: Andalucía
Luxurious renovated townhouse on the beach side – ready to move in within weeks
Welcome to this beautiful townhouse, located on the sought-after beach side of the coast, where comfort, style and (...)
€425,000
TSEA5080153
- Guadiaro, Costa Del Sol, Sotogrande
Beds: 4 Baths: 4 M2: 150 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 4 M2: 150 Area: Sotogrande Region: Andalucía
CHARMING RUSTIC VILLAGE HOUSE WITH EXCEPTIONAL QUALITIES AND MOUNTAIN & SEA VIEWS
Located in the village of Guadiaro, this beautiful rustic-style townhouse stands out for its superb finishes, (...)
€580,000
TSEA5080009
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 66 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 66 Area: Mijas and Mijas Costa Region: Andalucía
Discover the essence of coastal living in this stylish 2-bedroom, 2-bathroom townhouse, located in the prestigious Doña Lola resort, set directly on the beachfront in Calahonda. With 57 m² of (...)
€1,290,000
TSEA5079925
- Rincón de la Victoria, Costa Del Sol East
Beds: 5 Baths: 4 M2: 603 Lot Size: 2,197 Region: Andalucía
Beds: 5 Baths: 4 M2: 603 Lot Size: 2,197 Region: Andalucía
Welcome to this magnificent villa, a true gem nestled in the most exclusive residential area of Rincón de la Victoria.
Located in the lower part of Cotomar, this property offers a privileged (...)
€870,000
TSEA5079868
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 334 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 334 Area: Marbella Region: Andalucía
Spacious semi-detached house with terrace, garden, swimming pool and double garage in one of the best residential areas of Marbella
Located in a quiet gated community with landscaped gardens and (...)
€4,900,000
TSEA5079865
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 4 Baths: 6 M2: 562 Lot Size: 1,342 Area: Marbella Region: Andalucía
Beds: 4 Baths: 6 M2: 562 Lot Size: 1,342 Area: Marbella Region: Andalucía
Exquisite Andalusian-Style Family Villa in Prestigious Sierra Blanca, Marbella
Nestled in the heart of the exclusive gated community of Urbanización Marbella Sierra Blanca, this elegant (...)
€4,595,000
TSEA5079424
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 476 Lot Size: 1,164 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 476 Lot Size: 1,164 Area: Marbella West Region: Andalucía
Set in a peaceful and prestigious location, Villa Provence is a remarkable 5-bedroom residence that masterfully blends the romantic charm of Provençal French architecture with the clean lines and (...)
€1,250,000
TSEA5079163
- El Rosario, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 275 Lot Size: 1,091 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 275 Lot Size: 1,091 Area: Marbella East Region: Andalucía
Spacious Villa with Private Pool in a Privileged Location in El Rosario – Your Ideal Lifestyle Awaits!
Situated on a flat plot in the quiet and secure residential area of El Rosario, Marbella, (...)
Current Featured Properties
€7,975,000
TSEA4712791
- La Mairena, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 1,254 Lot Size: 49,832 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 1,254 Lot Size: 49,832 Area: Marbella East Region: Andalucía
ASTONISHING LUXURY VILLA WITH SEA VIEWS IN LA MAIRENA
Astonishing luxury villa nestled in a secluded oasis of tranquility, close to La Mairena, offering unparalleled privacy amidst unspoiled natural (...)
€2,750,000
TSEA4446295
- Manilva, Costa Del Sol, Manilva
Beds: 5 Baths: 7 M2: 480 Lot Size: 1,400 Area: Manilva Region: Andalucía
Beds: 5 Baths: 7 M2: 480 Lot Size: 1,400 Area: Manilva Region: Andalucía
SEIZE THE OPPORTUNITY: SPECTACULAR HOME WITH MODERN AMENITIES AWAITS!!
With 5 bedrooms and 7 bathrooms, it is perfect for a large family or for those who love to entertain guests. The property (...)
€465,000
TSEA4292032
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
LARGE GARDEN, AMAZING VIEWS AND GYM!!!
In an incomparable enclave with magnificent views, a project of 40 semi-detached and semi-detached houses with 3 and 4 bedrooms with large terraces to enjoy (...)
