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 (43,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 (43,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 (43,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 41 - 60 of 306 €699,000
TSEA5129566
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 145 Lot Size: 354 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Lot Size: 354 Area: San Pedro Region: Andalucía
Welcome to this charming and well-designed semi-detached home in the sought-after Linda Vista alta area – just a short walk from the vibrant centre of San Pedro de Alcántara, with shops, (...)
€2,300,000
TSEA5128981
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 241 Lot Size: 508 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 241 Lot Size: 508 Area: Marbella East Region: Andalucía
Exclusive semi-detached house with private pool, right in front of Cabopino Marina, boasting stunning sea views.
This elegant and traditional property in Spanish style features 4 bedrooms, 3 full (...)
€435,000
TSEA5128711
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 275 Lot Size: 137 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 275 Lot Size: 137 Area: Mijas and Mijas Costa Region: Andalucía
DETACHED HOUSE IN THE CENTER OF PICTURESQUE MIJAS PUEBLO.
Detached house in Mijas Pueblo, close to all amenities, in a quiet area outside the town's commercial area.
The property is in need of (...)
€298,000
TSEA5126218
- Sedella, Costa Del Sol East
Beds: 3 Baths: 2 M2: 254 Lot Size: 254 Region: Andalucía
Beds: 3 Baths: 2 M2: 254 Lot Size: 254 Region: Andalucía
This extraordinary property blends over 400 years of history with contemporary living comfort. In 2022, it underwent a full renovation with great attention to detail and a strong focus on quality and (...)
€359,000
TSEA5125144
- Torrox Costa, Costa Del Sol East
Beds: 2 Baths: 1 M2: 53 Lot Size: 180 Region: Andalucía
Beds: 2 Baths: 1 M2: 53 Lot Size: 180 Region: Andalucía
Charming Sunlit Semi-Detached Home Just Steps from the Beach in Torrox Costa
Located in the sought-after Centro Internacional Urbanization, this bright and inviting semi-detached home is just 50 (...)
€599,000
TSEA5124175
- Lauro Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 210 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 210 Area: Mijas and Mijas Costa Region: Andalucía
Very spacious home in the scenic Golf Resort near Malaga.
The area and the golf course are a big favorite among golfers, who are attracted by the 27 holes in top quality.
Weekly tournaments and (...)
€599,000
TSEA5124142
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 203 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 203 Area: Mijas and Mijas Costa Region: Andalucía
Very spacious home in the scenic Golf Resort near Malaga.
The area and the golf course are a big favorite among golfers, who are attracted by the 27 holes in top quality.
Weekly tournaments and (...)
€515,000
TSEA5123968
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
In the heart of Estepona's charming old town lies this magnificent and spacious casa mata, a gem with an unbeatable location. Located in the heart of the town, this property combines the authenticity (...)
€1,850,000
TSEA5122906
- Los Monteros, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 238 Lot Size: 694 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 238 Lot Size: 694 Area: Marbella East Region: Andalucía
Elegant Semi-Detached Beachside Villa in Los Monteros, Marbella East – Just 150m from the Beach
Located in the exclusive and secure beachside enclave of Los Monteros in Marbella East, this (...)
€504,000
TSEA5122144
- Sierrezuela, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 240 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 240 Area: Mijas and Mijas Costa Region: Andalucía
Corner Semi-Detached Chalet in La Sierrezuela – Peace, Space, and Connectivity
Discover this fantastic corner semi-detached home located in an exclusive and quiet gated community in La Sierrezuela (...)
€569,000
TSEA5122012
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 116 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Malaga Region: Andalucía
This exclusive apartment is located in the beautiful area of Casares Playa, in Casares, Málaga. With a privileged location, this apartment offers a peaceful and relaxing environment. With 2 bedrooms (...)
€450,000
TSEA5121949
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
We present to you this house located in a beautiful square in the heart of Estepona's old town. This charming property blends authentic Andalusian style with spacious and functional living areas. (...)
€942,000
TSEA5121433
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 131 Lot Size: 40 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 131 Lot Size: 40 Area: Marbella West Region: Andalucía
This spectacular semi-detached house is located in one of the most sought-after areas of Nueva Andalucia. It has 4 en-suite bedrooms, a spacious living room, a fully equipped kitchen, and a storage (...)
€128,000
TSEA5119993
- Canillas de Aceituno, Costa Del Sol East
Beds: 2 Baths: 2 M2: 50 Lot Size: 55 Region: Andalucía
Beds: 2 Baths: 2 M2: 50 Lot Size: 55 Region: Andalucía
Magnificent apartment for sale in excellent condition, fully ready to move into, located in the heart of the charming town of Canillas de Aceituno, in the province of Malaga. This welcoming (...)
€970,000
TSEA5118349
- Ojén, Costa Del Sol, Ojen
Beds: 4 Baths: 2 M2: 205 Lot Size: 282 Area: Ojen Region: Andalucía
Beds: 4 Baths: 2 M2: 205 Lot Size: 282 Area: Ojen Region: Andalucía
This stunning semi-detached home in La Mairena, one of the most peaceful and exclusive residential areas on the Costa del Sol, truly has it all: contemporary design, privacy, energy-efficient (...)
€520,000
TSEA5118148
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 164 Lot Size: 231 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 164 Lot Size: 231 Area: Mijas and Mijas Costa Region: Andalucía
Discover your new home in this charming semi-detached villa! This property has 3 spacious bedrooms and 3 bathrooms, perfect for enjoying the comfort and space you have always wanted. The house offers (...)
€529,000
TSEA5114656
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Semi-detached house with an apartment (separate studio, separate entrance). The house has three bedrooms and a studio.
Communal pools, paddle tennis court, and multipurpose court. Located very close (...)
€904,000
TSEA5113795
- Almayate Alto, Costa Del Sol East
Beds: 3 Baths: 3 M2: 196 Lot Size: 31,295 Region: Andalucía
Beds: 3 Baths: 3 M2: 196 Lot Size: 31,295 Region: Andalucía
This impressive finca near Almayate spans almost 32,000 m2 of land and offers ample space for peace, self-sufficiency or small-scale farming projects. At its heart lies a charming house of approx. (...)
€875,000
TSEA5112391
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 258 Lot Size: 71 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 258 Lot Size: 71 Area: Malaga Region: Andalucía
This beautifully maintained 2009 terraced home in the tranquil Terrazas de Miraflores community is perfect for investors, commuters, and families alike. Located just ten minutes from Málaga's (...)
€675,000
TSEA5111371
- Artola, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 187 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 187 Area: Marbella East Region: Andalucía
Impressive renovated Town House beachside Artola-Cabopino. This property is nestled in a cosy 16 dwelling urbanization with a gifted location, just 70m from the protected "Dunas de Artola" (...)
Current Featured Properties
€1,580,000
TSEA4639777
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 174 Lot Size: 10 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
€1,100,000
TSEA4638103
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 138 Lot Size: 34 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Lot Size: 34 Area: Fuengirola Region: Andalucía
This project represents an outstanding commitment in the development of a boutique proposal located just 500 meters from the beach, with easy and unobstructed access.
This exclusive development (...)
€443,000
TSEA4027225
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Lot Size: 154 Area: Mijas and Mijas Costa Region: Andalucía
4 UNITS LEFT
DREAM AWAY LAZY EVENINGS BY LOOKING AT A STUNNING VIEW!!!
Off-plan development of contemporary semi-detached houses in Riviera del Sol, Mijas, with views over the Mediterranean. The 3 (...)
