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 (40,36,37,38)
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 (40,36,37,38)
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 (40,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1761 - 1780 of 1780 €455,000
Beautiful contemporary apartments with stunning rooftop pool!
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 83 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 83 Area: Marbella West Region: Andalucía
CLOSE TO FABULOUS PUERTO BANUS AND THE BEACHES.
Offering homes from 90m2 to 150m2 with finishes of first QUALITY AND MODERN design. All have a large private terrace, garage space in the building (...)
€415,000
New homes for a fantastic price!
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 83 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 83 Area: Marbella West Region: Andalucía
MINUTES TO PUERTO BANUS, FANTASTIC VALUE IN NUEVA ANDALUCIA.
The property of YOUR DREAMS for you and your family is in a new neighbourhood, surrounded by all the services you may need: schools, (...)
€895,000
TSEA3609788
- Málaga Este, Costa Del Sol, Nerja and Malaga East
Beds: 3 Baths: 3 M2: 200 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Area: Nerja and Malaga East Region: Andalucía
Middle Floor Apartment, Málaga East beachfront, Costa del Sol.
3 Bedrooms, 3 Bathrooms, Built 200 m2;.
Setting : Beachfront, Town, Beachside, Close To Sea.
Climate Control : Air Conditioning.
Views (...)
€2,310,000
Beach-Side Luxury Apartments with Panoramic Views, Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 114 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 114 Area: Estepona Region: Andalucía
UNIQUE BOUTIQUE DEVELOPMENT BEACHSIDE ESTEPONA!!!!!
A special opportunity to own one of 9 apartments in a new beachside development close to the marina of Estepona. This PREMIUM LUXURY apartment (...)
€4,385,000
Luxury Beach-Side Apartments with Panoramic Views, Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 203 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 203 Area: Estepona Region: Andalucía
UNIQUE BOUTIQUE DEVELOPMENT BEACHSIDE ESTEPONA. A special opportunity to own one of 9 apartments in a new beachside development close to the marina of Estepona. This PREMIUM LUXURY apartment is (...)
€850,000
TSEA3592087
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 209 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 209 Area: Marbella West Region: Andalucía
Beautifully Renovated 3 Bedroom Apartment in Jardines del Puerto.
Experience luxury living in this beautifully renovated three-bedroom apartment, situated in the renowned Jardines del Puerto (...)
€995,000
Luxury Beach-Side Apartments with Fantastic Sea Views, Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 92 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Estepona Region: Andalucía
BOUTIQUE BEACHFRONT DEVELOPMENT IN ESTEPONA.
Amazing new development of ONLY 14 APARTMENTS right on the beachfront on the edge of Estepona town. This premium development will boast FABULOUS SEA AND (...)
€249,000
TSEA3534652
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 25 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 25 Area: Estepona Region: Andalucía
Studio in the center of Estepona, 50 meters from the beach, in a quiet alley on the first floor.
The apartment has a fully fitted kitchen with a dining room, a living-bedroom with a built-in wardrobe (...)
€470,000
Oasis of tranquility close to beaches
- San Roque, Costa Del Sol, San Roque
Beds: 3 Baths: 2 M2: 115 Area: San Roque Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: San Roque Region: Andalucía
OASIS OF TRANQUILITY CLOSE TO BEACHES.
New release! A great opportunity to buy an off plan apartment at an UNBEATABLE PRICE. The apartment style is light and bright with large open plan living (...)
€319,500
Move straight in today, beach life is waiting for you
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 71 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Manilva Region: Andalucía
BEACH LIFE IS WAITING FOR YOU!!!
Sea, sun and nature merge in this residential complex close to the beach. In this oasis, cool off in one of the two large SWIMMING POOLS, perfect when there are more (...)
€1,500,000
TSEA3302287
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 170 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 170 Area: Estepona Region: Andalucía
Middle Floor Apartment, Estepona, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 170 m², Terrace 50 m².
Setting : Beachfront, Beachside, Close To Shops, Close To Sea, Close To Town, Urbanisation, (...)
€244,000
TSEA3237004
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 2 Baths: 1 M2: 80 Area: Manilva Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Area: Manilva Region: Andalucía
Flat in Sabinillas very bright corner, the facade overlooks three streets.
The entrance is direct from the street to a first floor, on the ground floor there is a store for sale as well.
Ideal for (...)
€368,300
TSEA3053995
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 101 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Fuengirola Region: Andalucía
SPACIOUS AND STYLISH, YOUR TWO FAVOURITE WORDS!
This new, OFF PLAN development is an innovative and elegant promotion of 1, 2 AND 3-BEDROOM APARTMENTS and penthouses with swimming pool, private (...)
€427,400
TSEA3053554
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 131 Lot Size: 100 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Lot Size: 100 Area: Fuengirola Region: Andalucía
EASY LIVING NEAR THE BEACHES, SHOPS AND RESTAURANTS.
This new development is an innovative and elegant promotion of APARTMENTS and penthouses with swimming pool, private parking and located in a (...)
€830,000
TSEA2998166
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 121 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 121 Area: Marbella West Region: Andalucía
This is a simply beautiful apartment in the fashionable Marina of Puerto Banus with views over the harbour. Completely reformed to a very high standard, it comprises 2 spacious bedrooms, the Master (...)
€505,000
TSEA2955539
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 115 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Marbella West Region: Andalucía
Magnificent fully refurbished apartment in the marina of Puerto Banus steps away from all facilities and the beach. The property comprises of 2 bedrooms, 2 bathrooms, large living / dining area, (...)
€799,500
Amazing panoramic views of the Mediterranean
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 2 M2: 92 Lot Size: 21 Area: Ojen Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Lot Size: 21 Area: Ojen Region: Andalucía
EXCEPTIONAL LIVING ON THE COSTA DEL SOL!!!
These exciting new off-plan apartments are being built with the highest quality materials to ensure the best standard of completion. The apartments feature (...)
€950,000
TSEA2929403
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 138 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Area: Marbella West Region: Andalucía
Fabulous apartment located in the heart of Puerto Banús, on the second line of Muelle Ribera, with panoramic views of the sea and the ships.
It counts on 3 bedrooms, 3 bathrooms (two of them en (...)
€1,500,000
TSEA823240
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 200 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 200 Area: Estepona Region: Andalucía
This luxury apartment is situated in Costalita on the beach side. Costalita is a nice gated complex with swimming pools and nice gardens. The apartment has 3 bedrooms and 3 bathrooms, a big living (...)
€600,000
TSEA3119527
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 86 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Malaga Region: Andalucía
2017-V MALAGA (Center) opportunity only in a building emblematic of the center of Malaga facing it Street Larios in a building historical of the century 18 protected i completely reformed in 2006 is (...)
Current Featured Properties
€382,000
TSEA5078233
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
This development is the vision of renowned architect — an architectural masterpiece that reimagines residential living as a seamless extension of the Mediterranean.
THE ESSENCE OF THE COSTA DEL (...)
€379,000
TSEA5138899
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 51 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Estepona Region: Andalucía
This is not simply a place to live. It's a lifestyle ecosystem. From sunrise swims in your private pool to sunset walks along the coastal path, this is more than just a home — it's a (...)
€2,406,000
TSEA4942102
- Málaga, Costa Del Sol, Malaga
Beds: 4 Baths: 3 M2: 263 Area: Malaga Region: Andalucía
Beds: 4 Baths: 3 M2: 263 Area: Malaga Region: Andalucía
71 luxury homes from 1 to 4 bedrooms, on the beachfront. The building, designed by the prestigious Lamela studio, has homes up to 404m2 built with large terraces facing the sea. Among the common (...)
