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 21 - 40 of 1080
€510,000
TSEA5155954
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
???? Attention investors
New listing in Puerto Banús, Marbella!
Spacious 114 m² apartment with terrace and private parking space, located in one of the most exclusive and peaceful complexes in the (...)
€255,000
TSEA5155915
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
For sale: ground-floor apartment with two terraces, one at the entrance of the home and another at the front, totaling approximately 30 m2.
The apartment has a constructed area of 99 m2, of (...)
€599,000
TSEA5155873
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 116 Lot Size: 56 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Lot Size: 56 Area: Mijas and Mijas Costa Region: Andalucía
New on the market!!
Welcome to your dream getaway!
Located on the ground floor of the prestigious Casa Banderas complex, this modern 3-bedroom, 2-bathroom apartment offers the perfect blend of (...)
€316,000
TSEA5155780
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Beautiful renovated 114 m2 apartment with 2 bedrooms and 2 bathrooms in a residential area very close to Estepona beach.
The property stands out for its brightness, freshness, and charm, offering a (...)
€399,000
TSEA5155435
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 113 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Fuengirola Region: Andalucía
HIGHLIGHTS
Pine Hill Residences represents a unique opportunity to enjoy life on the Costa del Sol in a modern and exclusive setting. This development combines a strategic location, just minutes from (...)
€215,000
TSEA5155156
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Investment Opportunity – Las Lagunas de Mijas
Discover this excellent property located in the heart of Las Lagunas de Mijas, within a well-connected residential area and just steps away from all (...)
€2,600,000
TSEA5155126
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 4 Baths: 4 M2: 201 Lot Size: 30 Area: Marbella West Region: Andalucía
Beds: 4 Baths: 4 M2: 201 Lot Size: 30 Area: Marbella West Region: Andalucía
Welcome to this newly renovated duplex ground floor apartment in the heart of Nueva Andalucia, Marbella.
This property is very unique because of its spacious rooms , terraces , private garden and (...)
€265,000
TSEA5155075
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Apartment with two bedrooms, one bathroom, a fully equipped kitchen, a large living area with access to a terrace facing west, for sale in Riviera del Sol, Mijas Costa. This apartment is located in (...)
€559,000
TSEA5154883
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 138 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 138 Area: Marbella Region: Andalucía
Spacious Duplex ground floor with Renovation Potential in Xarblanca, Marbella
This charming Duplex ground floor, located in the popular residential area of Xarblanca in Marbella, offers an excellent (...)
€480,000
TSEA5154850
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Marbella West Region: Andalucía
Spacious corner ground floor apartment of 3 bedrooms, 2 bathrooms, big lounge and dining area with exit to a West facing terrace of 68 m2, fully fitted kitchen. Has cold and hot A/C, metallic (...)
€339,000
TSEA5154808
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 101 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Marbella Region: Andalucía
We are pleased to present a nicely maintained 3-bedroom, 2-bathroom apartment located in the prestigious La Reserva de Marbella. This property perfectly blends comfort, style, and Mediterranean (...)
€740,000
TSEA5153692
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 212 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 212 Area: Marbella Region: Andalucía
New Development: Prices from 740,000 € to 1,020,000 €. [Beds: 2 - 3] [Baths: 2 - 3] [Built size: 212.00 m2 - 271.00 m2]
This development is an exclusive residential complex comprised of 88 (...)
€295,000
TSEA5153683
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 59 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 59 Area: Fuengirola Region: Andalucía
Brand New Apartment (2024) with Tourist License – Just 200m from the Beach & 2 Minutes from the Train Station
Beautiful 2-bedroom, 2-bathroom apartment in a newly built building from 2024, (...)
€675,000
TSEA5153557
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 128 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Area: Marbella West Region: Andalucía
We are pleased to present this impeccably designed, Scandinavian-style ground-floor apartment, located in the prestigious and highly sought-after urbanisation of Aldea Blanca. This property offers an (...)
€344,900
TSEA5153257
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 85 Lot Size: 85 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 85 Area: Benahavis Region: Andalucía
????️♂️ Experience Golf, Sun, and Exclusivity in the Marbella – Benahavís Golf Valley ☀️
In the heart of the prestigious El Paraíso Golf Valley lies this modern 85 m² apartment, (...)
€230,000
TSEA5152852
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 65 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Benalmadena Region: Andalucía
Charming One-Bedroom Apartment in Torrequebrada in a Peaceful Area
Spacious living room with plenty of room for a dining table as well. A compact kitchen that still includes everything you need for (...)
€597,000
TSEA5152840
- Higueron, Costa Del Sol
Beds: 3 Baths: 2 M2: 152 Lot Size: 62 Region: Andalucía
Beds: 3 Baths: 2 M2: 152 Lot Size: 62 Region: Andalucía
For Sale: Ground Floor 3-Bedroom Apartment with Garden & Terrace in Las Lomas del Higuerón
Discover a beautifully designed ground floor apartment located in the prestigious Las Lomas del (...)
€680,000
TSEA5152669
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
FANTASTIC APARTMENT WITHIN WALKING DISTANCE OF LA CALA DE MIJAS!
This beautiful apartment in Jardinana Lotus is the ideal (holiday) apartment!
The apartment features 3 bedrooms, 2 bathrooms, a (...)
€415,000
TSEA5152627
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beautiful 90 m2 apartment with 2 bedrooms and 2 bathrooms, a terrace with garden views, and direct access to the beach in an exclusive Estepona development.
This ground-floor apartment with two (...)
€429,000
TSEA5152285
- Hacienda del Sol, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 152 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 152 Area: Estepona Region: Andalucía
Two bedroom ground floor apartment in the luxurious urbanisation Hacienda del Sol.
Layout:
- living room, dining room
- kitchen
- 2 bedrooms, 1 with bathroom en suite
- 2 bathrooms
On the (...)
Current Featured Properties
€699,259
TSEA4568743
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 100 Lot Size: 42 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Lot Size: 42 Area: Mijas and Mijas Costa Region: Andalucía
A STUNNING GATED DEVELOPMENT!!!
It is a modern project of 50 homes of 2 and 3 bedrooms, each with its own parking space and storage room. The construction will always respect our commitment to the (...)
€665,000
TSEA4250983
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 166 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 166 Area: Estepona Region: Andalucía
SPACIOUS PROPERTIES WITH SPECTACULAR VIEWS!!
An exclusive community comprising 84 luxury properties with generous indoor spaces, roomy terraces, spectacular views, community areas, swimming pool and (...)
€590,000
TSEA5072011
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 140 Lot Size: 69 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Lot Size: 69 Area: Casares Region: Andalucía
Discover this exclusive new development consisting of 99 apartments and penthouses, each with 2 or 3 bedrooms, designed to help you find where you truly belong. Situated in the prime location of (...)
