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 (47,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 (47,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 (47,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 341 - 360 of 895
€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 (...)
€290,000
TSEA5050981
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beautifully renovated duplex for sale in a quiet area of Las Lagunas, offering extra privacy with no neighbors above or below, only on each side.
Originally a 3-bedroom property, it has been (...)
€549,000
TSEA5050462
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 177 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 177 Area: Fuengirola Region: Andalucía
Beautiful townhouse, ideal for those seeking comfort, style, and an unbeatable location.
Spacious 3-Bedroom Townhouse in Fuengirola – Ideal Coastal Living
Situated in a sought-after urbanisation (...)
€1,000,000
TSEA5050369
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 216 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 216 Area: San Pedro Region: Andalucía
Investment Opportunity in the Heart of San Pedro de Alcántara – Ideal for Boutique Hotel or Apartment Conversion
Prime Central Location
Located right in the town center of San Pedro de (...)
€90,000
TSEA5050291
- Archidona, Costa Del Sol, Antequera
Beds: 4 Baths: 1 M2: 154 Area: Antequera Region: Andalucía
Beds: 4 Baths: 1 M2: 154 Area: Antequera Region: Andalucía
GREAT INVESTMENT!
Townhouse with Potential – Reform Needed – in the Historic Heart of Archidona!
Located in the very center of Archidona, this 154 m² townhouse offers a unique opportunity (...)
€535,000
TSEA5050177
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 249 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 249 Area: Mijas and Mijas Costa Region: Andalucía
Experience Luxury and Tranquility at La Cala Golf
Discover this exclusive 3-bedroom, 4-bathroom townhouse located in the heart of La Cala Golf, the largest golf resort in Spain. Perfect for those (...)
€615,000
TSEA5050165
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 149 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Area: Estepona Region: Andalucía
Beautifully Renovated Townhouse in the Sought-After Beachside McDonald Resort Community.
Nestled in the charming Andalusian-style McDonald Resort, this beautifully updated three-bedroom townhouse (...)
€845,000
TSEA5049418
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 305 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 305 Area: Estepona Region: Andalucía
Unique Townhouse in Dominion Beach – Estepona
5 Bedrooms | 3 Bathrooms | Jacuzzi | 2 Parking Spaces | Rental License
Discover this spacious and stylish 5-bedroom, 3-bathroom townhouse, ideally (...)
€1,995,000
TSEA5049322
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 240 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 240 Area: Marbella East Region: Andalucía
This fully renovated property is located in the desirable area of Altos de Puente Romano, less than a 20 minutes' walk to the well know Puente Romano Hotel, the beach and the promenade that links you (...)
€490,000
TSEA5049223
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 140 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 140 Area: Benalmadena Region: Andalucía
Townhouse, Benalmadena Costa, Costa del Sol.
4 Bedrooms, 3 Bathrooms, Built 140 m².
Setting : Commercial Area, Close To Shops, Close To Sea, Close To Town, Close To Schools, (...)
€395,000
TSEA5049043
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 147 Lot Size: 300 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 147 Lot Size: 300 Area: Estepona Region: Andalucía
Charming townhouse with sea views in the exclusive urbanization Don Pedro, Estepona.
Located in a quiet and well-kept urbanization just five minutes drive from the center of Estepona and its (...)
€185,000
TSEA5049028
- Alora, Costa Del Sol, Älora
Beds: 4 Baths: 1 M2: 183 Area: Älora Region: Andalucía
Beds: 4 Baths: 1 M2: 183 Area: Älora Region: Andalucía
Charming village house in the centre of Álora - 4 bedrooms, terrace and great potential.
Charming townhouse in the centre of Álora, with independent entrance from the street. This is a traditional (...)
€949,000
TSEA5048650
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 129 Lot Size: 38 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 129 Lot Size: 38 Area: Marbella West Region: Andalucía
Top renovated 4 bedroom townhouse with beautiful golf views
Newly renovated 4-bedroom townhouse located in the heart of the prestigious Aloha area in Nueva Andalucía. This elegant townhouse offers (...)
€695,000
TSEA5048608
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 198 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 198 Area: Estepona Region: Andalucía
Charming Townhouse with Private Garden and Panoramic Sea Views in El Paraíso
Located in a peaceful residential area of El Paraíso, this bright and spacious townhouse offers the perfect balance of (...)
€364,000
TSEA5048593
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 3 M2: 125 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 3 M2: 125 Area: Torremolinos Region: Andalucía
*Large Townhouse with Spacious Spaces and Unbeatable Location!*
This spectacular townhouse, located in La Colina, offers a prime location less than a minute's walk from the commuter train station, (...)
€600,000
TSEA5048548
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 145 Lot Size: 182 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 145 Lot Size: 182 Area: Estepona Region: Andalucía
Welcome to this charming 4-bedroom, 2-bathroom house located in the sought-after Bahia Dorada 4 complex, nestled in the picturesque town of Estepona on the stunning Costa del Sol.
The property (...)
Current Featured Properties
€1,595,000
TSEA5010322
- La Heredia, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 308 Lot Size: 181 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 308 Lot Size: 181 Area: Benahavis Region: Andalucía
STUNNING 5-BEDROOM TOWNHOUSE WITH PANORAMIC SEA, MOUNTAIN AND GOLF VIEWS
Located in the award winning village of La Heredia, close to Benahavis on the Ronda road, this beautiful 5-bedroom townhouse (...)
€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, (...)
€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 (...)
