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 (48,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 (48,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 (48,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 2561 - 2580 of 2656 €6,000,000
TSEA3333502
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 8 Baths: 8 M2: 900 Lot Size: 4,100 Area: San Pedro Region: Andalucía
Beds: 8 Baths: 8 M2: 900 Lot Size: 4,100 Area: San Pedro Region: Andalucía
A totally reformed substantial palatial Arabian styled villa which offers eight-bedroom suites which incorporate 2 self-contained suites. The villa has four-meter height impressive double entrance (...)
€636,300
TSEA3330436
- San Martín de Tesorillo, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 200 Lot Size: 28,000 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Lot Size: 28,000 Area: Sotogrande Region: Andalucía
Incredible 28,000 square meters estate located in San Enrique del Tesorillo. This wonderful estate consists of a house of 200 square meters with outdoor garage, composed of three bedrooms, large (...)
€6,800,000
TSEA3329614
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 7 Baths: 7 M2: 1,000 Lot Size: 4,500 Area: San Pedro Region: Andalucía
Beds: 7 Baths: 7 M2: 1,000 Lot Size: 4,500 Area: San Pedro Region: Andalucía
Detached Villa, Guadalmina Baja, Costa del Sol.
Built 1000 m², Terrace 250 m², Garden/Plot 4500 m².
Setting : Commercial Area, Beachside, Close To Golf, Close To Shops, Close To Sea, (...)
€2,300,000
TSEA3329542
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 733 Lot Size: 6,860 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 733 Lot Size: 6,860 Area: Estepona Region: Andalucía
FANTASTIC VILLA OF HIGH ARCHITECTURAL LEVEL, on three floors with impressive panoramic views of the Mediterranean Sea and the mountains. Very exceptional details, such as its own winery, private (...)
€1,890,000
MORE THAN JUST A VILLA...A REFLECTION OF WHO YOU ARE !
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 602 Lot Size: 756 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 602 Lot Size: 756 Area: Benahavis Region: Andalucía
MORE THAN JUST A VILLA...A REFLECTION OF WHO YOU ARE!!!
A truly UNIQUE AND SPECIAL project. There is nowhere else quite like this. Designed especially for you where an authentic philosophy of life (...)
€200,000
TSEA3313990
- Frigiliana, Costa Del Sol East
Beds: 2 Baths: 1 M2: 44 Lot Size: 14,797 Region: Andalucía
Beds: 2 Baths: 1 M2: 44 Lot Size: 14,797 Region: Andalucía
Situated just a 7 minutes drive from the beautiful mountain pueblo of Frigliana, this cortijo is surrounded by 15´000m2 of pristine avocado plantations.
Upon entering this property you are (...)
€1,700,000
TSEA3306496
- Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 4 Baths: 4 M2: 358 Lot Size: 3,090 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 4 M2: 358 Lot Size: 3,090 Area: Sotogrande Region: Andalucía
Attractive and charming 4-bedroom Spanish-style villa, designed and built for the current owner/occupier to Northern European standards
Plot size 3,090 m2.
House built 385m2
Building completed in (...)
€212,100
TSEA2964851
- Salares, Costa Del Sol East
Beds: 3 Baths: 4 M2: 300 Lot Size: 300 Region: Andalucía
Beds: 3 Baths: 4 M2: 300 Lot Size: 300 Region: Andalucía
Brand-new semi-detached house in Salares. The house has a large living room with fireplace and access to a terrace, spacious and fully equipped kitchen, it has three bedrooms with fitted wardrobes (...)
€148,400
TSEA2425934
- Riogordo, Costa Del Sol East
Beds: 2 Baths: 1 M2: 167 Lot Size: 167 Region: Andalucía
Beds: 2 Baths: 1 M2: 167 Lot Size: 167 Region: Andalucía
Nice village house in Riogordo. Central location. Authentic country house. On the ground floor is a commercial space of 63.95m2. The house has 2 floors. It has living room with fireplace, 2 bedrooms (...)
€446,000
TSEA3105226
- Algarrobo, Costa Del Sol East
Beds: 8 Baths: 3 M2: 300 Lot Size: 450 Region: Andalucía
Beds: 8 Baths: 3 M2: 300 Lot Size: 450 Region: Andalucía
Fantastic opportunity to purchase a complete building of new construction in Algarrobo town. The building itself, gives to two streets, the ground floor consists of one apartment: living room, large (...)
€1,500,000
TSEA3209428
- Benajarafe, Costa Del Sol East
Beds: 8 Baths: 5 M2: 460 Lot Size: 80,000 Region: Andalucía
Beds: 8 Baths: 5 M2: 460 Lot Size: 80,000 Region: Andalucía
Magnificent villa in Benajarafe alto, facing the Mediterranean Sea, on the Costa del Sol. Consists of seven rooms and four bathrooms and also an entire apartment for guests. All rooms with fitted (...)
€899,000
TSEA3302554
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 265 Lot Size: 10,000 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 265 Lot Size: 10,000 Area: Estepona Region: Andalucía
Discover your dream home in the serene surroundings of Estepona!
This beautifully detached villa offers an unparalleled living experience with its high level of finishing and breathtaking views (...)
€475,000
TSEA3301060
- Monda, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 277 Lot Size: 7,100 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 277 Lot Size: 7,100 Area: Marbella Region: Andalucía
Opportunity at Bargain price! Lovely country house set between the picturesque Andalusian villages of Monda and Guaro, just a few kilometres away from Marbella, with stunning views over the (...)
€695,000
TSEA3288319
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 3 M2: 315 Lot Size: 2,148 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 3 M2: 315 Lot Size: 2,148 Area: Nerja and Malaga East Region: Andalucía
Country house in Nerja with a view of the sea and and mountains. The villa is distributed over 2 floors and both floors are accessed independantly.
From the main entrance there is a living-dining (...)
€900,000
TSEA3287659
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 2 M2: 320 Lot Size: 28,640 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 2 M2: 320 Lot Size: 28,640 Area: Nerja and Malaga East Region: Andalucía
Fantastic Villa set in the countryside surrounded by an abundance of fruit trees and plants. The ground floor of the villa comprises of a spacious lounge with fireplace, dining area, fully fitted (...)
€1,000,000
TSEA3278446
- Torrox, Costa Del Sol East
Beds: 8 Baths: 8 M2: 500 Lot Size: 3,000 Region: Andalucía
Beds: 8 Baths: 8 M2: 500 Lot Size: 3,000 Region: Andalucía
A rare opportunity to purchase one of the most outstanding properties in the Axarquia. The accommodation, both indoors and outdoors, offers everything the discerning buyer could wish for, including a (...)
€1,299,000
TSEA3258919
- Frigiliana, Costa Del Sol East
Beds: 5 Baths: 5 M2: 450 Lot Size: 2,239 Region: Andalucía
Beds: 5 Baths: 5 M2: 450 Lot Size: 2,239 Region: Andalucía
Nestled in the serene and sought-after community of Cortijos San Rafael, just off the Frigiliana road near Nerja, this outstanding detached villa—completed in 2008—offers an exceptional standard (...)
€1,795,000
TSEA3250426
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 639 Lot Size: 939 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 639 Lot Size: 939 Area: Benahavis Region: Andalucía
Situated on a gated community just a short walk from the beautiful village of Benahavis and all its famous restaurants, and just seven kilometres inland from the glamourous coastal hotspots of Puerto (...)
€915,000
TSEA3240280
- Coín, Costa Del Sol, Coin
Beds: 6 Baths: 3 M2: 473 Lot Size: 2,654 Area: Coin Region: Andalucía
Beds: 6 Baths: 3 M2: 473 Lot Size: 2,654 Area: Coin Region: Andalucía
CLOSE TO LA TROCHA COMERCIAL CENTER! Andalousian style villa in town with pool, tropical gardens and fruit trees. Has its own well.
The house offers a large outdoor space with patio, sitting area and (...)
€8,000,000
TSEA3234529
- Antequera, Costa Del Sol, Antequera
Beds: 8 Baths: 8 M2: 1,100 Lot Size: 298,000 Area: Antequera Region: Andalucía
Beds: 8 Baths: 8 M2: 1,100 Lot Size: 298,000 Area: Antequera Region: Andalucía
Huge finca of 298 hectares (298.000 square meters) located 21 kms West of Antequera, between Bobadilla and Campillos, destined for agricultural use. Of the 298 has, 175 has are made up with (...)
Current Featured Properties
€6,900,000
EMPTY
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M2: 890 Lot Size: 2,872 Area: Marbella West Region: Andalucía
Beds: 6 Baths: 6 M2: 890 Lot Size: 2,872 Area: Marbella West Region: Andalucía
URB. LA CERQUILLA, NUEVA ANDALUCIA, MARBELLA
A great, recently renovated villa with a perfect fusion between contemporary design and Andalusian style. Located in the sought after residential area of (...)
€595,000
TSEA4927306
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 150 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 150 Area: Benahavis Region: Andalucía
ABSOLUTELY FABULOUS LA HEREDIA HOUSE RECENTLY REDUCED IN PRICE.
This stunning, detached, stand-alone house is one of the few original homes in the charming and picturesque village of La Heredia, (...)
€4,950,000
TSEA4790245
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 488 Lot Size: 970 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 488 Lot Size: 970 Area: Marbella West Region: Andalucía
Nestled within the illustrious enclave of Nueva Andalucia, This new development provides residents a luxurious escape that embodies the true essence of luxury living. With its privileged location in (...)
