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 81 - 100 of 2008

Properties

Results 81 - 100 of 2008

€825,000

TSEA5145994 - Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M²: 137 Lot Size: 563 Area: Estepona Region: Andalucía

Detached Villa in Atalaya Baja, Estepona – Spacious, Bright & Full of Potential Located in the exclusive Atalaya Baja urbanization, this charming detached villa sits on a generous 563 m² (...)

€1,484,700

TSEA5145973 - Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M²: 303 Lot Size: 1,149 Area: Benalmadena Region: Andalucía

SPECTACULAR AND MODERN VILLA WITH SEA VIEWS We are delighted to present this very special villa with its unique, modernist-inspired design, located in one of the most privileged and growing areas of (...)

€1,900,000

TSEA5145913 - El Paraiso, Costa Del Sol, Estepona
Beds: 6 Baths: 5 M²: 458 Lot Size: 1,271 Area: Estepona Region: Andalucía

Discover a fantastic opportunity to create your dream home in the sought-after area of El Paraiso, Estepona. This spacious 6-bedroom, 5-bathroom villa is ready for a complete reform and is perfectly (...)

€1,790,000

TSEA5145895 - Hacienda Las Chapas, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M²: 456 Lot Size: 1,664 Area: Marbella East Region: Andalucía

FOR INVESTORS! VILLA WITH SEA VIEWS & RENOVATION POTENTIAL IN HACIENDA LAS CHAPAS. Located in the prestigious gated community of Hacienda Las Chapas, this villa presents an excellent investment (...)

€975,000

TSEA5145856 - Valtocado, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M²: 112 Lot Size: 3,533 Area: Mijas and Mijas Costa Region: Andalucía

For Sale – Authentic Andalusian Finca with Sea Views, Private Pool, Casita & Wellness Features in Mijas Perched in the hills above the Costa del Sol, this exquisite Andalusian finca offers the (...)

€1,295,000

TSEA5145832 - Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M²: 327 Lot Size: 1,005 Area: Mijas and Mijas Costa Region: Andalucía

Set in the peaceful surroundings of Mijas Golf, this frontline golf villa offers a blend of privacy, comfort, and Mediterranean charm. With a 1,005 m² plot and 327 m² built, the property is (...)

€400,000

TSEA5145808 - La Línea, Costa Del Sol, San Roque
Beds: 3 Baths: 2 M²: 150 Area: San Roque Region: Andalucía

Incredible 3-Bedroom Chalet for Sale in Venta Melchor with Views of Gibraltar This magnificent home has been designed to make the most of natural light, allowing it to flow through every room and (...)

€829,000

TSEA5145739 - Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M²: 240 Lot Size: 500 Area: Fuengirola Region: Andalucía

This exclusive luxury villa, combines modern architecture with top-quality construction and a carefully designed layout. The home is filled with natural light thanks to large floor-to-ceiling windows (...)

€4,500,000

TSEA5145691 - Benahavís, Costa Del Sol, Benahavis
Beds: 8 Baths: 9 M²: 883 Lot Size: 4,746 Area: Benahavis Region: Andalucía

This exclusive villa is a classic jewel of Mediterranean style in a prestigious location. With direct access to the golf course. Situated in the prestigious Marbella Club Golf Resort on the Costa (...)

€748,000

TSEA5145256 - Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 3 M²: 188 Lot Size: 289 Area: Nerja and Malaga East Region: Andalucía

Located between Frigiliana and Nerja, this charming Andalusian-style property combines a comfortable main house with extraordinary exteriors, set on a spectacular plot of over 6,000 m2. Surrounded by (...)

€1,500,000

TSEA5145217 - Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M²: 209 Lot Size: 5,000 Area: Mijas and Mijas Costa Region: Andalucía

Property Description: Casanicky – Luxury Villa, Boutique B&B & Rare Investment Opportunity in Mijas Welcome to Casanicky, a unique property in the heart of Mijas, Málaga province, offered (...)

€2,100,000

TSEA5145193 - Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M²: 350 Area: Marbella West Region: Andalucía

