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 (31,42,43,44,45)
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 (31,42,43,44,45)
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 (31,42,43,44,45)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 341 - 360 of 6631
€540,000
TSEA5147887
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 130 Lot Size: 50 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 50 Area: Marbella West Region: Andalucía
Ground Floor Apartment, Nueva Andalucía, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 26 m², Garden/Plot 50 m².
Setting : Close To Schools, Urbanisation.
Orientation : East, (...)
€649,000
TSEA5147875
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 93 Lot Size: 250 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Lot Size: 250 Area: Fuengirola Region: Andalucía
Discover your new home in Torreblanca! This impressive detached house is an excellent investment opportunity, as it has a tourist license and is ready to move into. Located in the upper part of (...)
€425,000
TSEA5147836
- Hacienda del Sol, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
A beautifully located first-floor apartment in the highly sought-after Hacienda del Sol development. The apartment features a spacious master bedroom with an en-suite bathroom, a second bedroom, and (...)
€2,250,000
TSEA5147815
- Valtocado, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 6 M2: 556 Lot Size: 1,800 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 6 M2: 556 Lot Size: 1,800 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Detached Villa in Valtocado – Panoramic Sea & Mountain Views
This magnificent villa, set within the prestigious urbanisation of Valtocado, offers the perfect balance of elegance, space, (...)
€649,000
TSEA5147812
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 103 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: Benahavis Region: Andalucía
** Experience one of Marbella's most breathtaking panoramic Sea Views from this fully renovated apartment **
This spacious 103m² apartment has been completely renovated with high-quality finishes. (...)
€630,000
TSEA5147809
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 93 Lot Size: 139 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Lot Size: 139 Area: Fuengirola Region: Andalucía
Experience Contemporary Luxury in El Higuerón, Fuengirola
Discover this exclusive ground-floor apartment with a spacious private garden, designed in a modern and minimalist style in one of the most (...)
€415,000
TSEA5147797
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Fantastic 85m2 apartment with terrace. Spacious and bright, fully furnished and equipped with 2 bedrooms, 2 bathrooms, one en suite, on the beachfront in one of the most sought-after areas of the (...)
€199,000
TSEA5147791
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 26 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 26 Area: Benalmadena Region: Andalucía
Renovated Studio with Sea Views on the Top Floor – Puerto Marina, Benalmádena
Located on the seventh and top floor of a well-maintained building, this bright, renovated studio offers stunning (...)
€480,000
TSEA5147764
- Los Flamingos, 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
Imagine living in a spectacular penthouse in a very private and quiet complex, just at the entrance of Los Flamingos! This wonderful penthouse features 2 bedrooms and 2 bathrooms, a fully equipped (...)
€495,000
TSEA5147761
- Los Flamingos, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 110 Area: Estepona Region: Andalucía
Stunning Penthouse in an Exclusive and Peaceful Complex at the Entrance of Los Flamingos
This fantastic 3-bedroom, 3-bathroom penthouse offers the perfect blend of privacy, space, and breathtaking (...)
€585,000
TSEA5147521
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 110 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Marbella East Region: Andalucía
Spacious and bright ground floor apartment situated in a beachfront complex in Elviria.
The complex has a direct access to the beach, 2 open swimming pools (one is heated), beautiful well maintained (...)
€1,400,000
TSEA5147518
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 220 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 220 Area: Estepona Region: Andalucía
Modern Luxury Villa with Panoramic Golf & Sea Views in Estepona
This newly built modern villa in Valle Romano Golf, Estepona, boasts breathtaking panoramic views over both the golf course and (...)
€489,000
TSEA5147506
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 115 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Benahavis Region: Andalucía
Exclusive Apartment with Panoramic Views in Villa Padierna
Discover a rare opportunity to own a stunning apartment in the prestigious Villa Padierna community, Benahavís. With sweeping views over (...)
€495,000
TSEA5147467
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 81 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 81 Area: Fuengirola Region: Andalucía
???? Apartment for Sale – Paseo Marítimo, Fuengirola
Stunning fourth-floor apartment located on the beachfront, facing south with direct sea views.
The property features 2 bedrooms with built-in (...)
€2,250,000
TSEA5147461
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M2: 441 Lot Size: 1,384 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 4 M2: 441 Lot Size: 1,384 Area: Marbella West Region: Andalucía
Well located villa boarding the golf course in the low-density residential area of Nueva Andalucía, in the heart of the Golf Valley, about 10 minutes from both Marbella and Estepona and around 45 (...)
€5,390,000
TSEA5147437
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 588 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 588 Area: Marbella East Region: Andalucía
This exceptional duplex penthouse is located within Epic Marbella on the Golden Mile, one of the most prestigious addresses in Marbella. Designed to impress, the property spans 586 m², including 351 (...)
€345,000
TSEA5147416
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Charming two bedroom, two bathroom first floor apartment in quiet residential area close to golf, restaurants, shops and schools.
This south facing apartment is in fantastic condition and has (...)
€345,000
TSEA5147392
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Middle Floor Apartment, Selwo, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 132 m², Terrace 20 m².
Setting : Urbanisation.
Orientation : South West.
Condition : Excellent.
Pool : (...)
€775,000
TSEA5147380
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 127 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: San Pedro Region: Andalucía
Brand-new apartment in MARE Urbanización, San Pedro Alcántara
Discover this modern 3-bedroom, 2-bathroom apartment with 103 m² of interior space and a 30 m² sunny terrace, perfect for enjoying (...)
€2,950,000
TSEA5147371
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 7 Baths: 7 M2: 623 Lot Size: 1,400 Area: San Pedro Region: Andalucía
Beds: 7 Baths: 7 M2: 623 Lot Size: 1,400 Area: San Pedro Region: Andalucía
Detached Villa, Guadalmina Alta, Costa del Sol.
7 Bedrooms, 7 Bathrooms, Built 623 m², Terrace 60 m², Garden/Plot 1400 m².
Setting : Close To Golf, Close To Shops, Close To Schools.
Orientation : (...)
Current Featured Properties
€1,400,000
TSEA4341787
- Las Chapas, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 187 Lot Size: 182 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 187 Lot Size: 182 Area: Marbella East Region: Andalucía
LIVING IN PARADISE!!!
Your dream come true. Set among rolling hills on the outskirts of Marbella and caressed by sea breezes and infinite sky. A total of 104 three and four-bedroom homes will exceed (...)
€1,095,000
TSEA4624024
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
EMBRACE SPANISH LIFE TO THE FULLEST. Beautifully styled contemporary apartments and sky villas, extensive green areas and a PANORAMIC OVERVIEW of the Mediterranean sea is what sets this development (...)
€365,000
TSEA4545550
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 78 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 78 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 (...)
