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,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 (31,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 (31,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 541 - 560 of 3987
€560,000
TSEA5135170
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 115 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Estepona Region: Andalucía
Spacious 3-bedroom apartment in an exclusive urbanization with 24-hour security.
This bright 115 m² apartment offers an ideal layout to enjoy life on the Costa del Sol:
• 3 bedrooms and 2 (...)
€275,000
TSEA5135161
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Lot Size: 15 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 15 Area: Estepona Region: Andalucía
✨ Spacious Ground-Floor Apartment with Sea & Golf Views – Fully Renovated 3 Years Ago
If you're the kind of person who never settles for average and always seeks the best, this stunning (...)
€480,000
TSEA5135146
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 72 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Area: Estepona Region: Andalucía
New Development: Prices from 480,000 € to 480,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 72.00 m2 - 72.00 m2]
At this development, we have 1, 2 and 3 bedroom homes with large terraces, (...)
€620,000
TSEA5135143
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 98 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 98 Area: Marbella Region: Andalucía
Impeccable top floor apartment in the heart of Marbella, just a 5-minute walk from the beach and the promenade, and next to supermarkets and shops. The property was renovated very recently, and (...)
€580,000
TSEA5135134
- Teatinos, Costa Del Sol
Beds: 3 Baths: 2 M2: 181 Region: Andalucía
Beds: 3 Baths: 2 M2: 181 Region: Andalucía
We present this spectacular ground-floor apartment located in the most valued and sought-after residential area of Teatinos. A modern, bright, and meticulously designed home, perfect for those (...)
€380,000
TSEA5135122
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Spacious 2 bedroom apartment with spacious terrace in the well sought after gated community Las Adelfas in Finca Dona Maria in Torrequebrada.
The views are mesmerizing: panoramic golf and sea views. (...)
€220,000
TSEA5134870
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 32 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 32 Area: Fuengirola Region: Andalucía
Located on the beachfront and Paseo Maritimo within the "Las Palmeras" Hotel, one of the most desirable areas on the coast, this renovated apartment is the perfect opportunity for those (...)
€329,000
TSEA5134813
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 113 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Manilva Region: Andalucía
This one stands out, ladies and gentlemen and you can take my word for it. Listen to this:
Tastefully renovated open plan kitchen with quality appliances, three good sized bedrooms, two renovated (...)
€420,000
TSEA5134771
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 112 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Benalmadena Region: Andalucía
Penthouse for Sale in Benalmádena Pueblo – Historic Centre with Terrace and Large Solarium
Discover this exclusive penthouse for sale in Benalmádena Pueblo, located right in the Historic Centre, (...)
€429,000
TSEA5134747
- Costalita, 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
Ground Floor 3-Bedroom Apartment in Prime Beachside Location
This three-bedroom apartment is located in the Costalita urbanisation in Estepona East. As you enter the apartment, you'll find the (...)
€265,000
TSEA5134741
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 85 Lot Size: 97 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 85 Lot Size: 97 Area: Fuengirola Region: Andalucía
2-Bedroom Raised Ground Floor Apartment with Sea & Mountain Views
Spacious and bright 2-bedroom apartment on a raised ground floor, offering beautiful views of the Mediterranean Sea and (...)
€330,000
TSEA5134723
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Lovely ground floor apartment located on the main strip of Calahonda, it's an excellent opportunity for an investment, holiday home or family home. This apartment has 2 very good size bedrooms, a (...)
€750,000
TSEA5134720
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 114 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: San Pedro Region: Andalucía
This beautifully refurbished third floor corner apartment in this sought after urbanisation has been upgraded to the highest standards, and is a delightful mix of modern elegance and comfort.
Upon (...)
€349,000
TSEA5134621
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
This appartment offers a large living area connecting with an open kitchen, fully equipped and with all new Bosch appliances. The modern apartment offers two bedrooms (1 ensuite) and two bathrooms, (...)
€220,000
TSEA5134552
- Ciudad Jardín, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 83 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 83 Area: Marbella Region: Andalucía
Your new home in Ciudad Jardín, Málaga.
83m² apartment,
Needs COMPLETE RENOVATION.
Three spacious bedrooms, offering the perfect space.
Bathroom.
Large living room, terrace connected to the (...)
€325,000
TSEA5134516
- Los Pacos, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 133 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Mijas and Mijas Costa Region: Andalucía
Live in style in Los Pacos, Fuengirola!
We present this magnificent apartment located in the prestigious Lomas de las Pacos Phase I residential complex, a unique opportunity for those seeking (...)
€440,000
TSEA5134489
- Málaga Centro, Costa Del Sol, Malaga
Beds: 4 Baths: 2 M2: 136 Area: Malaga Region: Andalucía
Beds: 4 Baths: 2 M2: 136 Area: Malaga Region: Andalucía
Fantastic opportunity to invest in the Huelin area, Carretera de Cádiz. Just 200 meters from the Huelin park and 500 meters from the seafront and beaches of Huelin.
Large 4-bedroom home of 136 (...)
€250,000
TSEA5134444
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 47 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 47 Area: Mijas and Mijas Costa Region: Andalucía
Opportunity investment, 1-bedroom apartment near the beach and shops, large terrace with 21m2 , living room with fireplace, one bedroom and bathroom, outdoor communal parking, elevator, and communal (...)
€350,000
TSEA5134420
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 106 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Mijas and Mijas Costa Region: Andalucía
LOCATION! LOCATION!
Walking distance to all amenities, located in a great area in the lower part of Calahonda, just about a 7-minute walk from the beach.
A few meters from all the services - (...)
€1,200,000
TSEA5134417
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 144 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Area: Fuengirola Region: Andalucía
NEW ON THE MARKET: Newly completed luxury residence in Reserva del Higuerón – €1,200,000 – ready for immediate viewing!
This stunning resale unit has just been completed and is move-in ready. (...)
Current Featured Properties
€2,250,000
TSEA4943188
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 142 Lot Size: 186 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 142 Lot Size: 186 Area: Malaga Region: Andalucía
This residential complex is where the contemporary and the traditional come together. For this reason, we will find renovated buildings, alongside newly built buildings or buildings protected as (...)
€4,300,000
EMPTY
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 7 Baths: 5 M2: 330 Area: Marbella West Region: Andalucía
Beds: 7 Baths: 5 M2: 330 Area: Marbella West Region: Andalucía
URB. NINE LIONS, NUEVA ANDALUCIA, MARBELLA
A truly unique and stunning fully private 7-bed apartment located in urb. Nine Lions, Nueva Andalucia, a sought after and well secured urbanisation with 53 (...)
€695,000
TSEA4622989
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 78 Lot Size: 53 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Lot Size: 53 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 (...)
