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 (68,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 (68,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 (68,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 81 - 100 of 743 €525,000
TSEA5139019
- Higueron, Costa Del Sol
Beds: 4 Baths: 2 M2: 149 Lot Size: 15 Region: Andalucía
Beds: 4 Baths: 2 M2: 149 Lot Size: 15 Region: Andalucía
DETACHED TOWNHOUSE IN URBANIZATION OF HIGUERON, HIGH ZONE, CONSISTS OF TWO FLOORS, IN THE GROUND FLOOR A LARGE KITCHEN WITH LAUNDRY ROOM, GUEST TOILET, LIVING-DINING ROOM, WITH WOOD CHIMENY AND LARGE (...)
€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² (...)
€520,000
TSEA5137855
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 179 Lot Size: 35 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 179 Lot Size: 35 Area: Mijas and Mijas Costa Region: Andalucía
Modern 3-Bedroom House in Lower Riviera del Sol – Safe, Connected & Close to the Beach
Unique opportunity in the highly sought-after lower part of Riviera del Sol: a bright and modern (...)
€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 (...)
€235,000
TSEA5135368
- San Enrique, Costa Del Sol, Sotogrande
Beds: 2 Baths: 1 M2: 109 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 1 M2: 109 Area: Sotogrande Region: Andalucía
Single-story home. It has 109 m² of built area and a 100 m² outdoor patio, with a garage.
Fully furnished kitchen, appliances such as a refrigerator, washing machine, gas stove, and hot water (...)
€545,000
TSEA5134963
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 4 M2: 242 Lot Size: 30 Area: Manilva Region: Andalucía
Beds: 4 Baths: 4 M2: 242 Lot Size: 30 Area: Manilva Region: Andalucía
Unique Townhouse with Stunning Panoramic Sea Views.
This bright property is spread over four levels.
Ground Floor
A spacious living/dining area, a large fully fitted kitchen, a guest toilet, and two (...)
€540,000
TSEA5134789
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 177 Lot Size: 41 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 177 Lot Size: 41 Area: Fuengirola Region: Andalucía
This exceptional large corner townhouse offers space, comfort, and versatility for the entire family.
On the lower level, you'll find a generous 52 m² entertainment room, ideal for conversion into (...)
€475,000
TSEA5134435
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Discover this bright and welcoming semi-detached townhouse featuring:
Accommodations: 3 spacious bedrooms, 2 full bathrooms, and an additional guest toilet.
Orientation & Views: South-facing (...)
€425,000
TSEA5134426
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 5 Baths: 3 M2: 143 Lot Size: 168 Area: Nerja and Malaga East Region: Andalucía
Beds: 5 Baths: 3 M2: 143 Lot Size: 168 Area: Nerja and Malaga East Region: Andalucía
Property with apartment and premises in the center of Nerja, an exceptional investment opportunity.
This is a golden opportunity to acquire a two-story property in the center of Nerja,
where you (...)
€2,790,000
TSEA5134270
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 383 Lot Size: 765 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 383 Lot Size: 765 Area: Estepona Region: Andalucía
Located in the exclusive and secure community of Resina Golf in Estepona, this fully renovated villa offers an exceptional standard of luxury living. With meticulous attention to detail and high-end (...)
€850,000
TSEA5133667
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 180 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 180 Area: Estepona Region: Andalucía
This is a rare opportunity to own a beautifully renovated townhouse in one most desirable beachfront communities if Estepona West area — Bermuda Beach. Offering direct access to a peaceful, (...)
€650,000
TSEA5133313
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 100 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 100 Area: San Pedro Region: Andalucía
This three-bedroom townhouse in Guadalmina Pueblo is one of those rare finds you don't come across often — especially in such a prime Marbella location. It does need a full renovation, but that's (...)
€580,000
TSEA5133244
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 483 Lot Size: 1,550 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 483 Lot Size: 1,550 Area: Mijas and Mijas Costa Region: Andalucía
Independent Villa in the Urbanización Pinos de Alhaurín.
REDUCED!!!!!!!!
Owner open to offers.
Málaga Home Sales sells, EXCLUSIVELY, excellent independent villa with a large garden, and lots of (...)
€349,000
TSEA5133154
- Diana Park, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
Townhouse to Renovate in Nueva Atalaya – Excellent Investment Opportunity
Type: Townhouse
Condition: To renovate
Built area: 109 m²
Bedrooms: 3
Bathrooms: 2
Terrace / Porch: Yes
Location: Nueva (...)
€170,000
TSEA5132677
- Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 2 M2: 112 Lot Size: 306 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 2 M2: 112 Lot Size: 306 Area: Nerja and Malaga East Region: Andalucía
Nestled in the picturesque hills of Comares, this charming townhouse with its own plot is a real gem for those seeking authentic Andalusia. The house offers plenty of space and flexible layout (...)
Current Featured Properties
€495,000
TSEA5155090
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Located in the sought-after frontline beach development of Bahía Azul in Estepona West, this 2-bedroom townhouse offers an excellent opportunity to renovate and personalise a home in a prime coastal (...)
€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. (...)
€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, (...)
