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 (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
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.approved = 1 AND pm.cat_id IN (31,36,39,42,49,68,87,75,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117)
GROUP BY p.id
ORDER BY p.created DESC
Results 7341 - 7360 of 7581
TSEA3738706
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 102 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Estepona Region: Andalucía
Bright apartment located in a fantastic luxury urbanization. This apartment has stunning panorami views of the sea, gardens and pool.HOT and COLD water included.
It is built with the best qualities, (...)
TSEA3731638
- Coín, Costa Del Sol, Coin
Beds: 4 Baths: 3 M2: 426 Lot Size: 6,864 Area: Coin Region: Andalucía
Beds: 4 Baths: 3 M2: 426 Lot Size: 6,864 Area: Coin Region: Andalucía
Finca with AFO!!
Great Finca very well built on a fully usable plot with plenty of water.
The property has very good road access located a short distance to Coin and is distributed over 3 floors as (...)
TSEA3730702
- Marbella, Costa Del Sol, Marbella
Beds: 5 Baths: 2 M2: 220 Area: Marbella Region: Andalucía
Beds: 5 Baths: 2 M2: 220 Area: Marbella Region: Andalucía
Fantastic Local in Marbella with a wonderful location practically on the beachfront fully finished and renovated ready to
Entering, this place would be very interesting for a dental clinic or for a (...)
TSEA3713270
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 5 Baths: 3 M2: 230 Area: La Duquesa Region: Andalucía
Beds: 5 Baths: 3 M2: 230 Area: La Duquesa Region: Andalucía
Excellent value for money - 5 bedrooms, 2 lounges, 2 kitchens - reformed duplex penthouse in the heart of Puerto de la Duquesa. Views of the marina and Duquesa Golf.
Apartment - Penthouse, La (...)
TSEA3712520
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 344 Lot Size: 440 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 344 Lot Size: 440 Area: San Pedro Region: Andalucía
INDEPENDENT HOUSE NEXT TO THE CENTER OF SAN PEDRO DE ALCÁNTARA
Independent villa, a few minutes walk from the center of San Pedro de Alcántara, the boulevard and all kinds of services (schools, (...)
World class design-led villas with spectacular views
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía
400,000€ discount if you purchase before completion! This is a sustainable luxury development of 18 individually designed villas situated in the 200-hectare country club estate of Real de La (...)
TSEA3704048
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 5 Baths: 5 M2: 1,104 Lot Size: 24,500 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 5 M2: 1,104 Lot Size: 24,500 Area: San Pedro Region: Andalucía
Impressive Luxury Villa in 24.500 m2 plot in Guadalmina.
Located in one of the best areas on Costa del Sol, close to golf and San Pedro de Alcántara and just a short ride to the beach.
The (...)
TSEA3700997
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 279 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 279 Area: Marbella West Region: Andalucía
Magnificent front line beach duplex penthouse apartment, situated within walking distance of Puerto Banús and its beautiful Marina. The property enjoys fabulous views over the landscaped gardens the (...)
TSEA3688946
- Los Barrios, Costa Del Sol, Algeciras
Beds: 4 Baths: 3 M2: 478 Lot Size: 1,216 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 3 M2: 478 Lot Size: 1,216 Area: Algeciras Region: Andalucía
Beautiful villa in classic Andalusian style,
on a plot of 1216 m2 with south east exposure, the villa has a constructed area of 478 m2,
completely renovated, equipped with hot and cold air (...)
TSEA3687812
- Entrerrios, Costa Del Sol
Beds: 3 Baths: 3 M2: 1,018 Lot Size: 72,000 Region: Andalucía
Beds: 3 Baths: 3 M2: 1,018 Lot Size: 72,000 Region: Andalucía
Reduced from 1.710.000 to 1.590.000 for a quick sale
Large rustic finca right next to the river with a plot of 72.000m2!
This property has easy access to the road, is about 7km from the coast and its (...)
TSEA3687089
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 129 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 129 Area: Estepona Region: Andalucía
Top Floor Apartment, Atalaya, Costa del Sol.
3 Bedrooms, 4 Bathrooms, Built 129 m², Terrace 48 m².
Setting : Mountain Pueblo, Close To Golf, Close To Town, Close To Schools, Close To Forest, (...)
TSEA3679934
- Yunquera, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 98 Lot Size: 130,000 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 98 Lot Size: 130,000 Area: Marbella Region: Andalucía
The perfect place for growing avocado trees and start a new business. According to experts, the best in the province of Malaga. Thirteen hectares with several water wells and the right to seventy (...)
TSEA3672731
- Coín, Costa Del Sol, Coin
Beds: 5 Baths: 3 M2: 400 Lot Size: 6,575 Area: Coin Region: Andalucía
Beds: 5 Baths: 3 M2: 400 Lot Size: 6,575 Area: Coin Region: Andalucía
Stunning country house with wonderful views, with a profit of € 30,000 from the own avocado plantation, per year.
The construction area of this house is 362m2 built, it has 158m2 basement, (...)
TSEA3670745
- Atalaya, Costa Del Sol, Estepona
Beds: 7 Baths: 7 M2: 920 Lot Size: 3,244 Area: Estepona Region: Andalucía
Beds: 7 Baths: 7 M2: 920 Lot Size: 3,244 Area: Estepona Region: Andalucía
Cozy independent Andalusian style villa in Atalaya, Estepona, close to all services and golf courses. The villa is divided into two parts and each of them has its independent access and entrance. In (...)
TSEA3668675
- Casares Playa, Costa Del Sol, Casares
Beds: 4 Baths: 2 M2: 310 Lot Size: 2,200 Area: Casares Region: Andalucía
Beds: 4 Baths: 2 M2: 310 Lot Size: 2,200 Area: Casares Region: Andalucía
Beautiful RUSTIC STYLE FINCA with 2,200m plot in CASARES PLAYA, recently RENOVATED giving it a modern touch throughout, such as the kitchen and bathrooms. This magnificent property is excellently (...)
TSEA3667556
- Marbesa, Costa Del Sol, Marbella East
Beds: 5 Baths: 6 M2: 390 Lot Size: 779 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 6 M2: 390 Lot Size: 779 Area: Marbella East Region: Andalucía
TOTALLY NEW ULTRA MODERN BEACHSIDE VILLA WITH SEA VIEWS IN MARBESA, ELVIRIA BEACH.
Fabulous brand new modern villa situated in the residential area of Marbesa Beach, one of the areas of Elviria, (...)
TSEA3662555
- Totalán, Costa Del Sol East
Beds: 1 Baths: 1 M2: 80 Lot Size: 60,000 Region: Andalucía
Beds: 1 Baths: 1 M2: 80 Lot Size: 60,000 Region: Andalucía
Totalán is a village located in Malaga's Axarquía, just half an hour from Malaga city center and the airport. The farm has 60,000 m2 with mango and avocado trees and vines of various kinds of (...)
TSEA2755061
- Guaro, Costa Del Sol, Guaro
Beds: 1 Baths: 1 M2: 110 Area: Guaro Region: Andalucía
Beds: 1 Baths: 1 M2: 110 Area: Guaro Region: Andalucía
A property that could be your ‘little piece of heaven' with a little imagination this property could be amazing.
The views are wow, with the outdoor terrace is asking for a chill out seating (...)
TSEA3651992
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 270 Lot Size: 250 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 270 Lot Size: 250 Area: San Pedro Region: Andalucía
Bright and spacious corner townhouse with a large garden of 250m.
Located in a sought-after area, near the Golf Club and the shopping center and 7 minutes from the beach.
The community has concierge (...)
TSEA3650831
- Alcaucín, Costa Del Sol East
Beds: 3 Baths: 1 M2: 299 Lot Size: 3,600 Region: Andalucía
Beds: 3 Baths: 1 M2: 299 Lot Size: 3,600 Region: Andalucía
Before the professional cultivation of avocado and mango came to Axarquía not so many years ago, it was mainly almond and olive trees that shaped the landscape on the Costa del Sol. Even today, (...)
