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 (42,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 (42,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 (42,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 381 - 400 of 5891
€318,000
TSEA5145223
- Reserva de Marbella, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 80 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Marbella East Region: Andalucía
Penthouse Duplex, Reserva de Marbella, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 80 m², Terrace 80 m².
Setting : Urbanisation.
Condition : Good.
Pool : Communal, Children`s Pool.
Climate (...)
€468,000
TSEA5145220
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 149 Area: Mijas and Mijas Costa Region: Andalucía
Luxury Ground-Floor corner-Apartment with Panoramic Sea & Mountain Views –
The Perfect Investment,short-term rentals allowed and completely hassle-free!
Wake up to the Mediterranean, step onto (...)
€1,500,000
TSEA5145217
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 209 Lot Size: 5,000 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 209 Lot Size: 5,000 Area: Mijas and Mijas Costa Region: Andalucía
Property Description: Casanicky – Luxury Villa, Boutique B&B & Rare Investment Opportunity in Mijas
Welcome to Casanicky, a unique property in the heart of Mijas, Málaga province, offered (...)
€2,100,000
TSEA5145193
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 350 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 350 Area: Marbella West Region: Andalucía
Nice Villa with espectacular open mountain, landscape and pool views, in Nueva Andalucia,
Located in a peaceful and private location just a few minutes from Puerto Banus and Marbella at walking (...)
€349,000
TSEA5145187
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 68 Lot Size: 290 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 68 Lot Size: 290 Area: Mijas and Mijas Costa Region: Andalucía
Charming two bedroom detached bungalow in the popular area of El Faro, just a 5 minute drive to both Fuengirola and La Cala village. The beach is just a short 300 metre stroll away! This property has (...)
€725,000
TSEA5145166
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 175 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Area: Marbella Region: Andalucía
Spacious 3 Bedroom Apartment in the Heart of Marbella.
Just Steps from the Beach
New to the market, this very spacious three-bedroom, two-bathroom apartment is ideally located just one street back (...)
€449,500
TSEA5145130
- Calahonda, 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
Just Listed – Exceptional 2-Bed, 2-Bath Top Apartment with Breathtaking Mediterranean Views - Tourist Licences Permitted !
Welcome to your dream coastal home – where contemporary style meets (...)
€5,995,000
TSEA5145121
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 7 Baths: 7 M2: 720 Lot Size: 2,000 Area: Marbella East Region: Andalucía
Beds: 7 Baths: 7 M2: 720 Lot Size: 2,000 Area: Marbella East Region: Andalucía
This substantial property is set in a privileged position within walking distance of the beach and all amenities, offering a high level of privacy being accessed via a private cul-de-sac. There is a (...)
€14,000,000
TSEA5145118
- New Golden Mile, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 880 Lot Size: 2,610 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 880 Lot Size: 2,610 Area: Estepona Region: Andalucía
Luxury Beachfront Villa in Casasola – New Golden Mile, Estepona
Introducing a classic beachfront villa in Casasola, one of the most prestigious residential areas on Estepona's New Golden Mile. (...)
€510,000
TSEA5145076
- Sotogrande Costa, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 149 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Area: Sotogrande Region: Andalucía
Exclusive Apartment with Terrace and Views of Sotogrande Marina
Located in the Ribera de Sotogrande, this apartment is just 300 meters from the beach, allowing you to enjoy a coastal lifestyle (...)
€599,000
TSEA5145043
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 123 Lot Size: 128 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Lot Size: 128 Area: Mijas and Mijas Costa Region: Andalucía
Brand new fully furnished 3 bed apartment with a large sunny garden. This property has 3 spacious bedrooms and 2 bathrooms. The community offers luxury facilities that include an indoor pool, (...)
€1,460,000
TSEA5145040
- El Faro, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 336 Lot Size: 505 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 336 Lot Size: 505 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to your beachfront retreat! This recently refurbished villa, perfectly situated between Fuengirola and La Cala de Mijas, is designed for both comfort and seaside living. With five bedrooms (...)
€299,000
TSEA5144968
- Calypso, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 72 Lot Size: 205 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Lot Size: 205 Area: Mijas and Mijas Costa Region: Andalucía
Charming South-Facing Bungalow in Calypso – Walking Distance to the Beach!
Discover this delightful bungalow in the sought-after area of Calypso, perfectly located just a short stroll from the (...)
€547,500
TSEA5144950
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 173 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 173 Area: Estepona Region: Andalucía
Exclusive Frontline Beach Apartment in Marina Bay, Estepona
Situated in the sought-after Marina Bay urbanisation, perfectly positioned between the Port of Estepona and the popular Playa del Cristo, (...)
€385,000
TSEA5144932
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Do you want a pool, walking distance to the old town and the beach? Then this home is the perfect choice for you.
This bright and well-maintained apartment, completed in 2021 and never rented out, (...)
€569,000
TSEA5144884
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 116 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Marbella East Region: Andalucía
Discover Your Dream Coastal Retreat: Southwest-Facing Apartment in Jardines de Don Carlos, Marbella
This standout residence offers an unbeatable fusion of prime positioning, impeccable (...)
€485,000
TSEA5144869
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 63 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 63 Area: Marbella Region: Andalucía
Middle Floor Apartment, Marbella, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 63 m², Terrace 5 m².
Setting : Town, Commercial Area, Beachside, Close To Sea.
Orientation : South West.
Condition : (...)
€895,000
TSEA5144848
- Torre del Mar, Costa Del Sol East
Beds: 6 Baths: 5 M2: 410 Lot Size: 558 Region: Andalucía
Beds: 6 Baths: 5 M2: 410 Lot Size: 558 Region: Andalucía
This stunning villa with 6 bedrooms and 5 bathrooms is located in one of Torre del Mar's most sought-after areas, offering the perfect blend of modern comfort and classic Mediterranean charm. With a (...)
€345,000
TSEA5144836
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 124 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Casares Region: Andalucía
Stunning 3-Bedroom Penthouse in Casares Costa
This spacious and beautifully presented penthouse is ideally located in Casares Costa, just a short drive from the beach and all local amenities. (...)
€3,500,000
TSEA5144812
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 4 Baths: 4 M2: 367 Lot Size: 2,900 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 4 M2: 367 Lot Size: 2,900 Area: Sotogrande Region: Andalucía
New Development: Prices from 3,500,000 € to 3,500,000 €. [Beds: 4 - 4] [Baths: 4 - 4] [Built size: 367.00 m2 - 367.00 m2]
Located among golf courses, this villa embodies a life of serenity and (...)
Current Featured Properties
€424,000
TSEA4752082
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
IDEALLY SITUATED BETWEEN ESTEPONA AND PUERTO BANUS!!!
Your new home is more than just rooms and features, it must fit in with your lifestyle. We have created a floor-plan that is spacious designed to (...)
€470,000
TSEA4455349
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 80 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Estepona Region: Andalucía
Located on the in the center of the vibrant city of Estepona, on the Costa del Sol, this development complex is a truly unique new project overlooking the entire city with amazing views.
With a total (...)
€1,350,000
Spacious and contemporary apartments
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 194 Lot Size: 60 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 194 Lot Size: 60 Area: Sotogrande Region: Andalucía
STUNNING NEW HOMES IN VILLAGE COMMUNITY SETTING.
Exclusive Village Community in prestigious Sotogrande area. SPACIOUS AND CONTEMPORARY apartments have been created around an exclusive Village (...)
