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 161 - 180 of 7581
TSEA5155102
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 166 Lot Size: 385 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 166 Lot Size: 385 Area: Marbella Region: Andalucía
This exclusive villa in the heart of Marbella offers the perfect mix of modern style and comfortable living. It has 4 bedrooms, 2 bathrooms, a guest toilet, and two secure garage spaces. The home (...)
TSEA5155093
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 75 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 75 Area: Fuengirola Region: Andalucía
Modern Fully Renovated Apartment with Parking – Fuengirola
This stylish apartment, recently reformed to a high standard, is perfectly located in Fuengirola with excellent transport connections and (...)
TSEA5155090
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Located in the sought-after frontline beach development of Bahía Azul in Estepona West, this 2-bedroom townhouse offers an excellent opportunity to renovate and personalise a home in a prime coastal (...)
TSEA5155084
- Sotogrande Costa, Costa Del Sol, Sotogrande
Beds: 4 Baths: 3 M2: 252 Lot Size: 1,665 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 3 M2: 252 Lot Size: 1,665 Area: Sotogrande Region: Andalucía
New Build Key in Hand Dream Villa expected completion summer 2026.
An exceptional home that offers you a life without limits, combining rest and comfort.
With a constructed area of 252 m² (...)
TSEA5155075
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Apartment with two bedrooms, one bathroom, a fully equipped kitchen, a large living area with access to a terrace facing west, for sale in Riviera del Sol, Mijas Costa. This apartment is located in (...)
TSEA5155048
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 363 Lot Size: 150 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 363 Lot Size: 150 Area: San Pedro Region: Andalucía
Located in the well-established urbanisation of Tiro de Pichón, this traditional Andalusian townhouse offers 4 bedrooms and 3 bathrooms, set on a 240m2 plot with a built area of 309m2 plus (...)
TSEA5155027
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 55 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: Manilva Region: Andalucía
Lovely beachfront 1-bedroom apartment with sea views in La Noria, in Sabinillas.
We are welcomed by the large and bright living room that leads to a private covered terrace with beautiful sea and (...)
TSEA5155024
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 127 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 127 Area: Casares Region: Andalucía
Exclusive beachfront townhouse in Marina de Casares.
Charming corner house, located in one of the most privileged areas of the Costa del Sol, in Marina de Casares, perfectly situated between the (...)
TSEA5155012
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 182 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 182 Area: Estepona Region: Andalucía
For sale, beautiful modern 3-bedroom semi-detached house with a large garage.
Excellent location in the centre of Estepona, just 300 metres walk from Calle Terraza, close to all amenities and the (...)
TSEA5154985
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 422 Lot Size: 3,000 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 422 Lot Size: 3,000 Area: Marbella Region: Andalucía
Finca with Sea & Port Views – Marbella, Urb. Lindasol
Located to the East of Marbella, this 4 bedroom, 3 bathroom finca offers stunning views of the Mediterranean and down to the lively port. (...)
TSEA5154940
- Casares, Costa Del Sol, Casares
Beds: 5 Baths: 7 M2: 529 Lot Size: 867 Area: Casares Region: Andalucía
Beds: 5 Baths: 7 M2: 529 Lot Size: 867 Area: Casares Region: Andalucía
New Development: Prices from 3,500,000 € to 3,500,000 €. [Beds: 5 - 5] [Baths: 7 - 7] [Built size: 529.00 m2 - 529.00 m2]
Living on the Costa del Sol reaches a new level with this exclusive (...)
TSEA5154937
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Marbella West Region: Andalucía
Duplex in Nueva Andalucía, Costa del Sol
A unique opportunity in one of Marbella's most prestigious areas. This charming duplex with 3 bedrooms and 2 bathrooms is ideally located within walking (...)
TSEA5154919
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 1 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
BEACHFRONT OPPORTUNITY and a Perfect rental investment.
This large 1-bedroom apartment can easily accommodate a family of 4 to 5.
There is an open room on the entrance that can be made into a small (...)
TSEA5154904
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 280 Lot Size: 407 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 280 Lot Size: 407 Area: Marbella West Region: Andalucía
For Sale in Nueva Andalucía – La Campana
We present a beautiful house in Nueva Andalucía, located in the La Campana area and in excellent condition. The property features three spacious (...)
TSEA5154889
- Benamara, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 125 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 125 Area: Estepona Region: Andalucía
Corner Townhouse beachside between San Pedro and Estepona. Recently reformed this 4 bed 3 bath property sits in the wonderful Benamara complex walking distance to the beach. Modern brand new open (...)
TSEA5154883
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 138 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 138 Area: Marbella Region: Andalucía
Spacious Duplex ground floor with Renovation Potential in Xarblanca, Marbella
This charming Duplex ground floor, located in the popular residential area of Xarblanca in Marbella, offers an excellent (...)
TSEA5154874
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Modern flat for sale in the centre of Fuengirola, just 150 metres from the beach and surrounded by all services, shops and transport links. Located in a contemporary building built in 2023, this (...)
TSEA5154859
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 419 Lot Size: 419 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 419 Lot Size: 419 Area: Estepona Region: Andalucía
New Development: Prices from 1,800,000 € to 1,800,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 419.00 m2 - 419.00 m2]
Discover the collection of eight exclusive designed residential villas, (...)
TSEA5154856
- New Golden Mile, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 372 Lot Size: 567 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 372 Lot Size: 567 Area: Estepona Region: Andalucía
New Development: Prices from 2,650,000 € to 2,650,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 372.00 m2 - 372.00 m2]
Discover the collection of eight exclusive designed residential villas, (...)
TSEA5154850
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Spacious corner ground floor apartment of 3 bedrooms, 2 bathrooms, big lounge and dining area with exit to a West facing terrace of 68 m2, fully fitted kitchen. Has cold and hot A/C, metallic (...)
