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 (163,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 (163,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 (163,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 521 - 540 of 3894 €475,000
TSEA5135203
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 123 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 123 Area: Marbella East Region: Andalucía
** Exceptional 2-Bedroom Apartment with Breathtaking Mountain & Sea Views – La Mairena **
Nestled in a charming Andalusian-style gated and secured community in the picturesque area of La (...)
€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 - (...)
Current Featured Properties
€1,599,900
TSEA4624528
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 103 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Fuengirola Region: Andalucía
This brand new development stands out! An exclusive residential complex with spacious layouts and top-tier construction. The residences have been built with the highest-quality materials and feature (...)
€490,000
TSEA4721146
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 76 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 76 Area: Estepona Region: Andalucía
A BRAND NEW BOUTIQUE COMPLEX OF ONLY 15 PROPERTIES! Our architects have carefully designed this project, sparing no details. You won't find small windows here, only large glass panels that flood the (...)
€467,250
TSEA3923275
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 93 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Estepona Region: Andalucía
CHARMING SPACIOUS APARTMENTS!!!
The apartments are specially designed to fully enjoy the charm of the Mediterranean lifestyle, but they are also designed with a Northern European vision. A well (...)
