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,68,69,70)
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,68,69,70)
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,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 301 - 320 of 757 €595,000
TSEA5055076
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 145 Lot Size: 60 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Lot Size: 60 Area: Estepona Region: Andalucía
This beautifully renovated townhouse offers modern design and comfort. It includes three bedrooms, two bathrooms, and a guest toilet. The master bedroom has an ensuite with underfloor heating, which (...)
€999,999
TSEA5054731
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 3 M2: 174 Area: Marbella Region: Andalucía
Beds: 7 Baths: 3 M2: 174 Area: Marbella Region: Andalucía
Historic House in the Heart of Marbella's Old Town –
Located on one of the most iconic streets in Marbella's historic center, this charming three-story home with a rooftop terrace features (...)
€375,000
TSEA5053303
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
Renovated Traditional Townhouse with Rooftop Solarium & Investment Potential
Mijas Pueblo location & Panoramic views
Located on the characterful cobbled streets near Bar Niño and the (...)
€496,000
TSEA5053300
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 2 M2: 174 Area: Estepona Region: Andalucía
Beds: 5 Baths: 2 M2: 174 Area: Estepona Region: Andalucía
Unique opportunity in the heart of Estepona!
Are you looking for a home that combines comfort, style, and a privileged location? This is your chance!
Located just meters from the Town Hall and the (...)
€2,695,000
TSEA5053147
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 266 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 266 Area: Marbella East Region: Andalucía
This brand new renovation project is a beautifully crafted 5-bedroom, 5-bathroom Town Villa located on Marbella's prestigious Golden Mile. Blending contemporary Scandinavian elegance with (...)
€456,000
TSEA5052049
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 1 M2: 170 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 1 M2: 170 Area: Benalmadena Region: Andalucía
Located in the heart of Arroyo de la Miel, on a quiet street that ensures both peace and privacy, this bright and charming townhouse offers the perfect blend of central location and a tranquil (...)
€520,000
TSEA5051917
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 81 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Estepona Region: Andalucía
Nestled in a sought-after and well-maintained urbanization in Los Altos del Paraíso, this beautifully presented 2-bedroom, 2-bathroom townhouse offers the perfect blend of comfort, style, and (...)
€530,000
TSEA5051554
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 240 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 240 Area: Estepona Region: Andalucía
Spacious 5-Bedroom Townhouse with Stunning Sea Views
Discover this exceptional townhouse in one of the coast's most sought-after areas, just minutes from the beautiful beaches of Costalita. Located (...)
€437,000
TSEA5051536
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
We present this exclusive semi-detached single-family home, located in one of the quietest and most sought-after areas of Mijas, specifically in Calahonda, a privileged residential area that combines (...)
€437,000
TSEA5051479
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
We present this exclusive semi-detached single-family home, located in one of the quietest and most sought-after areas of Mijas, specifically in Calahonda, a privileged residential area that combines (...)
€299,000
TSEA5051473
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 60 Lot Size: 116 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 60 Lot Size: 116 Area: Mijas and Mijas Costa Region: Andalucía
Recently Renovated and Ready to Fall in Love – Charming Home with Large Terrace and Expansion Potential in Mijas Pueblo
We present to you a unique property, fully renovated with style and (...)
€649,900
TSEA5051341
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 220 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Area: Mijas and Mijas Costa Region: Andalucía
We present this stunning townhouse with 3 bedrooms and 3 bathrooms, located in the exclusive Monte Alto complex in La Cala Golf, Mijas – one of the most sought-after areas on the Costa del Sol. (...)
€689,400
TSEA5051299
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 128 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Marbella West Region: Andalucía
Charming Family Home in Los Naranjos de Marbella: Your Ideal Retreat
Discover this beautiful 3-bedroom house in the highly sought-after urbanization of Los Naranjos de Marbella. Its location is (...)
€1,195,000
TSEA5051224
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 174 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 174 Area: San Pedro Region: Andalucía
Welcome to a newly renovated townhouse located just a few meters from the beaches of San Pedro. The house is surrounded by schools, shops, sports facilities, restaurants, and all essential services. (...)
€437,000
TSEA5051197
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
We present this exclusive semi-detached single-family home, located in one of the quietest and most sought-after areas of Mijas, specifically in Calahonda, a privileged residential area that combines (...)
€442,500
TSEA5051176
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
We present this exclusive semi-detached single-family home, located in one of the quietest and most sought-after areas of Mijas, specifically in Calahonda, a privileged residential area that combines (...)
€437,000
TSEA5051149
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
An excellent semi-detached house is offered for sale, spread over four levels, located in a residential complex in the Calahonda area, in the municipality of Mijas.
The property has a total usable (...)
€560,000
TSEA5051125
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 225 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 225 Area: Mijas and Mijas Costa Region: Andalucía
???? Terraced House in Las Lagunas de Mijas
This 225 m² property, built on a 113 m² plot, is distributed over 5 levels:
???? Ground Floor:
Spacious living-dining room, separate kitchen with (...)
€320,000
TSEA5051110
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
???? Terraced House for Sale – Los Ríos Area, Las Lagunas de Mijas
Discover this charming two-storey terraced house located in a quiet area with excellent access to all services. Perfect for (...)
€443,500
TSEA5051104
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
We present this exclusive semi-detached single-family home, located in one of the quietest and most sought-after areas of Mijas, specifically in Calahonda, a privileged residential area that combines (...)
Current Featured Properties
€673,000
TSEA4107058
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Lot Size: 118 Area: Manilva Region: Andalucía
ARE YOU LOOKING FOR SPECTACULAR SEA VIEWS?
The second phase of this fabulous Residential Development comprises 33 townhouses of 3 and 4 bedrooms and is located in Manilva, on the Costa del Sol, (...)
€599,000
TSEA4765870
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
These impressive homes, set over 4 floors provide 3 bedrooms, 2.5 bathrooms, an ample basement area, private parking, garden, solarium and multiple terraces. The blend of sleek design with the (...)
€580,000
TSEA4941487
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 183 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 183 Area: Mijas and Mijas Costa Region: Andalucía
Discover 19 stunning homes that combine nature and sea. With elegant details, spacious terraces and fitted kitchens, you will enjoy exceptional living in the heart of Mijas. Immerse yourself in a (...)
