TSEA5138848 - The Spanish Estate Agent

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 (44,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 (44,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 (44,42,43,44,45) GROUP BY p.id ORDER BY p.created DESC

Subcategories

Detached - (2652), Semi Detached - (2652), Terraced - (2652), Finca - (2652)

Advanced Search

Results 41 - 60 of 2639

Properties

Results 41 - 60 of 2639

€900,000

TSEA5154904 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M²: 280 Lot Size: 407 Area: Marbella West Region: Andalucía

For Sale in Nueva Andalucía – La Campana We present a beautiful house in Nueva Andalucía, located in the La Campana area and in excellent condition. The property features three spacious (...)

€1,800,000

TSEA5154859 - New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M²: 419 Lot Size: 419 Area: Estepona Region: Andalucía

New Development: Prices from 1,800,000 € to 1,800,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 419.00 m2 - 419.00 m2] Discover the collection of eight exclusive designed residential villas, (...)

€2,650,000

TSEA5154856 - New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M²: 372 Lot Size: 567 Area: Estepona Region: Andalucía

New Development: Prices from 2,650,000 € to 2,650,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 372.00 m2 - 372.00 m2] Discover the collection of eight exclusive designed residential villas, (...)

€3,495,000

TSEA5154823 - Gaucín, Costa Del Sol, Gaucin
Beds: 4 Baths: 5 M²: 525 Lot Size: 40,000 Area: Gaucin Region: Andalucía

Stunning Rural Villa in Gaucín with Panoramic Views Nestled in the picturesque Andalusian countryside, this impressive villa built in 2008 offers a perfect blend of rustic charm and modern comfort. (...)

€244,000

TSEA5154787 - San Roque, Costa Del Sol, San Roque
Beds: 3 Baths: 1 M²: 95 Area: San Roque Region: Andalucía

Detached house in Carteya (San Roque Pueblo, Costa del Sol) In the heart of the historic center of San Roque, next to the Church and the Mirador Poeta Domingo de Mena, lies this detached house that (...)

€695,000

TSEA5153797 - Arenas, Costa Del Sol East
Beds: 3 Baths: 3 M²: 183 Lot Size: 4,284 Region: Andalucía

Are you dreaming of a life under the Spanish sun, surrounded by peace, space and ultimate comfort? This bright and elegant villa, located between Vélez-Málaga and the charming village of Arenas, (...)

€2,295,000

TSEA5153674 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 3 M²: 222 Lot Size: 721 Area: Marbella West Region: Andalucía

Detached Andalusian-Style Villa in Nueva Andalucía — Walk to Puerto Banús & the Beach Tucked away in a quiet cul-de-sac, this charming Andalusian-style villa offers privacy, stunning views (...)

€1,092,500

TSEA5153542 - Los Pacos, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M²: 349 Lot Size: 250 Area: Mijas and Mijas Costa Region: Andalucía

Appointments for viewing is in January 2026 -The property is rented until end of June 2026. Contact us for more informacion. Amazing independent villa for sale in Los Pacos -beautiful seaviews, (...)

€340,000

TSEA5153530 - San Roque, Costa Del Sol, San Roque
Beds: 4 Baths: 3 M²: 270 Lot Size: 2,500 Area: San Roque Region: Andalucía

Spacious Independent Villa in San Roque Pueblo – Private Pool, Garden, and Special Land Offer! Discover this elegant independent house in the charming heart of San Roque Pueblo, built in 2005 and (...)

€288,000

TSEA5153482 - Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 5 Baths: 1 M²: 235 Lot Size: 2,300 Area: Nerja and Malaga East Region: Andalucía

UNIQUE OPPORTUNITY: Authentic Mill House in Los Dioses - A Gem Full of Potential Discover this exceptional property in the picturesque hamlet of Los Dioses, just 1.5 km from the charming village of (...)

€2,200,000

TSEA5153254 - San Roque Club, Costa Del Sol
Beds: 5 Baths: 5 M²: 658 Lot Size: 1,408 Region: Andalucía

This beautifully renovated villa is located in one of Sotogrande's most prestigious areas, just steps from the world-renowned Valderrama Golf Course. Designed in an elegant Mediterranean style and (...)

€578,000

