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 (70,36,37,38)
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 (70,36,37,38)
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 (70,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 61 - 80 of 677
€395,000
TSEA5143597
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 114 Lot Size: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Lot Size: 100 Area: Mijas and Mijas Costa Region: Andalucía
Townhouse for sale in Las Lagunas de Mijas
Spacious townhouse for sale located in one of the fastest growing areas of Las Lagunas, at a very competitive price and well below that of any apartment in (...)
€549,000
TSEA5143066
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 200 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Lot Size: 18 Area: Mijas and Mijas Costa Region: Andalucía
This very spacious 3 double bedroom, 3 bathroom townhouse is spread over 4 floors and offers a family a fabulous opportunity to enjoy holidays or residence in high-end quality surroundings. (...)
€685,000
TSEA5142505
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 142 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 142 Area: Marbella Region: Andalucía
This elegant duplex in Santa Clara Golf, Marbella, is spread over two floors, offering spacious and
comfortable areas. On the ground floor, there is a large living room that connects with the (...)
€795,000
TSEA5141764
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 199 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 199 Area: Fuengirola Region: Andalucía
Come and discover this stunning townhouse, designed to combine comfort, technology, and a sustainable lifestyle.
The basement features a spacious garage with room for two cars, and a multi-purpose (...)
€489,000
TSEA5141719
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 5 M2: 239 Area: Manilva Region: Andalucía
Beds: 3 Baths: 5 M2: 239 Area: Manilva Region: Andalucía
**Elegant 3-Storey Townhouse + Basement with Panoramic Sea Views and the Rock of Gibraltar – Manilva**
Discover this exceptional and spacious townhouse, perfectly located in a quiet and secluded (...)
€254,500
TSEA5141122
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 27 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 27 Area: Mijas and Mijas Costa Region: Andalucía
This beachfront studio apartment is an excellent opportunity for those seeking a property in a prime location. The apartment is south-east facing, offering spectacular views of the Mediterranean, the (...)
€170,000
TSEA5141044
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 1 M2: 120 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 1 M2: 120 Area: Alhaurin el Grande Region: Andalucía
3-bedroom, 1-bathroom semi-detached house in Alhaurín el Grande. The property needs renovation, it offers excellent potential for customization. Located in a sought-after area, it's ideal for (...)
€398,000
TSEA5140831
- Campo Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Partially renovated townhouse in Campo Mijas with panoramic views. Spread over 3 floors, it features 3 bedrooms, terraces on every level, a solarium, modern kitchen, and BBQ terrace. Community pool (...)
€699,000
TSEA5140534
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 123 Lot Size: 149 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 123 Lot Size: 149 Area: Benalmadena Region: Andalucía
Townhouse for sale at La Capellanía - El Higuerón, Benalmádena
Discover this exclusive semi-detached house located in the prestigious Reserva El Higuerón complex, a privileged enclave on the (...)
€555,000
TSEA5139736
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 162 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Estepona Region: Andalucía
This charming three-storey semi-detached villa combines comfort, spaciousness and a functional layout, ideal for enjoying with the family.
On the main floor, upon entering the house, we find a (...)
€549,000
TSEA5139616
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 107 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 107 Area: Fuengirola Region: Andalucía
*Unique Opportunity in Torreblanca, Fuengirola – Your Dream Home Awaits!*
Discover this charming terraced house in the heart of Torreblanca, Fuengirola. With a generous 107 m² constructed area (...)
€390,000
TSEA5139130
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 127 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Casares Region: Andalucía
Step into your new coastal retreat! This beautifully maintained property offers 3 spacious bedrooms, 2 bathrooms, plus a convenient guest toilet.
Enjoy outdoor living with a private newly tiled (...)
€444,755
TSEA5139070
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 170 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 170 Area: Mijas and Mijas Costa Region: Andalucía
Property with potential value, Benalmádena.
This semi-detached house is the strategic investment you are looking for. Its unbeatable location opposite the Torrequebrada International School, (...)
€640,000
TSEA5138659
- Torrox, Costa Del Sol East
Beds: 5 Baths: 3 M2: 181 Region: Andalucía
Beds: 5 Baths: 3 M2: 181 Region: Andalucía
Short description
Unique opportunity to purchase a townhouse i Torrox Pueblo
Description
Here is a unique opportunity to live in an idyllic Andalusian village with whitewashed houses, winding (...)
€595,000
TSEA5137957
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Located in one of the most desirable areas of Estepona, this cozy townhouse combines comfort, style, and a privileged location. The property, in excellent condition, has a built area of 128 m² (...)
€1,690,000
TSEA5137822
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 371 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 371 Area: Benahavis Region: Andalucía
Brand-New Luxury Semi-Detached Villa in La Alborada, Benahavís
We are delighted to present this magnificent brand-new semi-detached villa, ready to move into, located in the exclusive complex. A (...)
€399,000
TSEA5137810
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 165 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 165 Area: Mijas and Mijas Costa Region: Andalucía
TOWNHOUSE FOR SALE!!
Beautiful townhouse spread over 3 levels, featuring 4 bedrooms, a storage room, 2 terraces and a patio with barbecue – IDEAL FOR FAMILIES!
The property offers a very (...)
€650,000
TSEA5137576
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 5 Baths: 5 M2: 508 Area: Nerja and Malaga East Region: Andalucía
Beds: 5 Baths: 5 M2: 508 Area: Nerja and Malaga East Region: Andalucía
OPPORTUNITY.
On the emblematic Cristo Street in Vélez-Málaga, stands this elegant manor house that blends traditional charm with spacious areas designed for modern comfort.
On the ground floor, it (...)
€375,000
TSEA5135893
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 130 Lot Size: 25 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Lot Size: 25 Area: Estepona Region: Andalucía
Townhouse, Atalaya, Costa del Sol.
3 Bedrooms, 3 Bathrooms, Built 130 m², Terrace 25 m², Garden/Plot 25 m².
Setting : Commercial Area, Close To Shops, Urbanisation.
Orientation : South.
Condition (...)
€370,000
TSEA5135440
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 141 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 141 Area: Estepona Region: Andalucía
Spacious townhouse set within a private well maintained gated community in Bel Air. Recently renovated property featuring an open plan kitchen, good size lounge with a fireplace, w.c., 3 bedrooms and (...)
Current Featured Properties
€715,000
TSEA4798984
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 175 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 175 Area: Estepona Region: Andalucía
BOUTIQUE COLLECTION OF FRONT-LINE GOLF TOWNHOUSES!
Situated on the front line of Estepona Golf Course, your new residence is steps away from the clubhouse and fairways of one of the best golf courses (...)
€470,250
TSEA5065117
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 146 Area: Estepona Region: Andalucía
Welcome to the residential complex in Estepona, your new home on the Costa del Sol.
The residential development is an exclusive promotion of 87 single-family homes ready to move into, located in the (...)
€720,000
TSEA4713529
- La Cala Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 116 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive Branded Residence comprising of 58 incredible 2 and 3 bedroom frontline golf homes to be built to the highest specification overlooking the renowned La Cala Resort Golf course. Reaching the (...)
