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 (42,36,37,38) 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 (42,36,37,38) 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 (42,36,37,38) GROUP BY p.id ORDER BY p.created DESC

Subcategories

Ground Floor - (11), Middle Floor - (11), Penthouse - (11)

Advanced Search

Results 181 - 200 of 2008

Properties

Results 181 - 200 of 2008

€470,000

TSEA5132500 - Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M²: 74 Area: Estepona Region: Andalucía

New Development: Prices from 470,000 € to 470,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 74.00 m2 - 74.00 m2] The new development offers a carefully selected mix of 1, 2 and 3 bedroom (...)

€1,750,000

TSEA5132254 - Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 2 M²: 356 Lot Size: 601 Area: Mijas and Mijas Costa Region: Andalucía

New Development: Prices from 1,750,000 € to 1,750,000 €. [Beds: 5 - 5] [Baths: 2 - 2] [Built size: 356.00 m2 - 356.00 m2] Exclusive Villa under construction in Riviera del Sol with Sea View We (...)

€1,295,000

TSEA5132158 - San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M²: 211 Lot Size: 1,272 Area: San Pedro Region: Andalucía

Nestled in the peaceful residential enclave of Alta Vista, perfectly positioned between San Pedro de Alcántara and Guadalmina, this inviting single-level villa presents a rare opportunity to create (...)

€399,950

TSEA5132149 - Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 2 M²: 176 Lot Size: 145 Area: Nerja and Malaga East Region: Andalucía

New Development: Prices from 399,950 € to 449,950 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 176.00 m2 - 179.00 m2] We present to you an exclusive residential development of 30 semi-detached (...)

€2,295,000

TSEA5132125 - La Capellania, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M²: 265 Lot Size: 601 Area: Fuengirola Region: Andalucía

Located next to La Capellanía, just five minutes from the charming Benalmádena Pueblo and directly beneath the iconic Buddhist Stupa in Retamar, this exceptional single-level villa has been (...)

€689,000

TSEA5131834 - Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 2 M²: 110 Lot Size: 6,902 Area: Ojen Region: Andalucía

Can you imagine waking up every morning surrounded by pure nature, in a private estate with panoramic views stretching across the Mediterranean, Gibraltar, and Africa? This hidden gem in the Altos de (...)

€495,000

TSEA5131741 - El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M²: 179 Lot Size: 602 Area: Mijas and Mijas Costa Region: Andalucía

Traditional house in El Faro in Mijas-Costa with two levels and with beautiful sea views offering in the main residence a living room with separate dining room and bright terrace, kitchen, two (...)

€850,000

TSEA5131735 - La Viñuela, Costa Del Sol East
Beds: 6 Baths: 4 M²: 320 Lot Size: 4,418 Region: Andalucía

This charming villa in Los Romanes, Málaga, perfectly combines traditional Spanish architecture with modern comfort. The main house features 4 bedrooms, including a spacious master suite, 3 full (...)

€449,000

TSEA5131732 - Arenas, Costa Del Sol East
Beds: 3 Baths: 1 M²: 176 Lot Size: 5,976 Region: Andalucía

Nestled in the beautiful hills of Arenas, this charming property offers breathtaking views of both the mountains and the Mediterranean Sea. Its the perfect retreat for those seeking peace, nature, (...)

€3,800,000

TSEA5131675 - Santa Clara, Costa Del Sol, Marbella East
Beds: 5 Baths: 3 M²: 592 Lot Size: 1,450 Area: Marbella East Region: Andalucía

Icon Signature – Santa Clara Golf, Marbella This unique property, located in the prestigious Santa Clara Golf urbanisation, offers spectacular views of the Mediterranean Sea, La Concha Mountain (...)

€1,200,000

TSEA5131642 - Torremuelle, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M²: 126 Lot Size: 831 Area: Mijas and Mijas Costa Region: Andalucía

Villa in La Perla de Torremuelle, perfect for renovation, located on a plot of 831 square meters with great development potential. The property offers the possibility of building a second floor, (...)