Nice Villa with espectacular open mountain, landscape and pool views, in Nueva Andalucia, Located in a peaceful and private location just a few minutes from Puerto Banus and Marbella at walking (...)

€349,000

TSEA5145187 - El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M²: 68 Lot Size: 290 Area: Mijas and Mijas Costa Region: Andalucía

Charming two bedroom detached bungalow in the popular area of El Faro, just a 5 minute drive to both Fuengirola and La Cala village. The beach is just a short 300 metre stroll away! This property has (...)

€5,995,000

TSEA5145121 - The Golden Mile, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M²: 720 Lot Size: 2,000 Area: Marbella East Region: Andalucía

This substantial property is set in a privileged position within walking distance of the beach and all amenities, offering a high level of privacy being accessed via a private cul-de-sac. There is a (...)

€14,000,000

TSEA5145118 - New Golden Mile, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M²: 880 Lot Size: 2,610 Area: Estepona Region: Andalucía

Luxury Beachfront Villa in Casasola – New Golden Mile, Estepona Introducing a classic beachfront villa in Casasola, one of the most prestigious residential areas on Estepona's New Golden Mile. (...)

€1,460,000

TSEA5145040 - El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M²: 336 Lot Size: 505 Area: Mijas and Mijas Costa Region: Andalucía

Welcome to your beachfront retreat! This recently refurbished villa, perfectly situated between Fuengirola and La Cala de Mijas, is designed for both comfort and seaside living. With five bedrooms (...)

€299,000

TSEA5144968 - Calypso, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M²: 72 Lot Size: 205 Area: Mijas and Mijas Costa Region: Andalucía

Charming South-Facing Bungalow in Calypso – Walking Distance to the Beach! Discover this delightful bungalow in the sought-after area of Calypso, perfectly located just a short stroll from the (...)

€895,000

TSEA5144848 - Torre del Mar, Costa Del Sol East
Beds: 6 Baths: 5 M²: 410 Lot Size: 558 Region: Andalucía

This stunning villa with 6 bedrooms and 5 bathrooms is located in one of Torre del Mar's most sought-after areas, offering the perfect blend of modern comfort and classic Mediterranean charm. With a (...)

€3,500,000

TSEA5144812 - Sotogrande, Costa Del Sol, Sotogrande
Beds: 4 Baths: 4 M²: 367 Lot Size: 2,900 Area: Sotogrande Region: Andalucía

New Development: Prices from 3,500,000 € to 3,500,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 367.00 m2 - 367.00 m2] Located among golf courses, this villa embodies a life of serenity and (...)

€695,000

TSEA5144791 - Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M²: 230 Lot Size: 1,382 Area: Mijas and Mijas Costa Region: Andalucía

With incredible views down the valley to the coast of Málaga and the sea, this impressive, detached villa can be used as either a spacious family home or has the possibility of being a high-end (...)

Page 5 of 101

Current Featured Properties

€1,490,000

Control your home with your smart device! - Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M²: 371 Lot Size: 323 Area: Benahavis Region: Andalucía

ULTIMATE IN DESIGNER LIVING IN BEAUTIFUL MARBELLA!!! Villas in a unique project with an emphasis on design to meet the requirements of the most demanding client. Located on a privileged plot, the (...)

€1,990,000

TSEA4979719 - Río Real, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M²: 504 Lot Size: 903 Area: Marbella East Region: Andalucía

Villa Fantastica is a luxurious property located in the breathtaking surroundings of Marbella. The villa boasts 4 bedrooms, 4 bathrooms, and a built area of 504 square meters. Its exceptional German (...)

€8,800,000

Detached Villa in Marbella - Marbella, Costa Del Sol, Marbella
Beds: 6 Baths: 7 M²: 1,071 Lot Size: 2,090 Area: Marbella Region: Andalucía

This development consists of eight contemporary villas in a gated community inside the prestigious Atalaya de Rio Verde urbanization. All houses have more than 1.000 m2 enclosed areas with a plot (...)

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