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,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 (70,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 (70,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 21 - 40 of 677
€1,100,000
TSEA5153719
- Málaga, Costa Del Sol, Malaga
Beds: 4 Baths: 3 M2: 257 Lot Size: 215 Area: Malaga Region: Andalucía
Beds: 4 Baths: 3 M2: 257 Lot Size: 215 Area: Malaga Region: Andalucía
Exclusive home in Pedregalejo, beautifully designed and recently built. Quality, design and location come together in this property to create one of the most desirable houses for sale in the area. (...)
€355,000
TSEA5153524
- El Coto, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 118 Area: Mijas and Mijas Costa Region: Andalucía
Charming townhouse in Mijas, Lagarejo area, in a private community with large communal areas, gardens, and a pool.
The property has 3 bedrooms, 1 full bathroom, and 1 toilet. Perfect for a quiet life (...)
€156,000
TSEA5153470
- Comares, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 86 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Nerja and Malaga East Region: Andalucía
AUTHENTIC SPANISH CORNER HOUSE IN THE HEART OF COMARES
Discover this charming corner house located in the picturesque center of Comares, just 50 meters from the local supermarket and 30 meters from (...)
€1,050,000
TSEA5153440
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 203 Lot Size: 256 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 203 Lot Size: 256 Area: Mijas and Mijas Costa Region: Andalucía
Discover the ultimate blend of luxury, comfort, and lifestyle with this stunning, beautifully maintained, and elegantly furnished townhouse, located in the prestigious La Valvega residential (...)
€829,000
TSEA5152930
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 4 Baths: 4 M2: 224 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 4 M2: 224 Area: Fuengirola Region: Andalucía
Modern Townhouse with Panoramic Sea Views – Torreblanca, Fuengirola
Wake up every morning to the sparkle of the Mediterranean, the warmth of the sun, and the privilege of calling this modern (...)
€600,000
TSEA5152867
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 5 Baths: 3 M2: 160 Area: Fuengirola Region: Andalucía
Beds: 5 Baths: 3 M2: 160 Area: Fuengirola Region: Andalucía
Your Dream Space with Potential in Los Boliches
Discover the perfect home in the quiet and exclusive upper area of Los Boliches. This spacious three-storey townhouse with 5 bedrooms and 3 bathrooms (...)
€614,000
TSEA5152636
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 5 Baths: 4 M2: 187 Lot Size: 1 Area: Fuengirola Region: Andalucía
Beds: 5 Baths: 4 M2: 187 Lot Size: 1 Area: Fuengirola Region: Andalucía
Discover this spacious 5-bedroom, 4-bathroom townhouse in Fuengirola, located right next to Higuerón and designed for those who want to enjoy the Mediterranean lifestyle to the fullest. This home is (...)
€280,000
TSEA5152213
- Coín, Costa Del Sol, Coin
Beds: 5 Baths: 2 M2: 159 Lot Size: 78 Area: Coin Region: Andalucía
Beds: 5 Baths: 2 M2: 159 Lot Size: 78 Area: Coin Region: Andalucía
Unique opportunity in the heart of Coín! This spacious 3-story townhouse combines Andalusian style with practicality. Featuring 5 bedrooms and 2 full bathrooms—one with a shower and the other with (...)
€449,900
TSEA5152006
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 101 Lot Size: 42 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Lot Size: 42 Area: Marbella East Region: Andalucía
Unique Stunning Ibiza-Style Townhouse with Private Garden – Cabopino Area minimalistic decorated with micro cement , wood and linen !!
Discover this beautifully renovated townhouse offering the (...)
€699,000
TSEA5151985
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 5 M2: 284 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 5 M2: 284 Area: Benalmadena Region: Andalucía
Unique opportunity in Benalmadena!
In the best area of Benalmadena, an impressive, fully renovated house is for sale, ready to move into. A property meticulously cared for, perfect as both a (...)
€359,000
TSEA5151778
- Archidona, Costa Del Sol, Antequera
Beds: 5 Baths: 5 M2: 510 Lot Size: 185 Area: Antequera Region: Andalucía
Beds: 5 Baths: 5 M2: 510 Lot Size: 185 Area: Antequera Region: Andalucía
Unique Baroque Townhouse for Sale in the Heart of Archidona, east of Antiquera. Step inside the timeless elegance of this impressive townhouse in the charming Andalusian town of Archidona. Spread (...)
€231,200
TSEA5151637
- San Roque, Costa Del Sol, San Roque
Beds: 3 Baths: 3 M2: 175 Area: San Roque Region: Andalucía
Beds: 3 Baths: 3 M2: 175 Area: San Roque Region: Andalucía
Townhouse in La Pólvora (San Roque, Costa del Sol)
In a quiet residential area of San Roque, well connected and with all amenities close at hand, lies this spacious townhouse, ideal for (...)
€495,000
TSEA5151043
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 211 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 211 Area: Mijas and Mijas Costa Region: Andalucía
Are you dreaming of a spacious home in peaceful and beautiful surroundings – close to both the coast and the mountains? Then this property is perfect for you.
3 bright bedrooms
2 bathrooms
Large (...)
€550,000
TSEA5150941
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 178 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 178 Area: Mijas and Mijas Costa Region: Andalucía
FANTASTIC PROPERTY IN A PRESTIGOUS LOCATION
We are delighted to offer this lovely duplex town house in the very convenient location of Miraflores Resort. The property comprises:- Spacious lounge with (...)
€495,000
TSEA5150911
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
This beautiful, fully exterior apartment stands out for its excellent location and natural brightness throughout. Located in a peaceful residential area of Marbella, it is just 400 meters from the (...)
€675,000
TSEA5150860
- Atalaya, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 212 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 212 Area: Estepona Region: Andalucía
Spacious 4-Bedroom Townhouse in Sought-After Atalaya
Located in the highly desirable residential area of Atalaya—perfectly positioned between Estepona's charming old town and glamorous (...)
€222,900
TSEA5150437
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 64 Area: Mijas and Mijas Costa Region: Andalucía
**64 m² Studio Apartment for Sale – Riviera del Sol, Costa del Sol (Spain)**
This attractive ground floor studio is located in a gated and secure community, just 400 meters from the beach, (...)
€435,000
TSEA5150092
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 3 M2: 225 Area: Estepona Region: Andalucía
Beds: 5 Baths: 3 M2: 225 Area: Estepona Region: Andalucía
Renovation Project: Stunning South-Facing Townhouse Near the Beach and Laguna Village – Motivated Seller!
Seize this fantastic renovation opportunity with endless potential in a spacious 5-bedroom, (...)
€165,000
TSEA5149822
- Manilva, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 38 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 38 Area: Manilva Region: Andalucía
Situated in Playa Paraíso, Manilva, this charming duplex apartment enjoys an enviable position just a few steps from a quiet and peaceful stretch of beach.
The area offers a tranquil coastal (...)
€452,000
TSEA5148715
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 213 Area: Mijas and Mijas Costa Region: Andalucía
Semi-detached house for sale located in the exclusive area of Calahonda, Mijas Costa, within a quiet and well-connected residential complex. A unique opportunity to acquire a spacious home on (...)
Current Featured Properties
€599,000
TSEA4765870
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Lot Size: 31 Area: Fuengirola Region: Andalucía
These impressive homes, set over 4 floors provide 3 bedrooms, 2.5 bathrooms, an ample basement area, private parking, garden, solarium and multiple terraces. The blend of sleek design with the (...)
€465,000
TSEA4292032
- Manilva, Costa Del Sol, Manilva
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
Beds: 4 Baths: 3 M2: 148 Area: Manilva Region: Andalucía
LARGE GARDEN, AMAZING VIEWS AND GYM!!!
In an incomparable enclave with magnificent views, a project of 40 semi-detached and semi-detached houses with 3 and 4 bedrooms with large terraces to enjoy (...)
€1,595,000
TSEA5010322
- La Heredia, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 308 Lot Size: 181 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 308 Lot Size: 181 Area: Benahavis Region: Andalucía
STUNNING 5-BEDROOM TOWNHOUSE WITH PANORAMIC SEA, MOUNTAIN AND GOLF VIEWS
Located in the award winning village of La Heredia, close to Benahavis on the Ronda road, this beautiful 5-bedroom townhouse (...)