€1,150,000

TSEA5131582 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M²: 336 Area: Benalmadena Region: Andalucía

The villa with panoramic views of the Mediterranean from its peaceful and perfect location. Situated very close to the town of Benalmádena, in an exclusive complex of detached villas, it is (...)

€1,990,000

TSEA5131495 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M²: 533 Lot Size: 660 Area: Mijas and Mijas Costa Region: Andalucía

New Development: Prices from 1,990,000 € to 1,990,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 533.00 m2 - 533.00 m2] Welcome to an exclusive enclave of three impressive residences located (...)

€1,945,000

TSEA5131489 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M²: 551 Lot Size: 718 Area: Mijas and Mijas Costa Region: Andalucía

New Development: Prices from 1,945,000 € to 1,945,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 551.00 m2 - 551.00 m2] Welcome to an exclusive enclave of three impressive residences located (...)

€1,970,000

TSEA5131474 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M²: 551 Lot Size: 720 Area: Mijas and Mijas Costa Region: Andalucía

New Development: Prices from 1,970,000 € to 1,970,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 551.00 m2 - 551.00 m2] Welcome to an exclusive enclave of three impressive residences located (...)

€22,490,000

TSEA5131117 - Sierra Blanca, Costa Del Sol, Marbella
Beds: 7 Baths: 10 M²: 1,953 Lot Size: 2,013 Area: Marbella Region: Andalucía

An architecturally unique, south-facing property located in the exclusive gated community of Sierra Blanca on Marbella's prestigious Golden Mile. This brand-new mansion offers exceptional design, (...)

€325,000

TSEA5131069 - Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M²: 327 Lot Size: 2,994 Area: Coin Region: Andalucía

Nestled in the peaceful countryside northwest of Coín, just a 12-minute drive (6.5 km) from the village, this versatile country property offers a fantastic opportunity for those seeking privacy, (...)

€530,000

TSEA5131033 - Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M²: 290 Lot Size: 1,500 Area: Mijas and Mijas Costa Region: Andalucía

✅ Great Opportunity in Los Pinos, Alhaurín de la Torre! ???? Spacious Home with Endless Possibilities on a 1,500 m² Plot For sale: excellent detached house located in one of the most peaceful (...)

€1,549,000

TSEA5130982 - Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M²: 290 Lot Size: 643 Area: Estepona Region: Andalucía

Panoramic Views of the Mountains, Gibraltar, and Even Africa! Discover your dream home in the heart of Estepona — a truly stunning villa offering luxury, comfort, and unforgettable views that (...)

€4,450,000

TSEA5130820 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 7 Baths: 8 M²: 954 Lot Size: 2,175 Area: Benalmadena Region: Andalucía

This spectacular detached villa, located in the exclusive area of Benalmádena Costa, is an architectural gem that combines luxury, comfort, and design in a privileged setting. With an impressive (...)

Page 10 of 101

Current Featured Properties

€2,995,000

TSEA4831399 - El Padron, Costa Del Sol, Estepona
Beds: 6 Baths: 7 M²: 341 Lot Size: 3,000 Area: Estepona Region: Andalucía

ELEGANT HILLTOP VILLA IN EL PADRON, ESTEPONA This beautiful hilltop villa is the perfect escape for those seeking peace, privacy, and incredible views, all while staying close to everything Estepona (...)

€3,485,000

TSEA5156128 - Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M²: 573 Area: Benahavis Region: Andalucía

A top quality, new built contemporaty villa (2024), located in the sought after residential area of La Alqueria, Benahavís. South to west facing with views to mountains and some seaviews from the (...)

€1,645,000

TSEA4719550 - Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M²: 418 Lot Size: 10,000 Area: Casares Region: Andalucía

STUNNING VILLA IN CASARES WITH BREATHTAKING VIEWS. This magnificent villa is located in the beautiful landscape of Casares, offering a perfect blend of elegance and modern luxury. Set on a spacious (...)

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