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 (40,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 (40,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 (40,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 81 - 100 of 1780
€372,000
TSEA5152111
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 77 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 77 Area: Benalmadena Region: Andalucía
APARTMENT CLOSE TO PALOMA PARK, BENALMADENA: Nice 2 bedrooms, 1 bathroom apartment ideally located just a short stroll from the lush green haven of Parque de la Paloma and the vibrant heart of Arroyo (...)
€570,000
TSEA5152066
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 150 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Area: Estepona Region: Andalucía
In the heart of Estepona's New Golden Mile, where the Costa del Sol shows off its most sophisticated side, lies a unique opportunity for those looking to live or invest on the seafront. The Mar Azul (...)
€595,000
TSEA5152033
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 85 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Mijas and Mijas Costa Region: Andalucía
Stunning 2-Bedroom Beachfront Apartment in Sitio de Calahonda.
Discover coastal living at its finest with this beautiful 2-bedroom, 2-bathroom modern apartment located in an the sought-after (...)
€650,000
TSEA5152009
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Marbella East Region: Andalucía
Discover the perfect blend of convenience and coastal living with this fantastic apartment, located just 400 meters from the beach. This property is ideally suited for anyone seeking either a (...)
€420,000
TSEA5151979
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Elegant Apartment with Sea Views in Lower Carvajal
Property with rental license.
Welcome to this stylish two-bedroom, two-bathroom apartment nestled in the peaceful and sought-after area of Lower (...)
€355,000
TSEA5151955
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Fuengirola Region: Andalucía
Breathe and enjoy life at your own rhythm. This brand new apartment development offers the space to be yourself, to focus on what matters, and to reconnect with a lifestyle that feels effort-less. (...)
€550,000
TSEA5151799
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
Beautiful and spacious 2 bedroom apartment located in the five star urbanisation of Capanes Del Golf, Benahavis. This apartment enjoys wonderful golf, lake and mountain views. The kitchen has been (...)
€380,000
TSEA5151766
- Valle Romano, 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
An ideal setting...
2 bedroom, 2 bathroom open plan apartment on the fist floor of recently completed new development.
Habitat Valle Romano is perched on a gentle hilltop overlooking the bay of (...)
€530,000
TSEA5151739
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 88 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 88 Area: Fuengirola Region: Andalucía
Breathe and enjoy life at your own rhythm. This brand new apartment development offers the space to be yourself, to focus on what matters, and to reconnect with a lifestyle that feels effort-less. (...)
€850,000
TSEA5151736
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 157 Area: Mijas and Mijas Costa Region: Andalucía
The One Residence urbanisation is an exclusive, luxury complex next to the Calanova Golf Course. This fabulous apartment is one of the best within the urbanisation providing commanding PANORAMIC SEA (...)
€340,000
TSEA5150992
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 1 M2: 96 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 1 M2: 96 Area: Marbella East Region: Andalucía
Apartment for sale in La Reserva de Marbella, Marbella with 2 bedrooms, 1 bathroom and with orientation south, with communal swimming pool and communal garden. Regarding property dimensions, it has (...)
€349,000
TSEA5150977
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 68 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 68 Area: Benalmadena Region: Andalucía
Just a two-minute walk from the beach, this home combines a prime location with comfort. Surrounded by shops, restaurants, and all kinds of services, it's an ideal place to live year-round or to (...)
€275,000
TSEA5150956
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 56 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Benalmadena Region: Andalucía
APARTMENT IN BENALMÁDENA COSTA
We present this exclusive, newly renovated 56 m² apartment, located in the well-known building in Arroyo de la Miel, one of the most sought-after areas of (...)
€379,000
TSEA5150953
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 58 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Area: Marbella Region: Andalucía
Elegant 1-Bedroom Home in "Golden Banus" – Steps from Puerto Banús
This inviting apartment is located in the sought-after Golden Banus development, offering the perfect mix of comfort (...)
€375,000
TSEA5150938
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 123 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Marbella West Region: Andalucía
This apartment in Nueva Andalucía, in the La Campana area, is an excellent opportunity for those seeking comfort and a good location. The property has three bedrooms and two bathrooms, offering a (...)
€495,000
TSEA5150911
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
This beautiful, fully exterior apartment stands out for its excellent location and natural brightness throughout. Located in a peaceful residential area of Marbella, it is just 400 meters from the (...)
€325,000
TSEA5150899
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 140 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 140 Area: Benahavis Region: Andalucía
We would like to offer a list of selling points for our apartment.
A top location in the village of 'Benahavis' with a stunning view from the terrace
3 minutes walk from the center of the village, (...)
€1,090,000
TSEA5150803
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 160 Area: Benahavis Region: Andalucía
HIGHLIGHTS
Exquisite apartment located in the prestigious Marbella Club Hills development. A 5-star residence set within a privileged natural environment, in collaboration with the iconic Marbella (...)
€550,000
TSEA5150794
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 159 Area: Marbella West Region: Andalucía
HIGHLIGHTS
This apartment offers a unique investment opportunity in one of the most sought-after areas of Marbella. With its proximity to Puerto Banús and the beach, this property has enormous (...)
€390,000
TSEA5150722
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 117 Area: Mijas and Mijas Costa Region: Andalucía
Magnificent apartment with stunning views in Mijas Golf.
Discover this magnificent apartment located in a prime location for golf lovers, where tranquility and light blend perfectly.
This property (...)
Current Featured Properties
€2,406,000
TSEA4942102
- Málaga, Costa Del Sol, Malaga
Beds: 4 Baths: 3 M2: 263 Area: Malaga Region: Andalucía
Beds: 4 Baths: 3 M2: 263 Area: Malaga Region: Andalucía
71 luxury homes from 1 to 4 bedrooms, on the beachfront. The building, designed by the prestigious Lamela studio, has homes up to 404m2 built with large terraces facing the sea. Among the common (...)
€487,000
TSEA4646767
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 81 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Estepona Region: Andalucía
This is a magnificent development comprising fifty-one 2-, 3- and 4-bedroom homes, which also include penthouses with suntrap terraces and community facilities featuring a kiddies' paddling pool, a (...)
€2,995,000
TSEA4458478
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 210 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 210 Area: Estepona Region: Andalucía
BOUTIQUE BEACHFRONT DEVELOPMENT IN ESTEPONA.
Amazing new development of ONLY 14 APARTMENTS right on the beachfront on the edge of Estepona town. This premium development will boast FABULOUS SEA AND (...)
