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 (39)
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 (39)
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 (39)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 421 - 440 of 1067 €475,000
TSEA5063128
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Estepona Region: Andalucía
Renovated Apartment with Independent Studio apartment close Estepona Port. Just twenty meters from the beach!
NEW PRICE: 475.000€!!
Price: €495.500
Surface: 137 m²
Bedrooms: 3
Bathrooms: (...)
€719,000
TSEA5063035
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
The apartment features two spacious bedrooms, one of which has an en-suite bathroom. The modern kitchen and living room have an open floor plan with direct access to the terrace. The master bedroom (...)
€195,000
TSEA5063017
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 1 Baths: 1 M2: 53 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 1 M2: 53 Area: Torremolinos Region: Andalucía
Located in the heart of Torremolinos, this beautifully renovated 1-bedroom apartment offers the perfect blend of comfort and convenience. Just a 15-minute walk to the beach, it's ideal for those (...)
€949,000
TSEA5063005
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 119 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 119 Area: Marbella Region: Andalucía
Discover this lovely bohemian-style apartment located on the first floor of one of the most prestigious and sought-after beachfront developments in Puerto Banús.
This exclusive community, (...)
€1,490,000
TSEA5063002
- Málaga, Costa Del Sol, Malaga
Beds: 4 Baths: 4 M2: 337 Area: Malaga Region: Andalucía
Beds: 4 Baths: 4 M2: 337 Area: Malaga Region: Andalucía
This exceptional duplex penthouse residence is situated in the upper area of the prestigious Cerrado de Calderón urbanization in Málaga. The property boasts a sought-after south-facing orientation (...)
€275,000
TSEA5062540
- Estepona, 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
We offers MAGNIFICENT APARTMENT LOCATED ON THE OUTSIDE OF ESTEPONA.
Ideal for habitual residence as well as for holiday or long term rental.
Characteristics of the property:
-Surface area: 89 m² (...)
€829,000
TSEA5062309
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 132 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: La Duquesa Region: Andalucía
This stunning 3 bedroom frontline beach apartment is located in La Duquesa, with panoramic sea views and just a few steps away from the beautiful beach.
Located within one of the most prestige (...)
€380,000
TSEA5061490
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 87 Lot Size: 35 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Lot Size: 35 Area: Mijas and Mijas Costa Region: Andalucía
This well maintained ground floor garden apartment has so much to offer. It has an amazing outside space. A covered seating area and plenty of space for sunbathing and the BBQ. There is direct (...)
€295,000
TSEA5061388
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 295,000 € to 340,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 92.00 m2 - 106.00 m2]
Next Real Estate Development in Riviera del Sol - Málaga
We present an (...)
€549,950
TSEA5061067
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 150 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Estepona Region: Andalucía
Exclusive Listing – Elevated Ground Floor 3-Bedroom Apartment in South Sand III, Las Mesas
Welcome to this elegant and contemporary 3-bedroom apartment in the sought-after South Sand III (...)
€455,000
TSEA5060989
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 109 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 109 Area: Benahavis Region: Andalucía
Spacious Ground Floor Apartment with Mountain & Sea Views in Gated La Quinta Urbanization
This beautifully maintained 2-bedroom ground floor apartment is located in a secure, gated urbanization (...)
€649,000
TSEA5058754
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 113 Lot Size: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 113 Lot Size: 90 Area: Estepona Region: Andalucía
Welcome to this stylish 2 bedroom ground floor corner apartment!
Step into effortless elegance with this beautifully designed ground floor corner apartment, newly built to offer the perfect blend of (...)
€205,000
TSEA5058691
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 65 Lot Size: 30 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 65 Lot Size: 30 Area: Casares Region: Andalucía
Exclusive listing! Have you seen this amazing groundfloor apartment in hacienda casares? Now for sale! Two bed, two bath apartment with parking space included in the same block, lifts are also of (...)
€540,000
TSEA5058598
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 115 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Casares Region: Andalucía
Exquisite beachfront property in Casares del Mar, this is a major beachfront development located in one of the most sought-after and desirable areas of Casares Costa. This private, gated community (...)
€1,099,000
TSEA5058223
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 137 Lot Size: 90 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Lot Size: 90 Area: San Pedro Region: Andalucía
Space, Comfort, and Prime Location — A Unique Opportunity in the Heart of San Pedro de Alcántara- 300 sq m +
We offer an extraordinary, exclusive apartment with over 300 m² of total area, (...)
€495,000
TSEA5057896
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 75 Lot Size: 49 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Lot Size: 49 Area: Marbella West Region: Andalucía
Step into this beautifully appointed 2-bedroom ground-floor apartment located in the prestigious Dama de Noche residential complex, just a stone's throw from Puerto Banús. Designed with a clean, (...)
€585,000
TSEA5057452
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 104 Area: Manilva Region: Andalucía
Magnificent 3 bedroom ground floor flat in the beautiful urbanisation of Marina Castillo, on the beachfront. A very nice flat, good qualities, with air conditioning hot/cold and home automation. The (...)
€1,795,000
TSEA5056534
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 3 M2: 207 Area: Marbella Region: Andalucía
Beds: 2 Baths: 3 M2: 207 Area: Marbella Region: Andalucía
Luxury Living Near Sierra Blanca | Gated Community | Turnkey Property
This exceptional 2-bedroom, 2-bathroom + guest toilet ground-floor apartment presents a rare opportunity to own a refined (...)
€320,000
TSEA5056441
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
New Development: Prices from 320,000 € to 616,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 75.00 m2 - 109.00 m2]
Our company is a real estate investment and development group with 80 years (...)
€420,000
TSEA5056393
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 42 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 42 Area: Marbella Region: Andalucía
Ground Floor Apartment, Marbella, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 42 m², Terrace 12 m².
Setting : Beachfront, Close To Sea.
Orientation : East, South East, South.
Condition : Fair.
Current Featured Properties
€535,000
TSEA5063977
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
This development is part of a perfectly established community with fully operational common areas. This project has a total of 82 houses to be developed in 2 phases. Phase I corresponds to blocks 1 (...)
€689,900
TSEA4624537
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
This brand new development stands out! An exclusive residential complex with spacious layouts and top-tier construction. The residences have been built with the highest-quality materials and feature (...)
€305,000
TSEA4707214
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
New development for sale in the center of Fuengirola just 200 m to the beach, historic center, near the Fuengirola Marina. There are 6 apartments with 2 and 3 bedrooms, with 2 bathrooms, terrace and (...)
