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 (46,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 (46,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 (46,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 81 - 100 of 771 €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, (...)
€189,000
TSEA5133610
- Torre del Mar, Costa Del Sol East
Beds: 1 Baths: 1 Lot Size: 350 Region: Andalucía
Beds: 1 Baths: 1 Lot Size: 350 Region: Andalucía
This attractive plot in Viña-Málaga offers a rare combination of tranquility, convenience and a pleasant residential setting. With 350 m2 of space, its the perfect canvas for those looking to build (...)
€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 (...)
Current Featured Properties
€730,000
Townhouse in Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 164 Lot Size: 25 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 164 Lot Size: 25 Area: Estepona Region: Andalucía
STYLISH AND ENERGY EFFICIENT IN BEAUTIFUL ESTEPONA.
This boutique development of ten 4-bed, 3-bath luxury villas offer private gardens with beautiful sea, golf and mountain views. With unique (...)
€584,250
TSEA5065531
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 151 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 151 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 (...)
€445,000
TSEA4989478
- Estepona, 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
SECOND LINE BEACH 2 BED/2 BATH TOWNHOUSE – ESTEPONA PROMENADE!
Immaculately maintained and upgraded family townhouse less than 2 minutes walking distance from the emblematic Mirador de Estepona, (...)
