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)
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)
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)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1741 - 1760 of 1769 €587,000
Middle Floor Apartment in Los Monteros
- Los Monteros, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
LUXURY TO ITS HIGHEST STANDARD!!!
A development of 39 luxury apartments. Located in the upper part of Los Monteros, this contemporary design development distributed over 5 floors plus an attic, has (...)
€438,000
TSEA3969424
- Los Monteros, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 87 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Marbella East Region: Andalucía
SO PEACEFUL YOU WON'T HEAR A PIN DROP!!!
Come and see this fabulous development of 39 luxury apartments located in the upper part of Los Monteros. This contemporary design development distributed (...)
€1,100,000
TSEA3950773
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 159 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 159 Area: Estepona Region: Andalucía
Ggreat property in Alhambra del Golf ready to move in. High standards, perfect location, beach side, three bedrooms 3 baths, garage and storage. Closed gated secured complex. Beach side of the main (...)
€299,000
TSEA3936313
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 106 Lot Size: 218 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Lot Size: 218 Area: Estepona Region: Andalucía
LAST THREE BED AVAILABLE, GET IN TOUCH TODAY BEFORE IT IS GONE!!!
Brand new project, 90 dwellings of 1, 2 and 3 bedrooms, all of them with garage space and storage room. It is an exclusive (...)
€577,500
TSEA3923743
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
GREAT LOCATION CLOSE TO CHARMING ESTEPONA.
The apartments are specially designed to fully enjoy the charm of the Mediterranean lifestyle. A well thought out floor plan, bathrooms with lovely (...)
€570,000
TSEA3922510
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
LAST OPPORUNITY TO ACQUIRE!!!!
One of the last opportunities to acquire a newly built property in the centre of Estepona, seaside and just 1 minute from the beach. A dream lifestyle which can be (...)
€600,000
TSEA3898675
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 141 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Area: Estepona Region: Andalucía
2 bedroom apartment located in the hotel complex called Paraiso Beach, located in the Paraiso Barronal Urbanization, Cancelada, between Marbella and Estepona, Malaga
The apartment has 2 bedrooms and (...)
€320,000
TSEA3800587
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 70 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 70 Area: Marbella West Region: Andalucía
Nice one bedroom apartment for sale is located in the best area of Nueva Andalucía a few minutes walk from Puerto Banus and all amenities such as shops, bars, restaurants. T
he apartment is in (...)
€750,000
TSEA3738733
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 152 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 152 Area: Marbella West Region: Andalucía
This is a High quality three bedrooms apartment on a first floor enjoy a fabulous location in the heart of the prestigious golf valley in Marbella, They are ideally situated within five minutes drive (...)
€279,000
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, (...)
€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 (...)
€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, (...)
Current Featured Properties
€425,000
TSEA5057473
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 101 Lot Size: 62 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Lot Size: 62 Area: Estepona Region: Andalucía
LOCATED IN BEAUTIFUL ESTEPONA!!!
One of the most attractive corners of the Costa del Sol. The town has become one of the most sought-after spots on the Costa del Sol, thanks to its quality of life (...)
€390,000
TSEA4790908
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 89 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Casares Region: Andalucía
New residential project of 43 units with different typologieNew development of five blocks, 43 units with communal swimming pool, landscaped green areas, parking spaces and storage rooms.
Each unit (...)
€409,000
TSEA4895635
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
This is an impressive new development located in Calanova Golf, Mijas Costa, Malaga. This luxury project, with the exclusivity of being the only agency offering it, offers a variety of housing (...)
