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 (61,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 (61,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 (61,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 121 - 140 of 2653

Properties

Results 121 - 140 of 2653

€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 (...)

€535,000

TSEA5144878 - Coín, Costa Del Sol, Coin
Beds: 4 Baths: 2 M²: 131 Lot Size: 5,740 Area: Coin Region: Andalucía

Located just a few minutes from the charming village of Coín, this delightful country house offers the perfect combination of tranquillity, privacy and comfort, right in the heart of the Andalusian (...)

€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 (...)

€349,000

TSEA5144194 - Cártama, Costa Del Sol, Cartama
Beds: 3 Baths: 2 M²: 233 Lot Size: 2,536 Area: Cartama Region: Andalucía

Located on the outskirts of the village of Villafranco, this delightful country property enjoys excellent road access and is just a 5-minute drive from the A357 motorway, and 10 minutes from both (...)

€239,000

TSEA5144152 - Almachar, Costa Del Sol East
Beds: 3 Baths: 2 M²: 109 Lot Size: 3,869 Region: Andalucía

This charming Spanish home is set entirely on one level and is located just a nine-minute drive from Almáchar. The road leading to the property is mostly paved, with the final four kilometers along (...)

€429,000

TSEA5144131 - Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 2 M²: 138 Lot Size: 80 Area: Mijas and Mijas Costa Region: Andalucía

Spectacular 3-storey semi-detached villa for sale very close to La Cala de Mijas! This modern, spacious and very bright 4-bedroom, 3-bathroom villa is built to the highest standards. It has air (...)

€2,390,000

TSEA5144125 - Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M²: 296 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía

Spectacular villa that perfectly blends Mediterranean style with contemporary design, combining traditional charm with modern comfort and top-quality finishes. Located in the prestigious Buena Vista (...)

€985,000

TSEA5144044 - Fuengirola, Costa Del Sol, Fuengirola
Beds: 6 Baths: 4 M²: 218 Area: Fuengirola Region: Andalucía

Corner villa in Puebla Lucía, the most exclusive residential area in Fuengirola In the heart of Fuengirola, within the prestigious and gated community of Puebla Lucía, lies this bright (...)

€850,000

TSEA5143966 - Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 3 M²: 132 Area: Nerja and Malaga East Region: Andalucía

Cartujano Villas – Luxury and Privacy Just Steps from Burriana Beach Discover Cartujano Villas, an exclusive collection of only four detached villas in the heart of Nerja, just a short walk from (...)

€645,000

TSEA5143933 - Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 4 Baths: 3 M²: 227 Lot Size: 4,375 Area: Alhaurin el Grande Region: Andalucía

Fabulous Four Bedroom Finca This exceptional property is the very definition of a country finca. From its spacious four-bedroom accommodation to its extensive landscaped gardens, this meticulously (...)

€995,000

TSEA5143927 - Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 3 M²: 580 Lot Size: 701 Area: Nerja and Malaga East Region: Andalucía

This historic property is a large renovated old Mill, previously a working flour mill for the Larios family until approximately 60 years ago named Molino San Jose. The villa has three bedrooms, three (...)

€1,695,000

TSEA5143909 - La Mairena, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M²: 254 Lot Size: 2,750 Area: Marbella East Region: Andalucía

Spacious Family Villa with Panoramic Views in La Mairena This beautifully presented villa in La Mairena was originally built in 2009 and tastefully renovated in 2021, bringing it up to modern (...)

€1,869,000

TSEA5143879 - Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M²: 210 Area: Casares Region: Andalucía

Luxury villa with unrivalled Mediterranean views – Camarate del Golf, Casares Costa In the privileged setting of Camarate del Golf, one of the most exclusive residential areas of Casares Costa, (...)

€685,000

TSEA5143825 - Coín, Costa Del Sol, Coin
Beds: 4 Baths: 5 M²: 287 Lot Size: 630 Area: Coin Region: Andalucía

STUNNING FOUR BEDROOM, FIVE BATHROOM VILLA A must-see, substantially built and deceptively spacious, four-bedroom detached villa with four en-suite bathrooms, located within an exclusive and (...)

€1,395,000

TSEA5143783 - San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M²: 195 Lot Size: 420 Area: San Pedro Region: Andalucía

Discover this spectacular modern design villa for sale! Located on a 420 m² plot and with 195 m² of usable area, this property offers an exclusive and sophisticated lifestyle. Upon entering, you'll (...)

€3,685,000

TSEA5143681 - La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M²: 550 Lot Size: 1,805 Area: Mijas and Mijas Costa Region: Andalucía

New Development: Prices from 3,685,000 € to 3,685,000 €. [Beds: 5 - 5] [Baths: 5 - 5] [Built size: 550.00 m2 - 550.00 m2] I am pleased to present a unique opportunity: the sale of an off-plan (...)

Page 7 of 133

Current Featured Properties

€6,895,000

World class design-led villas with spectacular views - Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M²: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía

400,000€ discount if you purchase before completion! This is a sustainable luxury development of 18 individually designed villas situated in the 200-hectare country club estate of Real de La (...)

€2,250,000

TSEA4707427 - El Madroñal, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M²: 255 Lot Size: 1,666 Area: San Pedro Region: Andalucía

Welcome to your dream retreat! This magnificent 4 bedroom, 4 bathroom villa is located in the popular gated community of El Madroñal. Located at entrance number 1, making the villa easily accesible, (...)

€7,975,000

TSEA4712791 - La Mairena, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M²: 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 (...)

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