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 (36,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 (36,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 (36,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 301 - 320 of 746 €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 (...)
€442,500
TSEA5051086
- 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 magnificent semi-detached single-family home, located in one of the quietest and most desirable areas of the municipality of Mijas, in Calahonda.
The home is distributed over four (...)
Current Featured Properties
€640,000
TSEA4551028
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 3 M2: 193 Area: Istan Region: Andalucía
Beds: 3 Baths: 3 M2: 193 Area: Istan Region: Andalucía
STUNNING MOUNTAIN AND SEA VIEWS!!!
This new development encompasses precisely this combination of the best of the mountains and coast on Costa del Sol. Originally the location of an ancient oil mill (...)
€461,000
TSEA5038750
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 104 Lot Size: 32 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 104 Lot Size: 32 Area: Fuengirola Region: Andalucía
Located in the town of Fuengirola, in the prestigious Torreblanca area, This is an exclusive residential complex consisting of 19 townhouses that offers everything you need for a dream life on the (...)
€570,000
TSEA4975855
- La Heredia, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 133 Area: Benahavis Region: Andalucía
LA PERLA DE LA HEREDIA , BENAHAVIS.
This charming townhouse is located in the cozy village of La Perla de la Heredia, just off Ronda Road. It faces south to southwest, offering lovely views of the (...)
