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
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
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
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1481 - 1500 of 7575 €475,000
TSEA5117845
- Torrox Costa, Costa Del Sol East
Beds: 4 Baths: 3 M2: 161 Lot Size: 300 Region: Andalucía
Beds: 4 Baths: 3 M2: 161 Lot Size: 300 Region: Andalucía
Charming Renovated Villa with Private Pool & Sea Views in Torrox Costa (El Peñoncillo)
This beautifully renovated southeast-facing villa is located in the sought-after area of El Peñoncillo, (...)
€499,000
TSEA5117836
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 144 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Area: Estepona Region: Andalucía
Exclusive Duplex Penthouse with Sea Views in Estepona. Your New Retreat on the Costa del Sol!
Discover this spectacular 2-bedroom, 2-bathroom duplex penthouse located in a sought - after (...)
€2,700,000
TSEA5117815
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 137 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Marbella West Region: Andalucía
Fantastic 3 bedrooms, corner apartment on a 5th floor for sale in Marina Banus. Open sea views. lots of light as it is South facing. Immaculate!!! Parking and storeroom included in the price.
€410,000
TSEA5117806
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 94 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Benalmadena Region: Andalucía
Located in the sought-after area of Montealto, Benalmádena, this spacious 2-bedroom, 2-bathroom penthouse offers stunning sea and mountain views, a private rooftop terrace, and excellent outdoor (...)
€189,000
TSEA5117803
- Ojén, Costa Del Sol, Ojen
Beds: 1 Baths: 1 M2: 47 Area: Ojen Region: Andalucía
Beds: 1 Baths: 1 M2: 47 Area: Ojen Region: Andalucía
Ww offers MAGNIFICENT LIVING OPRTUNITY IN MÁLAGA!
Located 10 KM from Marbella, you have easy access to all the life of the city, with the privilege of living in a natural and quieter (...)
€545,000
TSEA5117773
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
This unique and beautifully partitioned 2-bedroom, 2-bathroom penthouse is cleverly configured as two separate apartments in one—each with its own fully equipped kitchen, living area, and bathroom. (...)
€698,000
TSEA5117764
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 125 Lot Size: 45 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Lot Size: 45 Area: Mijas and Mijas Costa Region: Andalucía
Discover your dream home in beautiful La Cala de Mijas. This charming, newly finished property is built on two floors and features, on the entrance floor; spacious living/dining area, open plan fully (...)
€7,950,000
TSEA5117725
- Marbella, Costa Del Sol, Marbella
Beds: 7 Baths: 6 M2: 676 Lot Size: 2,548 Area: Marbella Region: Andalucía
Beds: 7 Baths: 6 M2: 676 Lot Size: 2,548 Area: Marbella Region: Andalucía
Introducing a stunning contemporary villa located in the prestigious neighbourhood of La Cerquilla, nestled in the heart of Nueva Andalucía's Golf Valley. This exclusive 7-bedroom residence sits on (...)
€707,850
TSEA5117677
- Campanillas, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
We present an innovative residential project that redefines the concept of living in Malaga. The development features a variety of homes, from one-bedroom apartments to four-bedroom penthouses, all (...)
€411,840
TSEA5117674
- Campanillas, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 96 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 96 Area: Marbella Region: Andalucía
We present an innovative residential project that redefines the concept of living in Malaga. The development features a variety of homes, from one-bedroom apartments to four-bedroom penthouses, all (...)
€499,000
TSEA5117659
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 70 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Marbella West Region: Andalucía
Beautiful, stylishly renovated 2-bedroom apartment in the charming, popular, typically Spanish urbanization of La Maestranza, in the heart of Nueva Andalucia.
This apartment has been recently (...)
€399,000
TSEA5117656
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
Beautifully presented 2-bedroom, 2-bathroom apartment for sale in the sought-after area of Guadalmina Alta. The property was fully renovated in January 2023 and is in excellent condition—ready to (...)
€530,000
TSEA5117650
- Benajarafe, Costa Del Sol East
Beds: 2 Baths: 1 M2: 150 Lot Size: 101 Region: Andalucía
Beds: 2 Baths: 1 M2: 150 Lot Size: 101 Region: Andalucía
Welcome to your own slice of paradise. This charming Casa Mata, a traditional Andalusian fisherman's home, is nestled just 10 meters from the shoreline — offering the rare luxury of an oasis just a (...)
€620,000
TSEA5117644
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 3 M2: 221 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 3 M2: 221 Area: Marbella West Region: Andalucía
A Place You'll Never Want to Leave – Duplex in Le Village, Nueva Andalucía
Hidden among the peaceful, palm-lined streets of Nueva Andalucía lies a community unlike any other. Welcome to Le (...)
€290,000
TSEA5117293
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 55 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: Benalmadena Region: Andalucía
Lovely Corner Apartment with Panoramic Sea Views in Benalmádena Costa
Wake up every day to the sparkling blue of the Mediterranean and the gentle sea breeze from your private balcony. This (...)
€412,000
TSEA5117209
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 133 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Marbella Region: Andalucía
Fantastic opportunity to acquire a spacious ground floor apartment with a private garden and terrace, located in the prestigious and well-connected area of East Marbella. The property is situated (...)
€595,000
TSEA5117206
- Nagüeles, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 127 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Marbella Region: Andalucía
This spacious and light-filled duplex penthouse is located in the well-established residential community of Altavista, Nagüeles – one of Marbella's most desirable and quiet neighbourhoods, ideally (...)
€995,000
TSEA5117146
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 166 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 166 Area: San Pedro Region: Andalucía
Discover a rare opportunity to own an exceptionally spacious apartment on the 4th floor of a sought-after complex in Guadalmina Alta. Perfectly positioned in one of the area's most desirable (...)
€795,000
TSEA5117113
- Arenas, Costa Del Sol East
Beds: 5 Baths: 5 M2: 322 Lot Size: 5,297 Region: Andalucía
Beds: 5 Baths: 5 M2: 322 Lot Size: 5,297 Region: Andalucía
Nestled in the hills of Arenas, Málaga, this enchanting cortijo is more than just a home it's a Mediterranean haven full of character, peace, and possibility. Divided into three separate apartments, (...)
€650,000
TSEA5117035
- Nagüeles, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 137 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 137 Area: Marbella Region: Andalucía
NEW PRICE..MOTIVATED VENDOR. Super opportunity to obtain a spacious apartment in the Golden Mile, within the sought-after area of Nagūeles.
Gated community with concierge.
The community within which (...)
Current Featured Properties
€1,250,000
TSEA5115490
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 135 Lot Size: 195 Area: Estepona Region: Andalucía
NEW DEVELOPMENT – Elegance and Exclusivity on the Costa del Sol!
Discover this new luxury project, a prestigious complex of 14 independent villas located in an exceptional setting in Estepona, (...)
€525,000
TSEA5074066
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 144 Area: Mijas and Mijas Costa Region: Andalucía
This development consists of 79 luminous 2 and 3 bedroom apartments and penthouses.
Located only 3 minutes away from the picturesque village La Cala de Mijas, with an abundance of bars, shops, (...)
€725,000
TSEA4858963
- Estepona, Costa Del Sol, Estepona
Beds: 6 Baths: 2 M2: 250 Lot Size: 4,000 Area: Estepona Region: Andalucía
Beds: 6 Baths: 2 M2: 250 Lot Size: 4,000 Area: Estepona Region: Andalucía
THE BEST OF BOTH WORLDS – COUNTRY LIVING JUST MINUTES FROM ESTEPONA TOWN.
If you're looking for peace and privacy without giving up convenience, this charming country estate is the perfect fit. (...)
