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 681 - 700 of 1524 €220,000
TSEA5042299
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 30 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 30 Area: Fuengirola Region: Andalucía
Looking for a ready-to-go holiday home or a smart investment property with instant income? This beautifully renovated 1-bedroom apartment in Fuengirola, could be exactly what you're after.
Located (...)
€295,000
TSEA5042227
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 69 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 69 Area: Nerja and Malaga East Region: Andalucía
Apartment in Nerja with 150 meters to the sea, sea views and the possibility of buying your own large garage.
Spacious apartment with two bedrooms and one bathroom, fully equipped kitchen with open (...)
€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 (...)
€5,950,000
TSEA5042191
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 294 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 294 Area: Estepona Region: Andalucía
UNIQUE BEACHFRONT PROPERTY WITH SEA VIEWS
Spectacular luxury property with enormous terraces and stunning sea views, in a prime beachfront location in Estepona, just minutes from the port and (...)
€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 (...)
€539,000
TSEA5041303
- El Presidente, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 125 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 125 Area: Estepona Region: Andalucía
Fantastic top-floor apartment, south-facing, in El Presidente. The beautiful entrance, filled with aromatic plants, welcomes us, and as soon as we enter the hall, we appreciate how the entire (...)
€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 (...)
€260,000
TSEA5041153
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 68 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 68 Area: Benahavis Region: Andalucía
Fully Renovated 1-Bedroom Apartment in a Unique Location in the Heart of Benahavís
Discover this beautiful, move-in-ready apartment located in the charming center of Benahavís. Recently fully (...)
€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
TSEA5040337
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 5 M2: 471 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 5 M2: 471 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to this exceptional five-bedroom, five-bathroom triplex located just moments from the heart of La Cala de Mijas. Offering an impressive blend of space, style, and resort-style living, this (...)
€649,000
TSEA5040316
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 98 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Benahavis Region: Andalucía
Stunning Penthouse with Golf Course Views and Tourist Licence in La Quinta
Set in the prestigious La Quinta area, just minutes away from Nueva Andalucía, Puerto Banús, and San Pedro de Alcántara, (...)
€850,000
TSEA5040163
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 136 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 136 Area: Fuengirola Region: Andalucía
Prestigious Two-Bedroom Penthouse with Private Elevator Access and Panoramic Sea Views at Higueron West
Welcome to one of the most exclusive and elegant penthouses in the sought-after Higueron West (...)
€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 (...)
Current Featured Properties
€1,960,000
TSEA4893418
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 217 Lot Size: 18 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 217 Lot Size: 18 Area: Marbella Region: Andalucía
A community of 27 opulent semidetached homes with expansive rooms, private gardens, swimming pools, and prime sea views can be found in Marbella at The List Rio Real. Because to its multi-level (...)
€518,000
TSEA3955906
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 118 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 118 Area: Estepona Region: Andalucía
ELEGANT AND MODERN IN THE HEART OF COSTA DEL SOL. This development is nestled in an incomparable natural environment where the sea meets the mountain and there is golf and all the services of (...)
€950,000
TSEA4430956
- Estepona, Costa Del Sol, Estepona
Beds: 5 Baths: 5 M2: 240 Area: Estepona Region: Andalucía
Beds: 5 Baths: 5 M2: 240 Area: Estepona Region: Andalucía
Exceptional very spacious townhouse located in frontline beach residential complex Belgravia club, Estepona.
This spectacular home has fantastic sea views and the location is unbeatable, just a few (...)
