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 (162,39,40,41,162,163)
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 (162,39,40,41,162,163)
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 (162,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (11), Middle Floor - (11), Penthouse - (11), Top Floor Apartment - (11), Penthouse Duplex - (11)Properties
Results 161 - 180 of 3894
€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. (...)
€185,000
TSEA5151949
- La Campana, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 47 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 47 Area: Marbella West Region: Andalucía
Ground Floor Apartment, La Campana, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 47 m².
Setting : Town, Suburban, Commercial Area, Village, Close To Shops, Close To Town, Close To (...)
€300,000
TSEA5151841
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Modern Renovated Apartment in Nueva Atalaya, Estepona – 2 Bedrooms, 2 Bathrooms, Private Terrace & Communal Pool
Located in the sought-after area of Nueva Atalaya, Estepona, this beautifully (...)
€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 (...)
€250,000
TSEA5151781
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 96 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 96 Area: Estepona Region: Andalucía
Ground Floor Apartment, Estepona, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 96 m², Terrace 15 m².
Setting : Beachfront, Town, Commercial Area, Beachside, Port, Village, Close To Port, Close To (...)
€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 (...)
€595,000
TSEA5151748
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 130 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 130 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Living in Finca San Antonio – A Rare Gem Near Mijas Pueblo
Step into elegance with this exceptional 2-bedroom, 2-bathroom apartment nestled in the prestigious Finca San Antonio community, (...)
€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 (...)
€880,000
TSEA5151628
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 199 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 199 Area: Benahavis Region: Andalucía
Luxurious Ground-Floor Apartment in Capanes del Golf – Resort Living within El Higueral Golf course close to Marbella, Benahavis & Estepona
Discover this very spacious apartment in Capanes del (...)
€325,000
TSEA5151052
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 60 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Estepona Region: Andalucía
New Development: Prices from 325,000 € to 995,000 €. [Beds: 1 - 3] [Baths: 1 - 2] [Built size: 60.00 m2 - 147.00 m2]
This is an exclusive residential complex in the Las Mesas area, combining (...)
€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 (...)
€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, (...)
€229,000
TSEA5150893
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 49 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 49 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. (...)
€275,000
TSEA5150836
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 81 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 81 Area: Manilva Region: Andalucía
Investment Apartment for Sale
Become the owner of a stunning penthouse duplex apartment – perfect as your own holiday home or as a smart investment.
Highlights:
Just a short walk to the (...)
€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 (...)
Current Featured Properties
€534,450
TSEA4581373
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 105 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: San Pedro Region: Andalucía
The development in San Pedro de Alcantara is made up of 35 homes with 2 and 3 bedrooms, with duplexes with terraces-solariums. Garages in the basement and commercial premises on the ground floor, in (...)
€220,000
TSEA4871923
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 42 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 42 Area: Estepona Region: Andalucía
Cozy and Immaculately presented studio apartment in a frontline beach urbanisation beween San Pedro and Estepona, very close to Velerín and with a great offer of chiringuitos and a wonderful beach (...)
€2,695,000
TSEA5143117
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Located between Marbella and Estepona, Bahía del Velerín is a prestigious community with a beautiful pool area, a snack bar, lush tropical gardens, and 24/7 security.
This fully renovated penthouse (...)
