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 301 - 320 of 6631
€370,000
TSEA5149840
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€475,000
TSEA5149831
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
The spacious apartment to reform with 2-bedroom, 2-bathroom (one en suite) is located in an exclusive frontline beach complex in Calahonda. Situated on the third floor with lift access, it boasts a (...)
€370,000
TSEA5149801
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€425,000
TSEA5148742
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
ELVIRIA. LOVELY APARTMENT WITH GREAT POTENTIAL SITUATED ON THE TOP FLOOR IN THE CENTRAL URBANIZATION OF PARQUE ELVIRIA. THE APARTMENT IS 105 m2 INCLUDING TERRACES. THE APARTMENT HAS 3 BEDROOMS AND 2 (...)
€400,000
TSEA5148733
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 1 Baths: 1 M2: 71 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 1 M2: 71 Area: Marbella East Region: Andalucía
Beautiful one bedroom apartment with spacious lounge dining room, fitted kitchen and terrace. Property has air conditioning, marble floors, 1 storage room and a parking space in the underground (...)
€185,000
TSEA5148727
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Discover the charm of this beautiful and spacious studio, which was originally a cozy one-bedroom apartment. Located in a prime location, you'll enjoy spectacular sea views from the comfort of your (...)
€1,850,000
TSEA5148709
- Istán, Costa Del Sol, Istan
Beds: 4 Baths: 5 M2: 234 Lot Size: 800 Area: Istan Region: Andalucía
Beds: 4 Baths: 5 M2: 234 Lot Size: 800 Area: Istan Region: Andalucía
This exceptional four-bedroom villa, occupies the best position within the prestigious gated community of Sierra Blanca Country Club. Offering 100% privacy and uninterrupted panoramic views across (...)
€315,000
TSEA5148703
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 78 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 78 Area: Torremolinos Region: Andalucía
FLAT FOR SALE IN TORREMOLINOS
Beautiful, sunny flat for sale, built in 2007 with high-quality finishes, located on the second floor of a building with a lift and only seven neighbours, completely (...)
€315,000
TSEA5148673
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
spacious 3 bed 2 bath apartment centrally located
large communal pool
in need of some updating
located close to shops and restaurants
Middle Floor Apartment, Las Lagunas, Costa del Sol.
3 (...)
€285,000
TSEA5148664
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic apartment located in Las Lagunas.
Discover this fantastic 126 m2 apartment located in the coveted area of Las Lagunas.
The property features three bedrooms, all equipped with (...)
€595,000
TSEA5148604
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 152 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 152 Area: Mijas and Mijas Costa Region: Andalucía
Bright and Spacious 3 Bed Corner Apartment with Stunning Views, Private Terrace and Premium Facilities
Welcome to this inviting 3-bedroom apartment in the sought-after Las Olas complex in (...)
€535,000
TSEA5148583
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
This four-bedroom flat, situated in the heart of Marbella, Malaga, presents an exceptional opportunity for those seeking a well-located property with substantial potential. Set within a gated (...)
€174,500
TSEA5148568
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 60 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Manilva Region: Andalucía
*** Walk Everywhere Apartment - No Car Necessary! ***
Charming apartment ideally located in the centre of San Luis de Sabinillas.
**** NOTE: This is a 1 bedroom and 1 bath apartment, however, it (...)
€590,000
TSEA5148544
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
For sale: an exclusive apartment located in one of the most sought-after residential areas of Nueva Alcántara, San Pedro de Alcántara. This property stands out for its spacious layout, prime (...)
€4,195,000
TSEA5148511
- Las Brisas, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 341 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 341 Area: Marbella West Region: Andalucía
We're pleased to offer an off-market villa in one of the most desirable areas of Nueva Andalucía – Las Brisas – available exclusively through private introduction.
This south-facing villa, (...)
€459,000
TSEA5148505
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 114 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Fuengirola Region: Andalucía
Fantastic Apartment with Sea Views on the Second Line of the Beach
In the Torreblanca area.
Spacious and bright apartment in a high-quality building of approximately 130 m2, just steps from the (...)
€238,000
TSEA5148484
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 1 M2: 60 Area: Ojen Region: Andalucía
Beds: 2 Baths: 1 M2: 60 Area: Ojen Region: Andalucía
Middle Floor Apartment, Ojén, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 60 m².
Setting : Town, Close To Schools.
Orientation : South West.
Condition : Good.
Climate Control : Air Conditioning, (...)
€743,000
TSEA5148427
- Los Alamos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 102 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 102 Area: Torremolinos Region: Andalucía
Looking to live by the sea in a prime location?
Close proximity to parks, schools, supermarkets, restaurants, and bars.
Easy access to the highway, with quick connections along the coast.
Just a (...)
€2,025,000
TSEA5148343
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 3 M2: 168 Lot Size: 984 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 3 M2: 168 Lot Size: 984 Area: Marbella West Region: Andalucía
This charming villa is tucked away in a peaceful cul-de-sac within the exclusive gated community of Marbella Country Club, one of Nueva Andalucía's most desirable residential areas. Set on a flat (...)
€344,900
TSEA5148319
- Torre del Mar, Costa Del Sol East
Beds: 3 Baths: 2 M2: 96 Lot Size: 96 Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Lot Size: 96 Region: Andalucía
This modern apartment in the center of Torre del Mar combines comfort, brightness, and an unbeatable location. The property offers 3 bedrooms, one of them currently used as a laundry room, adding (...)
Current Featured Properties
€505,000
TSEA4726054
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 116 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Casares Region: Andalucía
LAST CHANCE TO BUY! SEA VIEWS THAT YOU DREAM ABOUT!!!
Last 2 beds starting from 360,495€ and one last 3 bed at 558,000€!
Designed in a contemporary style, the apartments and penthouses have been (...)
€403,000
TSEA4686217
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 105 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Casares Region: Andalucía
Located in the area of Doña Julia Golf, this new development emerges as an oasis of elegance and tranquility on the Costa del Sol, much more than a simple residential area. A refuge for lovers (...)
€520,000
TSEA5106760
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Discover, an incredible new development in one of Estepona's most exclusive areas. This private residential complex features apartments, including flats, penthouses, and ground-floor units with 2, 3, (...)
