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 (41,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 (41,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 (41,68,69,70)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 341 - 360 of 1524
€250,000
TSEA5114215
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 119 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 119 Area: Malaga Region: Andalucía
Fantastic house for sale located in the coveted neighborhood of San José del Viso, an area undergoing rapid expansion and with all the amenities at your fingertips.
This bright home features 3 (...)
€415,000
TSEA5114212
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 1 M2: 99 Lot Size: 109 Area: Malaga Region: Andalucía
Beds: 3 Baths: 1 M2: 99 Lot Size: 109 Area: Malaga Region: Andalucía
Charming Casa Mata (Townhouse) with rooftop terrace in a sought-after neighbourhood.
Discover the potential of this bright and spacious casa mata located in a tranquil street, just a short walk from (...)
€950,000
TSEA5113849
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 4 Baths: 3 M2: 230 Lot Size: 273 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 3 M2: 230 Lot Size: 273 Area: Sotogrande Region: Andalucía
Town House for sale in La Finca, Sotogrande with 4 bedrooms, 3 bathrooms, 1 toilet and with orientation south/east, with communal swimming pool, private garage (2 parking spaces) and private garden. (...)
€349,000
TSEA5113708
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Amazing single-story townhouse, with the possibility of building another floor above (this information pending confirmation).
With a front and rear porch.
It has a fireplace.
Open-plan kitchen. (...)
€330,000
TSEA5112367
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 65 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Marbella West Region: Andalucía
Located just 1 kilometre from the iconic Puerto Banús, this three-level, Southwest orientated, corner, 1 bedroom townhouse is perfect as a Marbella base. This is a fantastic opportunity at a (...)
€403,000
TSEA5112346
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
Penthouse with Sea Views – Atalaya, Estepona
This exclusive 2-bedroom, 2-bathroom penthouse apartment, with 110 m² of built area and a 25 m² terrace, is located in a private development in (...)
€380,000
TSEA5112271
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 3 Baths: 2 M2: 127 Area: Alhaurin el Grande Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Alhaurin el Grande Region: Andalucía
Set in one of the most sought-after areas of Alhaurín Golf, this beautifully presented and much-loved townhouse offers the perfect blend of comfort, style, and convenience. Ideal for permanent (...)
€995,000
TSEA5111875
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 160 Lot Size: 185 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Lot Size: 185 Area: Marbella West Region: Andalucía
Discover this rare opportunity to own a charming townhouse for sale in Los Altos de Aloha, one of the most desirable residential complexes in Nueva Andalucía, Marbella. Perfectly positioned (...)
€425,000
TSEA5111626
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 138 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 138 Area: La Duquesa Region: Andalucía
Townhouse, La Duquesa, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 138 m², Terrace 88 m².
Setting : Frontline Golf, Close To Golf, Close To Port, Close To Town, Close To Marina.
Orientation : (...)
€395,000
TSEA5111614
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 4 M2: 195 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 4 M2: 195 Area: La Duquesa Region: Andalucía
A beautiful townhouse with a large private garden and fantastic terrace, overlooking the fairways of Duquesa Golf. This is located in the highly desirable community Villas del Golf, a pleasant walk (...)
€498,000
TSEA5111575
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 121 Lot Size: 91 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Lot Size: 91 Area: Benalmadena Region: Andalucía
WONDERFUL TOWNHOUSE FOR SALE located in the prestigious and sought-after location, La Reserva del Higuerón.
Situated between Benalmadena and Mijas Pueblo with easy access to highway, beaches and a (...)
€265,000
TSEA5111404
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 72 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 72 Area: La Duquesa Region: Andalucía
This is a charming semi detached townhouse found on a peaceful urbanisation close to the marina of La Duquesa.
The property has 3 bedroom, 2 bathroom, a split level lounge/dining room with a working (...)
€330,000
TSEA5111269
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 2 M2: 92 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Alhaurin el Grande Region: Andalucía
Fantastic corner penthouse apartment with 3 balconies for sale in Las Brisas, Alhaurín Golf, Alhaurín el Grande.
Magnificent penthouse with superb views accessed by a lift or stairs. You enter (...)
€560,000
TSEA5110996
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 225 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 225 Area: Mijas and Mijas Costa Region: Andalucía
Stylish south east facing, three-bedroom semi detached townhouse located in Riviera del Sol. This property offers bright and spacious interiors filled with natural light and high ceilings. The (...)
€790,000
TSEA5110927
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 154 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 154 Area: Marbella West Region: Andalucía
This beautifully presented townhouse, nestled in the heart of the sought-after Aloha Pueblo, offers the perfect blend of traditional Andalucian charm and modern comfort. Set across two levels with (...)
€1,150,000
TSEA5110819
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 120 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 120 Area: Benahavis Region: Andalucía
Luxurious Penthouse in Marbella Club Hills
Welcome to your new dream home, an unparalleled penthouse with 3 bedrooms and 3 bathrooms, located in the prestigious Marbella Club Hills. This exceptional (...)
€285,000
TSEA5110684
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
PENTHOUSE WITH SEA VIEWS NEXT TO THE BEACH
Fantastic penthouse located in the Torrequbrada area (Benalmadena costa) just a few minutes walk from the beach close to all kinds of services.
Apartment (...)
€525,000
TSEA5110609
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 2 M2: 260 Area: Manilva Region: Andalucía
Beds: 4 Baths: 2 M2: 260 Area: Manilva Region: Andalucía
Renovated Townhouse with Panoramic Sea, Garden, and Mountain Views – Manilva, Costa del Sol
This impressive 230m² townhouse, with 3 terraces, a private garden, and an 80m² enclosed garage, (...)
€195,000
TSEA5110459
- Tolox, Costa Del Sol, Yunquera
Beds: 5 Baths: 2 M2: 168 Area: Yunquera Region: Andalucía
Beds: 5 Baths: 2 M2: 168 Area: Yunquera Region: Andalucía
Spacious Townhouse with Large Basement
. Prime village location next to the countryside
. Light-filled and airy interior
. Spacious basement with separate access – ideal for conversion into (...)
€460,000
TSEA5110243
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 3 M2: 173 Area: Casares Region: Andalucía
Beds: 2 Baths: 3 M2: 173 Area: Casares Region: Andalucía
Luxury Villa Just 5 Minutes from the Beach
Nestled in one of the most sought-after locations, this fully renovated luxury villa offers the perfect blend of elegance, comfort, and functionality. (...)
Current Featured Properties
€736,000
TSEA4324069
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
YOU WILL LOVE LIVING IN ESTEPONA!!!!
Located in Estepona, one of the most attractive corners of the Costa del Sol. The town has become one of the most sought-after spots on the Costa del Sol, thanks (...)
€515,000
TSEA4814728
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 109 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Istan Region: Andalucía
COUNTRY LIVING ONLY 10 MINS FROM EVERYTHING!
This is the first phase on sale, comprising 32 exclusive apartments with stunning panoramic views, situated in the most elevated part of the Almazara (...)
€483,000
TSEA3980794
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 139 Area: Manilva Region: Andalucía
NESTLED BETWEEN STUNNING LANDSCAPE GARDENS!!
An exclusive development of 46 townhouses of 2, 3 and 4 bedrooms, some of them semi-detached, built in a contemporary style, in a privileged location two (...)
