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 (51,39,40,41,162,163)
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 (51,39,40,41,162,163)
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 (51,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 2541 - 2560 of 3915 €2,075,000
TSEA4980892
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 174 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 174 Area: La Duquesa Region: Andalucía
This is a complex of 2 and 3 bedroom apartments, 3 and 4 bedroom penthouses and 5 large bungalows with 3 bedrooms 3 bathrooms plus a guest cloakroom. located on the first line of the beach.
All homes (...)
€795,000
TSEA4980841
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 113 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 113 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse, Calahonda, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 113 m², Terrace 150 m².
Setting : Country, Commercial Area, Close To Golf, Close To Shops, Urbanisation.
Orientation : (...)
€1,495,000
TSEA4980742
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 166 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 166 Area: Marbella Region: Andalucía
Exquisite Apartment with Sea Views in Mansion Club, Marbella's Prestigious Golden Mile
Nestled in the exclusive Mansion Club on Marbella's Golden Mile, this wonderful first-floor apartment offers (...)
€420,000
TSEA4980739
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Discover this stunning, brand-new apartment, built to the highest standards and impeccably furnished and decorated with exclusive Valentino designs. Located within the prestigious Celere Views (...)
€275,000
TSEA4980712
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 79 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 79 Area: Benahavis Region: Andalucía
A beautiful second floor 1 bed apartment - A practical hassle-free investment!
This property offers the perfect blend of resort hotel services and amenities with the independence of an apartment. (...)
€415,000
TSEA4980601
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 98 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 98 Area: Estepona Region: Andalucía
FANTASTIC 3-BEDROOM APARTMENT IN ESTEPONA!!
With an unbeatable location in Estepona Pueblo, this property is 200 meters from the beach and the Estepona Viewpoint. You'll be in the Estepona Marina (...)
€810,000
TSEA4980541
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Luxury Apartment on the Beach with direct Gate Access.
The apartment is located in a modern, bright, quiet, family friendly community. No Noisy neighbours – a villa one side and a protected nature (...)
€900,000
TSEA4980526
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 2 Baths: 2 M2: 133 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Sotogrande Region: Andalucía
This stunning mid-floor apartment is located in the exclusive Village Verde community in Sotogrande, one of Spain's most sought-after luxury destinations. Designed for modern living, the property (...)
€390,000
TSEA4980283
- Costalita, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
OPPORTUNITY NEXT TO THE BEACH IN THE EXCLUSIVE AREA OF COSTALITA
Located on the New Golden Mile, between Marbella and Estepona in the exclusive area of Costalita, less than 400 meters from the (...)
€650,000
TSEA4980025
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 144 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Area: Marbella East Region: Andalucía
Situated on the third floor, this stunning apartment is nestled within the sought-after Hacienda Playa Phase 3, providing a delightful glimpse of the sparkling sea. Boasting two generously sized (...)
€118,000
TSEA4979992
- Sayalonga, Costa Del Sol East
Beds: 4 Baths: 1 M2: 193 Lot Size: 193 Region: Andalucía
Beds: 4 Baths: 1 M2: 193 Lot Size: 193 Region: Andalucía
Duplex for sale in immaculate condition in the picturesque village of Sayalonga, ideally located close to the shops and church, ensuring easy access to all local amenities. On the first floor, the (...)
€600,000
TSEA4979887
- Río Real, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 187 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 187 Area: Marbella East Region: Andalucía
Discover this beautiful apartment located in one of the most emblematic areas of Marbella, in the prestigious urbanization of Rio Real. A home that combines spaciousness, comfort and the essence of (...)
€425,000
TSEA4979833
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 110 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 110 Area: Marbella East Region: Andalucía
Spacious 3-Bedroom Corner Apartment for Sale – Santa Maria Village, Elviria
Large Covered Terrace | 3 Bedrooms | 3 Bathrooms | Garage & Storage | Secure Complex
Discover this beautifully (...)
€530,000
TSEA4979722
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 145 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Area: Marbella Region: Andalucía
Unique opportunity in the heart of Marbella!
Two 2-bedroom apartments for sale, currently combined into a spacious and bright 4-bedroom home in the heart of Marbella. Boasting an unbeatable (...)
€430,000
TSEA4979644
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 84 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 84 Area: Casares Region: Andalucía
Townhouse, Casares Playa, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 84 m².
Setting : Beachfront, Beachside, Close To Golf, Close To Port, Close To Shops, Close To Sea, Close To Town, Close To (...)
€275,000
TSEA4979293
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Lot Size: 38 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Lot Size: 38 Area: Estepona Region: Andalucía
In this small gated community of only 18 apartments we have this beautiful, frontline golf, 2 bed 2 bath ground floor, south west facing apartment in Estepona Golf. 40m2 private garden, peaceful (...)
€950,000
TSEA4979287
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 124 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Estepona Region: Andalucía
Discover this stunning, move-in-ready Penthouse located in Las Mesas, one of Estepona's
most sought-after areas. Perfectly positioned within walking distance to the beach, Estepona
Marina, shops, and (...)
€475,000
TSEA4970881
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Benalmadena Region: Andalucía
New Development: Prices from 475,000 € to 1,019,000 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 124.00 m2 - 399.00 m2]
Experience the best views of the bay from your terrace
A residential (...)
€5,800,000
TSEA4978921
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 298 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 298 Area: Marbella East Region: Andalucía
Luxury beach front apartment in Oasis Club, this emblematic beachfront community on the Golden Mile of Marbella. This apartment features 3 bedrooms and 3 bathrooms.
It is the perfect residence for (...)
€450,000
TSEA4978912
- La Campana, Costa Del Sol, Marbella West
Beds: 4 Baths: 2 M2: 178 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 2 M2: 178 Area: Marbella West Region: Andalucía
A spacious 4 bedroom apartment situated in the area of La Campana, with plenty of amenities right on the doorstep and just a 10 minute drive to the beach. The apartment is perfect for permanent (...)
Current Featured Properties
€1,190,000
TSEA5002087
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Discover the beauty of the natural surroundings of your community. Enjoy the serenity of a home committed to nature, which cares for the environment and is committed to replanting native vegetation (...)
€585,000
TSEA4164577
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 130 Lot Size: 210 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 210 Area: Marbella East Region: Andalucía
BEACHFRONT HOME FOR SALE - LIVE THE BEACH LIFE YOU'VE ALWAYS WANTED!!
This middle floor apartment located in Elviria, Marbella East is a great investment opportunity for those who love the beachfront (...)
€557,000
TSEA4989562
- Valle Romano, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Estepona Region: Andalucía
The residential complex has a total of 135 properties with 1, 2 or 3 bedrooms in 6 low-rise buildings. The modern, attractive design features clean, contemporary lines. The privileged south-facing (...)
