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 321 - 340 of 757
€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 (...)
€480,000
TSEA5048374
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 136 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Casares Region: Andalucía
Marina de Casares, charming terraced house.
Located in the sought-after community of Marina de Casares, just moments from the vibrant town of San Luis de Sabinillas, this charming Spanish-style (...)
€450,000
TSEA5048176
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Estepona Region: Andalucía
Spacious End-Terrace Townhouse with Sea Views in Residencial Atalaya Golf
Nestled in the sought-after Residencial Atalaya Golf, this end-terrace townhouse presents an exceptional opportunity for (...)
€155,000
TSEA5047231
- Viñuela, Costa Del Sol East
Beds: 2 Baths: 1 M2: 81 Lot Size: 386 Region: Andalucía
Beds: 2 Baths: 1 M2: 81 Lot Size: 386 Region: Andalucía
Charming opportunity in La Aldea, Viñuela!
Are you looking for a house with character, outdoor space, and lots of possibilities? Here it is!.
Located in the quiet and picturesque area of La Aldea, (...)
€398,000
TSEA5047069
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 136 Lot Size: 8 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Lot Size: 8 Area: Mijas and Mijas Costa Region: Andalucía
Charming Andalusian style townhouse in Mijas Golf!
Located in a peaceful and exclusive setting, it combines Andalusian style charm with modern comfort. Situated in a well-kept urbanization in Mijas (...)
Current Featured Properties
€980,000
TSEA4621648
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 268 Lot Size: 216 Area: Mijas and Mijas Costa Region: Andalucía
This exclusive project with an elegant Scandinavian design blends harmoniously with the surrounding nature. The architecture of the townhouses follows seamlessly the undulating shapes of the (...)
€370,500
TSEA4868902
- Cancelada, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Estepona Region: Andalucía
YOU COULD NOT ASK FOR A BETTER LOCATION!!
Exclusive multi-family homes of 2 and 3 bedrooms located in the privileged surroundings of the Golden Mile of Estepona. The homes enjoy large terraces (...)
€825,000
TSEA4340413
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 2,388 Lot Size: 46 Area: Mijas and Mijas Costa Region: Andalucía
EVERYONE IS TALKING ABOUT MOVING TO MIJAS!!!
Located in La Cala de Mijas, one of the urban centers belonging to the municipality of Mijas. Just a 5-minute drive from the residential area, you can (...)
