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 (57,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 (57,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 (57,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 301 - 320 of 755 €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 (...)
€480,000
TSEA5052310
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 80 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Area: Marbella West Region: Andalucía
Discover this spectacular office for sale in the heart of Nueva Andalucía! Located in the prestigious Alzambra Commercial Centre, this property is ideal for entrepreneurs and professionals looking (...)
€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
€349,000
TSEA5077342
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 116 Lot Size: 20 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Lot Size: 20 Area: Estepona Region: Andalucía
Beautifully Reformed 3-Bedroom Townhouse in Bel Air
Step into this bright and airy reformed townhouse, offering 3 spacious bedrooms and 2 modern bathrooms in the sought-after area of Bel Air. (...)
€483,000
TSEA3980794
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
NESTLED BETWEEN STUNNING LANDSCAPE GARDENS!!
An exclusive development of 46 townhouses of 2, 3 and 4 bedrooms, some of them semi-detached, built in a contemporary style, in a privileged location two (...)
€950,000
TSEA4430956
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 240 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 240 Area: Estepona Region: Andalucía
Exceptional very spacious townhouse located in frontline beach residential complex Belgravia club, Estepona.
This spectacular home has fantastic sea views and the location is unbeatable, just a few (...)
