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,42,43,44,45)
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,42,43,44,45)
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,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 841 - 860 of 3420 €438,000
TSEA5073124
- Tolox, Costa Del Sol, Yunquera
Beds: 3 Baths: 2 M2: 136 Lot Size: 3,002 Area: Yunquera Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Lot Size: 3,002 Area: Yunquera Region: Andalucía
Welcome to a beautiful finca perfectly nestled between the picturesque villages of Tolox and Alozaina, offering a fantastic mix of rustic living and modern comfort.
The main house has been carefully (...)
€550,000
TSEA5073013
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 103 Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Region: Andalucía
Great New Sea View Apartment in EL Higueron with TL
Description
Luxury Apartment with Panoramic Sea Views – El Higuerón, Fuengirola Experience elevated coastal living in this fully furnished, (...)
€949,000
TSEA5072992
- Torremuelle, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 288 Lot Size: 1,201 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 288 Lot Size: 1,201 Area: Mijas and Mijas Costa Region: Andalucía
Charming Villa with Sea Views & Huge Potential – Torremuelle, Benalmádena
Located in the sought-after residential area of Torremuelle, this charming villa offers the perfect opportunity to (...)
€2,300,000
TSEA5072962
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 333 Lot Size: 2,991 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 333 Lot Size: 2,991 Area: Marbella Region: Andalucía
The unbeatable location of a house in the center of Marbella with a 2,992 m2 plot.
4 bedrooms, 3 bathrooms
It's a perfect investment.
€3,300,000
TSEA5072929
- Cancelada, Costa Del Sol, Estepona
Beds: 6 Baths: 6 M2: 460 Lot Size: 1,067 Area: Estepona Region: Andalucía
Beds: 6 Baths: 6 M2: 460 Lot Size: 1,067 Area: Estepona Region: Andalucía
Modern newly built villa with 6 bedrooms and 6 en-suite bathrooms, spread over 3 floors and located in an exclusive area, designed for those seeking luxury, comfort, and style. With 460sqm of built (...)
€1,695,000
TSEA5072626
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 180 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 180 Area: San Pedro Region: Andalucía
Step into this beautifully renovated 3-bedroom, 3.5-bathroom duplex penthouse, ideally situated just steps from the beach and within easy walking distance to shops, the town center, restaurants, and (...)
€2,250,000
TSEA5072482
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 291 Lot Size: 850 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 291 Lot Size: 850 Area: Benahavis Region: Andalucía
Step into your dream home with this breathtaking Andalusian-style villa, which perfectly blends timeless elegance with modern luxury. Nestled in a serene setting with partial sea views, this stunning (...)
€455,000
TSEA5072401
- Los Arqueros, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 98 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Benahavis Region: Andalucía
Stunning Penthouse with Panoramic Views – Los Arqueros, Benahavís
Wake up every day to breathtaking views of the Mediterranean Sea, the majestic Benahavís mountains, and a lush golf course — (...)
€305,000
TSEA5071315
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 80 Lot Size: 1,680 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Lot Size: 1,680 Area: Estepona Region: Andalucía
Finca - Cortijo, Estepona, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 70 m², Terrace 20 m², Garden/Plot 1680 m².
Setting : Country, Close To Town.
Orientation : South.
Condition : Fair.
Pool : (...)
€1,190,000
TSEA5071291
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 227 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 227 Area: Mijas and Mijas Costa Region: Andalucía
EXCLUSIVE PENTHOUSE with PRIVATE POOL and SEA VIEWS in Benalmádena Costa
Discover this stunning penthouse in Cortijo de Torrequebrada! A truly unique property that combines luxury, spacious living (...)
€780,000
TSEA5071135
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 175 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Area: Sotogrande Region: Andalucía
URGENT SALE
Flat with certified valuation at €800,000. Price reduction for a quicker sale.
This property located in Ribera del Paraiso offers an unrivalled living experience in the heart of La (...)
€399,000
TSEA5071096
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 111 Lot Size: 110 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Lot Size: 110 Area: Mijas and Mijas Costa Region: Andalucía
SEMI-DETACHED HOUSE in Mijas Pueblo
Opportunity to acquire one of the unique properties you can find in the area. The property has 3 bedrooms, 2 full bathrooms, an open-plan kitchen with a living (...)
€265,000
TSEA5070973
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Tranquil Apartment with Panoramic Views in Puebla Tranquila, Mijas
This bright and inviting 73 m² apartment offers 2 well-proportioned bedrooms and 1 bathroom, all thoughtfully laid out to (...)
€1,250,000
TSEA5070868
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 250 Lot Size: 829 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 250 Lot Size: 829 Area: Marbella East Region: Andalucía
VILLA FOR SALE IN ELVIRIA JUST 10 MINUTES WALK FROM THE BEACH – A UNIQUE OPPORTUNITY TO INVEST IN EAST MARBELLA
LIVE OR INVEST IN THE HEART OF ELVIRIA
If you're looking for a detached villa with (...)
€750,000
TSEA5070838
- Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 128 Lot Size: 175 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Lot Size: 175 Area: Marbella East Region: Andalucía
The most beautiful corner house in the complex in Cabopino with incredible panoramic views of the sea, pine forest and golf course. Recently the house has been completely renovated and has large (...)
€334,000
TSEA5070799
- Bajondillo, Costa Del Sol, Torremolinos
Beds: 1 Baths: 1 M2: 43 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 1 M2: 43 Area: Torremolinos Region: Andalucía
Welcome to your dream coastal retreat in the heart of Torremolinos!
This beautifully designed one-bedroom apartment, built in 2018, perfectly combines modern living with unparalleled convenience. (...)
€1,795,000
TSEA5070685
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 265 Lot Size: 1,450 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 265 Lot Size: 1,450 Area: Estepona Region: Andalucía
Situated in a prime location in El Paraíso, Estepona, this south-facing villa offers great renovation potential just a 10-minute walk from the beach and close to shops, restaurants, schools, and (...)
€334,000
TSEA5070583
- Alcaucín, Costa Del Sol East
Beds: 4 Baths: 2 M2: 284 Lot Size: 1,125 Region: Andalucía
Beds: 4 Baths: 2 M2: 284 Lot Size: 1,125 Region: Andalucía
This charming chalet near Alcaucín offers the perfect blend of Mediterranean lifestyle, comfort, and a close-to-nature location. Surrounded by greenery and offering wonderful views of the (...)
€420,000
TSEA5070574
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 107 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Area: Benahavis Region: Andalucía
Located in the exclusive, gated community of La Quinta near Marbella, this 2-bedroom, 2-bathroom apartment offers a peaceful retreat with captivating views of the La Quinta Golf Course. Set in a (...)
€2,580,000
TSEA5070559
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 372 Lot Size: 1,335 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 372 Lot Size: 1,335 Area: Sotogrande Region: Andalucía
This Magnificent Home in Sotogrande
This stunning home in Sotogrande has been completely renovated with modern architectural and design trends in mind. Spacious and filled with natural light, it (...)
Current Featured Properties
€1,225,000
TSEA5020480
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 4 M2: 207 Lot Size: 103 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 4 M2: 207 Lot Size: 103 Area: Marbella East Region: Andalucía
This project is a complex of 21 luxurious residences in Marbella, embracing the natural surroundings and creating an ecosystem of peace and harmony. A boutique development offering the perfect (...)
€682,000
TSEA4251622
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 98 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Benalmadena Region: Andalucía
AN AMAZING LOCATION!!!
This is an exclusive, private development situated in a privileged location in Benalmádena. Thanks to its elevated position, all homes boast breathtaking panoramic views of (...)
€565,000
TSEA5138848
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 67 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 67 Area: Estepona Region: Andalucía
Your Dream Beachfront Home in Estepona
Imagine waking up every day with the sound of the waves just steps away. This beautifully renovated 2-bedroom, 2-bathroom apartment is set within one of (...)
