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,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 (70,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 (70,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 341 - 360 of 743
€740,000
TSEA5045011
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 215 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 215 Area: Estepona Region: Andalucía
Beautiful modern townhouse built in October 2019, located in a quiet neighborhood in the heart of Estepona. The property has a plot of 84 m² and a built area of 232 m² distributed in three bedrooms (...)
€450,000
TSEA5044714
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 171 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 171 Area: Fuengirola Region: Andalucía
Lovely townhouse for sale in Los Boliches close to all amenities and walking distance to the beach. This property offers 4 bedrooms and 4 bathrooms, lounge dining and underground parking space. Nice (...)
€682,000
TSEA5044267
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 4 Baths: 3 M2: 251 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 3 M2: 251 Area: Torremolinos Region: Andalucía
We present to you this exclusive townhouse located in a quiet and well-maintained family-friendly residential complex in Torremolinos — a perfect setting for those who value peace without giving up (...)
€470,000
TSEA5044264
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 3 Baths: 1 M2: 213 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 1 M2: 213 Area: Benalmadena Region: Andalucía
Three-bedroom semi-detached house for sale in a quiet and safe residential area. The house comes with a private garage and a communal garden and pool, perfect for enjoying the sun and nature.
House (...)
€549,000
TSEA5043595
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 278 Lot Size: 78 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 278 Lot Size: 78 Area: Mijas and Mijas Costa Region: Andalucía
Exclusive townhouse in Riviera del Sol with panoramic views and elegant interior
We present this townhouse located in the prestigious gated community Estrellas del Golf, surrounded by golf courses. (...)
€1,166,550
TSEA5042740
- Cancelada, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 306 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 306 Area: Estepona Region: Andalucía
Unique Opportunity for Sale in Cancelada, Estepona! Corner Townhouse Just Minutes from Puerto Banús and Marbella
Discover this fantastic corner townhouse located in one of the best areas of (...)
€1,975,000
TSEA5042473
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 344 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 344 Area: Marbella East Region: Andalucía
This spacious and light-filled 3-bedroom, 3-bathroom townhouse offers a rare combination of generous interior space, stunning views, and outdoor living in one of Marbella's most sought-after (...)
€515,000
TSEA5042206
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 130 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Marbella West Region: Andalucía
Charming Townhouse with Investment Potential in the Heart of Nueva Andalucía
Discover this cozy and charming property located in the sought-after area of Nueva Andalucía, just a 10-minute walk (...)
€675,000
TSEA5041882
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 135 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 135 Area: Fuengirola Region: Andalucía
Townhouse, Fuengirola, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 135 m², Terrace 40 m².
Setting : Town, Close To Shops.
Orientation : East.
Condition : Good.
Pool : Communal.
Climate Control : (...)
€399,000
TSEA5041846
- Torreguadiaro, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 112 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Sotogrande Region: Andalucía
Ticking All Boxes In Torreguadiaro
This is a rare find - a 3 bedroom townhouse in Torreguadiaro that's affordable and allows you to comfortably walk to everything.
The property is 112m2 built as (...)
€349,000
TSEA5041840
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 1 M2: 87 Lot Size: 71 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 1 M2: 87 Lot Size: 71 Area: Marbella East Region: Andalucía
Lovely townhouse full of character in the heart of Elviria. Located just a 5-minute walk from the Elviria shopping center and a mere 10 minutes to the beach, this gated complex is perfect for (...)
€460,000
TSEA5041777
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 46 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 46 Area: Mijas and Mijas Costa Region: Andalucía
Charming Corner Townhouse by the Beach – Riviera del Sol
Situated in a sought-after beachfront urbanisation in Riviera del Sol, this delightful corner townhouse offers the perfect blend of (...)
€550,000
TSEA5041237
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 98 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 98 Area: Marbella Region: Andalucía
Mediterranean-Style Townhouse with Breathtaking Sea Views in Altos de Los Monteros
Welcome to this charming Mediterranean-style townhouse, nestled in an exclusive gated community of just 25 homes in (...)
€1,590,000
TSEA5040688
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 261 Lot Size: 200 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 261 Lot Size: 200 Area: Marbella Region: Andalucía
Semi-Detached House for Sale in Hill Club, Sierra Blanca, Marbella
Discover this stunning semi-detached house in the exclusive area of Hill Club, in Sierra Blanca, Marbella. With a constructed area (...)
€495,000
TSEA5040073
- Monda, Costa Del Sol, Marbella
Beds: 5 Baths: 3 M2: 342 Area: Marbella Region: Andalucía
Beds: 5 Baths: 3 M2: 342 Area: Marbella Region: Andalucía
Traditional Andalusian Home with Guest Apartment – Prime Location in Monda Village
Welcome to this beautifully restored village home, full of authentic charm and modern comfort, located right in (...)
€699,000
TSEA5039860
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 138 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Area: Benahavis Region: Andalucía
This charming townhouse is located in El Alto, an exclusive gated community perched at the top of the hill, offering a peaceful retreat far from the noise and hustle of daily life. The urbanisation (...)
€479,000
TSEA5039452
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 110 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 110 Area: Fuengirola Region: Andalucía
This 110-square-meter property offers an excellent investment opportunity just steps from the sea. The home features four spacious bedrooms, ideal for families or those seeking comfort and (...)
€525,000
TSEA5039365
- Guadalmar, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 134 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Malaga Region: Andalucía
Discover this delightful 3-bedroom, 2-bathroom townhouse nestled in the sought-after coastal neighbourhood of Guadalmar, Málaga — just a short stroll from the beach and local amenities.
Key (...)
€427,000
TSEA5039149
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 95 Lot Size: 200 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Lot Size: 200 Area: Marbella Region: Andalucía
Nestled in the serene enclave of Los Altos de Marbella, Marbella East, this exquisite duplex offers a harmonious blend of modern comfort and natural beauty. Spanning a built area of 95m², this (...)
€1,750,000
TSEA5039128
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 164 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 164 Area: Benahavis Region: Andalucía
This is a meticulously renovated three-level townhouse for sale located in the secure, well-maintained community of La Quinta Hills in Benahavís. Fully renovated in 2024, this property showcases a (...)
Current Featured Properties
€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 (...)
€747,000
Townhouse in Mijas
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 141 Lot Size: 24 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 141 Lot Size: 24 Area: Mijas and Mijas Costa Region: Andalucía
TOWNHOUSES IN LA CALA DE MIJAS.
Ideally located next to El Chaparral Golf Course, a few metres from the beach, very close to the lively, bustling entertainment area of La Cala de Mijas and 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, (...)