TSEA5153134 - Canillas de Albaida, Costa Del Sol East
Beds: 3 Baths: 3 M²: 135 Lot Size: 2,500 Region: Andalucía

This charming country house in Canillas de Albaida, Malaga, offers a harmonious combination of rustic charm and modern comfort. The property, on one floor, is distributed in three bedrooms with (...)

€10,900,000

TSEA5153119 - Aloha, Costa Del Sol, Marbella West
Beds: 6 Baths: 7 M²: 702 Lot Size: 2,349 Area: Marbella West Region: Andalucía

Aloha 40 is a true retreat set in the exclusive Aloha neighborhood at the heart of Marbella's Golf Valley. This impressive residence is located within a secure gated community and enjoys a privileged (...)

€5,900,000

TSEA5153068 - Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 5 M²: 429 Lot Size: 1,250 Area: Marbella East Region: Andalucía

Marbella – Exceptional Contemporary Villa, Sold Furnished, in the Exclusive Rio Real Area, Next to the Golf This stunning villa, fully renovated in 2023 with the finest materials, is south-facing (...)

€1,200,000

TSEA5152990 - Sotogrande Alto, Costa Del Sol, Sotogrande
Beds: 4 Baths: 3 M²: 413 Lot Size: 1,167 Area: Sotogrande Region: Andalucía

Elegant Villa in Sotogrande Alto with Mediterranean Charm and Open Views Located in one of the most peaceful and established areas of Sotogrande Alto, this villa combines traditional Mediterranean (...)

€2,600,000

TSEA5152978 - San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 5 M²: 420 Lot Size: 395 Area: San Pedro Region: Andalucía

Welcome to this spectacular corner semi-detached house, located just 250 meters from the promenade and the vibrant San Pedro boulevard! This area is renowned for being one of the most sought-after on (...)

€600,000

TSEA5152948 - Pelayo, Costa de la Luz
Beds: 7 Baths: 3 M²: 500 Lot Size: 11,711 Region: Andalucía

Exclusive urban estate set on three plots totaling 11,000 m², located in Pelayo just 5 minutes from Algeciras and 15 minutes from Tarifa, bordering Los Alcornocales Natural Park and offering an (...)

€1,390,000

TSEA5152159 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 6 Baths: 6 M²: 346 Lot Size: 534 Area: Marbella West Region: Andalucía

Modern beautiful newly renovated 3 floor villa located in the heart of Nueva Andalucia very close to famous padelclub Real Club Padel. The villa has a private pool beautiful garden and parking. (...)

€2,195,000

TSEA5152036 - San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M²: 382 Lot Size: 609 Area: San Pedro Region: Andalucía

Welcome to this charming beachside villa with private pool in San Pedro! Just 300 meters from the golden sands of the Mediterranean, this stunning 4-bedroom villa offers the perfect blend of coastal (...)

€595,000

TSEA5152030 - Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 6 Baths: 4 M²: 418 Lot Size: 4,905 Area: Alhaurin el Grande Region: Andalucía

Exclusively with us! Attention investors and large families! This could be your opportunity! This is a very large country house with a built area of 368m2, a 50m2 pool, and a 4905m2 plot (...)

Page 3 of 132

Current Featured Properties

€5,495,000

TSEA4784011 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M²: 592 Lot Size: 1,274 Area: Marbella West Region: Andalucía

Set within a development of 5 brand new luxury villas, This villa enjoys an elevated position within the prestigious Golf Valley of Nueva Andalucia, providing scenic mountain and sea views. Designed (...)

€1,750,000

Deatched Villa Malaga - Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M²: 186 Lot Size: 535 Area: Malaga Region: Andalucía

A unique development of 10 villas The development offers different housing solutions that adapt to the needs of each client, choose the layout from a wide variety of options. A modern and functional (...)

€1,535,000

TSEA5021377 - Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M²: 282 Lot Size: 528 Area: Mijas and Mijas Costa Region: Andalucía

The villas are located in the exclusive Las Farolas Urbanisation of Mijas Costa, an area that blends tranquillity with close proximity to top-tier amenities. Just a few minutes' walk from the (...)

Intellectual Property :: Real Estate Component by theThinkery.net. v3.3.5