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,36,37,38)
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,36,37,38)
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,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 161 - 180 of 1080
€135,000
TSEA5130694
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 1 Baths: 1 M2: 51 Area: Alhaurin el Grande Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Alhaurin el Grande Region: Andalucía
Charming corner apartment of almost 51m², located on a quiet street in the centre of Alhaurín El Grande. The property has two entrances: one through the kitchen and the other through the living (...)
€250,000
TSEA5130538
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 71 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: La Duquesa Region: Andalucía
Charming ground-floor apartment with terrace and mountain views – La Duquesa. Beautiful and bright ground-floor apartment located in the sought-after area of La Duquesa, just 5 minutes by car from (...)
€860,000
TSEA5130514
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 113 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Malaga Region: Andalucía
Welcome to this unique beachfront duplex penthouse located on the prestigious Paseo Ibérico in Málaga. Spread across three well-designed levels, this 3-bedroom, 2-bathroom home offers a stylish (...)
€280,000
TSEA5129842
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 71 Lot Size: 11 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 71 Lot Size: 11 Area: Mijas and Mijas Costa Region: Andalucía
Charming Ground-Floor Apartment with Sunny Terrace and Garden – Just Minutes from the Beach in La Cala de Mijas
Welcome to picturesque La Cala de Mijas – one of the most sought-after coastal (...)
€735,000
TSEA5129824
- Los Flamingos, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 162 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 162 Area: Estepona Region: Andalucía
Beautiful 3-Bedroom Ground Floor Corner Apartment with Private Garden in Los Flamingos Golf Resort.
Located in the exclusive and secure Los Flamingos Golf Resort, this spacious 3-bedroom ground (...)
€350,000
TSEA5129761
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 79 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 79 Area: Estepona Region: Andalucía
Charming renovated garden apartment for Sale in El Paraiso Golf
We are delighted to present this beautifully renovated garden apartment, located in the heart of the prestigious El Paraiso Golf (...)
€785,000
TSEA5129731
- Limonar, Costa Del Sol
Beds: 3 Baths: 2 M2: 127 Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Region: Andalucía
Ground-Floor Apartment with Excellent Layout, Bright and Ready to Move Into
Located in a quiet yet well-connected area, this home is ideal for families, couples, or as an (...)
€450,000
TSEA5129584
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 77 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Benalmadena Region: Andalucía
Stylish Property in Blossom Phase 2 – Benalmádena Pueblo
Situated in the charming and sought-after Benalmádena Pueblo, this modern and move-in-ready home is part of the high-quality new (...)
€154,000
TSEA5129581
- Casares Playa, Costa Del Sol, Casares
Beds: 1 Baths: 1 M2: 55 Area: Casares Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: Casares Region: Andalucía
Apartment 100m from the beach with terrace – Investment opportunity
Prime location near the beach
Charming apartment just 100 meters from the sea, set in a quiet area with excellent access to all (...)
€344,500
TSEA5129047
- Punta Chullera, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 172 Lot Size: 14 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 172 Lot Size: 14 Area: Sotogrande Region: Andalucía
An exclusive, ultra-luxury property located just 4 km from Sotogrande and only 900 meters from the beach. Nestled in a prestigious gated community surrounded by lush golf courses, this exceptional (...)
€535,000
TSEA5129002
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 124 Lot Size: 25 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Lot Size: 25 Area: Estepona Region: Andalucía
Modern Family Home in the Popular Oasis – Selwo, Estepona
Welcome to Oasis, a sought-after and modern new development located in the up-and-coming Selwo area of Estepona. Ideally situated between (...)
€379,000
TSEA5128990
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 98 Lot Size: 16 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Lot Size: 16 Area: Estepona Region: Andalucía
Fantastic apartment in the New Golden Mile, Estepona!
Beautiful ground floor Apartment.
It has 2 bedrooms and two bathrooms, the master bedroom with en suite bathroom. From the secondary bedroom (...)
€350,000
TSEA5127880
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic apartment in Miraflores!
This apartment is located in one of the most popular communities in Miraflores.
Just a short walk from shops, restaurants, and the sea, this is a fantastic (...)
€260,000
TSEA5127871
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Fantastic apartment located in Los Boliches.
Fantastic apartment located in Los Boliches. It is a ground floor apartment with a constructed area of 61 m².
It consists of a bedroom with a built-in (...)
€345,000
TSEA5127775
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 80 Lot Size: 167 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Lot Size: 167 Area: Estepona Region: Andalucía
Attractive 2 bedroom, ground floor apartment off the New Golden Mile!
Tucked inside the tranquil Sun Garden residential complex in Estepona East, this 80m2 ground-floor apartment radiates warmth, (...)
€245,000
TSEA5127607
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 3 M2: 90 Lot Size: 110 Area: Casares Region: Andalucía
Beds: 2 Baths: 3 M2: 90 Lot Size: 110 Area: Casares Region: Andalucía
Located in the sought-after and secure urbanization of Casares del Sol, this ground-floor apartment offers a peaceful living environment just minutes from the sea and some of the region's finest golf (...)
€479,000
TSEA5127475
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Bright 2-Bed, 2-Bath Apartment Just 300m from the Beach – Torreblanca
Spacious and sunny 143m² southwest-facing apartment all on one level, featuring 2 bedrooms, 2 bathrooms, and a huge private (...)
€516,000
TSEA5127403
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 114 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Casares Region: Andalucía
Fantastic 2-bedroom beachfront apartment just 75 meters from the sea, located in the prestigious gated community in Casares beach, surrounded by beautiful tropical gardens. Situated on a ground floor (...)
€349,500
TSEA5127388
- La Cala Hills, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 129 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 129 Area: Mijas and Mijas Costa Region: Andalucía
SparklingSouth- West Facing - Sunlit 2‑Bed, 2‑Bath Apartment with Uninterrupted Fuengirola Views - Freshly Painted and Refurbished !
Welcome to your serene sanctuary in La Cala Hills—a (...)
€325,000
TSEA5127364
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 66 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 66 Area: Mijas and Mijas Costa Region: Andalucía
LOCATION LOCATION LOCATION !!!! Only a 4 minute walk to the beach; super markets; restaurants and shops of Riviera Del Sol you can find this beautifully presented 2 bedroom 1 bathroom apartment ! (...)
Current Featured Properties
€720,000
TSEA4939045
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
This new development is integrated in a privileged natural environment with views over the bay of Estepona and the mountains of Marbella, very close to the sea and very well connected. A project of (...)
€476,700
TSEA4289707
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 118 Lot Size: 20 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Lot Size: 20 Area: Benahavis Region: Andalucía
A HOME YOU WILL NEVER WANT TO LEAVE!!!
The homes in this development are designed to offer you everything you need. On the ground floor you will have a garden and wine cellar, and on the top floor (...)
€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 (...)
